Tag Archives: SQLNewBlogger

Using the DAC with SSMS

Posted on June 11, 2015 by way0utwest

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

FORMATing Dates

Posted on June 3, 2015 by way0utwest

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. FORMAT is a function that was introduced in SQL Server 2012. It is designed to … Continue reading →

Posted in Blog | Tagged , , | 3 Comments

DB_Owner Querying for Database Options

Posted on May 21, 2015 by way0utwest

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

Getting Database Properties – DatabasePropertyEx()

Posted on May 14, 2015 by way0utwest

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I had someone ask me a question about security recently, and while working through the answer, I ran across … Continue reading →

Posted in Blog | Tagged , , , | Comments Off on Getting Database Properties – DatabasePropertyEx()