Monthly Archives: March 2018

A New New Microsoft

Posted on March 31, 2018 by

Microsoft is changing again. Microsoft is reorganizing and the head of Windows, Terry Myerson, is leaving. The reorganization isn’t that surprising, as like most large companies, Microsoft usually does something each year. What is interesting is that they are moving away from … Continue reading →

Posted in Editorial | Tagged ,

dbatools is Growing Up

Posted on March 29, 2018 by

The dbatools.io project is growing up rapidly. I went to check something the other day and I was amazed at the command list. This used to fit on one page. Now it’s not close. Here’s the first page: In fact, it … Continue reading →

Posted in Editorial | Tagged , ,

Learning is Hard–March Goals Update

Posted on March 29, 2018 by

This is the third update for my goals for 2018. This is about 3 weeks after the last update, and it’s too soon. Not in time, but because I haven’t done a great job. This was a busy month. March … Continue reading →

Posted in Blog | Tagged , ,

Moving to AWS EC2

Posted on March 28, 2018 by

SQLServerCentral has been stuck in the past for some time, but we’ve finally decided to move. I’ve been asking for this, and it’s usually a resource issue. However, earlier this year we started to debate and examine the costs, and … Continue reading →

Posted in Blog | Tagged , | 1 Comment

The Nightmare Letter

Posted on March 28, 2018 by

I’m not sure if this imaginary GDPR letter is a nightmare, but I do know that in most of the organizations where I’ve worked, this type of request would result in a crash project for me. I’d be working long hours, contacting … Continue reading →

Posted in Editorial | Tagged ,

Small Changes and Big Impacts

Posted on March 27, 2018 by

I’ve been doing some work with RLS lately (Row-Level Security). I think this is one of the most useful features added in SQL Server 2016, and I wish it had been available earlier in my career. I’ve had the need … Continue reading →

Posted in Editorial | Tagged

The 700 Milestone for SQL Saturday

Posted on March 26, 2018 by

This past weekend was SQL Saturday #700. Another milestone in the franchise of events, and I was glad to attend. This is my fifth or sixth Colorado Springs event, and everything ran great. The leadership has changed over the years, … Continue reading →

Posted in Blog | Tagged , ,

A True Lift and Shift

Posted on March 26, 2018 by

Microsoft bought a data center. That’s not news, after all, they’ve been building and buying data centers for some time as they look to expand their Azure footprint, as well as continue to power their own internal systems. As they’ve grown, they’ve also learned … Continue reading →

Posted in Editorial | Tagged

Scripting Tables with dbatools

Posted on March 23, 2018 by

I really like the dbatools project. This is a series of PowerShell cmdlets that are built by the community and incredibly useful for migrations between SQL Servers, but also for various administrative actions. I have a short series on these … Continue reading →

Posted in Blog | Tagged , ,

Ad Hoc Logs

Posted on March 23, 2018 by

A long time ago I started working in a team of people as a general systems administrator. I worked in a team of six people managing a large, 1000+ node network with a number of servers. In my first exposure to … Continue reading →

Posted in Editorial | Tagged