October 17, 2011 2:00 PM
Posted by: Denny Cherry
SQL Server,
T/SQLEveryone has their favorite way or running a block of code over and over again. If you have to run an entire batch over and over again there is nothing as quick and easy as using the "GO n" syntax. When you put a number after the GO batch separator SQL Server Management Studio (as well...
October 14, 2011 6:52 PM
Posted by: Denny Cherry
Confio,
Kerry Tyler,
Pat Wright,
SQL PASS,
SQL PASS 2011,
Tamara ClarkSince I didn't make it to the SQL PASS keynotes this morning, I figured that I'd tell you about another little event that happened late last night. Last night there was a SQL PASS first. There was a wedding here at the PASS summit. Tamera Clark (
October 13, 2011 4:50 PM
Posted by: Denny Cherry
Keynotes,
PASS,
SQL PASS,
SQL PASS 2011,
SQL ServerWelcome to SQL PASS Summit Keynote on Day 2. Today was another day of announcements made by Quentin Clark who is the Corporate VP for Microsoft who is in charge of the SQL Server database engine.
Quentin started his talk about how SQL Server 2012 will improve the way that SQL Server provides...
October 12, 2011 5:02 PM
Posted by: Denny Cherry
Azure,
SQL PASS,
SQL PASS 2011,
SQL Server,
SQL Server 2012,
SQL Server MVP Deep Dives Volume 2Today was Day 1 of the SQL PASS summit. Today there were a few announcements during the keynotes which if you didn’t see on the live streaming site you probably want to hear about.
During the PASS portion of the keynote we also heard about the massive amount of training the the SQL PASS...
October 11, 2011 11:11 PM
Posted by: Denny Cherry
SQL PASS,
SQL PASS 2011The SQL PASS Summit is getting ready to begin. If you are attending the SQL PASS summit I hope that you have already arrived in Seattle so that you can have some fun tonight at the events before getting started at the conference tomorrow.
Things you can look forward to tonight at the PASS...
October 10, 2011 2:00 PM
Posted by: Denny Cherry
SQL PASS,
SQL PASS 2011,
SQL Server,
SSRSWhile doing some research for my Half Day SQL PASS Session with Stacia Misner (blog | @staciamisner) I discovered that some of the queries which the SSRS engine runs against the ReportServer database are less than perfect total crap. My specific...
October 6, 2011 2:00 PM
Posted by: Denny Cherry
SQL Karaoke,
SQL PASS,
SQL PASS 2011,
SQL ServerThe SQL PASS summit is quickly approaching, and with the excitement of large conferences comes the worry of what to do during the week. How am I going to meet people, what am I going to do after hours or during the day when there is a session that I don't want to attend?
This is a question...
October 4, 2011 7:58 PM
Posted by: Denny Cherry
auto-stats,
SQL Server,
SQL Server 2008 R2,
SQL Server 2012,
Statistics,
Trace FlagI recently learned about a new trace flag which has been introduced in SQL Server 2008 R2 SP1 (and SQL Server "Denali"). This trace flag, number 2371, changes the way that the SQL Server figures out when auto-stats should kick in.
Up until now auto-stats was fixed to kick in every time that...
October 4, 2011 7:36 PM
Posted by: Denny Cherry
Birds of a Feather,
SQL PASS,
SQL PASS 2011,
SQL Server,
StorageThis year at the SQL PASS summit I'm once again taking a lunch table for the Birds of a Feather lunch on Friday. And even better than last year I don't have a session that I'm presenting right before lunch so I'll actually be there on time (last year I was like 30 minutes late because of Q&A...
