Presenting Two Sessions at PASS Summit 2019
In just a few days, I’ll begin my annual journey to Seattle, Washington for the PASS 2019 Summit. This is one of my favorite conferences to attend. It is...
2019-10-30
24 reads
John Morehouse | Sqlrus.com
Improving TweetDeck with Better TweetDeck
If you are at involved with the #sqlfamily, you are bound to hear about the benefits of social media platforms such as Twitter. Twitter helps us to engage each...
2019-10-31 (first published: 2019-10-18)
357 reads
HammerDB for Azure SQL DB
Bench marking your environment is an important step when introducing new hardware, which is accomplished by running a test workload against the hardware. There are multiple ways to...
2019-10-03 (first published: 2019-09-27)
776 reads
Using Powershell for SQL Saturday Logos
Out of necessity are born the tools of laziness. This is a good thing. I have found that organizing and running a SQL Saturday event is a great way...
2019-09-23 (first published: 2019-09-13)
363 reads
Moving to Azure SQL Database Serverless
In a previous post, I discussed the public preview of Azure SQL Database Serverless. This is a newer product released from Microsoft for the Azure ecosystem. Moving to this...
2019-09-13 (first published: 2019-08-30)
965 reads
Finding the Best Azure Datacenter
When dealing with cloud technology there is a phrase that everybody should remember: Physics Always Wins. There isn’t any way to get around the speed of light (2.98 x...
2019-07-26
305 reads
Getting Your SQL Server Backup Footprint
Recently, I needed to be able to determine the total size for all the most recent full backups for certain servers. Luckily for me these particular servers were using...
2019-07-15 (first published: 2019-06-28)
465 reads
SQL Server Data Pages on Linux
One of the new phrases coming out of Microsoft is that “SQL is just SQL” regardless of what operating system...
2019-03-22
459 reads
Checking Open Ports in Azure
Let’s be honest here, data security is really important to me. Some people probably think that I go to extremes...
2019-04-03 (first published: 2019-03-15)
760 reads
Secure Travel
Traveling in today’s age of technology is a lot easier than in the past. You can start your journey in...
2019-03-22 (first published: 2019-03-08)
1,997 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