Thomas Rushton
is… The Lone DBA.
- "... a scholar and a true gentleman." - Buck Woody, Microsoft's "Real World" SQL Server DBA.
-
Recent Posts
- Agresso
- AskSSC
- availability groups
- Azure
- Backup
- Book Review
- Books
- Career
- Configuration
- CTE
- DBCC
- Deadlock
- Denali
- Deployment
- Design
- Disaster Recovery
- DMV
- Documentation
- Education
- Error Logs
- Error Message
- ETL
- Full Text Indexes
- Geometry
- Indexing
- Installation
- IT Management
- Kaseya
- Kindle
- Maintenance
- Maintenance Plans
- Management
- Meme Monday
- Memory
- Migration
- Monitoring
- MSDB
- Normalization
- Performance
- PowerShell
- Programming
- Project Management
- red-gate
- Redgate
- Restore
- Scheduled Tasks
- Security
- Spatial
- SQL Agent
- SQLBits
- SQL Monitor
- SQLPrompt
- SQLSaturday
- SQL Server
- SQL Server 2000
- SQL Server 2005
- SQL Server 2008 R2
- SQL Server 2012
- SQL Server 2014
- SQL Server 2016
- SQLSouthWest
- SSMS
- SSRS
- T-SQL
- T-SQL Tuesday
- Training
- Triggers
- Troubleshooting
- Upgrade
- User Group
- Virtual Machines
- Windows
- Windows 2012
- WordPress
- WTF
Archives
Categories
SQL Server blogs
- Brent Ozar – Too Much Information
- Denny Cherry & Co (DCAC)
- Microsoft SQL Server blog
- Microsoft SQL Server Team blog
- Midnight DBA – DBARant
- Midnight DBA – SQLAwesomeSauce
- Redgate Hub – SimpleTalk
- Simple-Talk – DBA, Dev, Admin
- SQL Server Central Articles
- SQLBlog – Aaron Bertrand
- SQLRockstar – Thomas LaRock
- SQLSkills
- The Scary DBA
- Voice of the DBA
Author Archives: thomasrushton
T-SQL Tuesday #170 – Abandoned Projects
New year, new blogging regime? No. I just saw Deborah Melkin’s T-SQL Tuesday post, and had to participate… T-SQL Tuesday, second Tuesday of every month, click the image above for a link to the archive. This month – Reitse Eskens is inviting … Continue reading
Why I’m Not Attending SQLBits 2024
OK, so I’m jumping on the Steve Jones / Brent Ozar bandwagon of explaining why I’m not attending SQLBits this year… Why am I not going? Covid. No, not because I’ve got Covid, or I’m going to have Covid, or am … Continue reading
Death of a Community, or RIP AskSSC
Ask SQLServerCentral is closing down on 11th December, for Reasons. When I started out as a full-time DBA back in 2010, it was the first Q&A site I found that was active, friendly, and easy to use. It differs from … Continue reading
Well This Is Different, or “You did *what*?”
Relax, nobody dropped the production database… July 2021 There I was, coming to the end of my contract with the data science team at NHS Digital, working on shutting down their mahoosive SQL Server, and beginning to think about looking … Continue reading
Capturing Extended Properties on Drop Table
TL;DR – Nope. Extended Properties Custom extended properties can be a useful tool when creating a self-documenting database. However, in an environment where tables are routinely dropped and recreated by software/systems not within your control, it may be desirable to … Continue reading
Shooting Yourself In The Foot While Testing Triggers, or The Importance of GO
No, not “Go” the game… I was working on some functionality for a create table trigger. I had the whole creation / testing thing wrapped up in a single script for easy testing and possible deployment across multiple databases: All … Continue reading
Advent of Code and BULK INSERT problems
Have I said how much I hate the new WordPress “add post” page? No? Well, I do. Particularly when editing an earlier post… Anyway. Where were we? Oh yes. Advent Of Code. For those of you who don’t know, it’s … Continue reading
CmdExec vs Powershell – error? What error?
Just a quickie Batch file scripts, called by SQL Agent, are not propagating their errors back up to the SQL Server job system because…. they’re being called from a Powershell script? To replicate the problem, create a .bat file containing … Continue reading
Testing SQL Agent Job Step Output During The Job
(This follows on from my previous script about emailing SQL Job ouput.) There are times when a SQL server scheduled task needs to look at the output from the previous step, and make decisions based on that – particularly when … Continue reading