Data Bits – Episode 6 – Peter Shore
SQL DBA Peter Shore (t) and I had a great time recording this. Quotables: “Vehemently OK”, “Intentional Accidental DBA”, “Professional Nerd”, “Senior DBA as defined by AARP” I cut...
2020-04-13
21 reads
Blog Posts
Develop Resiliency
We are all going through some tough times. It’s tougher for some more than others. Now is the time when you have to work on being resilient, and it...
2020-04-13
9 reads
Learning Postgres:Installation
I had the opportunity of working on a project converting a postgres database to a sql server based one at work. I used this opportunity to learn more of...
2020-04-13 (first published: 2020-04-06)
319 reads
Upcoming Webinar: Learning from Data Breaches
Recently I partnered up with Kevin Kline (SentryOne blog | twitter) and SentryOne to record a webinar on learning from data breaches. We start by talking about Mitre’s ATT&CK...
2020-04-13
27 reads
Design patterns (short description)
Here is some short description of GoF design patterns. It is just to remind the explanations. so first you have to understand each design pattern separately.Adapter Pattern: Convert the interface...
2020-04-11
22 reads
Design patterns (short description)
Here is some short description of GoF design patterns. It is just to remind the explanations. so first you have to understand each design pattern separately.Adapter Pattern: Convert the interface...
2020-04-11
85 reads
Charting in Azure Data Studio
The March 2020 release of Azure Data Studio (ADS) includes a charting feature for SQL queries. This is a quick look at the feature, which I think will have...
2020-04-10 (first published: 2020-03-30)
554 reads
Daily Coping 10 Apr 2020
I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is helping me deal with the issues in the world. I’m adding my responses for each...
2020-04-10
16 reads
Diversity & Inclusivity – a personal journey
This article is about my own experiences in making my user group and community events more inclusive for people from diverse backgrounds. I am going to use growing my...
2020-04-10 (first published: 2020-03-31)
861 reads
The Car Game
I started this on Facebook, privately with friends. I heard about it from one of them and liked it. I didn’t get many guesses, so I took a chance...
2020-04-10
257 reads
Blogs
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,...
Designing a Storage Load Test for SQL Server
I’ve been doing storage load tests for SQL Server for a long time, both...
Forums
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...
Half of All Engineers
Comments posted to this topic are about the item Half of All Engineers
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