SQL Works
Have you ever needed advice that was easy to use and just made things work? This is SQL Works
Monday, December 2, 2013
Thursday, November 14, 2013
90 Days to MCSA - week 6
Well here we are in "week 6" and the time has been flying...being so busy with fully renovating a house (dedicateddiy.blogspot.com) I have neglected my 90 Days To MCSA prep, but no more!
Tonight I will be asking about certifications at the New England SQL Server Users Group meetup and see who has some advice for me, and then I think I need to just book the first test to jolt myself into action.
Checking out the dates and locations near me on Prometrics site I see there are plenty of test dates right nearby, so I have no excuse there. Has anyone else stalled out, or are you all charging ahead ? How is it going ? A walk across the MIT campus is always inspiring, I'll make sure to do that again after the meetup.
From last month:
Tonight I will be asking about certifications at the New England SQL Server Users Group meetup and see who has some advice for me, and then I think I need to just book the first test to jolt myself into action.
Checking out the dates and locations near me on Prometrics site I see there are plenty of test dates right nearby, so I have no excuse there. Has anyone else stalled out, or are you all charging ahead ? How is it going ? A walk across the MIT campus is always inspiring, I'll make sure to do that again after the meetup.
From last month:
Wednesday, October 23, 2013
PASS TV YouTube channel - all sessions available
Now that PASS 2013 is over, head to the PASS TV YouTube channel to watch the sessions, I have embedded my favorite so far, parallel query plans with Paul White (@SQL_Kiwi)
Friday, October 18, 2013
90 Days to MCSA - Week 2 - New functions for 2012
In studying for the Querying Microsoft SQL Server 2012 (70-461) exam I am trying out a couple new items, below are a few that are mentioned in a few different training programs, probably good to know these.
IIF works just like the instant IF in Excel
TRY_CONVERT and TRY_PARSE both perform the same function as CONVERT and PARSE respectively, but these new version will return a NULL instead of raising an error if the conversion or parse fails
OFFSET and FETCH are good for pagination, in the example above it would return rows 6-10
Happy studying!
-- NEW FOR 2012 -- IIF(<boolean expr>, <value if true>, <value if false>) SELECT IIF(1 = 1, 'True Value', 'False Value') -- TRY_CONVERT(<expr>, <datatype>, <style>) SELECT TRY_CONVERT(DATETIME, '1/1/12330', 101) -- TRY_PARSE(<string val> AS <datatype> USING <culture>) SELECT TRY_PARSE('String' AS INT USING 'cy') -- OFFSET...FETCH SELECT name FROM sys.objects OFFSET 5 ROWS FETCH NEXT 5 ROWS ONLY
IIF works just like the instant IF in Excel
TRY_CONVERT and TRY_PARSE both perform the same function as CONVERT and PARSE respectively, but these new version will return a NULL instead of raising an error if the conversion or parse fails
OFFSET and FETCH are good for pagination, in the example above it would return rows 6-10
Happy studying!
Thursday, October 17, 2013
90 Days to MCSA - Week 2 YouTube video training playlist
I have been watching some video training on YouTube and found these videos to be pretty well made and contain some good review points for exam 70-461. It can be pretty basic in a lot of places but it's always good to brush up before the test. Check it out:
Subscribe to:
Posts (Atom)