Stretch Databases in 60 seconds
SQL Server 2016 introduces Stretch Databases, a beautiful feature that by itself makes migrating to SQL 2016 worth it. What...
2016-10-12
227 reads
Webcast Tomorrow: Building an Auditing Framework for SQL Server
Faced with auditing SQL Server on a regular basis with no 3rd party tools? Where do you start? That’s what...
2016-10-12
447 reads
The Snippet Manager in SQL Prompt
I love SQL Prompt, since it makes T-SQL coding quicker and easier. One of the handiest things is the Snippet...
2016-10-12
723 reads
So Long, Farewell, I Hate to Say Goodbye
The Sound of Music is one of my all time favorite movies. It reminds me of some great times with...
2016-10-12
521 reads
An Update on My 2012 Mac Air
Typically I want to get 3 years out of a laptop to amortize spending on a premium grade machine. I’m...
2016-10-12
434 reads
Diff All Files - Reviewing Changesets Quickly
If you need to do code comparison on a lot of files in Visual Studio, I ran across an extension...
2016-10-12
817 reads
SQL Live Health Check - part 3 - permission requirements and the rest
This is the last part of the series, where I discuss about the monitoring application that I build. If you...
2016-10-12
1,311 reads
T-SQL Tuesday #83: Resource Governor CAP_CPU_PERCENT: It just runs faster?
Welcome to T-SQL Tuesday #83 being hosted this month by Andy Mallon (blog|@AMTwo). This month’s topic is “We’re still dealing...
2016-10-11
707 reads
Connect to SQL Azure database from SSMS
In this article I’ll show you how to connect to SQL Azure database instance and create a simple database. First you have to own an Azure account. In the account you...
2016-10-11
4 reads
Connect to SQL Azure database from SSMS
In this article I’ll show you how to connect to SQL Azure database instance and create a simple database. First you have to own an Azure account. In the account you...
2016-10-11
16 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