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,418 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,549 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,106 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,043 reads
Blogs
Trace Query in Extended Events
The ability to quickly and easily trace a query is important to database professionals....
Using Erik Darling’s sp_pressure_detector to resolve CPU issues
By DesertDBA
Last Friday I spent my lunch break going through some links I had marked...
How to Resolve Remove-AzKeyVaultKey : Operation returned an invalid status code ‘Forbidden’ Error
I’ve come across another error message in my seemingly never-ending battle with Azure Key...
Forums
Read Only Files
Comments posted to this topic are about the item Read Only Files
Why A Query May be Faster the Second Time it Runs
Comments posted to this topic are about the item Why A Query May be...
OLE DB 0x80004005 connection error trying to run SQL HA Maintenance Plans
Hi, I'm getting a connection error when I try to run even the most...
Ask SSC