Picking the Right Type of Tool For the Job
Do we need the right tool or just a tool? A guest editorial from Andy Warren gives a few thoughts on getting things done effectively.
PowerShell Tool Time: Building Help
Learn how you can customize the help for your library of scripts in this edition of PowerShell Tool Time.
Forwarded Fetches and Bookmark Lookups
If someone says clustered indexes slow you down, they haven't read this.
What's New in the First Public CTP of SQL Server 2019
In this article we look at the first public CTP release of SQL Server 2019 and some of the great new features that will be part of SQL Server 2019.
An Open Thank You to the Microsoft SQL Server Team
Thanks for improving the string or binary data truncated error message.
SQL Server From .Net: Using SQL Server Schema to Build a Data Set
A basic introduction for developers (or anyone) to using the metadata for a SQL Server database to build a DataSet in ADO.Net that represent objects in any SQL Server database.
Security, Compliance, Data Ethics, and Breaking the “Not My Job” Mindset
Security, compliance, and data ethics are related concepts that everyone who works with software should know about, from the help desk to the C-level office… but almost everyone thinks that worrying about these things is someone else’s problem.
The Uninteresting But Necessary Work
Data classification may not be fun or even interesting, but it is necessary.
SQL Server MERGE statement usage and examples
In this tip we look at how to use MERGE compared to running separate INSERT and UPDATE statements.
Renaming a Schema in SQL Server
If you have a schema you want to retire, here's a method for moving all objects inside that schema to a new one.
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