Daily Coping 9 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-09
17 reads
Blog Posts
Replaying Workloads to a different Database
One of the features I was asked to implement for WorkloadTools is the ability to replay commands to a database name different from the one recorded in the source...
2020-04-09 (first published: 2020-03-31)
399 reads
Running Jupyter Notebooks as Agent Jobs
Azure Data Studio is a great tool for connecting with your data platform whether it is in Azure or on your hardware. Jupyter Notebooks are fantastic, you can have...
2020-04-09 (first published: 2020-03-30)
649 reads
SQL Saturday Organizer Q&A
A little while ago, Ray Kim (blog | twitter) asked a few folks who organize SQL Saturday events a few questions for his blog. The results are in and...
2020-04-09
5 reads
Webinar: How to unlock the value of frequent deployments
I’m doing a webinar next week, on Wednesday, April 15, 2020, that looks at some of the learnings from the 2020 State of Database DevOps report. I’ll be discussing...
2020-04-09
31 reads
Administration Basics: Point in time recovery
Nowadays, data is a precious asset for companies today. If you are a database administrator (by decision or by mistake) or simply you are the "IT guy," you have...
2020-04-08 (first published: 2020-03-30)
431 reads
Join me (virtually) in Adelaide!
I will be presenting a session to the Adelaide SQL Server User Group on April 15th, 2020, and if you’re awake at that time (it’ll be 9pm on April...
2020-04-08
55 reads
SQL Prompt and SSMS 18.5
I downloaded SSMS 18.5, as there were a lot of fixes in here and thought this was a good upgrade to try. I’d heard reports of major changes in...
2020-04-08
2,229 reads
The Power of Git–Getting Code
I find git to be incredibly useful, and this is a quick example of one of the ways that this matters to me. This post is also available in...
2020-04-08 (first published: 2020-04-01)
653 reads
Azure Analysis Services – Processing Hot & Cold Data using Tabular model partitions
Introduction Recently have been working on a “Proof of Concept” task where I wanted to test the capabilities of Azure Analysis Services Tabular model when loading data from different...
2020-04-07 (first published: 2020-03-30)
988 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