Tag Archives: sql server

A Tour of SQL Server Security Features

Abstract Protecting data from unauthorized access becomes more important all the time. SQL Server includes a number of features that make data protection and security easier for developers and DBAs with a framework for protecting data. Come learn how Always … Continue reading

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

No More Service Packs

The new servicing model for SQL Server is out, with a great explanation from Glenn Berry (there’s also a webcast). The summary is that going forward with SQL Server 2017, we won’t get Service Packs anymore. I’m somewhat sad, as I was always looking … Continue reading

Posted in Editorial | Tagged , | 1 Comment

The New CU Schedule

Is my math right? The new CU servicing schedule for SQL Server 2017 is: 1 CU per month for the first year 1 CU per quarter through mainstream support (5 years) That means by my count, we get this: WITH … Continue reading

Posted in Blog | Tagged , , | Leave a comment

We Have a Date

For nearly half of my life, I’ve looked forward to new versions of SQL Server. At first I was just hoping to see SQL Server run on a stable OS, as the OS/2 1v.3 was my original installation. That system … Continue reading

Posted in Uncategorized | Tagged | Leave a comment

Oct 2, 2017 is the GA date for SQL Server 2017

Announced today at Microsoft Ignite, the general availability date is Oct 2, for Windows, Linux, and Docker. Time to get ready to upgrade.

Posted in Blog | Tagged , | 1 Comment

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