iAwaaz-News-by-People - Stories tagged with Database
1
Awaaz

FILESTREAM directory structure - where do the GUIDs come from? - Jacob's Blog

published 78 days, 15 hours, 58 minutes ago posted by amit_it7amit_it7 80 days, 14 hours, 45 minutes ago
Sunday, June 20, 2010 2:46:27 AM GMT Friday, June 18, 2010 3:59:55 AM GMT
SQL Server uses GUID values to name the FILESTREAM folders and you might find it really hard to relate a folder to a table or column. This post explains how you can do it. (more)
category: Technology | clicked: 0 | comment | | source: beyondrelational.com
tags: Blob, DAC, Database, DBA, FILESTREAM, SQLServer
1
Awaaz

The future of Document management is p2p, tag-based with real-time on-demand database merging?

posted by nancynancy 80 days, 15 hours, 9 minutes ago
Friday, June 18, 2010 3:35:37 AM GMT
...Basically, instead of loading only one database, Tabbles would load several databases, one for each user, have them (more)
category: Technology | clicked: 0 | comment | | source: tabbles.net
tags: Database, Document management, merge, tabbles, XML
1
Awaaz

SSAS Dimension Attribute Properties : Part 1 - Some Random Thoughts

posted by nancynancy 80 days, 15 hours, 16 minutes ago
Friday, June 18, 2010 3:29:16 AM GMT
In this post, Jason provides a quick overview of SSAS Dimension Attribute properties and provides a wonderful explanation of each property. (more)
category: Technology | clicked: 0 | comment | | source: beyondrelational.com
tags: analysis, cube, Data Mining, Data Warehousing, Database, Dimension, SQLServer, SSAS
1
Awaaz

T-SQL Enhancements in SQL 2008

published 84 days, 10 minutes ago posted by nancynancy 85 days, 22 hours, 4 minutes ago
Monday, June 14, 2010 6:34:58 PM GMT Saturday, June 12, 2010 8:40:34 PM GMT
Seth Phelabaum explains his favorite TSQL programmability enhancements added in SQL Server 2008. (more)
category: Technology | clicked: 0 | comment | | source: beyondrelational.com
tags: Database, developer, Programmability, SQL Server, TSQL
1
Awaaz

WCF based client-server version ? Part 2 : Tabbles developers' blog

posted by attitudeattitude 132 days, 15 hours, 20 minutes ago
Tuesday, April 27, 2010 3:24:25 AM GMT
We?re missing some of the theory about if and how transactions could be implemented in our WCF-based custom database, the whole story here: http://social.msdn.microsoft.com/Forums/en/wcf/thread/1371d0dd-c65a-491e-a3cf-2fb7b4919961 Thanks to everyone who?s willing to provide any help! (more)
category: Technology | clicked: 0 | comment | | source: tabbles.net
tags: .NET 3.5 SP1, Database, Transactions, WCF
1
Awaaz

VistaDB 4 and Visual Studio 2010

published 138 days, 19 hours, 13 minutes ago posted by attitudeattitude 140 days, 23 hours, 51 minutes ago
Tuesday, April 20, 2010 11:31:41 PM GMT Sunday, April 18, 2010 6:54:01 PM GMT
Yes, Visual Studio 2010 was released today to much fanfare in Las Vegas. (more)
category: Technology | clicked: 1 | comment | | source: infinitecodex.com
tags: Database, VistaDB, Visual Studio
1
Awaaz

Creating a Time UUID (GUID) in .NET - Nick Berardi's Coder Journal

posted by attitudeattitude 150 days, 20 hours, 32 minutes ago
Thursday, April 08, 2010 10:13:05 PM GMT
Previously I had written about how to setup Cassandra as a database on your Windows machine. (more)
category: Technology | clicked: 0 | comment | | source: www.coderjournal.com
tags: Cassandra, Database, Programming
1
Awaaz

Dynamic Database Creation in Entity Framework

