SQL Server Storage Internals Part 5 - Properties of Clustered and Non Clustered Index pages
In this article, I thought of explaining different types and levels of index pages. but while start preparing for that, I realise...
2010-12-27
9,558 reads
PBM and PowerShell
The best new management feature added to SQL Server 2008 is Policy Based Management or PBM. PBM allows DBAs to...
2010-12-25
2,381 reads
Merry Christmas
This is just a short post for a Friday and not just any old Friday either, Santa is on his...
2010-12-24
567 reads
Server Side trace
Most of us are aware of tracing queries using SQL profiler. But an effective way of performing tracing is using...
2010-12-24
517 reads
Get SQL Scripts Manager for Free
Red Gate Software has released a new, free tool for database administrators and developers called SQL Script Manager. It includes...
2010-12-23
747 reads
PASS Summit 2010 Session Eval Results
Speakers and bloggers alike crave feedback (good or bad) so I was excited to see my session evaluations from the...
2010-12-23
1,055 reads
SQL Bits 8
It seems the dates for the next SQLBITS have been released will take between April the 7th and April 9th...
2010-12-23
510 reads
PASS Summit Speaker Evals – THE ANALYSIS
Rule: No Sushi with Adam within 24 hours of session
I’m inspired by Brent Ozar‘s and Andy Leonard‘s sharing of their PASS...
2010-12-23
795 reads
PASS Summit 2010 Survey Results
As I have done in previous years, I’m going to post the results from my sessions at the PASS Summit....
2010-12-23
804 reads
Filling in Data Potholes with Recursive CTEs
Data: it can break your foot.
Imagine that you are writing a script that looks at data grouped by the minute....
2010-12-23
1,162 reads
Blogs
T-SQL Tuesday #204 – Are blogs still relevant?
By DesertDBA
Note: This post is the invitation for T-SQL Tuesday #204 on November 3rd, 2026....
A Front Door for the DBA Team – AgentDBA UI
By Arun Sirpal
AgentDBA began as a command line. That suits one DBA on one server, but...
Cleaning Up Azure MS Defender Billing
By Steve Jones
I have a few Azure subscriptions, which are fairly small and not used that...
Forums
SQL Server Vector Support II
Comments posted to this topic are about the item SQL Server Vector Support II
Great Things
Comments posted to this topic are about the item Great Things
Troubleshooting Slow Queries That Already Have an Index
Comments posted to this topic are about the item Troubleshooting Slow Queries That Already...
Question of the Day
SQL Server Vector Support II
With regard to SQL Server 2025's Vector support, what is an embedding?
See possible answers