SSMS Quick Tip
Today’s quick tip is for SQL Server Management Studio (SSMS). From time to time when I’m speaking I’ll get a question on how I pulled up help for a...
2020-05-14 (first published: 2020-04-30)
987 reads
Today’s quick tip is for SQL Server Management Studio (SSMS). From time to time when I’m speaking I’ll get a question on how I pulled up help for a...
2020-05-14 (first published: 2020-04-30)
987 reads
I’ll start by saying that I swear I posted this at some point in the past but I don’t see it looking back at old posts. This is from...
2020-04-27 (first published: 2020-04-15)
1,541 reads
Some time back I wrote about the new data classification features in Azure and SQL Server Management Studio. If you’ve done quite a bit of work classifying your data...
2020-04-24 (first published: 2020-04-11)
996 reads
Recently I ran into an error when trying to copy a small database bacpac into an Azure Managed Instance. It’s said that SSMS is able to do this task....
2020-04-16 (first published: 2020-04-03)
286 reads
I figured it would be nice to start up a weekly chat while everyone is on lock down. If it goes well I’m up to make this a regular...
2020-04-16
29 reads
Let’s talk about what XLOCK is supposed to do. XLOCK is a table hint that can be applied to a query to place an exclusive lock on the resources...
2020-02-20 (first published: 2020-02-12)
456 reads
I’ve created a sample ads extension that checks TSQL syntax in real-time for potential bad practice. Right now the extension is using regex, which isn’t the best for parsing...
2020-02-13
74 reads
Have you ever needed to bulk edit a table from excel to change it into a group of insert statements or change multiple query lines? In SQL Server Management...
2020-02-12
4,005 reads
If you’re a data professional or application developer chances are you’ve run into Microsoft SQL Server once or twice. I would think that the majority of SQL Server professionals...
2019-05-30
89 reads
About a year ago I wrote about a new feature in SSMS that allows you to add a data classification...
2019-03-08 (first published: 2019-02-20)
2,539 reads
By Brian Kelley
If you want to learn better, pause more in your learning to intentionally review.
By John
If you’ve used Azure SQL Managed Instance General Purpose, you know the drill: to...
By DataOnWheels
Ramblings of a retired data architect Let me start by saying that I have...
Hi everyone, Below is a consolidated summary of what we validated Architecture & data...
Hi all, I recently moved to a new employer who have their HA setup...
Comments posted to this topic are about the item Semantic Search in SQL Server...
I have this data in a SQL Server 2025 table:
CREATE TABLE Response ( ResponseID INT NOT NULL CONSTRAINT ResponsePK PRIMARY KEY , ResponseVal VARBINARY(5000) ) GOIf I want to get a value from this table that I can add to a URL in a browser, which of these code items produces a result I can use? See possible answers