posted by attitudeattitude 157 days, 21 hours, 32 minutes ago
Thursday, April 01, 2010 9:13:01 PM GMT
Entity Framework 4 RC allows you to create and drop databases in run-time using SSDL for DDL generation. Now ObjectContext has CreateDatabase(), DropDatabase(), and CreateDatabaseScript() methods. They appeared in Entity Framework v4 CTP for Code Only and only for SQLClient initially but later they became available for other EF-providers. In this article we describe implementation of these methods in Devart data providers. We are using dotConnect for Oracle as a data provider in the following examples.... (more)
category: Technology | clicked: 0 | comment | | source: www.devart.com
tags: Database, Entity Framework, Visual Studio 2010
1
Awaaz

Tabs Studio adds advanced tabs to Microsoft SQL Server Management Studio 2008 IDE

posted by nancynancy 168 days, 19 hours, 48 minutes ago
Sunday, March 21, 2010 10:56:50 PM GMT
Tabs Studio add-in adds experimental support for multiple tab rows and tab grouping in SSMS 2008 IDE. (more)
category: Technology | clicked: 0 | comment | | source: tabsstudio.wordpress.com
tags: Database, SQL, SQL Server, ssms
1
Awaaz

Updated CTP for SQL Azure Database includes complete feature set for PDC 2009! - SQL Azure Team Blog

posted by nancynancy 168 days, 19 hours, 48 minutes ago
Sunday, March 21, 2010 10:56:47 PM GMT
Updated CTP for SQL Azure Database includes complete feature set for PDC 2009! A few short weeks ago we announced the SQL Azure Database August CTP. Since the announcement, tens of thousands in the community have signed up for the service and have provided us with a tremendous amount of positive feedback. Today, the SQL Azure Database October CTP (CTP 2) update is another major milestone as we get ready for the Professional Developers Conference (PDC) on November 17th - 20th, 2009. We are also excited t... (more)
category: Technology | clicked: 0 | comment | | source: blogs.msdn.com
tags: Azure, CTP, Database, PDC, PDC 2009, SQL, SQL Azure
1
Awaaz

Eschewing Date Types in our Database - Karl Seguin - CodeBetter.Com

posted by nancynancy 168 days, 19 hours, 48 minutes ago
Sunday, March 21, 2010 10:56:44 PM GMT
About a month ago, I found myself transforming data for the reporting portion of our application. Like many reporting systems, ours works off of date ranges, with statistics grouped together by the day (and a few by the hour). An early prototype made heavy use of TSQL Date functions (like DateAdd and DatePart). However, I wasn't happy with this solution, my transformations were unnecessarily coupled to SQL Server. I mean, database date functions all do pretty primitive date arithmetic's, surely we can co... (more)
category: Technology | clicked: 0 | comment | | source: codebetter.com
tags: Database
1
Awaaz

VS 2010 Beta 2 Read Me Items for Web Deployment - Vishal Joshi

posted by nancynancy 168 days, 19 hours, 48 minutes ago
Sunday, March 21, 2010 10:56:41 PM GMT
There are some known issues/bugs related to VS 2010 Web Deployment features in VS 2010 Beta 2 Read Me? I can imagine reading the entire Beta 2 read me file can be daunting so I thought I can just copy paste the ones related to Web Deployment here? DB Deployment will fail if the Database Name is longer than 127 characters Description: If you are using latest VS 2010 Web Deployment Features and trying to deploy your database using the Deploy SQL property page then at times you might get error from VSMsDe... (more)
category: Technology | clicked: 0 | comment | | source: vishaljoshi.blogspot.com
tags: Database, DB, Deploy, Deployment, SQL, Visual Studio 2010, visual studio 2010 beta 2, VS 2010, VS2010
1
Awaaz

Are You Using Scalable Shared Databases? - Ben Nevarez

