24 Hours of PASS registration open
Registration is open for 24 hours of PASS in March! Go to http://bit.ly/fMzarY to register. This one is “Celebrating Women in Technology” and has some great sessions lined up, including discussions on T-SQL, SSRS, SSIS, performance, MDX, even Twitterdata in Azure! You don’t want to miss this!
24 Hours of PASS – March 15-16 2011
The 24 Hours of PASS is returning March 15th-16th 2011, and they’re looking for feedback on which sessions to include! If you’d like to participate, the link to the survey can be found here. I chose the ones I’d like to see, be sure to stop by and make your selections for your favorites! I’m looking forward to another great set of informative sessions! If you haven’t done the 24 Hours of PASS yet, it’s definitely worth attending! If you…
Case expressions may only be nested to level 10
I was working on a rather lengthy query that used a typical CASE WHEN THEN ELSE END sequence, but it kept telling me “Case expressions may only be nested to level 10”, even though I wasn’t nesting or doing something unique with them, just like this: case when field1 = ‘data’ then ‘data1’ when field1 = ‘datax’ then ‘data2’ when field1 = ‘datay’ then ‘data3’ when field1 = ‘dataz’ then ‘data4’ when field1 = ‘dataa’ then ‘data5’ when field1 =…
24 Hours of PASS is back!
SQL PASS (@sqlpass) is having it’s FREE 24 Hours of PASS event again, May 19th and 20th. For 24 hours, industry professionals such as Brian Knight, Donald Farmer, Thomas Grohser, and Brad McGehee will be presenting topics on SQL Server 2008 R2, including database design, SSRS, SSIS, BI, data warehousing, dashboards, server performance and much more. The link to register is here. I did the last one back in October 2009 and it was fantastic. A little difficult to stay…
Long SQL query time and account permissions
My good friend @MichaelPerillo and I were recently discussing the possible cause for a SQL query to take an excessively long time, even though proper measures had been taken to ensure performance tuning had taken place. He made a suggestion that I believe is noteworthy, so I’m putting it here, also so I can reference it later. A transactional SQL database performs each transaction in a queue, assigning each transaction a queue request. Queue requests are prioritized not only by…