Watch this week's video on YouTube
How many times have you had to transform some column value and ended up stacking several nested SQL REPLACE() functions like this?
-- Input: Red,...
2017-08-15
15 reads
This post demonstrates one of the ways to gather an inventory of database backup information. The output of the script...
2017-08-15
441 reads
I mentioned in my previous post about manually updating statistics that you can specify whether they’re updated using a full...
2017-08-23 (first published: 2017-08-15)
1,498 reads
Lots of people are confused by how to deal with bad parameter sniffing when it occurs. In an effort to...
2017-08-15
210 reads
Lots of people are confused by how to deal with bad parameter sniffing when it occurs. In an effort to...
2017-08-24 (first published: 2017-08-15)
2,359 reads
I recently wrote a post about using Transparent Data Encryption (TDE) with Azure Key Vault as an alternative to managing certificates. Today’s post will explore using SQL Server’s Always...
2017-08-15
183 reads
I recently wrote a post about using Transparent Data Encryption (TDE) with Azure Key Vault as an alternative to managing...
2017-08-23 (first published: 2017-08-15)
2,218 reads
Don’t you want to go to the single largest collection of Microsoft Data Platform professionals and developers on the planet?...
2017-08-14
179 reads
Don’t you want to go to the single largest collection of Microsoft Data Platform professionals and developers on the planet?...
2017-08-14
477 reads
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2017-08-14
980 reads
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
Hello We recently encountered an issue where a SQL table unexpectedly grew in size...
Comments posted to this topic are about the item The New World Of AI...
Thanks in advance, I'm trying to avoid using IIF for performance reasons, but the...
What does this return on SQL Server 2025?
select bit_count(null)See possible answers