Monthly Archives: September 2018

The Ever Expanding Data Platform

Posted on September 29, 2018 by

This past week was the 2018 Ignite conference from Microsoft, where we had a number of announcements about the data platform. You can rewatch some of the sessions from the event, and I might recommend the keynotes to see some of the … Continue reading →

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

Understanding a UK Keyboard for a US developer

Posted on September 28, 2018 by

One of the very interesting parts of my job is that I run into UK keyboards on a regular basis. Redgate is a UK company and most of the trade show laptops that they bring to events are UK layouts. … Continue reading →

Posted in Blog | Tagged , | Leave a comment

Off to #SQLSat Pittsburgh

Posted on September 28, 2018 by

I’ve never been to Pittsburgh. Actually, in all of my speaking and traveling, I don’t think I’ve even flown through the airport. I’ve been wanting to rectify this, and quite a few friends, like Bill and Konstantine, have been asking … Continue reading →

Posted in Blog | Tagged , , , | 4 Comments

Finding Objects in a Schema #SQLNewblogger

Posted on September 27, 2018 by

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. One of the things I needed to do recently was move some objects from one schema to another. I … Continue reading →

Posted in Blog | Tagged , , | 5 Comments

An Open Thank You to the Microsoft SQL Server Team

Posted on September 27, 2018 by

Thank you, Microsoft SQL Server Development team. I really am happy with your work. I was going through emails and noticed the someone had posted a surprise in the SQL Server 2019 CTP. The post was slightly cryptic, but since … Continue reading →

Posted in Editorial | Tagged | 1 Comment

The Uninteresting But Necessary Work

Posted on September 26, 2018 by

There has been a rising tide of data legislation in the last few years that asks for organizations, especially private companies, to better protect their data. The GDPR is one of the most well known, taking effect with regards to … Continue reading →

Posted in Editorial | Tagged , | Leave a comment

No More Mysterious Truncation

Posted on September 26, 2018 by

If you read the Microsoft White Paper on SQL Server 2019, there’s a gem buried on page 17. It mentions a trace flag, which some of you might appreciate. Here’s a little repro:   As you can see, the plee … Continue reading →

Posted in Blog | Tagged , | 6 Comments

Practical Refactoring

Posted on September 25, 2018 by

Today I hosted a webinar with Gene Kim (@RealGeneKim) and we had a fantastic discussion. I was slightly star struck since I’ve been reading his work and quoting him for years in talks about Database DevOps. It feels like I … Continue reading →

Posted in Blog | Tagged , , | 2 Comments

SQL Server v.Next is Coming in 2019

Posted on September 25, 2018 by

Yesterday the 2018 Ignite conference kicked off with a number of announcements from Microsoft. You can re-watch some talks and the keynote, catching up on Windows, CosmosDB, and more. The big announcement concerning most of us is about the next version … Continue reading →

Posted in Editorial | Tagged | Leave a comment

SOS to ADS

Posted on September 24, 2018 by

When Microsoft announced SQL Operations Studio last year, I wasn’t thrilled. The move to a VS Code shell was less of a concern to me than having a better SSMS toolset. Actually, with VS moving to MacOS, I was hoping … Continue reading →

Posted in Blog | Tagged , , | 1 Comment