Audit data using SQL Server 2005's COLUMNS_UPDATED function
Auditing data changes in your production environment is very important, especially if you are dealing with confidential information.
Auto generated SQL Server keys - uniqueidentifier or IDENTITY
I'm designing a table and I've decided to create an auto-generated primary key value as opposed to creating my own scheme or using natural keys. I see that SQL Server offers globally unique identifiers (GUIDs) as well as identities to create these values. What are the pros and cons of these approaches?
36 Changes
Agile, or maybe even hyper-agile. Steve Jones talks about some challenges in the web 2.0 world.
Fast Project Rollbacks
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.
A Virtual Database World
Steve Jones talks about virtualization with databases, but not in the way you might think.
A Virtual Database World
Steve Jones talks about virtualization with databases, but not in the way you might think.
A Virtual Database World
Steve Jones talks about virtualization with databases, but not in the way you might think.
Filtered Indexes in SQL Server 2008
This article demonstrates the performance improvements that can be achieved using Filtered Indexes in SQL server 2008
Tips for tuning SQL Server 2005 to improve reporting performance
We are required to report from our SQL Server 2005 database. There are five or six tables regularly used for holding the reporting data, but these tables have five-to-seven million rows of data in them already. We need to use these tables consistently and our performance involving reporting is struggling. Do you have any tips to help improve it?
Data Ownership
Sometimes determining who owns the data or information isn't that easy. Steve Jones has an example from the US election in 2008.
Blogs
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them Introducing PlanTrace — a free, browser-based...
A Cloud Dependency Failure from Amazon
By Steve Jones
I went to sleep while reading a Kindle book on my phone. I know...
Deploying AI in logistics (the unfiltered version)
A conversation with Jan Laš, CIO at HOPI, about what deploying a data agent...
Forums
SPAM Issues May 2026
We suffered a SPAM attack from May 1-6, which unfortunately corresponded with time off...
SQL Password enforcing
Hi to all We have situation at a client where someone is illegally changing...
SQL Password enforcing
Hi to all We have situation at a client where someone is illegally changing...
Question of the Day
Creating a JSON Document III
I have this data in a table called dbo.NFLTeams
TeamID TeamName City YearEstablished ------ -------- ---- --------------- 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960 5 49ers San Francisco 1946 6 Broncos Denver 1960 7 Seahawks Seattle 1976 8 Patriots New England 1960If I run this code, how many rows are returned?
SELECT TOP 2
json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers