SQL Server 2012 Diagnostic Information Queries (September 2012)
Here is the September 2012 version of my SQL Server 2012 Diagnostic Information Queries, with some minor tweaks and improvements...
2012-09-16
1,218 reads
Blog Posts
SQLSaturday #171, Pittsburgh
Date: October 6, 2012
Title: Searching for the Holy Grail of DDL Auditing
Abstract:
Who altered this view and how? When was that...
2012-09-16
690 reads
Attendant’s checklist to a SQL Saturday event
Weeks Before The Event
Check for conflict in Schedule
Family Activities (Y/N)Business Appointment (Y/N)Other Commitments (Y/N)Plan the Trip
Distance (calculate travel time)Budget $ (Gasoline,...
2012-09-15
707 reads
After Seven Years, Time for Something New
Earlier this month, I passed the seven year mark at Digineer. It was a weird feeling, since the last time...
2012-09-14
709 reads
Book Review: SQL Server 2012 Integration Services Design Patterns
This book is written by Andy Leonard, Matt Masson, Tim Mitchell, Jessica Moss, and Michelle Ufford. These are all highly...
2012-09-14
2,778 reads
Certificates of Completion for SQL Seminars
Most managers and employers distinguish between attending a conference and training. We (the royal SQL community we) offer quite a...
2012-09-14
1,116 reads
Change file logical name for mirror database
Today I encountered a interesting issue when rename logical name for mirror database.
We have a database which has been setup...
2012-09-14 (first published: 2012-09-09)
3,072 reads
Conference in Florida: SQL Server Live
This conference is new to me. In case it’s new to you, I thought I’d take a moment to point...
2012-09-14
969 reads
Detecting and Removing Duplicate Indexes
Indexes are the solution to many performance problems, but with too many indexes on tables can hurt the performance of...
2012-09-14
1,804 reads
Interesting Culture
A post from Alex Maccaw, programmer at Stripe. He talks about some things he likes about the company, and overall...
2012-09-14
1,199 reads
Blogs
Blog a Day – Day 1: History of AI
By Vinay Thakur
it has been a year since i have not written much on the blog...
A New Word: on tenderhooks
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
Forums
A Quick Restore
Comments posted to this topic are about the item A Quick Restore
Guarding Against SQL Injection at the Database Layer (SQL Server)
Comments posted to this topic are about the item Guarding Against SQL Injection at...
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
Question of the Day
A Quick Restore
While doing some testing of an application, I wanted to reset my environment after doing some testing with this code:
USE DNRTest BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO /* Bunch of stuff tested here */RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance. See possible answers