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
5 reads
FLX SQL
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
9 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
1 reads
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
2 reads
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
21 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
7 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
6 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
3 reads
T-SQL Tuesday #99 - Dealer's Choice / sqlibrium
This month’s T-SQL Tuesday from Aaron Bertrand gives us a choice:
Life beyond the technical in a search for what Drew with the Burdensome Name calls #sqlibrium Your own T-SQL...
2018-02-13
2 reads
PASS Summit 2017 Wrap-Up - The People!
I need a new social media profile picture.
That’s one of the most important (non-technical) conclusions I drew from my week at PASS Summit 2017. It seemed like everywhere I...
2018-02-05
4 reads
Blogs
Upgrading SQL Server Containers on the Laptop
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
How to Find Expensive Queries in Amazon Redshift
Slow-running queries can degrade your Redshift cluster’s performance and lead to increased costs. Identifying...
The Notification Trap: How Input Fatigue Is Killing Deep Work in Tech
By gbargsley
If you've been here before, you know this blog is usually about SQL Server,...
Forums
SQL 2019 instance with AG, across 2 Windows 2016 OS servers - OSin-place upgrade
Hi all Can I get some perspective from the community please on performing in-place...
How Long is a Long I/O?
Comments posted to this topic are about the item How Long is a Long...
T-SQL Trigonometric Functions in SQL Server
Comments posted to this topic are about the item T-SQL Trigonometric Functions in SQL...
Question of the Day
How Long is a Long I/O?
In SQL Server 2025, a long I/O is recorded in the error log with message 833. How long much an I/O request be outstanding before this message is written to the log?
See possible answers