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

Archives: February 2011

SQLskills Immersion Event on Internals and Performance – Day 5

Overview

Today was the fifth and final day of the Internals & Performance immersion event. I have really enjoyed learning from not only Paul and Kimberly, but my classmates as well. There were many smart people in that room and hearing each others’ perspectives is a part of the class… Read more

0 comments, 686 reads

Posted in Eric Humphrey on 26 February 2011

SQLskills Immersion Event on Internals and Performance – Day 4

Overview

We just finished the fourth day of SQLskills learning. Today was all on indexes and statistics. We learned about choosing a clustering key, what makes a good one, what makes a bad one. We also have to keep in mind the consequences to non-clustered indexes when choosing the clustered… Read more

0 comments, 551 reads

Posted in Eric Humphrey on 25 February 2011

SQLskills Immersion Event on Internals and Performance – Day 3

Overview

Today was mostly about Table Design, Partitioning, with a little of Indexing. Partitioning is a big, complex topics with a lot of intricate details and interactions. If you are thinking about implementing partitioning using either partitioned tables or partitioned views, do your homework. Don’t just implement either without knowing… Read more

0 comments, 176 reads

Posted in Eric Humphrey on 24 February 2011

SQLskills Immersion Event on Internals and Performance – Day 2

Overview

Day two of the SQLskills Immersion Event is over and I have listed the interesting parts below. The food, again, was great, except for the lack of danishes during breakfast (I really like those). Today I got see Kimberly’s teaching style. She’s a fast talker, so you better keep… Read more

0 comments, 311 reads

Posted in Eric Humphrey on 23 February 2011

PowerShell Script for Paul’s Survey: how is your tempdb configured?

Paul Randal (b | t) posted a survey how is your tempdb configured? Since I just happen to be at a SQLskills event this week I went ahead and created a PowerShell script to get the info across all your servers.

You’ll need a list of servers in… Read more

0 comments, 221 reads

Posted in Eric Humphrey on 23 February 2011

SQLskills Immersion Event on Internals and Performance – Day 1

Sonny Bryans Smokehouse Bbq would make an interesting classroom

Today was the first day of my first SQLskills event. The event is 5 8 hour days of intense, master level SQL training. This particular event is on Internals & Performance. Lucky for me, it’s being held in Dallas so I… Read more

0 comments, 163 reads

Posted in Eric Humphrey on 22 February 2011

PowerPointShell

I wanted to add a neat demo to my .NET Powers Activate! Form of PowerShell! presentation that would really demonstrate the use of .NET in PowerShell. I decided to have PowerShell create a PowerPoint presentation from code for my opening demo.

It uses New-Object -ComObject to instantiate a PowerPoint.Application COMobject.… Read more

0 comments, 109 reads

Posted in Eric Humphrey on 18 February 2011

Presenting for the PASS PowerShell Virtual Chapter

On Wednesday, February 16 at 2:00pm CST I’ll be presenting “.NET Powers Activate! Form of PowerShell!” to the PASS PowerShell Virtual Chapter.

PowerShell’s cmdlets can be pretty powerful on their own, but that’s only part of the power of PowerShell. The .NET Framework is the basis of the PowerShell…

Read more

0 comments, 252 reads

Posted in Eric Humphrey on 14 February 2011