What if you threw a house party and nobody came? You’d feel pretty sad, I’m sure. OK, what if you threw a house party for 20 people except those 20 people told all their friends about the party and 45 people showed up causing your neighbors to call the cops and shut the party down … Read more
Years ago I was involved in migrating some databases from Sybase ASE to Microsoft SQL Server. The process was a manual one. We had to BCP out the data from ASE into flat files, we had to parse the stored procedures for what would be obvious syntax errors in Microsoft SQL Server, we had to track … Read more
Looking for a good book on SQL 2012? Only a handful are available right now, you can see a list of books available for pre-order over at Amazon. No, you won’t find my name as an author to any of them. I’ve been asked to write a chapter or two a few times but nothing … Read more
I know three areas of SQL 2012 that have bright future, and learning these three will serve you well for years to come. I am at the MVP Summit this week and I am soaking up as much information about these three items as I possibly can. 2012 is a release year. That means it … Read more
I came across an interesting scenario last week, someone needed to trace statements and they didn’t have SQL Profiler installed. Turns out they don’t actually need SQL Profiler in order to trace the statements hitting the instance. There is a trace flag (4032) that can be used to trace statements. When used with 3605, you … Read more
Don’t give up on Microsoft Connect. The process is not perfect but it can (and often does) work.
