Who Inspires You?
Today we have a guest editorial from Chris Shaw. After the recent PASS Summit, Chris talks about the value of getting inspired by people he listens to talking about SQL Server.
SQL in the City Seminar Washington DC 2013 –Deployment Stairway
Join Red Gate for a free seminar on December 6 (the day before SQL Saturday Washington DC). Steve Jones and Grant Fritchey, SQL Server MVPs, will present best practices for SQL Server version control, continuous integration and deployment, in addition to showing Red Gate tools in action.
Windows Azure SQL Database (WASD) Primer
Are you a SQL Server DBA who is now being asked to migrate databases to Windows Azure SQL Database (WASD)? Are you a developer who is writing code for a cloud service that shall use SQL Database as the back-end? This blog post is based on issues encountered while supporting customers that were once in your shoes and the lessons learned in the process.
Dream Jobs
Today we have a guest editorial from Andy Warren. Andy asks today if you've thought about a dream job, and if so, what would it be?
Using Indexes to Reduce Blocking in Concurrent Transactions
New author Nilav Ghosh brings us a performance tuning article to help your queries run better. This article examines how indexes can help reduce blocking.
Explanation of SQL Server IO and Latches
This article is a whistle-stop tour of my exploration of latches; their different types, their purposes, why they are required and where they fit into the SQL database engine, in the hope it will be interesting and useful to you.
Time for Learning
Today Steve Jones talks about the time required to increase your skills and debates about what time you need to invest each year to gain knowledge.
What is your default database set to?
Some people set their default database to the database they use most often. This can cause issues when a restore fails.
Window Functions in SQL
SQL's windowing functions are surprisingly versatile, and allow us to cut out all those self-joins and explicit cursors. Joe Celko explains how they are used, and shows a few tricks such as calculating deltas in a time series, and filling in gaps.
Runtime Code
Do you test your code? What about code that is generated by applications and executed at runtime. Is that tested well? Steve Jones wonders.
Blogs
ISACA AI Material/Exam Prep Discount (May 18 – June 30, 2026)
By Brian Kelley
If you are considering any of the ISACA AI certs like the Advanced Artificial...
A Fabric solution can be very cost effective
By ChrisJenkins
Are you currently using Microsoft Fabric or considering migrating to it? If so, there...
Track SQL Server Configuration Changes Using the Error Log
By SQLPals
Track SQL Server Configuration Changes Using the Error Log If you...
Forums
Before Using AI with Business Data, Read This
Artificial intelligence tools are quickly becoming part of daily business operations, from document analysis...
Designing SQL Server ETL Pipelines That Don't Break at Scale
Comments posted to this topic are about the item Designing SQL Server ETL Pipelines...
Detecting Deadlocks Quickly
Comments posted to this topic are about the item Detecting Deadlocks Quickly
Question of the Day
Detecting Deadlocks Quickly
In the Database Engine, when a deadlock is detected, what does the detection interval shrink to (in time)?
See possible answers