DML Triggers to track SQL Server Agent Jobs creation, deletion and modification events
SQL Server Agent jobs are crucial to any SQL Server environment, as they are used for scheduling and performing critical...
2012-10-01
1,344 reads
Blog Posts
Free Training Before the PASS Summit
How many of you out there get approval to go to the PASS Summit (YES!) but then get denied the...
2012-10-01
634 reads
New York New York
Come and join me live in New York this coming December where I will be presenting Learning Tree’s2109 SQL Server...
2012-10-01
840 reads
October 2012 – Monthly SQL Server Checklist
October already. The PASS Summit is coming soon and we’re entering the time of the year that many of us...
2012-10-01
608 reads
Speaking at SQL Server #165 Lincoln this Saturday
The Omaha SSUG’s sister group, the Lincoln SSUG, is hosting a SQL Saturday this coming Saturday, October 6th, at Avery...
2012-10-01
698 reads
SQL in the City
That’s where we were on Friday. 780 Third Avenue, in the middle of Manhattan. The start of our 2012 US...
2012-10-01
1,199 reads
SQL in the City - New York 2012
I was able to attend the SQL in the City event in New York this past Friday. I highly recommend...
2012-10-01
706 reads
SQL Server 2000 || DBCC CHECKDB logs entried in T-log file
Issue : When running DBCC CHECKDB on SQL server 2000, We are facing t-log growth & blocking.
Cause : DBCC CHECKDB does block in...
2012-10-01
612 reads
SQL Server 2012 Diagnostic Information Queries (October 2012)
Here is the October 2012 version of my SQL Server 2012 Diagnostic Information Queries, with some minor tweaks and improvements...
2012-10-01
1,731 reads
Virtualizing Your Business Critical SQL Servers – Free Boot Camp by House of Brick
Just before PASS Summit in November, House of Brick and I will be holding a free boot camp on Virtualizing...
2012-10-01
712 reads
Blogs
Stanford Emerging Technology Review 2026 Report is out
By Brian Kelley
Artificial Intelligence and quantum computing are two areas of emerging technology that receive most...
How I Troubleshoot a Slow SQL Server Live
No two SQL Server environments are alike. A fix that resolves a performance issue...
T-SQL Tuesday #201 Invitation: Temp Tables, Friend or Foe?
By ReviewMyDB
My T-SQL Tuesday #201 invitation. Do temp tables help performance or hurt it? I...
Forums
Test topic for spam filtering
A new thread for testing the spam filter. Adding a link: https://www.bbc.co.uk/weather
Removing production permissions when restoring database to non-prod
Hello experts, An application team has asked us to modify a SQL Agent job....
Advanced T-SQL: Replacing Slow Cursors with Window Functions
Comments posted to this topic are about the item Advanced T-SQL: Replacing Slow Cursors...