Find failed SQL Agent jobs using Transact-SQL script
Today, I’m sharing the following T-SQL script which you can use to find which SQL Server Agent Jobs failed yesterday....
2012-08-15
2,307 reads
Blog Posts
JSSUG Speaker Idol 2012
The Jacksonville SQL Server User Group (JSSUG) has always encouraged new talent to be added to the pool of local...
2012-08-15
1,103 reads
PowerShell Saturday in Charlotte, NC
If you are in or around the Charlotte, NC area, there is a PowerShell Saturday coming your way on September...
2012-08-15
1,352 reads
SCRIPT: Find the row count of all tables and views
Today I’m sharing another script that I often find useful – Queries to find the count of rows from tables and...
2012-08-15
15,274 reads
SQL Server: Understanding the Data Page Structure
We all know very well that SQL server stores data in 8 KB pages and it is the basic unit...
2012-08-15 (first published: 2012-08-12)
8,772 reads
The Home Server is Back
After reading about the Amazon/Apple attack this morning, I grabbed a second cup of coffee and went in search of...
2012-08-15
711 reads
VM Guest Memory – Watch these numbers !
I have been using VMware vSphere client for a while now and the person who inspired me to use this...
2012-08-15
1,428 reads
Choosing a Mobile Workstation
I get a lot of e-mail and Twitter requests for advice about what laptop someone should buy. I don’t mind...
2012-08-14 (first published: 2012-08-11)
2,266 reads
Ctrl+R in SSMS 2012
After the successful installation of the SQL Server 2012, some shortcut keys can be possible to not work properly like...
2012-08-14
6,389 reads
Database and Disk Size - PowerShell Script
Every time we do a capacity analysis we need to analyse the database size (free and used) and the disk...
2012-08-14
6,043 reads
Blogs
Monday Monitor Tips: The MCP Server
By Steve Jones
I have been experimenting with MCP servers in a few ways, and pressing on...
Programmatic Tool Calling with the Claude SDK
Programmatic Tool Calling with the Claude SDK Every morning somebody on the team runs the...
A New Word: Mauerbauertraurigkeit
By Steve Jones
mauerbauertraurigkeit – n. inexplicable urge to push people away, even close friends whose company...
Forums
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...
Finding Bad Queries
Comments posted to this topic are about the item Finding Bad Queries