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,139 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,702 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,450 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,779 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,753 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,644 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,955 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,851 reads
By Steve Jones
I’ll be at SQL Bits tomorrow, Saturday Jun 20, 2025 for the final day...
By John
In a recent video, I took a hands-on look at the Next Gen General...
By Rohit Garg
India’s 2025 tax reforms have introduced a bold shift in how income is taxed,...
We are in the process of upgrading to SQL Server 2022 and would like...
Comments posted to this topic are about the item How to Choose the Right...
Comments posted to this topic are about the item Adding Defaults
I have a table, called dbo.logger, in SQL Server 2022. I decide to add two new columns to this table with this code.
ALTER TABLE dbo.logger ADD CreateDate DATETIME CONSTRAINT dfGetDate DEFAULT GETDATE() GO ALTER TABLE dbo.logger ADD ModifyDate DATETIME DEFAULT dfGetDate GOWhat happens when I run these two batches? See possible answers