Episode 6 is tonight, and of course I haven’t done show notes for LAST week. I can only claim Having a Life as an excuse. But not in a snarky way.
Season 3 Episode 6 show notes
- News & Twitter bits:
- Austin SQL Sat speaker deadline is 9/1. Submit early, submit often. www.sqlsaturday.com
- DataEducation Miss your high school chemistry classes? @sqlagentman brings you back: http://bit.ly/nPCuff
- Twitter
- SQL Sat OKC just sold out
- Emilymas #scarymovierulestoliveby don’t yell out Hello? As if the killer will be like “yeah I’m in the kitchen want a sandwich?”
- grumfellow #sqlsat64 #midnightdba Powershell for DBAs session opened my eyes about the goodness in Powershell. Thanks for a great session!
- LadyRuna Look, if you deleted the data and you don’t have a backup and you didn’t notice that you shouldn’t have deleted back then, it’s GONE.
- thecheckoutgirl If you can’t eat at least half your body weight in cheese, I’m not sexually attracted to you.
- TheTweetOfGod You can fool all of the people some of the time, and some of the people all of the time, so right there you’ve got a lot to work with.
- MeetingBoy Holding a meeting in the men’s bathroom to exclude a female executive is a total dick move… http://t.co/NrE8Z8u
- Baton rouge recap.
- Dallas TechFest recap
- Jen Topic: funny error, “SUM is not a recognized built-in function name”
- Jen Topic: MERGE
Optimizing MERGE Statement Performance http://technet.microsoft.com/en-us/library/cc879317.aspx - Sean: backup compression and T3042 http://blogs.msdn.com/b/psssql…up.aspx
KB http://support.microsoft.com/kb/2001026 - Sean: tsql (thingy) Spotlight: DBCC DBRepair — it’s still there, but it’s undocumented… drops corrupt DBs.
- Sean: default schema not working.
- Sean: dallas techfest recap.
- Sean: book review — i’ll come up with something.
- Sean: new cool ps blogs this wk.
- Sean: new denali countdown… it’s dynamic so it changes as they announce diff dates.
- Man-in-the-Field Report by Nic: new SQL 2012 data types
This is what you miss if you don't watch the show live
Linky links:
- This will make you happy until tonight’s show airs: http://music.mikephirman.com/ WE ARE PART OF THE REBEL ALLIANCE…
- Phil_Factor Experimental article I’ve just written. http://bit.ly/oci2re
- SQLChicken #SQLDenali CTP3 Product Guide http://t.co/ZseaOn2 #sqlserver #sqlpass
Season 3 Episode 5 show notes:
News & Twitter bits:
- @MSFTNews: 15yo “Microsoft Excel World Champion” beats out 228,000 competitors from 57 countries – Excel fans FTW! http://bbc.in/pl9bxK Seriously?
- @PaulRandal: [Blog] RTFM. No seriously, R.T.F.M. Then ask your question. http://tinyurl.com/3np39ca
- @Gizmodo: Facebook now wants to put ads in your personal feed http://t.co/NXJMpZR #clusterzuck
- I wanna make ginger ale. @wilw Making ginger ale using this recipe: http://t.co/UTPL5I6 Is it 48 hours from now, yet?
- 25HOP: Summit 2011 Preview edition http://cot.ag/piKwP9
- @mrdenny PASS is a coming, time to start thinking about your party plans http://bit.ly/prEW6i
- @grrl_geek Updated: A Cheat Sheet for All the *{_(%#$] PowerShell Punctuation – http://bit.ly/ofQ47C .
- @BoingBoing Perma-cookie wars continue: KISSMetrics sneaks cookies back onto your computer even if you turn off every cookie vector http://goo.gl/WLu1j
Links:
-
- @BrentOzarPLF [Blog] Sample DBA Resumes http://bit.ly/ovtvMC Nobody knows who I am.
- SQLChicken Apparently SQL Server puts out http://t.co/9meVqDM
- LadyAstronomer Free programming textbooks! #GreenTeaPress their “manifesto”: Students should read & understand textbooks. That’s it. http://t.co/gdCcSpd
Topics and bits:
- Topic: @erinstellato If you have only one DBA, who does DBA stuff when the DBA is on vacation?
- Sean: Interview rant.
- How can you roll back a truncate table. TRUNCATE doesn’t play well with replication.
Nic: More SAN hell. ALL THE THINGS!!!- Sean vid: find out what is holding the lock on a file.
- TSQL Spotlight: sp_fileexist
- Tech topic: Grant’s “Reason for Early Termination of Statement” blog, and a reading from SQL bible Ch 63. Pimp his PASS precon (http://www.scarydba.com/2011/08/03/all-about-execution-plans-2/)., site (scarydba.com)
- Topic: Leaving jobs, process, choosing, what to do before you leave.
SirSQL: “Dear Resume, I know I’ve not updated you in a while, but it’s time. I’ve done some things I’m not proud of and I don’t want to talk about those. Let me tell you about some cool shit that I did, some of it isn’t made up”
