Monthly Archives: March 2018

A New New Microsoft

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

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

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

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

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

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

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

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

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

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