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
Tag Archives: Windows
Nested Virtual / Remote Desktops and CTRL+ALT+DELETE
Just a quickie… You need to change your password, so you use Ctrl+ALT+Delete. That’s fine, as long as you’re physically at the machine. But if you’re connected to a remote desktop session somewhere, that key combo doesn’t get through. But … Continue reading
Posted in Uncategorized
Tagged Adminstration, Desktop, Remote Desktop, Virtualisation, Windows
Leave a comment
Departure of a SQL Server Administrator – What to Check?
A SQL Server administrator has left. But what does that actually mean? What do we need to check to make sure that things will continue to work after their Active Directory account is disabled? Some things to check are: SQL … Continue reading
Posted in Uncategorized
Tagged Administration, PowerShell, Security, SQL Server, T-SQL, Windows
1 Comment
Error: There is not enough space on the disk
I was running a query in SQL Server Management Studio (SSMS), nothing too complicated, and got this error, unexpectedly: An error occurred while executing batch. Error message is: There is not enough space on the disk. There’s plenty of space … Continue reading
Longrunning Query – xp_cmdshell?
Flicking through the ol’ Solarwinds activity monitor, I spotted this one day: That four day purple thing on the right? Not good. (The remaining images are from a reconstruction, partly to protect the not-so-innocent, and partly because the first job … Continue reading
Posted in SQLServerPedia Syndication
Tagged sp_WhoIsActive, SQL Server, Task Manager, Windows, WTF, xp_cmdshell
1 Comment
Patching
We had a communication from an Ops team saying that they intended to apply Windows patches to all our SQL Servers in one six hour period. This just felt wrong, on so many levels, including: QA, UAT, DR, Production all … Continue reading