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
4,058 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
7,008 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,199 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,493 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,929 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,951 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,635 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,920 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
8,087 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,421 reads
By Arun Sirpal
AgentDBA began as a command line. That suits one DBA on one server, but...
By Steve Jones
I have a few Azure subscriptions, which are fairly small and not used that...
This post shows you how to install containerd as the container runtime for Kubernetes...
Telp/Wa 628218200203 Bank Bca Kcu Purwakarta, Jl. Jendral Sudirman No.85, Nagri Tengah, Kec. Purwakarta,...
Telp/Wa 628218200233 Jl. Ir. H. Juanda No.118, Lebakgede, Kecamatan Coblong, Kota Bandung, Jawa Barat...
Comments posted to this topic are about the item SQL Server Vector Support II
With regard to SQL Server 2025's Vector support, what is an embedding?
See possible answers