It’s been a tough and long road to 31 Days of Disaster Recovery. It’s been very difficult coming up with quality topic ideas for the series as we near the end. For day 30 of the series, I am combining a post on performing piecemeal restores with a post on filegroups for T-SQL Tuesday #40 … Read More →
Tag Archives: T-sql
Day 18 of 31 Days of Disaster Recovery: How to CHECKDB Like a Boss
Day 18 of my 31 Days of Disaster Recovery series is drawing to a close. It’s 11:22 PM here, and I’ve been working feverishly to finish today’s post before the calendar flips over to tomorrow. This started out as sharing a simple script I use for running DBCC CHECKDB against all databases on a server, … Read More →
Day 13 of 31 Days of Disaster Recovery: Standard Backup Scripts
Today’s post took longer to prepare than I had anticipated which is why day 13 is being published on day 14. This won’t derail the 31 Days of Disaster Recovery series, even if it runs over into February. Day 13′s topic is standard backup scripts. I’ve said on numerous occasions that the first thing a … Read More →
Day 11 of 31 Days of Disaster: Converting LSN Formats
Welcome back to my series 31 Days of Disaster Recovery. Today is day 11, and today I want to talk about converting LSN formats. I had intended to write this blog post a long time ago, but I never seemed to get around to it. This started out as a question posted on Twitter’s #sqlhelp … Read More →
Day 3 of 31 Days of Disaster Recovery: Determining Files to Restore Database
Day 3 of 31 Days of Disaster Recovery: Determining Files to Restore Database Welcome back for day 3 of my month-long series on Disaster Recovery. For today’s post, I want to address something that, in my experience, has really flummoxed a lot of people who find themselves unprepared to handle a disaster scenario. Determining exactly … Read More →
Cross-database Queries by Contained Users
Cross-database Queries by Contained Users I presented to the Pacific Northwest SQL Server User Group / PASS Chapter (PNWSQL) last night on the subject of contained databases. The slide deck and demo code from my presentation, Implementing Contained Databases, can be downloaded below or will be uploaded to the User Group site in the near … Read More →
T-SQL Tuesday #36 – SQL Community
T-SQL Tuesday #36 – SQL Community This blog entry is participating in T-SQL Tuesday #36, hosted this month by Chris Yates(Blog|@YatesSQL). You are invited to visit his blog to join the blog party. You are welcome to write your own participating blog post for the party or just to read more blogs participating in this … Read More →
Man Vs Machine
Man Vs Machine Are you a fan of the television show Man Vs Food starring foodie Adam Richman? In this show, host and title subject “Man” Adam Richman travels the United States taking on food challenges where he finds them. Sometimes these challenges entail eating more food than is generally humanly possible. Other times it … Read More →
Performing Fast Searches of Query Plans
Performing Fast Searches of Query Plans I’ve made blog posts in the past on using the exist() method to search for query plans with specific attributes (e.g., Find Cached Query Plans By Index Name). Another good aspect of the exist() method is that it is a much faster way to search for a specific string … Read More →
Is SELECT Identity() … INTO Minimally Logged in Simple Recovery?
Is SELECT Identity() … INTO Minimally Logged in Simple Recovery? I was having a discussion with Idera (@idera_software) dev lead Vicky Harp (blog|@vickyharp) about minimizing log impact when performing schema changes on really large tables. One option discussed was using SELECT INTO to create a new table and populate it in a minimally logged operation. … Read More →
Twitter
LinkedIn
TLF
RSS
WritersCafe
SQLPASS
Facebook