Tag Archives: administration

Does It Count?

This editorial was originally published on Jan 28, 2011. It is being re-run as Steve is out of town. I wrote a blog recently about downtime and SLAs, and the need to have not only downtime SLAs, but also a … Continue reading

Posted in Editorial | Tagged , | Comments Off on Does It Count?

Using the DAC with SSMS

I’m writing this post as a way to help motivate the #SQLNewBloggers out there. Read the bottom for a few notes on structuring a post. While troubleshooting another issue, I needed to connect to SQL Server with the DAC. I … Continue reading

Posted in Blog | Tagged , , , | 3 Comments

T-SQL Tuesday #67 – Extended Events for DBCC

It’s the second Tuesday of the month and time for another T-SQL Tuesday. This time it’s #67 from Jes Borland on Extended Events. You can read the invite, and whether you can participate today or not, write your blog and … Continue reading

Posted in Blog | Tagged , , , | Comments Off on T-SQL Tuesday #67 – Extended Events for DBCC

DB_Owner Querying for Database Options

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. What can a user with the db_owner database role do? I assumed anything inside of the database (create/alter objects, … Continue reading

Posted in Blog | Tagged , , , | Comments Off on DB_Owner Querying for Database Options