Checking All Date Columns in a Table(s)
Find minimum and maximum values for all date columns in a table or range of tables, using a mask.
2016-09-15 (first published: 2014-10-27)
2,442 reads
Larry Schmidt
Update Trigger to Store Only Updated Column and Former Value
History table needs individual rows for each column that has been updated, i.e., a column history.
2012-12-17 (first published: 2012-12-04)
1,048 reads
Blogs
Microsoft Ignite Announcements 2021
By James-Serra
Microsoft Ignite has always announced many new products and new product features, and this year...
Daily Coping 4 Mar 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Which configuration changes in SQL Server require a restart?
SQL Server is a complex beast, with many configuration options that can range from...
Forums
Backing up SQL Express with batch file and SQL procedure.
I have a procedure to back up a SQL Express database. It works when...
Missing cmdlet in powershell module sqlserver
I have succesfully installed the module sqlserver version 21.1.18235 on my server which hosts...
Datacenter Downtime and SQL backups
I was wondering what others are doing in regards to a datacenter outage and...
Ask SSC