Migrate the SSIS Catalog in Just a Few Clicks
This wizard migrates SSIS Catalog from one server to another in just a few clicks.
2022-10-27 (first published: 2021-08-17)
12,173 reads
SQL Server
Business Analytics from Application Logs and SQL Server Database using Splunk
Learn how Splunk can be used to get information from application logs or a SQL Server database.
2022-08-08
1,140 reads
Can We Please Stop Sending Passwords Over the Wire?
While analyzing SQL Server's network protocol, I came across a weird fact: when a database client logs in using SQL Server authentication (as opposed to Windows authentication), it has to send the user's password to the server, in blatant violation of common security guidelines. At first, I couldn't believe it; SQL Server generally does an […]
2022-03-02
4,755 reads
MSSQL Server AlwaysON: Get alerted for inconsistencies in logins, jobs and databases
This script will create the necessary login and linked servers on a given availability replica. Please ensure that the script is executed on all the replicas.
2022-02-22 (first published: 2022-01-25)
6,047 reads
SQL Server Monitoring Using Free Tools
You can do essential monitoring of SQL Server instances and databases with a FREE toolkit!
2022-01-28
3,206 reads
How to replace an identity column with a sequence number
SQL Server provides two ways to include an incrementing number in a table. Greg Larsen explains how to replace an identity column with a sequence number.
2022-01-24
Performance Tuning Using Free Tools, Part 2
You can do essential performance tuning on your SQL Server databases using a FREE toolkit!
2022-01-14
4,537 reads
Query control made easy
Overview As we all know, data security is a never-ending battle. Every day, we hear of new data breaches. It's a hard problem, and there is no single solution, other than a defense in depth. Let's look at one of those defenses for databases: query control. Query control is a simple idea: most applications access […]
2022-01-07
3,579 reads
Performance Tuning Using Free Tools
You can do essential performance tuning on your SQL Server databases using a FREE toolkit!
2021-12-17
5,777 reads
SQL Server Data Classification Comes Alive
Overview Microsoft SQL Server 2012 introduced a feature called data classification, which allows you to mark certain columns with labels, indicating that these columns contain sensitive or special-handling data. For instance, you may want to mark a column containing credit card numbers as "confidential", or sales numbers as "management only". The problem is that you […]
2021-12-10
4,194 reads
Blogs
Converting Types in C#
By Steve Jones
I am not a great software developer. I’m OK, and I do know how...
Daily Coping 22 Mar 2023
By Steve Jones
Today’s coping tip is to appreciate your hands and all the things they do...
FIRST Robotics Competition 2023 - World Championships!
By alevyinroc
On to the FIRST Robotics Competition 2023 World Championship Last week I wrote about...
Forums
Query based on sorting based on month
SELECT BusinessEntityID,FirstName,MiddleName,LastName, YEAR(OrderDate) AS OrderYear, DATENAME(MM,OrderDate) AS OrderMonth FROM Person.Person Pp INNER...
SSRS 2017 - SSRS 2019 migration
I am after some advice, I have completed a SSRS migration 2017 - 2019. ...
Fixing a mismatched collation on MSDB
Hi, I've been tasked with finding out why we've been unable to patch the...
Ask SSC