PASS Elections – Improving the Process
Since there has been a bit of a furor over the PASS election process the past 2 years I thought...
2010-09-23
481 reads
Blog Posts
Braindumps and Certification
I saw a post recently that said that braindumps were the best way to prepare for certifications. It was posted...
2010-09-22
1,889 reads
Index Black Ops Part 3 – Index Usage
Last week, I mentioned in my TSQL2sDay index summary post, that I’d be writing a few posts on the information...
2010-09-22
1,467 reads
Microsoft Releases SQL Server 2008 SP1 Cumulative Update 10
On September 21, 2010, Microsoft released SQL Server 2008 SP1 Cumulative Update 10, which is Build 2799. I count 29...
2010-09-22
1,298 reads
Range locks do not only occur in Serializable transactions....
According to BOL, "Key-range locks protect a range of rows implicitly included in a record set being read by a...
2010-09-22
1,050 reads
Updates on SQLSaturday#59 in NYC
Hi, ALL: Just want to bring you some updates and news on SQLSaturday#59 @MS HQ in NYC on Nov 20, 2010. ...
2010-09-22
646 reads
Why You Should Come to SQL Saturday #48 - Columbia, SC
SQL Saturday #48 is on October 2. We're offering free SQL Server and PowerShell training from some great names in...
2010-09-22
945 reads
Instant File Initialization – Is it Turned On?
I have posted a short note on instant file initialization previously, that post can be found here. The crux of...
2010-09-21
1,730 reads
On Vacation
I’ve hit that point where it feels like I need to work longer and harder to keep up, which is...
2010-09-21
583 reads
Putting Priorities into Practice
Yesterday I posted a review on the book Choosing to Cheat. I had begun putting some of the principles into...
2010-09-21
904 reads
Blogs
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...
New article – migrating from a named instance
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
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