Risk and Assumptions
Building software always involves risk, but in these tough times, Steve Jones thinks we should be working to lower the risk of IT projects.
Improved Application Availability During Online Operations in SQL Server 2014
SQL Server 2014 introduces enhancements to two common database maintenance operations namely Partition Switching and Online Index Rebuild which greatly increases enterprise application availability by reducing maintenance downtime impact.
SQL Saturday #213 Providence, RI
Join us for a free day of SQL Server training and networking on September 21 in Providence Rhode Island. Featured speakers include Paresh Motiwala, Wayne Sheffield, and Jason Brimhall.
Versions of Disaster
Dealing with a disaster is a trying experience for anyone, but having to then worry about having the proper software installed can make things much worse. Steve Jones talks a bit about the challenges of worrying about software versions.
Condensing a Delimited List of Integers in SQL Server
In real-world applications, it often makes sense to show denormalized data, such as delimited lists, within the application's user interface. Dwain Camps shows why, and how, the distribution business stores information about 'islands' in sequences in order to track the status of the shipping of a consignment. It makes a great SQL puzzle.
SQLskills and SQL Intersection
This fall SQLskills is running the SQL track at SQLIntersection, with an amazing lineup of speakers and sessions. Join Paul Randal and Kimberly Tripp in Las Vegas for the event, Oct 28-30.
SQL Saturday #249 San Diego
Join SQL Saturday San Diego for a free day of SQL Server training and networking on September 21st. There will also be a free SQL in the City Session on the 20th presented by Steve Jones and Grant Fritchey.
The Future of Knowledge Measurement
In part 3 of his thoughts on certifications, Steve Jones gives an idea for how we might move forward from here.
How to Recognize When a Relational Database is "Good Enough"
In this Webinar on Tuesday September 12, Louis Davidson will explain the differences between good and bad database design. He'll discuss characteristics such as comprehendible, documented, secure, well performing, and normalized (naturally). Register to come along.
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
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