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
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
Learn how Splunk can be used to get information from application logs or a SQL Server database.
2022-08-08
1,140 reads
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
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
You can do essential monitoring of SQL Server instances and databases with a FREE toolkit!
2022-01-28
3,206 reads
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
You can do essential performance tuning on your SQL Server databases using a FREE toolkit!
2022-01-14
4,537 reads
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
You can do essential performance tuning on your SQL Server databases using a FREE toolkit!
2021-12-17
5,777 reads
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
By Steve Jones
I am not a great software developer. I’m OK, and I do know how...
By Steve Jones
Today’s coping tip is to appreciate your hands and all the things they do...
By alevyinroc
On to the FIRST Robotics Competition 2023 World Championship Last week I wrote about...
SELECT BusinessEntityID,FirstName,MiddleName,LastName, YEAR(OrderDate) AS OrderYear, DATENAME(MM,OrderDate) AS OrderMonth FROM Person.Person Pp INNER...
I am after some advice, I have completed a SSRS migration 2017 - 2019. ...
Hi, I've been tasked with finding out why we've been unable to patch the...