Monthly Archives: March 2016

No Overtime

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

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

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

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

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

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

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

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

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

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 , ,