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: Design
T-SQL Tuesday #72 – Data Modelling Gone Wrong
This is the 72nd (72? Nearly 6 years…) T-SQL Tuesday, started by Adam Machanic. Each month, someone sets a topic – this month, Mickey Stuewe (Blog|@SQLMickey) has set the topic “Data Modelling Gone Wrong”. I noticed this rather too late … Continue reading
Disaster Prevention by Triggers
In my previous post, I discussed recovery from a situation where a user had updated every row of a table rather than the one that he was aiming at. At the end of that post, I suggested that a way … Continue reading
Unmitigated Disaster? Or was it also a Learning Experience?
The Situation You get a call. Someone has done something bad – in this case, failed to select the WHERE clause when running an UPDATE statement against your production database. Oops. Leaving aside thoughts of “why is he messing with … Continue reading
Posted in SQLServerPedia Syndication
Tagged Design, Disaster Recovery, Quest, red-gate, T-SQL
1 Comment
Denali feature: Sequences
SEQUENCES in SQL Server Denali are an improvement over IDENTITY fields in previous versions of SQL Server. They can, for example: be used as a single incrementing ID across multiple tables be set to recycle be more easily queried However, … Continue reading
Meme Monday – August 2011 – “Crappy Code”
This month’s Meme Monday, as run by Thomas “SQL Rockstar” LaRock (blog|twitter) is an exercise in writing about the worst pieces of code we have seen. Once upon a time… …I noticed that, what should have been a relatively simple … Continue reading
Database Design Horrors
Jen McCown, of the MidnightDBA (twitter / blog) recently posted a couple of articles about the basics of Database Design. As she was writing the second of these posts, she put out a Tweet (well, two tweets) saying: Help me … Continue reading
Inappropriate Indexes, and Programming Your Way Around Them
(This article should probably be called “Inappropriate Primary Keys…”, but that wouldn’t have the assonance…) Seeing various questions on AskSSC about using GUIDs as indexes, including GUIDs which are actually stored in Varchar(255) fields, reminded me of this little vignette … Continue reading
Posted in SQLServerPedia Syndication, Uncategorized
Tagged Design, Indexing, Programming, WTF
Leave a comment