SQL Azure–Failed to Update because the database is read-only

An error message for one of our many SQL Azure databases was brought to my attention today.
Msg 40628, Level 16,...

2012 PASS Elections Letter Of Recommendation From Karen Lopez

I'm a candidate in the 2012 PASS Board of Directors elections and believe that an important part of what makes...

Finding and removing hidden characters in your data using dynamic T-SQL

It has been a long morning for me. It was supposed to be a standard run for our quarterly data...

Reblog: September 28 to October 4

Welcome to this Friday’s reblog summary post.  The aim of these posts is to bring some old posts that newer...

SQL Saturday #149 Session Materials

This past weekend I attended this year’s SQL Saturday in Minnesota. It was a good time, and it was on...

10-minute SQL: Filtered Delete: join vs. sub-select vs. exist

I was doing some simple tuning of procedures for a client when I came across some delete statements that I...

Kathi Kellenberger speaking at Midlands PASS

On October 17th, Midlands PASS will welcome Kathi Kellenberger to speak on T-SQL 2012. Here's what her talk will be...

Is Instance name SQLEXPRESS is fixed for Express edition only ?

A Question “SQLEXPRESS instance name is fixed for Express edition only ?” is running in my mind. SO I have decide...

How to Make SQL Server Listen on Multiple Ports

Have you ever needed an instance of SQL Server to listen on multiple TCP/IP port numbers but didn't know how...

Presenting PowerShell: Automating SQL Stats Collection