Spell-checking dbatools with Visual Studio Code
Earlier this week I was working on adding a new feature to Update-DbaTools and while looking at another cmdlet to check syntax/conventions, I noticed an ugly typo in some...
2017-07-05
26 reads
Blog Posts
SQL Server 2017+ How To Replace Multiple Characters In A Single Statement With TRANSLATE
The REPLACE function in SQL Server has until now been quite limited. SQL Server 2017 has introduced a new TRANSLATE...
2017-07-05
1,907 reads
SSoL–Exiting Root
I don’t think most of us need to know Linux, but if you end up managing a system, it’s good...
2017-07-05
596 reads
The Three A’s: Authentication
When I start talking with folks about security, one of the areas of confusion I often find has to do...
2017-07-05 (first published: 2017-06-26)
1,831 reads
When do Distribution Statistics Get Updated?
Statistics objects are important to us for allowing SQL to make good estimates of the row-counts involved in different parts...
2017-07-05
784 reads
Celebrate Your Independence with Free Tools
Been working on this blog post for a while, thought I'd share today an inventory of tools I use regularly...
2017-07-04
775 reads
How to Automatically Purge Historical Data From a Temporal Table
Watch this week's video on YouTube
Temporal Tables are awesome.
They make analyzing time-series data a cinch, and because they automatically track row-level history, rolling-back from an "oops" scenario doesn't mean...
2017-07-04
38 reads
Loading All CSV Files with PowerShell
I ran across Denis Gobo’s post about working with names from Social Security cards and wanted to play with the...
2017-07-04 (first published: 2017-06-23)
2,219 reads
Reflecting on the Last Year of Microsoft’s OpenSource Technologies
This past year has certainly been interesting in the world of Linux. Microsoft has taken a new strategy and is...
2017-07-04 (first published: 2017-06-24)
1,642 reads
24 Hours of PASS, Summit Preview Session
I’m proud to announce that I’ve been selected to present a session in this year’s 24 Hours of PASS: Summit...
2017-07-03
349 reads
Blogs
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
When Your Microsoft Fabric Capacity Runs Out: Optimize, Scale Up, Scale Out, or Isolate?
By James Serra
Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform....
Forums
The New World Of AI Robots
Comments posted to this topic are about the item The New World Of AI...
Logic question in a WHERE clause using IIF?
Thanks in advance, I'm trying to avoid using IIF for performance reasons, but the...
Execute as failure
Security has long been a problem for me. Every time I think I understand...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers