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
901 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
5,123 reads
2016-11-17
2,945 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,639 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,193 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)
28,718 reads
2014-07-01
6,214 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)
22,837 reads
2012-02-22
6,223 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
24,801 reads
Blogs
A Blogging Break
By Steve Jones
Outside of coping tips, I’m gonna take a break from blogging. I’ve been aiming...
Daily Coping 5 Jul 2022
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
New Database Job – Understand What You Have
In my previous post, I expounded on my first 30 days I had at...
Forums
Designing a table
Hi, I have this list of training courses: Course_Code|Description 1 |Health and Safety 2...
Multiple Fact Tables
Please assist? I would like to do a data model of the tables here:...
Drop database on Secondary Node from Primary for automatic restore job
hi all We've ventured into the world of AAG's as we have now moved...
Ask SSC