Understanding SQL Server Query Optimization Statistics
SQL Server query optimizer uses statistics to create query plans that improve query performance. For most queries, the query optimizer...
2013-07-15
1,524 reads
Microsoft SQL Server security best practices checklist
SQL Server is a repository of sensitive information for organizations, and that is why it is important to ensure that...
2013-07-15
3,424 reads
Understanding SQL Server Database Restore Process
Data is a critical asset for an organization to keep information about their customers, inventory, products, purchasing, and financial stocks....
2013-07-15
700 reads
SQL Server Database Backups and Recovery Models – (Part 3)
Checkout the part-3 of my three part article series on SQL Server Database Backups and Recovery Modelshere, in which I discussed...
2013-07-15
742 reads
SQL Server Database Backups and Recovery Models – (Part 2)
Checkout the part-2 of my three part article series on SQL Server Database Backups and Recovery Modelshere, in which you’ll learn...
2013-07-15
934 reads
A Tale of Two Hotels
This is a long and convoluted post about my experiences at two hotels, but it has a point for DBAs...
2013-07-15
838 reads
Last Weeks Top “Reading” Links #41
For those that follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet out some links of...
2013-07-15
616 reads
New Hebrew SQL Server Podcast
Five months ago, I wrote a post about my love for Podcasts.
At some point, I started to think about starting...
2013-07-15
1,082 reads
SSAS Joining Facts at Different Granularities
In an SSAS cube you sometimes need to connect a dimension at a different granularity than other dimensions. For example,...
2013-07-19 (first published: 2013-07-15)
2,136 reads
Scripting a partitioned table or index, a caution.
I was researching a problem with a partitioned table that had somehow become unpartitioned and discovered something rather interesting.
First here...
2013-07-22 (first published: 2013-07-15)
2,561 reads
Blogs
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Tell It Once: Setting Up Claude With Skills and MCP Servers
By ReviewMyDB
Many of us use AI the same way every single day. Open a tab....
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident
By SQLPals
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident SQL...
Forums
does anyone used https://github.com/ktaranov/sqlserver-kit
Could you please let me know if anyone is used https://github.com/ktaranov/sqlserver-kit github for deployment...
How Can Database Performance Improve the Overall Website Experience?
I’ve been looking into ways to improve the connection between a website and its...
When And How to Automate?
Comments posted to this topic are about the item When And How to Automate?
Question of the Day
Hyperscale Replicas II
How many Azure SQL DB Hyperscale HA replicas can be configured as of Sept 2026?
See possible answers