What is the database property “Compatibility Level”
What is the database property Compatibility Level? I don’t get asked to write about specific subjects very often but in...
2015-07-08
672 reads
SQLStudies
Adding a new keyboard shortcut in SSMS.
I love keyboard shortcuts. I’d rather keep my hands on the keyboard than move back and forth to the mouse....
2015-07-13 (first published: 2015-07-06)
2,751 reads
Blocking and deadlocking on purpose
Blocking and deadlocking are not things you typically want to do deliberately. But sometimes you need to test error handling...
2015-07-07 (first published: 2015-07-01)
2,589 reads
Zero to Speaker pt 2
A few months ago I wrote a post about the fact that I had actually submitted a session to PASS...
2015-07-03 (first published: 2015-06-29)
1,712 reads
Which user function do I use?
Earlier this week I was scripting out a table with some legacy columns (InsertDate and InsertBy for example). If you...
2015-06-30 (first published: 2015-06-24)
2,091 reads
Copying a TDE database from one instance to another
I got my first real world experience with a TDE (transparent data encryption) database recently. For those who don’t know...
2015-06-22
921 reads
Pass TV
Recently Adam Machanic (b/t) was telling me about an interesting effect of the top operator. When I asked for an...
2015-06-17
668 reads
Rename a database
Renaming a database isn’t something you do frequently but it does have bit of a gotcha. First of all let’s...
2015-06-15
610 reads
Modifying the “New Query” template.
TLDR; Search for and modify the sqlfile.sql file.
During a recent T-SQL Tuesday Boris Hristov (b/t) taught me about SET NOEXEC...
2015-06-23 (first published: 2015-06-11)
3,115 reads
A walk-through of creating the Activity Tracking template using Extended Events.
It’s the second Tuesday of the month and that means T-SQL Tuesday time! T-SQL Tuesday is a blog party started...
2015-06-15 (first published: 2015-06-09)
2,333 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
When the Token Meter is Zero
Comments posted to this topic are about the item When the Token Meter is...
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...
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