Software Review: Idera’s Virtual Database
Ever since the upgrade from SQL Server 6.5 to 7.0 one of the most requested features I’ve heard people complain...
2010-09-21
3,184 reads
September PASSMN Meeting Tonight
As I’ve mentioned a couple times already our PASSMN meeting tonight will be in a new location. This is a ...
2010-09-21
444 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
Table Variables and Transactions
I actually had a question of the day submitted on SQLServerCentral about table variables and transactions, but the person didn’t...
2010-09-21
9,363 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
SQL Saturday 50 (#sqlsat50) – A Tale
This past weekend I went to SQL Saturday 50 – this is a day long SQL training event that is put...
2010-09-21
829 reads
SSAS - Defining Attribute Relationships in 2005 and 2008
Attribute relationships inside of Analysis Services are a critical piece to the design of your dimensions.The benefits of creating attribute...
2010-09-20
1,600 reads
What Do You Think Just Happened To This Database Server?
This is a screenshot of Task Manager for a database instance that is part of a synchronous database mirroring partnership...
2010-09-20
1,191 reads
Most SQL Server DBAs Still Don’t Know About Instant File Initialization
In my most recent poll, I asked DBAs if they have turned on instant file initialization on their SQL Servers....
2010-09-20
905 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