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,920 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
598 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,833 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
787 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
777 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
45 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,223 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,643 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
Creating a Local Model Chatbot on Windows
By Steve Jones
After my session at VSLive last week, I had a few questions from the...
To refer and to be referred
Referrals have never been more important in the job market. They’re no longer nice...
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Forums
Querying Multiple Tables for the Same Information
I have about 100 Tables that are all suffixed with _Modify. These tables record...
Make It Routine
Comments posted to this topic are about the item Make It Routine
Finding Gaps in Sequential Data Using SQL Server
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
Question of the Day
Negative and Positive Numbers
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers