SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: May 2010

Content Copy Followup

Last week I posted an article about plagiarism.  This is a follow-up to that.  After posting that blog article, Steiner quickly removed the copied content.  The tone may have been a bit harsh in that article.  My feeling on the subject has shifted only slightly.  Steinar was trying to… Read more

0 comments, 861 reads

Posted in SQL RNNR on 24 May 2010

Slick New Software

I’m lazy. And frankly, I’m not ashamed to admit it. When a software comes along that can do the work for me, even work I can do just fine on my own, I’m interested. When that software is inexpensive, even better. When it’s free…

I just got word that Confio… Read more

30 comments, 1,203 reads

Posted in The Scary DBA on 24 May 2010

Create Indexes from the Missing Indexes DMV

Glenn Berry (Blog) writes a lot of queries to extract information from the system DMV’s.  One of them in particular I found extremely helpful in fixing some of the issues in my system.  I took his query (the CTE at the top) and added some text manipulation to… Read more

6 comments, 2,027 reads

Posted in Never Say Never on 24 May 2010

East Coast PASS Event Options

After asking members about where the PASS Summit should be located and then deciding to keep it in Seattle for at least the next two years despite a clear majority of respondents desiring a central or east coast location, the board decided to look into holding a smaller event on… Read more

13 comments, 724 reads

Posted in Wise Man or Wise Guy on 24 May 2010

Image Testing

One of the things I heard recently from someone was that they clicked some of the links in the newsletter and the front page, expecting to read some information, and got sent to an event instead. That was annoying, and I can understand that. I do try to put in… Read more

2 comments, 617 reads

Posted in The Voice of the DBA on 24 May 2010

PASS Update #33 (SQLSaturday Transfer)

I’ve just finished handing over the source code for all the SQLSaturday related items after finishing up a couple minor bugs in the admin tools. Along with the just completed transfer of the domain, that finishes up all the tasks we had identified to get the hand off done.

The… Read more

0 comments, 440 reads

Posted in SQLAndy on 24 May 2010

The World Famous Stapler Method

This is long overdue and goes out to my buddies from the SSAS Class I taught late last year. Two guys from a company in Connecticut, I believe, came to the class and we were chatting about consultants who can tend to get a bad rap for putting in solutions… Read more

1 comments, 360 reads

Posted in Adam Jorgensen on 24 May 2010

SQL Saturday Jacksonville

Well, for those of you who attended, SQL Saturday Jacksonville, was, well I’ll say it, EPIC. Between all the great sessions we had in place, your great questions and feedback and of course, Iron Chef BI bringing it home, we had a great time. Folks came from all over the… Read more

0 comments, 284 reads

Posted in Adam Jorgensen on 24 May 2010

MS Airlift Event in Seattle

I have posted several entries lately about events that I’ve been attending, speaking and listening at and one of the most interesting ones was the Microsoft SQL Server 2008 R2 Partner Airlift Event. This is a chance for MS to show off all the new cool features in an upcoming… Read more

0 comments, 657 reads

Posted in Adam Jorgensen on 24 May 2010

Upcoming SQL Events

I realized this morning that I will be participating in three SQL Events this week and I want to share the event information with everyone.  Two of the events are available online and the other is a local user group meeting.  If you have time logon onto one of the… Read more

3 comments, 528 reads

Posted in SQLDownSouth on 23 May 2010


 What would get over 400 techies to give up a beautiful Saturday and spend the day inside learning about SQL Server and .Net? It was the IndyTechFest held in Indianapolis yesterday! Brad McGehee, Jessica Moss, Kevin Kline, Jimmy May, and I joined several other MVPs, Microsoft employees, and local experts… Read more

2 comments, 938 reads

Posted in Advice from Aunt Kathi on 23 May 2010

Evernote and the posting of scripts.

I heard of EverNote sporadically in the Twitter community and from my boss.  I had checked it out and it seemed like another place to store notes/tips/ideas.  I thought to myself 'What could I possibly use this for?"  I've read some articles where a restaurant chef uses this to… Read more

0 comments, 507 reads

Posted in SQLRunner on 23 May 2010

Portland SQL Saturday / Code Camp 2010

Today was the Portland SQL Saturday and Code Camp at the University of Portland and it was a great experience.  I didn't hear what the final attendee count was but many of the session rooms were full… 700-800 maybe?  The caliber of the sessions and learning opportunities were top-notch.  Logistics… Read more

0 comments, 391 reads

Posted in SQL Server BI Blog on 23 May 2010

Im on hols !

Sorry guys, I’m off for a week in the sun – will return June 2nd with more SQL Server 2008 New Features.

In the meantime – any of you out there have any favorite features of your own  -please post !

Have a good week all !


Read more

1 comments, 342 reads

Posted in DatabaseExpertise.com on 22 May 2010

What is a Good Way to Run CheckDB on a VLDB?


Today’s script is one that I wrote based on the logic outlined in this post by Paul Randal (Blog|Twitter). This script is written for SQL 2000 but, as Paul notes, the logic will work on SQL 2005.

The Script

This stored procedure stays pretty true… Read more

0 comments, 498 reads

Posted in Adventures in SQL on 21 May 2010

SQL Book Review

Recently I received a new opportunity via email.  Steve Jones at SQLServerCentral sent me an email to see if I would be interested in helping review a book and write about it on my blog.  I told Steve I would be happy to help out.

The book is titled Defensive… Read more

0 comments, 588 reads

Posted in SQL RNNR on 21 May 2010

Moving On

My oldest son graduates high school today. After a long journey, he’s the first of my wife’s and my three kids that is moving on. It’s a big day, and we have almost all our family in town to watch the first of our next generation becoming an adult.

I’m… Read more

1 comments, 618 reads

Posted in The Voice of the DBA on 21 May 2010

Daily SQL Server 2008 New Feature – Day 12

Every day for the next couple of weeks, I aim to highlight one of SQL Server 2008’s new features, simply for awareness. You can then go away and research the area and report back to me, we’ll then discuss how these new features can benefit us all.

Friday 21st May… Read more

0 comments, 363 reads

Posted in DatabaseExpertise.com on 21 May 2010

Ask for something and when you get it no one uses it

There was a time when almost every Chapter leader were asking PASS to find a place where the leaders can communicate with each other. What everyone had in mind is use a forum where leaders can exchange ideas. PASS saw that this was a good idea. There fore they added… Read more

4 comments, 362 reads

Posted in RumblingDBA on 21 May 2010

Book Review: Currencies That Buy Credibility

I ordered a copy of Currencies That Buy Credibility ($14 @ Amazon) after a comment from author Tom Wanek on Twitter about a post I had written on The Checklist Manifesto. Saw that Tom had a web site and book on marketing, did the impulse buy.

My really short… Read more

0 comments, 477 reads

Posted in SQLAndy on 21 May 2010

Newer posts

Older posts