You are browsing archives for
I’ve been working on migrating existing SQL Server database projects into Visual Studio for Database Professional projects. Most of the existing databases have imported without major problems, but there are a few that have warnings about cross-database joins in old unit tests. TSD3025: The following cross-database dependencies could not be verified: … Your database application […]
I just came across a good article by Keith Brown on a common trap when setting up SQL Server with kerberos delegation. As he noted, the port number for the Sql Server Service should be specified when setting the service principal name (SPN). Delegation is a powerful feature of Active Directory but can be difficult […]
Now that Microsoft have released Visual Studio Team Suite for Database Professionals (aka [story:datadude]) its time for SQL Server developers and dbas to learn more about Unit Testing. There is many different methods to test a database within the framework set by Visual Studio. So how do you know which way is best? Well one […]
Data Dude The simplest way to say “Visual Studio 2005 Team Suite Edition for Database Professionals”. A suite of tools built by Microsoft for designing, deploying and testing SQL Server databases within the Visual Studio IDE. Visit the Visual Studio 2005 Team Edition for Database Professionals A.K.A. DataDude website.
There’s been some interesting questions by users on the SQL Server Engine Tips blog. While almost all of them seem to be off topic, there are some interesting ideas. One of the fun ones was from Dave asking “Can we have some unsigned int data types?”. As a basic background for those of us who […]
The free version of SQL Server 2005 is the “Express” edition. Its a cut down version of SQL Server 2005 and is ideal as an upgrade from Access, for desktop use or small multi-user databases. Its not designed for large scale production use, and comes with a number of limitations. The most notable limitations are: […]
Its been a busy few weeks for me and I haven’t had as much time to catch up on my reading as I’d have liked. This is the list of things that I have been / trying to read. Software Development at Microsoft Observed Microsoft Research paper on developers� typical tools and work habits and […]
Microsoft have released details of a new feature available in SQL Server 2005 Enterprise Edition: Scalable Shared Databases. What is it? A read-only database stored on a SAN than can be attached to multiple SQL Server instances. It will allow you to have multiple instances of SQL Server host the same database, with the same […]
Davide Mauri has published a number of SQL Server 2005 scripts he uses as part of his DBA toolkit to analyse indexes including their usage and health. They’re a great short cut to building your own after wading through BOL. So far there are four UDFs he’s published that show the indexes on a table, […]
Today while working with a .bat file full of SQLCMDs with really verbose output, I wanted just to capture error messages that were being sent to STDERR without changing the .sql files. I know how to capture/redirect handles in a variety of programming languages, but I haven’t tried to do this in a windows command […]
