Fixing system database corruption with setup.exe
Corruption of the system databases is a serious matter. Setup.exe is a brute force method of replacing them.
2018-04-17
977 reads
Kenneth Fisher
Storing a variable with a SELECT, and why it didn't work.
Using SELECT to store values into variables is an important technique, but you need to know some of the gotchas as well.
2018-04-02
6,065 reads
2016-11-17
3,096 reads
Constant Data Types
Data types are an important part of how tables and variables work. Did you know that constants have databases too?
2016-10-03
1,662 reads
Spackle: Making sure you can connect to the DAC
The DAC is an important tool and several things can go wrong when trying to connect to it.
2014-07-31
3,296 reads
Single Quotation Marks in SQL
One of the common problems is dealing with apostrophes in T-SQL. This article examines the challenges of single quotation marks and ends with a short quiz.
2014-07-11 (first published: 2013-01-03)
36,491 reads
2014-07-01
8,440 reads
Fun with Outer Joins
Learn how an outer join works and how you can use it in your applications to find the results you need when matching data isn't in all your tables.
2014-01-17 (first published: 2012-09-10)
23,278 reads
2012-02-22
7,525 reads
A brief explanation and solution for the Double Hop problem
What on earth does “Login failed for user ‘(null)’, Reason: Not associated with a trusted SQL Server conn” mean?
2011-12-09
38,902 reads
Blogs
Upgrading SQL Server Containers on the Laptop
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
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,...
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