Indexes can be the most critical part of any database. they can drastically improve performance or they can ruin it. Wise management is the key to success.
2018-03-09 (first published: 2016-02-15)
8,145 reads
It's 15 years after the beginning of the century. Time to eliminate the security exposure of SQL logins, and implement integrated security. Active Directory Groups make this easy for the DBA.
2018-02-02 (first published: 2015-12-21)
9,712 reads
As security threats proliferate, the need for encryption will continue to rise. We who are the Guardians of the Data must be ready to make SQL Server respond and to manage the performance issues that are inherent in every data encryption solution.
2018-01-16
4,470 reads
Most IT departments are moving toward ITIL-aligned practices. Gain a general understanding of the ITIL framework and how Database Administrators can take advantage of it.
2017-10-24 (first published: 2015-10-26)
10,803 reads
Almost all SQL Server databases grow in size over time. Capacity planning is an important activity for the DBA. You need to know how long before you run out of space long before you actually do. Here are some helpful tips and tricks.
2017-05-12 (first published: 2016-06-09)
7,758 reads
Many reports you will generate in SSRS will need to report within date ranges, and most of those will need a date range parameter. Here's an way to make an easy-to-use date range parameter.
2017-03-31 (first published: 2015-11-18)
14,669 reads
With AD Authentication via groups, SQL Server is vulnerable to orphaned Windows users' logins being added to SQL Server at a later date. This article gives an improved user audit script that detects orphaned DB Users and also a delete script.
2016-07-18
2,964 reads
Risk-averse managers are reticent to upgrade to the latest and greatest. Why is this the case and how can the savvy DBA make the case for and get ready for a newer version of SQL Server?
2016-06-28
2,868 reads
By Brian Kelley
For those testing SQL Server 2025 before it officially releases, Microsoft has made the...
If there’s one thing I’ve learned in consulting, it’s that SQL Server, and other...
By Chris Yates
Embracing the New Paradigm Fabric real-time data signals a fundamental shift in how organizations...
Comments posted to this topic are about the item Detecting Multiple Changes
Comments posted to this topic are about the item Ghostworkers
We have a few stored procs where we need to a dos command "net...
I want to write a trigger to detect changes to columns in SQL Server 2022. I have this table:
CREATE TABLE CustomerLarge (CustomerID INT NOT NULL IDENTITY(1, 1) CONSTRAINT CustomerLargePK PRIMARY KEY CLUSTERED , CustomerName VARCHAR(20) , CustomerContactFirstName VARCHAR(40) , CustomerContactLastName VARCHAR(40) , Address VARCHAR(20) , Address2 VARCHAR(20) , City VARCHAR(20) , CountryCode CHAR(3) , Postal VARCHAR(20) , creditlimit INT , discount NUMERIC(4, 2) , lastorderdate DATETIME , lastorderamount NUMERIC(10, 2) , lastordercontact VARCHAR(20) , created DATETIME , modified DATETIME , modifiedby VARCHAR(20) , statusid INT , active BIT , customersize INT , primarysalesid INT); GOI want to determine if both the CustomerContactFirstName and CustomerContactLastName fields are changed, but no others. What is the mask I need to use with COLUMNS_UPDATED()? See possible answers