T-SQL Tuesday #081: Sharpen Something – Reminder
This month I am asking you to not only write a post but to do a little homework - first. In other words, plan to do something, carry out...
2016-08-02
17 reads
Blog Posts
Azure SQL Database Live Migrations
Unfortunately, with Azure SQL Database you are not able to take an existing SQL Server Backup and restore it on...
2016-08-01 (first published: 2016-07-26)
2,270 reads
Azure SQL IaaS – TempDB Performance on SSD vs Premium Disk
[read this post on Mr. Fox SQL blog]
When it comes to deploying SQL Server onto an Azure IaaS VM, it is sometimes difficult...
2016-08-01 (first published: 2016-07-26)
3,228 reads
Easily Shred Event Data
Parsing XML is the epitome of salt in a wound for a DBA. Parsing the XML from Extended Events need not be so painful. Read further to discover how...
2016-08-01
30 reads
Index-Cheat-Sheet. The complete Index-compatibility Matrix for SQL Server
(DE)
Mit dem Aufkommen der Columnstore Technologie und auch der In-Memory Technologie in SQL Server 2014 sind insgesamt 4 neue...
2016-08-01
675 reads
Index-Cheat-Sheet. The complete Index-compatibility Matrix for SQL Server
(DE) Mit dem Aufkommen der Columnstore Technologie und auch der In-Memory Technologie in SQL Server 2014 sind insgesamt 4 neue Indextypen zu den althergebrachten page-basierten hinzugekommen.
Wo es früher nur...
2016-08-01
12 reads
Monday Morning SQL Break – August 1, 2016
It’s Monday and time for this week’s blog and twitter round-up for last week. If you haven’t already, follow me...
2016-08-01
880 reads
Monday Morning SQL Break – August 1, 2016
It’s Monday and time for this week’s blog and twitter round-up for last week. If you haven’t already, follow me on twitter (@StrateSQL). This is a good chance to...
2016-08-01
9 reads
Power BI Custom Visuals Class (Module 10 – Card with States)
In this module you will learn how to use the Card with States Power BI Custom Visual. The Card with...
2016-08-01
1,218 reads
SQL Server Indexing Book Giveaway – Part 7
More of the same with the next Expert Performance Indexing for SQL Server book giveaway. So far, I’ve sent out six copies of the book based on comments from the past six (1, 2,...
2016-08-01
20 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