TRUNCATE TABLE master..sysdatabases

...and other neat SQL Server tricks
posts - 56, comments - 60, trackbacks - 14


Criminals and Other Illegal Characters

SQLTeam's favorite Slovenian blogger Mladen (b | t) had an interesting question on Twitter: I liked Kendal Van Dyke's (b | t) reply: And he was right!  This is one of those pretty-useless-but-sounds-interesting propositions that I've based all my presentations on, and most of my blog posts. If you read all the replies you'll see a lot of good suggestions.  I particularly like Aaron Bertrand's (b | t) idea of going into the Unicode character set, since there are over 65,000 characters available.  But how to find an illegal character?  Detective work? I'm working on the premise that if SQL Server will...

posted @ Wednesday, June 19, 2013 4:50 PM | Feedback (0) | Filed Under [ Coolness Hotness ]

SQL Saturday #220 - Atlanta - Pre-Con Scholarship Winners!

A few weeks ago, AtlantaMDF offered scholarships for each of our upcoming Pre-conference sessions at SQL Saturday #220. We would like to congratulate the winners! David Thomas SQL Server Security ...

posted @ Tuesday, May 07, 2013 3:18 PM | Filed Under [ Coolness Hotness ]

SQL Saturday #220 - Atlanta - Pre-Conference Scholarships!

  We Want YOU…To Learn! AtlantaMDF and Idera are teaming up to find...

posted @ Monday, April 22, 2013 3:59 PM | Filed Under [ Coolness Hotness ]

SQL Saturday #220 Atlanta May 2013!

If you love SQL Server training and are near the Atlanta area, or just love us so much you're willing to travel here, please come join us for: SQL SATURDAY #220! The main event is Saturday, May 18.  The event is free, with a $10.00 lunch fee.  The main page has more details here: We are also offering pre-conference sessions on Friday, May 17, by 5 world-renowned presenters: Denny Cherry: ...

posted @ Wednesday, March 20, 2013 6:52 PM | Filed Under [ Coolness Hotness ]

T-SQL Tuesday #33: Trick Shots: Undocumented, Underdocumented, and Unknown Conspiracies!

Mike Fal (b | t) is hosting this month's T-SQL Tuesday on Trick Shots.  I love this choice because I've been preoccupied with sneaky/tricky/evil SQL Server stuff for a long time and have been presenting on it for the past year.  Mike's directives were "Show us a cool trick or process you developed…It doesn’t have to be useful", which most of my blogging definitely fits, and "Tell us what you learned from this trick…tell us how it gave you insight in to how SQL Server works", which is definitely a new concept.  I've done a lot of reading and watching...

posted @ Tuesday, August 14, 2012 7:30 PM | Feedback (0) | Filed Under [ Coolness Hotness ]

T-SQL Tuesday #31 - Logging Tricks with CONTEXT_INFO

This month's T-SQL Tuesday is being hosted by Aaron Nelson [b | t], fellow Atlantan (the city in Georgia, not the famous sunken city, or the resort in the Bahamas) and covers the topic of logging (the recording of information, not the harvesting of trees) and maintains the fine T-SQL Tuesday tradition begun by Adam Machanic [b | t] (the SQL Server guru, not the guy who fixes cars, check the spelling again, there will be a quiz later). This is a trick I learned from Fernando Guerrero [b | t] waaaaaay back during the PASS Summit...

posted @ Tuesday, June 12, 2012 9:23 AM | Feedback (0) | Filed Under [ Coolness Hotness ]

SQL Saturday #89 in Atlanta!

(Yeah yeah, technically it's in Alpharetta, but it's close enough.) Saturday…Saturday….Saturday…. September 17th.  TWO THOUSAND ELEVEN! OK, it's not a tractor pull, but it's even better:  FREE SQL SERVER TRAINING!  They have a bunch of great speakers lined up, and for some reason, me.  (Protip: be good friends with the program committee, have sufficient bribe funds, and if all else fails, lots of alcohol, drugs and a camera.  Ba-ZING!  You too can speak at SQL Saturday!) I will be presenting Revenge: The SQL! in a new and improved SQL Saturday themed presentation.  Actually, it's the same ol' presentation, I just updated the slide...

posted @ Tuesday, September 13, 2011 11:00 AM | Feedback (0) | Filed Under [ Coolness Hotness ]

Powered by:
Powered By Subtext Powered By ASP.NET