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
877 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
4,737 reads
2016-11-17
2,839 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,627 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,137 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)
26,369 reads
2014-07-01
5,292 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,720 reads
2012-02-22
5,429 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
20,390 reads
Blogs
Daily Coping 22 Jun 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Why are my permissions missing?
You’d be amazed (or maybe you wouldn’t) how often I hear this: “I used...
Suggested Topics in Power Virtual Agents
By Devin-Knight
Power Virtual Agents empowers subject matter experts to build intelligent conversational bots, using a...
Forums
Putting a CTE with Subqueries into a stored procedure
Is there a way to place the following code into a SELECT routine in...
Migrating Folder Structure in Report Manager from one SSRS server to another
We are in the process of converting 500+ reports from our old reporting system...
Setting up and using dbt (Data Build Tool) with SQL Server
dbt, or Data Build Tool, is a piece of software that allows analysts to...
Ask SSC