Tag Archives: administation

Monitoring and Alerting

Monitoring your systems is important. It’s not just me that thinks so, as plenty of experienced DBAs and developers know the value of monitoring. Heck, most people have learned to build some sort of metric collection into their software. Azure … Continue reading

Posted in Editorial | Tagged ,

When were statistics updated?–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I ran across the STATS_DATE function recently, and it’s one that I hadn’t used in production code. I’m not … Continue reading

Posted in Blog | Tagged , , | 2 Comments

T-SQL Tuesday #70 – The Enterprise

It’s hard to believe this is the 70th edition of T-SQL Tuesday. I haven’t missed many, and I’ve enjoyed them all. I hope more of you are participating in this monthly blog party started by Adam Machanic (b / t). … Continue reading

Posted in Blog | Tagged , , ,

Upgrading a SQL Azure Database to v12

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I was looking to test some of the Azure v12 capabilities, but I needed to upgrade a database. Here’s … Continue reading

Posted in Blog | Tagged , , ,

The Log Chain

I ran across a question recently from someone that received a similar message to the one showed in this image: In this case, the log chain is broken. I’ve received this message, usually from a script that is automatically restoring … Continue reading

Posted in Blog | Tagged , , ,

Create a SQL Azure Database–Old Portal

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I worry about beta software, so when I wanted to create a new Azure database, I stuck with the … Continue reading

Posted in Blog | Tagged , , , | 2 Comments

Start SQL Server in Single User Mode

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I saw someone recently ask how to reset the sa password, and myself (along with a few others) suggested … Continue reading

Posted in Blog | Tagged , , ,

Using the DAC

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. The DAC is a really important tool for anyone managing a SQL Server. You might not use it often, … Continue reading

Posted in Blog | Tagged , ,

Password for SQL Server Service Accounts

I wrote recently about my philosophy for service accounts, and wanted to add a few more thoughts. Security is important for our database servers. One of the loopholes that everyone should be aware of is that the service running SQL … Continue reading

Posted in Blog | Tagged , ,

No Defaults – T-SQL Tuesday #68

It’s the second Tuesday of the month, and time for T-SQL Tuesday. This month’s invitation is from Andy Yun, where he asks you to Just Say No to Defaults. This is the monthly blog party started by Adam Machanic, and … Continue reading

Posted in Blog | Tagged , , | 1 Comment