Duplicate Statistics
The Setup:
Standard best practise is to have auto create and auto update statistics set for SQL Server databases. But there...
2013-09-03 (first published: 2013-08-28)
3,526 reads
VMware vSphere 5.5 details trickling out
VMworld 2013 is this week in San Francisco, and some exciting details about the next version of the vSphere suite,...
2013-08-28
564 reads
Winner of the worst recruiter of the year!
Every week I get a bunch of emails from recruiters about jobs that I am not qualified for (see Low-rate...
2013-08-27
1,147 reads
Check Your Azure Account Usage
It is absolutely not cool or fun to pay money to learn new technology. One of the main complaints people...
2013-08-27
789 reads
SharePoint SSRS “The permissions granted to user ‘Domain\User’ are insufficient for performing this operation”
Not too long ago I ran into a crazy situation where just about everything that could have gone wrong with...
2013-08-27
1,578 reads
How to Tell If Your Users are Connecting to the Availability Group Listener
You've spent a lot of time planning and building out a new SQL Server 2012 environment complete with Availability Group...
2013-08-29 (first published: 2013-08-27)
2,429 reads
Query Stats
DBAs rarely use the full potential of sys.dm_exec_query_stats. It’s common to see the queries for looking at the most expensive...
2013-09-04 (first published: 2013-08-27)
3,760 reads
A Rickety Stairway to SQL Server Data Mining, Part 14.2: Writing a Bare Bones Plugin Algorithm
By Steve Bolton
…………As I’ve said many times throughout this series of amateur mistutorials, SQL Server Data Mining (SSDM) is one...
2013-09-02 (first published: 2013-08-26)
2,777 reads
SQL – Identify & Drop Duplicate Index
This post explains the simple steps to identify a duplicate indexes in all the databases. The duplicate index are more than...
2013-08-26
892 reads
SQL Saturday 223 OKC
This past weekend I made the relatively short (about 3 hours) trip to the Oklahoma City area to attend and...
2013-08-26
812 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