White papers, DMVs and Monitoring Concepts
According to Jason Strate (SQL Server MVP) there are 5 white papers ever SQL Server DBA should read. Considering my...
2013-06-01
1,014 reads
Simple SQL Server
Blocking – Capturing and Monitoring
If a query is taking longer to run than normal, there’s a good chance it’s being blocked by something else....
2013-05-22
684 reads
Wait Stats – Monitoring and Using
sys.dm_os_wait_stats is one of the most important DMVs out there, and one that you should know the historical values of...
2013-05-21
1,838 reads
Indexes – Understanding basic types and their components
The biggest problem developers and newer DBAs have with understanding indexes is that you don’t realize when you’re using the...
2013-05-18
1,455 reads
Indexes – Unused and Duplicates
Indexes aren’t free, and many databases end up with unused indexes. Every time you make any update to a table...
2013-05-16
1,726 reads
Job Schedules – SQL Agent
This info should be easier to get than it is. Keep in mind that for something to run the subscription...
2013-05-15
1,318 reads
Roll Logs – Backup Recovery
Rolling log files for a day, especially with 15 or even 5 minute log backups is a pain at best....
2013-05-20 (first published: 2013-05-15)
2,022 reads
Table Sizes
There’s no simple way in SQL Server to see the sizes of all the tables and their indexes. Even seeing...
2013-05-15
654 reads
Index Columns and Names
Don’t trust the name of an index to tell you what it is. The name is wrong, or at least...
2013-05-14
1,502 reads
Running Processes
Sp_who2 is not used by this DBA. That info is amazingly good to have, but I want more. Don’t get...
2013-05-14
861 reads
Blogs
Identity Columns Can’t Be Updated: #SQLNewBlogger
By Steve Jones
I’m not sure I knew identity column values could not be updated. I ran...
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Forums
Can someone please explain what happens?
I have mentioned this several times over several years. Can someone please help me...
SELECT COUNT(DISTINCT) returns null when nothing is found instead of 0
SELECT COUNT(DISTINCT Component) AS Found FROM tblComponents WHERE(Component NOT LIKE '%[a-z]%') AND(LTRIM(RTRIM(Component)) = 'GM13622')...
Remotely Engineer Fabric Lakehouse objects: The Fabric Modern Data Platform
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
Question of the Day
Creating JSON III
In a SQL Server 2025 table, called Beer, I have this data:
BeerIDBeerName 1Becks 2Fat Tire 3Mac n Jacks 4Alaskan Amber 8KirinI run this code:
SELECT JSON_OBJECTAGG(
BeerID: BeerName )
FROM beer;
What are the results? See possible answers