Under which user your SQL Agent Job run : SQL Agent Service Account or SQL Agent Job Owner ?
Today, I am willing to do demo that under which user my SQL Agent Job run, SQL Agent Service Account...
2013-01-11
4,073 reads
Blog Posts
Auto grow–On or Off Straw Poll
David Postlethwaite who contributes to this blog regularly sent me an email this morning asking about Database Auto grow.
This...
2013-01-10 (first published: 2013-01-07)
1,994 reads
MDS Error SYSERR207 after SQL Server 2012 SP1 Upgrade
After upgrading to SQL Server 2012 SP1, I ran into a bug in Master Data Services (MDS) that applies only...
2013-01-10
1,255 reads
Restore database permissions
Introduction:
I came across a couple of subtle gotchas around the permissions required to restore a database in SQL Server 2008+...
2013-01-10
6,127 reads
sp_Blitz, v16, on SQLServerCentral
Brent Ozar Unlimited released v16 of this sp_blitz script, which is designed to run on a SQL Server instance and...
2013-01-10
1,400 reads
Speaking at Midlands PASS in February
On February 12th I'll be giving a SQL Server Security Refresher for Midlands PASS at Microstaff IT in Cayce/West Columbia,...
2013-01-10
962 reads
SQL Server Virtualisation and Consolidation
Come and join me in London this March for a 3 day course on SQL Server virtualisation and consolidation.The course...
2013-01-10
1,025 reads
Talking on Purpose
Last year I stepped into the intimidating (and slightly effervescent) waters of the consulting world, and found great success. This...
2013-01-10
774 reads
Try a Database Design Exercise At Your Next SQL User Group
Tried something different for the January 2013 meeting of the Baton Rouge SQL Server User Group (brssug.org), which meets every...
2013-01-10
956 reads
#SQLMaiden 2013 dates
Some time back at a SQL Server user group in Southampton I was speaking to an MVP called Simon Sabin...
2013-01-09
697 reads
Blogs
Claude AI Convinced Me Not to Build an iPad App
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Claude Code Helps Analyze Test Data Manager Log Files
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
Forums
Data Warehouse Toolkit meets Star Schema: The Complete Reference
Is there a good syllabus for reading these two together? (Yes, it's called the...
GPX distance and time analysis in SQL Server
Comments posted to this topic are about the item GPX distance and time analysis...
The DBA is Dead; Long Live the DBA
Comments posted to this topic are about the item The DBA is Dead; Long...
Question of the Day
Changing the AG Listener
In SQL Server 2025, if I want to remove an IP from a listener, what do I do?
See possible answers