Browsed by
Tag: SQL 2012

SQL Saturday #279 – Phoenix

SQL Saturday #279 – Phoenix

Here is the video from my SQL Saturday #279 session on developer best practices & good habits to help DBAs keep the server healthy and secure. Please excuse the fact I was dealing with a sinus & chest infection during the presentation, then halfway through the camera died & we had to switch to Lauri’s Windows Phone…such a superior product! You’ll notice halfway through the presentation the resolution changes, and I apologize. Next time I do a speaking engagement I…

Read More Read More

SharePoint Saturday Phoenix 2013

SharePoint Saturday Phoenix 2013

If you attended my session on Connecting a SharePoint list to a SQL table for CRUD ops, thank you for coming! If you missed it, or if you wanted to review it again, my girlfriend was kind enough to record it for everyone! The projector can be difficult to see due to room lighting, but you can always follow along with the slide deck. Both are included in this post: Slide deck

Windows 8 Enterprise error code: 0x800F0906 “Windows couldn’t connect to the Internet to download necessary files”

Windows 8 Enterprise error code: 0x800F0906 “Windows couldn’t connect to the Internet to download necessary files”

I fought with this one for nearly 8 hours today, attempting to install SSMS from SQL 2012.  This requires that the .Net Framework 3.5 and 2.0 be activated in Windows Features.  Sure, there’s a checkbox that you “should” be able to check and everything works fine.  Well, not for me.  I check it, click OK, it tells me it needs to download files from Windows Update, I say OK, and it throws this error. Basic troubleshooting courtesy of Google says…

Read More Read More

Case expressions may only be nested to level 10

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 =…

Read More Read More

%d bloggers like this: