SQL Homework – January 2017 – Inspect an Execution Plan
It’s a new year and yet education never ends. So this month let’s take a look at an important part...
2018-01-10 (first published: 2018-01-03)
2,491 reads
Kenneth Fisher
A Solution for Squirrely SQL Server Security: TSQL Tuesday #98
It’s the first T-SQL Tuesday of the year! Arun Sirpal (b/t) is our host this month. Thanks, Arun! The subject...
2018-01-09
300 reads
T-SQL Tuesday #97 – Setting learning goals for 2018
T-SQL Tuesday. Each month a different blogger hosts Adam Machanic’s (b/t) blog party. The host comes up with a topic...
2018-01-01 (first published: 2017-12-12)
1,691 reads
What is impersonation for?
I was doing some research on impersonation the other day, and among other things, I ran across a forum question...
2017-12-27
797 reads
Making music with Powershell
Happy holidays everyone! Ok, this isn’t even remotely related to SQL Server but it sounded fun. I found someone playing...
2017-12-20
960 reads
Restrict the usage of a SQL Server Authenticated Application Id
SQL Server login ids may not be the most secure thing in the world but they are likely to be...
2017-12-18 (first published: 2017-12-06)
1,721 reads
When do usernames and passwords belong in connection strings
tl;dr: When using a windows or active directory authenticated id you do not put the username or password into your...
2017-12-18
703 reads
How to: Create an Azure VM with SQL Server using a default template
One of the really cool things about the cloud is how quickly you can spin up a new machine to...
2017-12-14
526 reads
Closing all of the connections to a database
Doing a database restore may not be the most common task a database professional will ever do, but it’s a...
2017-12-07 (first published: 2017-11-27)
6,079 reads
SQL Homework – December 2017 – View the log
Last homework of the year. Last month was to create a view. This month it’s time to take a look...
2017-12-04
314 reads
Blogs
AI: Blog a Day – Day 6: Embeddings – How AI Understands
By Vinay Thakur
Continuing from Day 5 where we covered notebooks, HuggingFace and fine tuning AI now...
The Book of Redgate: Mistakes
By Steve Jones
This is kind of a funny page to look at. The next page has...
ADF Pipeline Debugging Fails with BadRequest – The Sequel
A while ago I blogged about a use case where a pipeline fails during...
Forums
Dynamic Unpivot
I have a table I didn't design that has tons of repeating groups in...
Writing as an Art and a Job
Comments posted to this topic are about the item Writing as an Art and...
String Similarity II
Comments posted to this topic are about the item String Similarity II
Question of the Day
String Similarity II
What is the range for the result from the EDIT_DISTANCE_SIMILARITY() function in SQL Server 2025?
See possible answers