SQL Server Diagnostic Information Queries for November 2013
I have made a number updates and bug fixes, including some additional columns in some of the queries for all...
2013-11-15
1,158 reads
Use application lock to synchronize T-SQL code
Application lock can be used to synchronize T-SQL code, you can control if the session is able to run the...
2013-11-15
5,061 reads
Reblog: November 8 to November 14
I’ve always been a fan of the feeling when I find an old blog post that’s got just the information...
2013-11-15
757 reads
Friday Followup For November 15, 2013
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2013-11-15
482 reads
A Tour of the Transaction Log: Part 3 Reading Log Backups
In part one and two of our Tour of the Transaction Log articles we focused on reading events from the...
2013-11-15
1,479 reads
Checking your users and groups in Command Window.
As a DBA, I work closely with the Infra guys to manage domain accounts. Now and then, there comes a...
2013-11-15
527 reads
Fill Factor, Why Do You Taunt Me? Part 1
Like all the arbitrary numbers we hear in the SQL community such as the 30% fragmentation and 1000 pages. These...
2013-11-15
747 reads
Powershell in a Month – Day 2, Help
This is part of my Powershell Challenge, to learn more about Powerhsell (PoSh) using the Learn Windows Powershell 3 in a...
2013-11-14
1,251 reads
Compare tables to find missing rows
Let’s talk about the case where you want to compare tables to see what’s missing. We might be comparing a...
2013-11-14
923 reads
VMware vCPU Ready Time Equivalent in Hyper-V
Jonathan Keyahias (b | t | l) from SQLskills has released a new blog post outlining the metric that Microsoft’s Hyper-V product...
2013-11-14
1,017 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