Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: July 2010

Interviewed by Andy Leonard

Andy Leonard is posting interviews of all the candidates PASS Board of Directors on his blog and mine is up today, check it out.

I also want to thank Andy for taking the time to provide this service to the community.

Read more

2 comments, 154 reads

Posted in Wise Man or Wise Guy on 28 July 2010

Interviewing for the PASS Board of Directors

My nomination application made it through the committee. I got an email yesterday telling me that I needed to schedule an interview, and a list of available slots.

I picked next Friday, August 6th, at 10am PST for my slot and it’s scheduled. It’s a phone interview, according to the… Read more

3 comments, 281 reads

Posted in The Voice of the DBA on 28 July 2010

PASS Update #38 (SQLSaturday Wiki)

For the past couple years we’ve had a few different documents that covered how to run a SQLSaturday, but as you all know building and maintaining documentation is hard, and we just didn’t have a good process for capturing new lessons and folding them in. A couple months back… Read more

1 comments, 245 reads

Posted in SQLAndy on 28 July 2010

Presenting at SQLSaturday #40 – South Florida

I'M ON A BOAT!

This is just a quick note to say that I’ll be in South Florida this weekend presenting at SQLSaturday #40. This weekend and the following week are particularly awesome for a few reasons:

  1. My birthday is Friday!
  2. Look at this lineup, it’s PACKED with #awesomesauce

Read more

0 comments, 149 reads

Posted in SQL Chicken on 27 July 2010

Hit and miss

Or “Monitoring plan cache usage

For people interested in the details of how SQL is using and reusing execution plans, there are some useful events in profiler for watching this in detail, under the Stored procedure group:

  • SP:CacheMiss
  • SP:CacheInsert
  • SP:CacheHit
  • SP:CacheRemove
  • SP:Recompile
  • SP:StmtRecompile

Additionally there’s the SQL:StmtRecompile event… Read more

1 comments, 306 reads

Posted in SQL In The Wild on 27 July 2010

Count(*) or Count(1) ?

Every so often on the on-line forums, the question of : Which is better Count(*) or Count(1) ? will occur.  So can it categorically be proved than one is better than the other ?

What we need to do is populate a table and use both count(*) and count(1) and… Read more

7 comments, 661 reads

Posted in Dave Ballantynes blog on 27 July 2010

Powershell Remoting with SQL Server

One of the best things to come out with Powershell V2 is remoting and asynchronous calls. Between the two of these, you can basically send commands simultaneously to a number of SQL Server instances. BUT… and there always seems to be one of those, there is a lot of work… Read more

0 comments, 1,008 reads

Posted in The Scary DBA on 27 July 2010

Slack Traveler

I realized over the weekend that I hadn’t booked a hotel for my SQL Saturday #28 trip to Baton Rouge. This was one I can’t miss since I’m doing 2 sessions and the keynote. I remembered today, and called the Cook Hotel, a beautiful place on the LSU campus where… Read more

0 comments, 250 reads

Posted in The Voice of the DBA on 27 July 2010

Speaking at SQLSaturday #40 – South Florida

I finally get to head down to Miramar to speak at SQLSaturday #40 – South Florida.  I really wanted to go last year, but I was in New England at the time, so I couldn’t make it.  So this weekend, July 30-31, I’ll be making the drive down to attend… Read more

0 comments, 109 reads

Posted in Wise Man or Wise Guy on 27 July 2010

Do As I Say, Not as I Do

Do I follow my own advice?
I’ve been asked that at a few of my Modern Resume presentations if I do all the things that I mention, and to what extent. My answer is that I do and I don’t. I’ve done them all at some point in my career,…

Read more

5 comments, 543 reads

Posted in The Voice of the DBA on 27 July 2010

[OT] Where Ya Been?

Have you heard the sound of silence?  Yep, that’s been my blog.

It’s been weeks since I’ve posted anything on here, and to both of my loyal readers I offer my apologies.  It’s been a bit of a wild summer already… I sold my house, moved my large family into… Read more

3 comments, 220 reads

Posted in Tim Mitchell on 27 July 2010

Pillbox Application

Ran across Pillbox in Government Computing News (GCN), a web app that lets you identify what a pill is based on shape, color, imprint, and more. They have an HTML version and a Flex version, the latter definitely more user friendly (more graphics), but both are useful. The article about… Read more

3 comments, 188 reads

Posted in SQLAndy on 27 July 2010

SQL Saturday #51 in Nashville

I just found out today that I will be one of the speakers at SQL Saturday #51 in Nashville, Tennessee on Saturday, August 21, 2010.  My presentation will be:

DMV Emergency Room!

If you have ever been responsible for a mission critical database, you have probably been faced with a…

Read more

0 comments, 206 reads

Posted in Glenn Berry's SQL Server Performance on 27 July 2010

Windows OS Power Saving Feature Directly Affects CPU Performance

While I have always known that the Windows operating system Power Plan options affect a server’s performance, I had not realized how much until SQL Server MVP Glenn Berry (Blog | Twitter) suggested I try out my new Dell T610 test servers under the three available power savings… Read more

2 comments, 604 reads

Posted in SQL Aloha on 27 July 2010

An Example of ‘Date tool’ dimension(calculation-Dimension)

Recently one of my clients would like to see their Revenue figures represented some of the time as a positive (+VE) value and some time as a negative (-VE) value. They would like to have the ability to select between the two at run time in the Analyses Services Cube.… Read more

2 comments, 779 reads

Posted in SyedQbBI on 26 July 2010

Presenting to the West Michigan SQL Server User Group

Presenting to the West Michigan SQL Server User Group / SQL PASS Chapter

I will be presentitng to the West Michigan SQL Server User Group/SQL PASS Chapter tomorrow at 6:45 PM Eastern Time / 3:45 PM Pacific Time. Topic will be Advanced Tuning: Unconventional Solutions to Everyday Problems. You're welcome… Read more

Jacksonville Code Camp – Introduction to Reporting Services 8.28.2010

The 6th Annual Jacksonville Code Camp is coming up fast. There are tons of great presenters slated to be here giving free training and demonstrations on the latest and greatest products out there. Below are some of the details about the event, what my presentation will be on and… Read more

0 comments, 151 reads

Posted in BrianKMcDonald on 26 July 2010

Tour de Career: Team Roles

In cycling each team is made up of nine riders. Each rider on a team can have a different specialization. A careful balance of skill sets on a team can determine if a team will stand triumphant on a champion’s podium at the end of the day or simply fade… Read more

1 comments, 304 reads

Posted in SQL Chicken on 26 July 2010

Defensive Db Programming Chapter 03

Chapter 3 of the Defensive Database Programming Book by Alex Kuznetsov teaches us about how to “survive” changes to database objects.  Alex brings to light how simple changes to the underlying schema could be damaging to performance and accuracy of the code that touches the objects to be changed.

Three… Read more

0 comments, 751 reads

Posted in SQL RNNR on 26 July 2010

The Vacation Backlash

Maybe I need a better name for it, but I’m describing the pain that happens when you’re getting ready for vacation and returning from one. I bet most of you have gone through it, and it’s easy to get to the point where going on vacation seems like more trouble… Read more

1 comments, 179 reads

Posted in SQLAndy on 26 July 2010

Newer posts

Older posts