Thanks for coming to today's webinar. We had a great turnout and hope to see you again soon. I have posted the powerpoint from the session here! 

 

Thanks everyone! - Adam Read more

Back in February, 2010, I did some preliminary testing on the effects of various BIOS settings and Windows Power Plans on processor performance in Windows Server 2008 R2 using the cross-platform Geekbench benchmark. That round of testing used an 2.8GHz Intel Core i7 860 processor in an ASUS desktop board.… Read more

From time to time, I need to find the largest tables in terms of rows / used space / total space etc. I originally used sp_spaceused, a temp table and a cursor (or sp_MSForEachTable) and put them into a stored procedure to get the information I need.

But now as… Read more

 

After having a few heated discussions on Facebook in reference to Open-Source Relational Databases, I would like to refer those who think that MySQL will cost your company nothing to the MySQL Enterprise DBA Savings Calculator page.

All Database servers have to be managed, and there are the costs… Read more

Third-party applications are a very important part of the IT landscape. Many of us have faced the common dilemma of trying to decide whether to build or buy that next important application our organizations need. (By the way, I’m talking about smaller, specialized applications like an inventory management system for… Read more

Today the much awaited Knight's Microsoft Business Intelligence 24-Hour Trainer book was release.  In this book you will learn about the entire Microsoft BI stack from a bunch of experts that work with me (Brian Knight, myself, Adam Jorgensen, Patrick LeBlanc, and Mike Davis).… Read more

Are you ready for Seattle?  Have you registered for the PASS Summit?  Hopefully with some good reasons you will be inspired to attend the summit this year.

Ten Reasons to Attend

There are, of course, countless reasons to attend the PASS Summit in November.  To hopefully inspire a few… Read more

There are a few times where you might want to perform a cross join/cartesian join/cartesian product operation in SSIS.  One of those scenarios could be performing some kind of a double-sided "range join" where you can't line up a specific key in your data flow to a specific key in your lookup table.  Quite often…

Read more

I talked about the basics of Influence in Part 1 and Part 2, today I’m trying something harder, showing you how to deliberately use your hard won influence to evoke change. Earning influence is perhaps not simple, but it’s an easy enough formula to understand. The risk is low.… Read more

I was lucky enough to present two sessions at SQLSaturday #52 in Denver on September 25, 2010. By my estimate, there were probably between 200-250 attendees for the event. The event was well organized, with easy parking, plenty of food, and a smooth registration process. The session rooms were a… Read more

On Sunday I learned of the passing of one of my greatest mentors, Major Herbert L. Day, USMC, Retired. He was Director of Bands at The Citadel, the Military College of South Carolina, from 1984-2004. My tenure there started in August 1991 and ended with graduation in May… Read more

This past weekend was the first SQL Saturday in Colorado, and it went very well. I think everyone enjoyed it, the organizers were pleased, and I’m hoping that we end up with 2, or more, events next year.

This was my 5th SQL Saturday of 2010, and it was interesting.…

Read more

 

 

I have a question for all you DBA’s and SQL Professionals out there.  It’s an exciting new contest that is sure to rock the SQL Community, and the prizes are fantastic!

Coming to you from the Ahmedabad Area, India, who wants to be a millionaire?!    Read more

SQL Sever MVP Jacob Sebastian (blog/twitter) has been working hard to organize the SQL Server Quiz 2010 event which will be starting on October 1, 2010. This will be a series of 30 Quiz questions, presented each day by a “Quiz Master”, who will be in… Read more

SQL Server MVP Arnie Rowland (blog/twitter) has put a lot of effort into conceiving, organizing, and publicizing Project Phoenix over the past several months. Just in case you have never heard of this effort, the gist of it is to reach out to unemployed/underemployed Developers and… Read more

Friday

6am – up to catch an 8:30 flight. My daughter Lisette is going with me on this trip.

9:30am local time, we arrive in CO. Grab a car and head north to Fort Collins for Beau Jo’s pizza, free loaner bikes from the Bicycle Library, and general sightseeing. BEAUTIFUL… Read more

Can Deadlocks be Resolved by Adding an Index? Yes. Really, I’m not kidding. Here, I’ll show you how.

First, let me set the scene: One of the applications I support has had issues with deadlocks for some time now. The deadlocks are really a result of design issues that it… Read more

I saw an odd statement the other day, “The size of the name of the parameter does not affect performance.” My first thought was, “Well, duh!” But then, I had one of those, “Ah, but are you sure” thoughts. And you know what, I wasn’t sure.

If size of the… Read more

We’re less than 30 days out from SQLSaturday #49 and we’re working hard on the logistics. Speaker gifts ordered, lanyards this year instead of stick on badges, Jack working on a deal with our after party location for great appetizers, and all the rest of the stuff that goes into… Read more

In my TSQL2sDay index summary post, that I’d be writing a few posts on the information that is contained in sys.dm_db_index_operational_stats. The posts will be the following:

• Index Black Ops Part 1 – Locking and Blocking
• Index Black Ops Part 2 – Page IO Latch, Page Latch
• Index…

Read more