Ensuring that your disk subsystem performs well and does not run out of space is a balancing act that many DBAs learn over time through trial and "out of space" errors. New author Arindam Banerjee takes a look at some of the things to consider when capacity planning.
2006-07-04
15,939 reads
This article adds some handy reporting capabilities to the new load testing tool in Visual Studio 2005 Team System.
2006-07-04
1,459 reads
Building a data warehouse is a complicated topic and a hot topic now. Many companies embark upon these projects without understanding what they really need. New author Janet Chan takes a look at some of the things you need to consider before embarking on a project such as this.
2006-07-03
11,117 reads
Enter to win a Ms Pacman/Galaga arcade machine when you download and register a free version of Microsoft Visual Studio Express Editions (free learning resources included).
2006-07-03
1,647 reads
The benefits and drawbacks of GUIDs as primary keys are generally known. Despite the drawbacks, some people use them to fulfill specific business requirements (the IDs are unique across multiple servers).
2006-06-30
2,858 reads
Over the last year we've taken a look at a number of people influential in the SQL Server community. This time Steve Jones spent a little time interviewing MVP and regular blogger Simon Sabin.
2006-06-29
5,047 reads
This article provides a guide for physical storage design and gives recommendations and trade-offs for physical hardware design and file architecture.
2006-06-29
3,858 reads
SQL Server guru Andy Warren has been working with all aspects of SQL Server for many years and is slowly upgrading his skills to SQL Server 2005. Here he takes a look at SMO basics, which is the replacement for DMO.
2006-06-28
10,410 reads
Use Linked Reports to provide multiple "versions" of a single source report, as a mechanism for restricting consumer groups to their respective data in accordance with a "need to know."
2006-06-28
2,200 reads
Have you ever used XP_RESULTSET in SQL Server? If you're like most DBAs, this procedure is rarely used and can be a little complicated to setup. New author J. T. Shyman brings us a look at just how useful this command can be in executing a command on every database.
2006-06-27
12,876 reads
When mirroring was first released for Azure SQL Database, it used Change Data Capture...
By Steve Jones
One of the things I’ve tried hard to do in database development situations if...
By DataOnWheels
The T-SQL Tuesday topic this month comes James Serra. What career risks have you...
We have two "identical" instances of an ASP.NET web service (or so I have...
Comments posted to this topic are about the item OPENQUERY Flexibility
Comments posted to this topic are about the item A Full Shutdown
Which of these are valid OPENQUERY() uses?
See possible answers