August 30, 2013 at 10:41 am
YAY! I have a new computer at work.
Which means I have just spent all morning recovering all my SSMS options, importing my email files, etc. etc. And now I have to figure out how to force BIDS to open up T-SQL into SSMS.
I did it once. I just can't remember where the setting is hiding.
August 30, 2013 at 11:17 am
Brandie Tarvin (8/30/2013)
YAY! I have a new computer at work.Which means I have just spent all morning recovering all my SSMS options, importing my email files, etc. etc. And now I have to figure out how to force BIDS to open up T-SQL into SSMS.
I did it once. I just can't remember where the setting is hiding.
Congrats. I just got a new laptop. Now I need to come to terms with Windows 8...
August 30, 2013 at 11:18 am
OK, I've learned my lesson...
Never, ever, ever, never, ever run DBCC Timewarp(slowtime) in production on a Friday...
At least I didn't use the "Reversetime" option...
:hehe:
August 30, 2013 at 11:57 am
ARGGGGH!
The crappy thing about a new computer?
Trying to remember what I did many years ago to get the CTRL-SHIFT-C and CTRL-SHIFT-R combinations to comment out code in SQL 2008. I can't freaking find it and Google is hopeless.
I tried setting the keyboard schema to SQL 2000, but it's not working. Grrr.
August 30, 2013 at 12:10 pm
Brandie Tarvin (8/30/2013)
ARGGGGH!The crappy thing about a new computer?
Trying to remember what I did many years ago to get the CTRL-SHIFT-C and CTRL-SHIFT-R combinations to comment out code in SQL 2008. I can't freaking find it and Google is hopeless.
I tried setting the keyboard schema to SQL 2000, but it's not working. Grrr.
I don't remember how to change it but you could just use the native shortcuts. (ctrl+k+c and ctrl+k+u). 🙂 The upside is that if you use visual studio the keyboard shortcuts are the same.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
August 30, 2013 at 12:18 pm
Sean Lange (8/30/2013)
Brandie Tarvin (8/30/2013)
ARGGGGH!The crappy thing about a new computer?
Trying to remember what I did many years ago to get the CTRL-SHIFT-C and CTRL-SHIFT-R combinations to comment out code in SQL 2008. I can't freaking find it and Google is hopeless.
I tried setting the keyboard schema to SQL 2000, but it's not working. Grrr.
I don't remember how to change it but you could just use the native shortcuts. (ctrl+k+c and ctrl+k+u). 🙂 The upside is that if you use visual studio the keyboard shortcuts are the same.
Those commands, they do not do what you think they do...
The first one (c) includes execution plan. The second highlights the database drop down box.
August 30, 2013 at 12:20 pm
So my new machine is Win 7. I have SQL 2008 installed fresh. Interestingly enough, the Open File with New Connection icon is not on the toolbar in Win 7 where it is in XP (my old box)...
Has anyone else noticed stuff like this when swapping between work boxes?
August 30, 2013 at 12:29 pm
Brandie Tarvin (8/30/2013)
Sean Lange (8/30/2013)
Brandie Tarvin (8/30/2013)
ARGGGGH!The crappy thing about a new computer?
Trying to remember what I did many years ago to get the CTRL-SHIFT-C and CTRL-SHIFT-R combinations to comment out code in SQL 2008. I can't freaking find it and Google is hopeless.
I tried setting the keyboard schema to SQL 2000, but it's not working. Grrr.
I don't remember how to change it but you could just use the native shortcuts. (ctrl+k+c and ctrl+k+u). 🙂 The upside is that if you use visual studio the keyboard shortcuts are the same.
Those commands, they do not do what you think they do...
The first one (c) includes execution plan. The second highlights the database drop down box.
That depends on which keyboard schema you are using. You must still be on SQL 2000. If you change it back to Standard those shortcuts work.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
August 30, 2013 at 12:29 pm
Brandie Tarvin (8/30/2013)
Sean Lange (8/30/2013)
Brandie Tarvin (8/30/2013)
ARGGGGH!The crappy thing about a new computer?
Trying to remember what I did many years ago to get the CTRL-SHIFT-C and CTRL-SHIFT-R combinations to comment out code in SQL 2008. I can't freaking find it and Google is hopeless.
I tried setting the keyboard schema to SQL 2000, but it's not working. Grrr.
I don't remember how to change it but you could just use the native shortcuts. (ctrl+k+c and ctrl+k+u). 🙂 The upside is that if you use visual studio the keyboard shortcuts are the same.
Those commands, they do not do what you think they do...
The first one (c) includes execution plan. The second highlights the database drop down box.
Check CodePlex for BIDS Helper.
That was the first thing we would load in for some of the tweaks it offers.
August 30, 2013 at 12:43 pm
Brandie Tarvin (8/30/2013)
YAY! I have a new computer at work.Which means I have just spent all morning recovering all my SSMS options, importing my email files, etc. etc. And now I have to figure out how to force BIDS to open up T-SQL into SSMS.
I did it once. I just can't remember where the setting is hiding.
Well, that's something that happens every 3 or 4 years - you should be used to the pain by now. 😛
Jan Van der Eecken (8/30/2013)
Congrats. I just got a new laptop. Now I need to come to terms with Windows 8...
Windows 8 isn't hard to come to terms with. If you simultaneously upgraded to Office 15 you may find some pain, though: Office Picture Manager is no more, no replacement except Windows Photo Gallery which omits rather a lot of OPM's features; Outlook seems to have some problems with recognising encodings (I think this is a bug, but of course it may be a "feature" :().
Tom
August 30, 2013 at 2:18 pm
Sean Lange (8/30/2013)
Brandie Tarvin (8/30/2013)
ARGGGGH!The crappy thing about a new computer?
Trying to remember what I did many years ago to get the CTRL-SHIFT-C and CTRL-SHIFT-R combinations to comment out code in SQL 2008. I can't freaking find it and Google is hopeless.
I tried setting the keyboard schema to SQL 2000, but it's not working. Grrr.
I don't remember how to change it but you could just use the native shortcuts. (ctrl+k+c and ctrl+k+u). 🙂 The upside is that if you use visual studio the keyboard shortcuts are the same.
Yeah, go with the times, Brandie. At least Ctrl-Insert, Shift-Delete, Shift-Insert as per the original IBM UAM guide (or whatever it was called, got the book somewhere) still work everywhere (mostly).
August 31, 2013 at 3:43 am
Just ....
Microsoft will no longer offer Masters and Architect level training rotations and will be retiring the Masters level certification exams as of October 1, 2013.
Sent late on a Friday night, right before a USA long weekend.
At least I no longer have to worry about budgeting for the upgrade exam.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 31, 2013 at 3:53 am
GilaMonster (8/31/2013)
Just ....Microsoft will no longer offer Masters and Architect level training rotations and will be retiring the Masters level certification exams as of October 1, 2013.
Sent late on a Friday night, right before a USA long weekend.
At least I no longer have to worry about budgeting for the upgrade exam.
Cool. That relieves a lot of pressure. I haven't taken a single Microsoft certification. Now, since the only one I respect is gone, I don't have to.
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
August 31, 2013 at 9:58 am
Grant Fritchey (8/31/2013)
Cool. That relieves a lot of pressure. I haven't taken a single Microsoft certification. Now, since the only one I respect is gone, I don't have to.
I like that attitude. I thought there were two probably respectable certs though, MCM (or MCSM) and MCA. Even those, of course, are were about ability to do things with MS products, not about broader ability to do things with, say, a number of different DBMSs running on different platforms (at least two out of Windows, Linux, mainstream UNIXes, and IBM operating systems). Actually, anyone who has MCM and MCA has to be extremely good, and so does anyone with just MCM, but people that good are generally known by reputation (I didn't know until today that Gail was MCM, but I certainly knew the was at least that good) so I don't see the value of the certification unless it was taken for fun, as a challenge.
I have a somewhat jaundiced view of MS Certs, anyway. I've never attempted any, couldn't see the value - if I needed to know something I could learn it without wanting a certification for it, and the outfits I wanted to work for were outfits that would understand that. So while I think some may be respectable, I never saw the point in someone like me going for them. It would have been a waste of either my time and money or of my time and my employer's money, unless the firm had so few MS certified people that we couldn't get the right partnership deals with MS (having a couple of junior guys in the shop hold pretty basic level MS certs is useful from that point of view, it saves senior people from having to waste time and money on certifications, and satisfies MS requirements for partnership deals).
I guess certs get pulled because MS is no longer making enough revenue from them; presumably a replacement (not quite the same as what it replaces, of course, that would be a bit too obvious) will appear in due course, to refresh the revenue stream.
edit:fix typo
Tom
August 31, 2013 at 10:37 am
Grant Fritchey (8/31/2013)
GilaMonster (8/31/2013)
Just ....Microsoft will no longer offer Masters and Architect level training rotations and will be retiring the Masters level certification exams as of October 1, 2013.
Sent late on a Friday night, right before a USA long weekend.
At least I no longer have to worry about budgeting for the upgrade exam.
Cool. That relieves a lot of pressure. I haven't taken a single Microsoft certification. Now, since the only one I respect is gone, I don't have to.
Ditto that. I also thought that having to renew the MCM every couple/three years was a bit unfair to those that busted a hump to attain it in the first place. It should be more like a Masters Degree where you always have it and it's understood that you will improve with experience and other training.
Gail, my hat's off to you for getting the MCM. Even when the cert goes away, you'll always have my respect not only as someone who achieved the MCM, but someone that was, in my eyes, an MCM even before the cert became available.
Grant, you're just as amazing. No "real" formal training but a great speaker on multiple subjects and you've written two of the best books on Execution Plans that there will ever be.
--Jeff Moden
Viewing 15 posts - 41,116 through 41,130 (of 66,000 total)
You must be logged in to reply to this topic. Login to reply