T-SQL Tuesday #113 -A Database for the Great Outdoors
This month’s T-SQL Tuesday comes from Todd Kleinhans (blog | twitter) who wants to know what we’re doing with databases outside of work.
I’m curious- outside of work and...
2019-04-09
6 reads
FLX SQL
T-SQL Tuesday #112 - The Cookie Jar
This month’s T-SQL Tuesday comes from Shane O’Neill (blog | twitter). He starts us off with this:
Dipping into the Cookie Jar is about when the going gets tough and...
2019-03-12
8 reads
Speaking
A place to collect abstracts & links to presentations I’ve given. Please be sure to check out my Sessionize profile as well.
Backup Basics with PowerShell and dbatools Abstract As...
2019-03-09
5 reads
Speaking: Rochester SQL Server User Group March 2019
Probably a bit late getting this posted but I will be speaking at the March 5, 2019 meeting of the Rochester SQL Server User group (RSVP link). I don’t...
2019-03-04
3 reads
One Peril of Database Proliferation
By now many of us have upgraded from SQL Server 2008R2 and we’re on the “regular Cumulative Updates” train now. For the rest, it’ll (hopefully) happen soon. And since...
2019-02-26
9 reads
Appearance: SQL Data Partners Podcast #161
Carlos Chacon (twitter) was kind enough to have me back on the SQL Data Partners Podcast to talk about my experiences with managing 8000 databases on a single instance...
2019-02-21
6 reads
Tidier PowerShell Scripts with Default Parameter Values
I was recently working on a PowerShell script to set up some new databases for my users and found myself writing the same things over and over again.
1 2...
2019-02-04
16 reads
Things I Wish I Knew When I Started
Way back in August, Matt Cushing (blog|twitter) was preparing to teach and asked for a list of “what do you wish you’d known when you started” items that he...
2019-01-21
10 reads
WordPress's Block Editor and the Publicize Feature
Like many folks using Wordpress, I post a tweet each time I publish a blog entry and that’s done automatically by Wordpress. In the Wordpress Classic Editor, there was...
2019-01-14
4 reads
A Monumental Migration to SQL Server 2016 - Part 2
In my previous post, I outlined the preparations we undertook to migrate a large SQL Server 2008R2 instance to SQL Server 2016. This post details migration day.
Final Prep We...
2019-01-09
10 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