Dynamic Data Masking in the execution plan
I think Dynamic Data Masking is pretty cool. The idea is basically to provide a mask for certain users when...
2019-02-07
811 reads
I think Dynamic Data Masking is pretty cool. The idea is basically to provide a mask for certain users when...
2019-02-07
811 reads
At first, this statement might sound a bit confusing. Usually, we expect wait statistics to show us what a query...
2019-02-06
211 reads
We occasionally get cool improvements in T-SQL in newer versions of SQL Server. Here’s a short post on some of...
2019-02-05
178 reads
I end up using the bcp utility to move tables between environments, and I’ve found that a lot of the...
2019-02-04 (first published: 2019-01-16)
3,104 reads
A lot of us turn to execution plans when we see a slow running query, and it’s not uncommon to...
2019-02-04
186 reads
I previously wrote about measuring wait statistics. This matters a lot, because you can track historically what wait statistics are...
2019-02-02
366 reads
It depends on where you’re looking and how many statements are in the stored procedure.
Let’s take a look at some...
2019-01-31
495 reads
When you build a brand new shiny SQL Server, you want to get a lot of memory so your queries...
2019-01-31 (first published: 2019-01-18)
2,918 reads
This post will cover the IN clause and another way to rewrite the same logic. I don’t intend to say...
2019-01-29
2,504 reads
This is a blog post about a perennial issue. Have you ever had a call in the middle of the...
2019-01-28 (first published: 2019-01-16)
3,025 reads
In my previous post, I showed you how to build a snapshot backup catalog...
By Steve Jones
Train employees well enough that they could get another job but treat them well...
By Steve Jones
I needed to test a striped backup, so I decided to ask the AI’s...
Comments posted to this topic are about the item Create an HTML Report on...
Comments posted to this topic are about the item Why Data Modelling Still Matters...
Hi when i think of server hops , i think of how kerberos assists...
When I run this code, how many rows are returned?
DECLARE @meals NVARCHAR(1000) = N'夕食昼食朝食' DECLARE @s NVARCHAR(1) = N'食' SELECT value FROM STRING_SPLIT(@meals, @s) GOSee possible answers