Finding New Employment
You can find new employment with a little work and choose the best job for you.
2022-05-07
111 reads
Editorials
2022-05-06
71 reads
Project Zero for Better Security
Project Zero from Google aims to study zero day vulnerabilities. Steve hopes it leads to better security.
2022-05-04
91 reads
2022-05-02
85 reads
What will convince you to upgrade?
You’ve probably heard that SQL Server 2022 is on the way, and, assuming the name doesn’t change, it will be later this year. That is great news for folks in the data platform community as features and improvements they’ve been hoping for are added. I’m not currently supporting any production SQL Servers, but I’m still […]
2022-04-30
93 reads
Gathering Data Through Life
Every once in a while, I find a list of places posted on the Internet with a "how many have you visited?" question attached. This might be US states, countries, cities, or even attractions. I love traveling with my wife and having new experiences, and as we've gotten older, we value the experiences more than […]
2022-04-29
96 reads
Migrating a Large Database
Large database upgrades are stressful, but a little planning and practice can help things go smooth.
2022-04-27
169 reads
The Craziness of Code
Building software can seem like a crazy process, especially to a developer who joins a project.
2022-04-25
183 reads
Scripting Makes Mistakes Easier Than Ever
A major outage from Atlassian because of a bad script has Steve thinking about the challenges of recovering from mistakes. When we are making changes to portions of our data and we need to plan for mistakes to occur and ensure we can restore the data.
2022-04-22
170 reads
Using T-SQL over PoSh
When do you choose to use one tool or language over another. Steve discussed T-SQL vs. PowerShell.
2022-04-20
143 reads
Blogs
Scary Scalar Functions - Part Two: Performance
By Zikato
Scary Scalar Functions series overview Part One: Parallelism Part Two: Performance Foreword In the second part of this...
Goal Progress for June 2022
By Steve Jones
I set goals at the beginning of the year, and I’m tracking my progress...
Using Sessionize for Your User Group – Part 2
Now that your CFS has been setup it’s time to get the word out...
Forums
Put result of one query into another
Hi all! I have to do this 177 times more, and it must be...
Add a column with default value
Hi guys I have a query with a SELECT statement, that joins 2 other...
Help with Pivoting Table
Hi all, Can someone please help Pivot a table. The table currently looks like...
Ask SSC