posted by nancynancy 168 days, 19 hours, 48 minutes ago
Sunday, March 21, 2010 10:56:38 PM GMT
Did you know that you can share read-only databases between several instances of SQL Server? Scalable Shared Databases is a very interesting SQL Server feature that many of us seem to almost have forgotten about it. Available for the first time in SQL Server 2005 and originally described on the Microsoft KB article 910378, it was later fully documented on Books Online. This Enterprise edition-only feature allows a read-only database to be accessed at the same time by two or more SQL Server instances (ma... (more)
category: Technology | clicked: 0 | comment | | source: sqlblog.com
tags: Database, DB, SQL, SQL Server
1
Awaaz

Dot Net Facts: Create a Firebird database from script file with ActiveRecord

posted by nancynancy 168 days, 19 hours, 48 minutes ago
Sunday, March 21, 2010 10:56:36 PM GMT
Once I needed to create a Firebird database from a SQL script file using the ActiveRecord component from Castle Project. First problem was to convince ActiveRecord to execute a non-query command and the second, to execute the script file using the Firebird embedded engine. Execute non-query commands with ActiveRecord The main idea is to grab the IDbConnection object from the current ActiveRecord session. After that, you can use this connection any way you want to. C# .NET ActiveRecordMediator.Exe... (more)
category: Technology | clicked: 0 | comment | | source: dotnetfacts.blogspot.com
tags: ActiveRecord, c#, Database, Firebird
1
Awaaz

Free Database: The Relational Databases Blog: Create Firebird database from script file by code

posted by nancynancy 168 days, 19 hours, 48 minutes ago
Sunday, March 21, 2010 10:56:34 PM GMT
It seems the Firebird embedded engine is not able to create a database by executing a full file script as one statement. If this is what you are trying to achieve, here is a workaround (.NET/C#/ActiveRecord): Create a Firebird database from script file with ActiveRecord (more)
category: Technology | clicked: 0 | comment | | source: free-database.blogspot.com
tags: ActiveRecord, Database, Firebird
1
Awaaz

Enter The Dragon: RoundhousE DB Migrations

published 168 days, 18 hours, 36 minutes ago posted by nancynancy 168 days, 19 hours, 48 minutes ago
Monday, March 22, 2010 12:08:51 AM GMT Sunday, March 21, 2010 10:56:32 PM GMT
RoundhousE is an open source automated database deployment (change management) system that allows you to use your current idioms and gain much more. Currently it only supports Microsoft SQL Server, but there are future plans for other databases. It seeks to solve both maintenance concerns and ease of deployment. We follow some of the same idioms as other database management systems (SQL scripts), but we are different in that we think about future maintenance concerns. We want to always apply certain sc... (more)
category: Technology | clicked: 1 | comment | | source: ferventcoder.com
tags: c#, Database, database migrations, Databases, DB, db migrations
1
Awaaz

RoundhousE DB Migration: Action Shots

published 168 days, 18 hours, 36 minutes ago posted by nancynancy 168 days, 19 hours, 48 minutes ago
Monday, March 22, 2010 12:08:51 AM GMT Sunday, March 21, 2010 10:56:29 PM GMT
A quick walk through of a sample database creation and migration. With action shots so you can see the total awesome that is RoundhousE in action. Is it the best thing since sliced bread? No - only cuz you can't eat it. It will make your database migration life so much easier you'll wonder how you ever lived without it. Are you still reading this? Click the link! (more)
category: Technology | clicked: 0 | comment | | source: ferventcoder.com
tags: Database, database migrations, DB, db migrations, migration
1
Awaaz

RoundhousE: Configuration

published 168 days, 18 hours, 36 minutes ago posted by nancynancy 168 days, 19 hours, 48 minutes ago
Monday, March 22, 2010 12:08:51 AM GMT Sunday, March 21, 2010 10:56:28 PM GMT
Let?s take a look at the RoundhousE's configuration. We are going to focus on the MSBuild/NAnt task configuration for now because the console isn?t yet complete. The console will actually have at least this much if not more (we?ve talked about how to use it to create the migration scripts and not just run them). (more)
category: Technology | clicked: 0 | comment | | source: ferventcoder.com
tags: Database, database migrations, DB, db migrations
1
Awaaz

RoundhousE: Version Your Database

published 168 days, 18 hours, 36 minutes ago posted by nancynancy 168 days, 19 hours, 49 minutes ago
Monday, March 22, 2010 12:08:51 AM GMT Sunday, March 21, 2010 10:56:25 PM GMT
Versioning your database is as important as versioning your code. How much time do we waste currently before we are even productive when we have to fix or enhance something in a database? RoundhousE versions your database how you want. The recommended way is to version based on source control, but that may not be your solution. But for a moment let?s pretend it is. Why would versioning your database based on source control be a big help? Read on to find out why DBAs, Auditors, and ladies that can't walk... (more)
category: Technology | clicked: 0 | comment | | source: ferventcoder.com
tags: Database, database migrations, db migrations
2
Awaaz

Spell-check OleDb Databases - Win Dev Blog

published 168 days, 18 hours, 27 minutes ago posted by nancynancy 168 days, 19 hours, 49 minutes ago
Monday, March 22, 2010 12:17:36 AM GMT Sunday, March 21, 2010 10:56:19 PM GMT
Introduction This article describes the implementation of C1DBSpellChecker, a utility that performs spell-checking on OleDb databases including SqlServer and Access. After reading this article, you will be able to specify a connection string, and then select a table and one or more string fields on the table to spell-check. Typing errors will then be displayed in a grid where they can be corrected. When all corrections have been made, the changes will be saved back to the database. Background Spell-c... (more)
category: Technology | clicked: 0 | comment | | source: helpcentral.componentone.com
tags: access, AdventureWorks, ComponentOne, Database, IntelliSpell, OLEDB, spell-check, spellchecker, spell-checking, spelling, SQLServer, Visual Studio, Windows Forms, WinForms
1
Awaaz

Mindscape LightSpeed 3 domain modeling and persistence framework

published 168 days, 18 hours, 36 minutes ago posted by nancynancy 168 days, 19 hours, 49 minutes ago
Monday, March 22, 2010 12:08:51 AM GMT Sunday, March 21, 2010 10:56:17 PM GMT
Mindscape has announced a new version of their dot net ORM tool named Mindscape LightSpeed 3. (more)
category: Technology | clicked: 0 | comment | | source: www.vistadb.net
tags: Database, LightSpeed, ORM, VistaDB, Visual Studio
1
Awaaz

SSMS tab grouping with Tabs Studio

published 168 days, 18 hours, 36 minutes ago posted by nancynancy 168 days, 19 hours, 49 minutes ago
Monday, March 22, 2010 12:08:51 AM GMT Sunday, March 21, 2010 10:56:16 PM GMT
SQL Server Management Studio uses quite different scheme for tab names from Visual Studio. I?ve significantly improved SSMS support in the next Tabs Studio version. (more)
category: Technology | clicked: 0 | comment | | source: tabsstudio.wordpress.com
tags: Database, SQL, SQL Server, SQL Server Management Studio, ssms
1
Awaaz

Working with transactions in Entity Framework and LINQ to SQL

published 168 days, 18 hours, 36 minutes ago posted by nancynancy 168 days, 19 hours, 49 minutes ago
Monday, March 22, 2010 12:08:51 AM GMT Sunday, March 21, 2010 10:56:11 PM GMT
Entity Framework In this article we consider a short description of the Entity Framework and LINQ to SQL transactional models. There are also some simple code listings illustrating different aspects of the transactional model. A transaction is a series of operations performed as a single unit of work. Entity Framework transactions are a part of its internal architecture. The SaveChanges method operates within a transaction and saves results of the work. It is designed to ensure data integrity. (more)
category: Technology | clicked: 0 | comment | | source: www.devart.com
tags: Database, Entity Framework, Linq
1
Awaaz

dotConnect Team?s Blog

published 168 days, 18 hours, 36 minutes ago posted by nancynancy 168 days, 19 hours, 49 minutes ago
Monday, March 22, 2010 12:08:51 AM GMT Sunday, March 21, 2010 10:56:09 PM GMT
Introduction In this article we consider how to build Entity Framework models using PostGIS objects in Entity Developer. PostGIS is a popular spatial extension for PostgreSQL that gives one an opportunity to work with geographic objects. To create and use such models we will: use a .NET wrapper for PostGIS (SharpMap) build a new Entity C# code generation template in order to enable geometry types support write some code dealing with change tracking (more)
category: Technology | clicked: 1 | comment | | source: www.devart.com
tags: Database, Entity Framework
1
Awaaz

10 things you must do to make your desktop database apps better

published 168 days, 18 hours, 36 minutes ago posted by nancynancy 168 days, 19 hours, 49 minutes ago
Monday, March 22, 2010 12:08:51 AM GMT Sunday, March 21, 2010 10:56:06 PM GMT
Each of these items could be a blog post unto themselves, but I am going to try really hard to not be too verbose and just cover the core of the concept and why you need to do it. Everyone knows that any app driven by data is much more than just the app. (more)
category: Technology | clicked: 0 | comment | | source: www.vistadb.net
tags: Application Development, Database, Reliability
Previous 1 2 Next