Show:

• S3 ep 09 of Psych is Christmas Joy: Shawn and Gus help a girl free a mall Santa from jail, only to realize they’ve been duped by con artists using Santa’s village to plot a big score. Elsewhere, Gus’ visiting sister plans to relive a fling she once had with Shawn, and Shawn helps the entire Guster family work through their various family secrets.

Events

• 24HOP next week, Sep 6 and 7. You can catch recorded 24HOP session on sqlpass.org.
• Things that PASS first timers really need to know webcast : http://bit.ly/pacLtg MrDenny:   On Tuesday September 6th, 2011 at 10am Pacific Time (1pm Eastern, 5pm GMT) I will be putting on a webcast to give first timers (and people that have attended before) some critical information about Seattle and the summit that they should probably have before actually getting to Seattle for the summit.
• Professional Underground for SQL Server – PUSS
• Alan Hirt’s SQL Server Foundations class, $218
  http://elearning.left-brain.com/event/sql-server-foundations?code=EP2919A1
• Allen White : Get to Know #PowerShell by Allen White (@SQLRunr) | Nov 14-16 Boston | http://bit.ly/k9CaIu | #sql #sqlserver @sqlserver #sqlcommunity

News

• InapproPASS (now P.U.S.S.) is ROARING! Fill out the survey, get your sessions ready. Also see Nic’s blog Being Inappropriate At The Summit (Nuurdygirl says PUSS-y)
• Sean talked about our boys
• And our phone
• SirSQL Canadian radio stations can once more play Dire Strait’s “Money for nothing” after it was banned in 1985. How cool is that? < We’re not banned in canada any more!!
• @MladenPrajdic well… looks like SSMS Tools Pack 2.0 is feature and bug fixes complete. Release probably late next week.

Discussion

• SQL Sentry Plan Explorer – Seventeen different kinds of FREE WIN.
  “SQL Sentry Plan Explorer is a FREE tool that builds upon the graphical plan view in SQL Server Management Studio (SSMS) to make query plan analysis more efficient. It is a lightweight standalone app that contains many of the plan analysis features introduced in SQL Sentry v6. It does not require a collector service or database. “
  Management studio addin
• tsql thingy (undocumented) –
  • xp_dirtree — finds dirs and their depth for given path… really useful for finding a dir whether a dir is located anywhere on a drive…
  • xp_subdirs– finds only 1st level dirs.
• Bad error messages: universe is collapsing around the Enterpeise in “Remember Me”, and Dr Crusher asks the computer “what was that [explosion]?”  Answer: “There is a flaw in the ship’s design.”
• Sean’s story: Space getting out of control. “And we’ve got 60 Tb to manage a 1Tb application.”
• SQLServerIO: Just want to thank Chief Wieners for putting Texas back on the map, in the worse way possible. http://gizmo.do/r7naqR [This is fucking outrageous]
• Man cave award
• Nic: FKs are inviolate…not. Connect item 685800 allows FK constraint violations. MS Programmability Team said they dno’t consider it a big issue. https://connect.microsoft.com/SQLServer/feedback/details/685800/parameterized-delete-and-merge-allow-foreign-key-constraint-violations
• Twitter bit: am740: Check out the #RockAndRollProductIntegration hashtag game – we photoshopped our faves as album covers: http://bit.ly/oRN8NY @RainnWilson [See http://twitter.com/#!/search/RockAndRollProductIntegration%20 ]
• Twitter bit: dfinke   OH: The problem with #PowerShell is it doesn’t have a GUI
• Tech tip: Partitioning without partitioning. OOOOhhhhh. “Partitioning and the Free Lunch”. http://www.midnightdba.com/DBARant/?p=685
• @Dave_Levy: “NoReplyAll Outlook Add-In http://research.microsoft.com/en-us/projects/researchdesktop/noreplyall.aspx ” #Finally
• kekline  A quick observation and straw poll regarding WIT experiences on my blog: http://bit.ly/pNPemX #WIT
• Story time with Sean: moving DB files (blog: http://www.midnightdba.com/DBARant/?p=689 )
• DBA Theatre!

 Twitter and Links To Read

• neilhimself   Is there a relatively innocent swear word (like a Bother! or a Bugger!) that has either a V or W in it?
• donalddotfarmer  The complexities of the -ass suffix: http://bit.ly/reNC2K
• shannonlowder   Review: String Manipulation — REPLACE, PATINDEX and Regular Expressions http://bit.ly/gUzlWg #Microsoft_SQL
• Phil_Factor:   My goodness. Another Phil Factor article! http://bit.ly/qZb8bJ Temporary Tables in SQL Server. They just sort of pop out.
• DevNambi  Just started following a bunch of people going to #sqlpass. The list is up at http://www.sqlpass.org/summit/2011/Connect/WhosComing.aspx
• BoingBoing   Gutenberg to Zuckerberg: the kind of Internet primer you want to slide under your boss’s door http://goo.gl/MF9iM
• NeilDavidson   Video on putting your database in source control, from @falafel – http://tv.falafel.com/default/11-08-06/Best_Practice_Source_Control_the_DB_in_Sitefinity.aspx
• @ryan_veino: If Chuck Norris wrote a #PowerShell script it would be a 1-liner, b/c he can do anything in 1 strike? http://blogs.technet.com/b/ashleymcglone/archive/2011/08/29/powershell-sid-walker-texas-ranger-part-1.aspx

Other things this week that didn’t make the show:

• This is total bullshit, i agree. #NOOOOOOO
• OLEDB / ODBC and again on Technet
• On the techie front, Tim Ford’s nice how to on sql agent service restart job:
• Holy shit, how have I missed this? Real life superheroes. Article,
  See the latest @Nerdist podcast #119 for an interview with Phoenix Jones, one of the Seattle superheroes.
  Also, video I haven’t watched yet: http://abcnews.go.com/US/real-life-superhero-phoenix-jones-tackles-streets-seattle/story?id=12562715