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)
989 reads
Daniel Janik
It’s 2020, Do I really need to DBCC CHECKDB?
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,544 reads
Database classifications have changed
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)
999 reads
Deploy BACPAC to Azure Managed Instance failing from SSMS?
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)
287 reads
Tech Chat with a Microsoft MVP Data Platform
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
31 reads
Why is the XLOCK table hint broken?
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)
458 reads
Azure Data Studio extension – help wanted
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
75 reads
Quick tip: Quickly bulk edit lines in SSMS
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,087 reads
Taking a gamble on Azure Data Studio Notebooks
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
90 reads
I’ve added data classifications. Now what?
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
Blogs
Overcoming Imposter Syndrome: A Plan
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
Advice I Like: Celebrate Success
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Forums
BCA KCP Morowali Telp:Cs.08216977726
Whatsapp:08216977726 Jl. Trans Sulawesi, Keurea, Kec. Bahodopi, Kabupaten Morowali, Sulawesi Tengah 94974
BCA KCP Kertopaten Telpon. 083135766741
WhatsApp 083135766741 Jl. Pegirian No.114, RT.007/RW.10, Sidodadi, Kec. Simokerto, Surabaya, Jawa Timur 60145
BCA KCP Kas Palu Barat Telp:Cs.083831618816
Whatsapp:083831618816 Jl. Sungai Malei No.35, Ujuna, Kec. Palu Bar., Kota Palu, Sulawesi Tengah 94111
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers