In this blog I will tell you about some issues I had to face as a SQL Server DBA and what were the insights I gained from each. Compare varchar and int - Implicit vs Expclicit conversions. While working on a query I stumbled across. By mistake, but I believe it is worth mentioning. I had a table with a varchar. Column that actually contained numbers, or so I believed. In my query as a result of lack of attention I wrote the following predicate.

Project Hosting for Open Source Software. By clicking Delete, all history, comments and attachments for this page will be deleted and cannot be restored. Is a toolset which assists in the development, deployment, and maintenance.

MGM Grand, Las Vegas, NV. Our earlybird giveaway expires in. Executive Vice President, Microsoft Cloud and Enterprise group. Corporate Vice President of Microsoft Azure, Microsoft.

Register now for SQL in the City 2015! Redgate SQL in the City. SQL Server Training the Redgate way.

A discussion on SQL Server. How not to do a Masters degree. Bull; Posted in Personal. There are many, many guides to successfully completing a post grad degree, so I am not going to add to them. Instead, this is a list of things, based on personal experience, that you can do to make it somewhere between very difficult and impossible to complete that Masters or Doctorate degree. Do the degree while holding down a full-time job. Blogging and writing are a gr.