Monthly Archives: March 2016

No Overtime

Posted on March 31, 2016 by

This editorial was originally published on Dec 5, 2011. It is being re-run as Steve is out of town. It’s been a long time since I received overtime at any job. Most of my IT work has been with a … Continue reading →

Posted in Editorial | Tagged

Examining SQL Server 2016

Posted on March 29, 2016 by

SQL Sever 2016 is getting close to release. The updates are coming fast and furious, causing issues in some cases as many people look to test the new features in different environments. Personally, I’m struggling a bit to determine which … Continue reading →

Posted in Editorial | Tagged ,

Protecting the SA Account

Posted on March 29, 2016 by

The sa account is a well, known, built in account for SQL Server. Years ago, in previous versions, I’d see people often use the “sa” account for development, usually with a blank password. Even those speakers and experts often showed … Continue reading →

Posted in Blog | Tagged , ,

Dexterity Matters

Posted on March 28, 2016 by

I typo things. I make mistakes in the QOD, checking the wrong box. Even in a browser at times there’s a button or hot area too close to the bookmarks bar and instead of completing an action, like checking my VSTS … Continue reading →

Posted in Editorial | Tagged

SQL Nexus in Copenhagen

Posted on March 28, 2016 by

The Nordic SQLNexus conference is taking place in Copenhagen on May 2-4. I’ve never been to the event, or the country, but I was accepted to speak, so I embark on another multi-city, multi day trip. SQLNexus has quite a … Continue reading →

Posted in Blog | Tagged ,

Protecting sa

Posted on March 25, 2016 by

Built in accounts are both a help and and a hindrance. Years ago I was working on a SQL Server 4.2 system, where I was an administrator. The database was very unstable, and we were trying to determine if it … Continue reading →

Posted in Editorial | Tagged ,

Default Data Masking

Posted on March 24, 2016 by

Dynamic Data Masking is a neat new feature in SQL Server 2016. I didn’t think much of it when it was introduced in Azure SQL Database, but since then I realize there is some value here. Even if it’s just … Continue reading →

Posted in Blog | Tagged , ,

Do Less

Posted on March 24, 2016 by

When I read this blog post, I was transported back to simpler times, when I learned to develop applications on 8088 processors. Back then, to make the system go faster, we learned to do less. It’s certainly true that the less … Continue reading →

Posted in Editorial | Tagged | 2 Comments

The OUPUT Clause in an INSERT–#SQLNewBlogger

Posted on March 23, 2016 by

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I got asked a question about the OUTPUT clause recently and realized I didn’t remember the syntax. I’ve rarely … Continue reading →

Posted in Blog | Tagged , , | 3 Comments

SQLBits in Space

Posted on March 22, 2016 by

It’s coming in May. The official UK SQL Server 2016 launch event is SQL Bits and the conference returns to Liverpool on May 4-7.  With a fun theme. Check out the launch video here: SQLBits XV Update (Mar 24): The … Continue reading →

Posted in Blog | Tagged , ,