Speaking: PowerHour, August 21st 2018
It’s official! I will be speaking at the inaugural PowerHour online lightning demo event on Tuesday, August 21st at 2200 UTC. I’ll be demoing Better, Safer SQL Queries from...
2018-08-14
FLX SQL
A Day in the Life (1/?) - August 7, 2018
This is my first installment in (I hope) a series responding to Steve Jones’s (blog|twitter) #SQLCareer challenge. I decided to jot down most of what I did through the...
2018-08-08
1 reads
PowerHour - Online PowerShell Lightning Talks!
Earlier this week, the PowerHour was announced. What is it? It’s kind of like a virtual user group. One hour, 6(ish) lightning demos (10 minutes or less), centered on...
2018-08-03
2 reads
T-SQL Tuesday #104 - Code You Would Hate To Live Without
This month’s T-SQL Tuesday is hosted by Bert Wagner and he asks us to write about code we’ve written that we would hate to live without.
First off, “hate” is...
2018-07-10
4 reads
Volunteer for PASS!
This week, I had the opportunity to be the moderator for Joseph Barth’s (blog|twitter) 24 Hours of PASS Summit Preview session about Azure Data Factory V2. It was fun,...
2018-06-15
Becoming a Production DBA - A Family Decision
I really enjoy my job. I became a full-time production DBA about 14 months ago and it has been an overwhelmingly positive move. I work for a good company...
2018-06-06
Triggers vs. Default Constraints: Choose Wisely
Triggers can be really useful in your database but you have to be careful with them. We often use them to record history to a separate table (at least,...
2018-05-29
4 reads
Quick Table Info Export with PowerShell
This week I had a user come to me asking about how fields were defined on a few tables he was using in writing some reports. Long story short,...
2018-05-18
3 reads
Processing SQL Saturday Raffle Tickets with PowerShell
Every year, I spend the Sunday after SQL Saturday Rochester scanning & processing raffle tickets for our wonderful sponsors. Here’s how the system works:
Attendees get tickets (one ticket per...
2018-04-10
4 reads
Appearance: SQL Data Partners Podcast
A couple weeks ago Carlos L. Cachon (blog|twitter) put out a call on Twitter looking for SQL Saturday organizers to join him on the SQL Data Partners Podcast. When...
2018-03-08
Blogs
SQL Saturday Atlanta BI Recap
By DataOnWheels
https://sqlsaturday.com/2025-03-08-sqlsaturday1102/#schedule SQL Saturday Atlanta BI is one of my favorite SQL Saturdays of the...
Mistakes IT Shops Without a DBA Make
By Kevin3NF
We get it. There’s no budget for a DBA on staff, or even a...
A New Word: Waldosia
By Steve Jones
waldosia– n. a condition in which you keep scanning faces in a crowd looking...
Forums
Dynamic T-SQL Script Parameterization Using Python
Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...
SQL 2017 server keeps locking up
I manage a two-node production SQL cluster running SQL Server 2017 CU31 on Windows...
Alternatiives to Junk Dimensions
Hello SSC, I am not sure if I posted this in the right spot,...
Question of the Day
Partial Backups II
What is a partial backup for a read-write database?
See possible answers