Tag Archives: sql server

A SQL Server Bug and Data Security

This week I saw a post from Microsoft Tiger Team on the issues with backup compression and TDE databases. Apparently when they added compression, they didn’t test a few edge cases. Or a few regular cases, like WITH INIT. There … Continue reading

Posted in Editorial | Tagged , | Leave a comment

SSoL: Adding disk space with a repartition

I don’t think most of us need to know Linux, but if you end up managing a system, it’s good to have a little idea of how to get around. This is a short series of posts as I remember … Continue reading

Posted in Blog | Tagged , , | 4 Comments

Backup Log to Nul– #SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. This is also a part of a basic series on git and how to use it. There are times … Continue reading

Posted in Blog | Tagged , , , | 4 Comments

SSoL: Where are my data and log files?

I don’t think most of us need to know Linux, but if you end up managing a system, it’s good to have a little idea of how to get around. This is a short series of posts as I remember … Continue reading

Posted in Blog | Tagged , , | Leave a comment

Getting Close to the 2017 RTM

I still can’t believe that we’ll have a new version of SQL Server this year. After speaking at so many events last year, talking about the new features of SQL Server 2016, it seems crazy that there’s a new version … Continue reading

Posted in Editorial | Tagged | Leave a comment

SQL Server 2017 RC1 is Here

And I’ve got it. Glenn Berry posted a a link to the MSDN blog and almost immediately a note that the link was still the CTP. I decided to fire up my Ubuntu install and check. No updates there, though … Continue reading

Posted in Blog | Tagged , , | 2 Comments

Database Mirroring Needs FQDNs

A quick basic post, and one that I’ve forgotten. Since blogging is a good way to remind myself of things, here goes. I was testing Database Mirroring (DBM) recently for an upgrade situation. I’ve set up it up in the … Continue reading

Posted in Uncategorized | Tagged , , , | Leave a comment

SQL Server is Lagging a Bit

I don’t expect this to last, or I hope it doesn’t, but SQL Server is lagging behind. I ran across a short piece on the SQL:2016 standards, and I know these standards aren’t necessarily an important consideration for most of us when choosing … Continue reading

Posted in Editorial | Tagged | Leave a comment

Adding Performance Counters back for SQL Server

I had a strange situation the other day, where a number of things went wrong with my instance. First, I lost permissions to detached databases. The SID was listed in the file permissions, but apparently unlinked to an account. Next, … Continue reading

Posted in Blog | Tagged , ,

Using OPENROWSET in SQL Server on Linux

I wanted to import the million song dataset in SQL Server on Linux. There’s a github repo that has the SQL to allow you to use this with the graph database features. However, it’s built for Windows. Linux is a … Continue reading

Posted in Blog | Tagged , , , | 2 Comments