02Nov 2010 by Grant Fritchey 12 Comments

TSQL Tuesday: Why Are DBA Skills Necessary

Misc
  Quote: "Database stuff, all this programming stuff, is easy. Anyone can do it. That's why everyone in the company has sa privileges." For nine months, I worked in an environment where everyone, from developers to QA to the sales people to the receptionist, had SA privileges. You know what? DBA skills are necessary. I speak from the point of view of someone that has had to recover a server after a salse person helpfully "cleaned up the temporary stuff on the server" by dropping tempdb, causing a late deployment for a client. I speak from the point of view of the guy who kept a window open on his desk with the database restore script ready to run, all day long, because of "accidents" that stopped development until I could get the…
Read More
01Nov 2010 by Grant Fritchey No Comments

SQLServerPedia Awards

Uncategorized
Right, I said I wouldn't compete, but I can't help pointing out that I'm pretty proud of this particular blog post that is in the Management and Automation category.  I thinki the number one tool for automation of administration of SQL Server, and pretty much all of Microsoft's server technologies, is PowerShell. Knowing how to execute scripts on multiple servers, asynchronously, is extremely important to a successful administration automation effort. So, please, despite what I said before, consider voting for PowerShell Remoting with SQL Server.
Read More
01Nov 2010 by Grant Fritchey No Comments

More Voting

Uncategorized
As if the US Election and SQL Rally voting were not enough (and have you voted yet for the SQL Rally Pre cons? Polls close tomorrow at 8PM), I just found out that SQLServerPedia is holding an awards vote. You only have a week, so get on over there and vote. There are a ton of categories and some really excellent blog posts to choose from. Yes, I have a post in there, but in this instance, I am not asking for your vote and won't provide a link. All of those bloggers, many of whom I know personally, put in extra work to get that information out to you. They all deserve your vote. That is a collection of extremely hard working, smart people, that I learn a lot…
Read More
31Oct 2010 by Grant Fritchey 3 Comments

Get Out The Vote

PASS
It's actually kind of cool that SQL Rally voting for the pre-conference seminars and voting in the real(ish) world in the USA are coinciding. I'm in the running for the pre-con AND I'm volunteering for an actual election campaign for the first time ever. Volunteering for the campaign is hard work. We're walking around neighborhoods dropping off literature, which is actually enjoyable. We have to cold call people, and if you've never done it, it's rather hard to describe. I did telemarketing for about 9 months in my youth, so I had a sense of what was coming. I wasn't prepared for some of the more interesting suggestions (anatomically impossible suggestions) that I was going to receive, but there you go. Luckily, to try to get out the vote for SQL…
Read More
28Oct 2010 by Grant Fritchey 2 Comments

PASS Summit Blogging

PASS
During the PASS Summit I have again been given the opportunity to keep my laptop plugged in... as long as I blog about the Key Notes. So, I'm going to do it, power is hard to come by in that place. Once again I can regale you, near real time, what's occurring in the key note addresses at the PASS Summit. Once more I'll have the opportunity to jump on to the table while wearing a kilt. But, this year, you may not want to read me. Instead, you might want to tune into the key notes yourself. PASS is going to transmit them live. You can go to the this link to watch them. Now, I can hear you, literally, thinking to yourself, "Right, just what I need in…
Read More
28Oct 2010 by Grant Fritchey 2 Comments

Writing Opportunities

Uncategorized
Are you looking for opportunities to show off your elite writing skills and consumate SQL Server knowledge? Want a chance to build up the resume a bit? Are you like me and you have a hard time thinking of ideas to write about? I've got a solution for you. There's a new forum over on SQL Server Central that is all about requests for articles. It's mostly small stuff, easy one-page articles, a bit more than a blog post but a bit less than a full blown multi-page drill down. Also, if you have ideas for articles that you'd like to see someone write up, you can post them there. You should read the rules about the forum, which aren't complicated, and then dive in.
Read More
28Oct 2010 by Grant Fritchey 1 Comment

SQL Rally: Performance Tuning Abstract

PASS
I get the call, you get the call, everyone gets the call. "Hey, my app/procedure/query/report is running slow." Now what do you do? You go to my full day session at SQL Rally, that's what. Assuming you vote for it. I didn't post the abstract I submitted for the SQL Rally before because I thought that it would be redudant. However, since it's not right off the voting page (unless they updated it since I voted), if you're interested, here's what I thought I would do for a day. If it sounds good to you, please go here and vote for it. One of the most common problems encountered in SQL Server is the slow running query. Once a query is identified as performing poorly, DBAs and developers frequently don’t understand how…
Read More
26Oct 2010 by Grant Fritchey 1 Comment

SQL Rally: One Day on Query Performance Tuning

Uncategorized
The SQLRally, a new PASS initiative taking place in the spring, is going to be a community driven event. This includes selection of the pre-convention (precon) paid presentations through a voting process. I have a session called Query Performance Tuning, Start to Finish. It's a one day session on everything about tuning queries. I won't republish the abstract and bore the heck out of you, but I will list the 5 skills I think you'll take away with you if you attend (after voting for me): The ability to collect performance metrics on your servers as part of an overall query tuning methodology The ability to generate, read, and understand execution plans from multiple sources in support of troubleshooting poorly performance queries An understanding of how the optimizer works in support…
Read More