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
Another Way to Look at Trees
An alternative to tree traversal, and ultimately more efficient way to look at organizational structures is presented.
2014-09-15
7,554 reads
SSRS Report Content Filtering by User Group
How to get an SSRS user's AD group membership in order to filter report content
2013-06-03
6,810 reads
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
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...
Installing missed items in SQL Server
Hi, Someone, prior to me, installed SQL Server 2019. and missed a few things...
Ask SSC