When a project is completed, one of the next steps is to roll this project out to the production environment. However a good rollback process is important to ensure that you can remove those changes if there are problems. Longtime author David Poole talks about how he handles this.
2008-10-22
3,974 reads
Longtime SQL Server author and expert David Poole takes a break from SQL Server to bring us a few life lessons for software development.
2008-05-14
6,959 reads
David Poole is a regular author at SQLServerCentral.com, sharing many of his knowledge and experiences with us over the years. This time he examines some of the issues that you might have with replication.
2008-03-06
12,123 reads
An IP address is something we all recognize and is a piece of data that is quite prevalent in many systems. However it is a piece of
data tha presents some challenges in its storage and retrieval. SQL Server guru David Poole presents us with a look at how you can
work with this strange formatting.
2008-02-19 (first published: 2007-04-02)
17,383 reads
Longtime SQL Server guru David Poole brings us a look at one of the thorny problems a DBA faces: tracking down illicit users.
2008-01-15
7,898 reads
Keeping track of the amount of space in a database is something every DBA needs to do or face the dreaded "out of space" errors appearing on every client's desktop. SQL Server guru David Poole brings us an automated way of doing just that.
2007-12-25 (first published: 2006-12-28)
20,906 reads
SQL Server guru David Poole takes a look at the different integer data types and the impact of each of those on your database.
2007-12-10 (first published: 2006-12-18)
23,366 reads
Most SQL Server programmers know to use the SET NOCOUNT command to prevent the number of rows message from being returned to the client. But how does this affect performance? Does it make sense to qualify the owner on your objects? SQL Server guru David Poole brings us some performance analysis of how your stored procedures perform.
2007-12-07 (first published: 2006-12-11)
25,772 reads
Many new DBAs think that User-defined types are a very cool feature in SQL Server when they first encounter them. However many experienced DBAs soon realize that UDTs can be a pain to work with and longtime SQL Server guru David Poole discusses his experiences
2007-07-23
7,953 reads
What does a SQL Server developer care about the Enterprise Library? SQL Server guru David Poole is starting to work with .NET and brings us his perspective on what this library is and how it benefits those who develop against SQL Server.
2006-08-21
15,377 reads
By Brian Kelley
On Patch Tuesday, in addition to OS and Office security patches, Microsoft also released...
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...
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