All posts by Jen

#TribalSQL: A new book by new voices in SQL Server

Tribal SQLTwo years ago, we were talking about how cool it would be to get a bunch of unpublished authors to write about what they thought was important about databases. You know, tribal knowledge. So we sent out a call for abstracts and got the ball rolling on one of the coolest things we’ve ever been a part of: TribalSQL.

Thanks to the authors, a slew of volunteer peer editors and technical editors, and not least of all Red Gate software, we’ve got a community-created, professionally-polished tome coming out in very short order!

Check out www.TribalSQL.com for information about the book, the authors, the backstory, and the wonderful charity that this project benefits, Computers 4 Africa. And of course, watch the Red Gate Book Store for the impending release…

Thank you, Red Gate! Thank you to the editors and the new authors. Thanks VERY much to all the folks who contributed to this project!

The man who really pulled it all together (after we pulled it all together)

Red Gate editor Tony Davis, who is rabidly (I presume) supportive of the Chelsea Football club and has a “penchant for real ales“.

(Thanks for all the emails, Tony. Show me a real ale and I’ll buy you one. Maybe three.)

The volunteer editors…

And definitely the authors and peer editors!

Each and every one a wonder and a gem, and also very kind to animals and children.  Also hardworking: getting through three-plus rounds of edits over two years is no small feat:

  • Ben Seaman
  • Bob Pusateri (author)
  • Chuck Lathrope (author)
  • Colleen Morrow (author)
  • Craig Purnell
  • Dave Ballantyne (author)
  • David Tate
  • Dev Nambi (author)
  • Diana Dee (author)
  • Ed Watson
  • James Zimmerman
  • Jason Thomas
  • Jason Yousef
  • John Barnett (author)
  • John Morehouse
  • Joseph D Antoni
  • Justin Dearing
  • Kevin Feasel (author)
  • Mark S. Rasmussen (author)
  • Matt Velic
  • Melody Zacharias
  • Nicholas Cain
  • Robert Volk
  • Scott Murray
  • Shaun Stuart
  • Stephan Lawson
  • Stephanie Locke  (author)
  • Steve Stedman
  • Tara Kizer (author)
  • Thomas Rushton
  • Wil Sisney (author)

And one more…

Thanks to Melanie Townsend over at Red Gate, for coordinating the TribalSQL site, graphics, authors, and associated miscellany!

#CISPA’s Coming Back: Time to Pay Attention Again

This is a cross-post from Jen’s blog…like we do, for important things.

@YourAnonNews: It’s official #CISPA is back. A law that violates your basic right to privacy. Sign & share this petition to stop it: bit.ly/VSuCiz

Lots of illegal things happen, everywhere, every day. People smuggle guns, drugs, and other people in cars and on their persons, to buildings and houses. Even so, authorities aren’t allowed to search an individual, their car, or their home without cause. There are strict limits on invasion of privacy for a reason. The biggest problem with CISPA (and similar bills) is the weakness of the requirements.

Not to put too fine a point on it, but: modern government is happy to pass the kind of bill that allows men with badges into your home on a whim, patdowns and strip searches at checkpoints on the streets. Only, the laws are already long-established for that kind of privacy, so they’ll get all they can online.

I’m an average person. I don’t pay super close attention to politics, to bills, to laws. I’m sure there are nuances and arguments to be made. And after all those nuances and arguments are done with, it will still come back to those basic rights, being taken away because it’s the Internet is still a brand new venue.

What You Must Do

Start paying attention again.

Watch President Obama’s State of the Union tonight at 9pm ET, see what he has to say.

Read up when they reintroduce CISPA tomorrow.

 

In the meantime, feel free to bone up on what this is all about:

Happy, ever-vigilant days,
Jen McCown
http://www.MidnightDBA.com/Jen

#InapproPASS Party 2012 – Seattle

Many of you know about our annual event for charity, where we present sessions and make jokes that aren’t fit for polite society. There’s a lot of swearing and lewd jokes, and it’s all in very good fun.  If you like deeply inappropriate language, and will be in Seattle on November 6, read on!

Summary for the impatient:

  • What’s commonly referred to as “InapproPASS” is our vulgar event for charity (benefiting the Shriners Hospitals for Children).
  • It will be Tuesday, November 6 from 8:30-midnight ish, in Seattle.
  • We’re sponsored by Trainsignal!
  • Pay your $20 entry fee and email our attendance coordinator (Nic at SirSQL.net) with your favorite swear (consider it your password).

And a note for our sponsor: Check out TrainSignal’s SQL Training vids
or find out how to become a SQL instructor.

If you want the wordier version of this blog, go check it out on our Groupies’ site. But if you’re sold, register today!

Buy your tickets here (1 ticket, $20) – but please, don’t register if very strong language and adult humor offends you:

Webcast: The Art and Science of Handling Recruiters

This is a repost from Jen’s blog.

Edit: This event has passed, but the “Handling Recruiters” recording is up! Enjoy.

Guys! We’re totally hosting our first DBARoadmap-sponsored webcast this week! Here are your details (updated to use LiveMeeting):

Who: Sean and Jen McCown, the MidnightDBAs (and you)

What: The Art and Science of Handling Recruiters, webcast complete with lecture, slides, FAQ, and pretty pretty pictures. At least 3 of those 4 guaranteed.

When: Thursday, August 23 at 11:30pm Central

Where:

Attend using Microsoft Office Live Meeting: https://www.livemeeting.com/cc/mvp/join?id=2PPTZ3&role=attend&pw=nh%28%22%244%28%7BB

Add to my Outlook Calendar: https://www.livemeeting.com/cc/mvp/meetingICS?id=2PPTZ3&role=attend&pw=nh%28%22%244%28%7BB&i=i.ics

Why:

Recruiters have the inside track on the majority of full time positions out there, but they come with a certain set of issues. You will find the occasional gold level recruiter who really knows his or her business, but most recruiters require a certain level of handling.

Here we’ll talk about some of the more common issues with technology recruiters, strategies for dealing with them, and some of the best advice you’ll never hear anywhere else.

Sponsored by www.DBARoadmap.com – attendees will receive a discount code, and one lucky attendee will get a free copy of the Roadmap!

Last of all, here’s the Google Calendar link with all the same information, for your convenience:

New Video: Uninstall a CU in SQL Server 2008 R2

Here I’ll show you how to uninstall a CU from SQL Server 2008 R2, CU5 to be specific, but it doesn’t matter. Here there’s a special circumstance where the original install media location doesn’t exist anymore so you have to specify it during the uninstall.

Join in our live DBAs at Midnight webshow
Fridays at 11pmCST on our Ustream channel!

Watch all past shows at MidnightDBA.com

New Video: Find query timeouts in Profiler

Here’s the scenario: Users are complaining that queries are timing out, but nobody knows what queries or SPs go with what tabs on the front end. It’s up to you to find out where the problem is…

This new video shows you how to get query timeouts from a profiler trace.

Join in our live DBAs at Midnight webshow
Fridays at 11pmCST on our Ustream channel!

Watch all past shows at MidnightDBA.com