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,410 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,546 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
5,919 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,038 reads
Blogs
SQL Server 2019 on Docker no longer runs as root by default
In my home lab I have an Ubuntu virtual machine that runs both SQL...
SQL Server 2019 – Compatibility Level in Azure
By Arun Sirpal
I am not sure when this became available but for Azure SQL Database 150...
When using Powershell to control Azure the Cloud Shell doesn’t require an additional login.
When studying Azure one of the things you’ll be asked to learn is the...
Forums
Is Data the Future of the Vibrant Web?
Comments posted to this topic are about the item Is Data the Future of...
Execution Plans
Hi, How do you share execution plans. Save the plan and share the .sqlformat...
transaction delay when replica unavailable - what effect?
I'm using AlwaysOn synchronous replica. User issues an update on primary via SSMS. In...
Ask SSC