Guide to SQL Server Table Indexes (Part 1)
One of the most important tasks for every database administrator (DBA) is to ensure that query times are consistent with...
2013-07-15
1,390 reads
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,523 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,422 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
837 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,135 reads
Blogs
A New Word: Gnossienne
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
Exploring DiskANN: Part I: Understanding the Algorithm before the disk
How I used AI for this postChatGPT to generate images based on info specifically...
Learning Tool – Deepstash
By Brian Kelley
A few months ago I started using Deepstash. Deepstash breaks books into the key...
Forums
Understanding Temp Tables and Table Variables in SQL Server
Comments posted to this topic are about the item Understanding Temp Tables and Table...
The Data API Builder MCP Server Tools
Comments posted to this topic are about the item The Data API Builder MCP...
Collecting Data Is Hard
Comments posted to this topic are about the item Collecting Data Is Hard
Question of the Day
The Data API Builder MCP Server Tools
The Data API Builder MCP Server, v2.x, includes a number of tools. What actions can these tools perform in your database?
See possible answers