Query all objects created or modified after specified date
This script will query across all databases, returning a result of objects recently created or modified.
2012-12-21 (first published: 2012-11-27)
2,084 reads
Scripts
2012-12-20 (first published: 2012-12-04)
1,724 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,189 reads
2012-12-14 (first published: 2012-11-27)
1,928 reads
Report Server Report Usage
Get information about how often, how fast your reports run and how big they are.
2012-12-12 (first published: 2012-11-27)
1,652 reads
Find Single use plans in Plan Cache
This script will return all the Adhoc Single use Plans currently in your Plan Cache.
It also excludes Plan Shells created from auto/forced parameterization. Works for 2005/2008
2012-12-11 (first published: 2012-11-26)
843 reads
2012-12-07 (first published: 2012-11-19)
1,395 reads
Get Scheduled Jobs from Multiple Servers
Script to loop thru multiple linked server and get agent scheduled jobs for the next XX hours.
2012-12-06 (first published: 2012-11-16)
926 reads
2012-12-03 (first published: 2012-11-07)
2,051 reads
2012-11-30 (first published: 2012-11-03)
1,104 reads
Blogs
Microsoft Tools for Making Data AI-Ready
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
Local Models Using GPUs with Ollama
By Steve Jones
Can you use your GPUs when running a local model under Ollama? You can,...
Don’t Fear the Technology
By Brian Kelley
The concern that a particular technology is going to destroy the world seems to...
Forums
Moving Beyond the Reboot: Finding the Culprit Behind Memory Pressure
Comments posted to this topic are about the item Moving Beyond the Reboot: Finding...
Reserved Words I
Comments posted to this topic are about the item Reserved Words I