The Pro-Active DBA List Updated

 
A couple of years back, in the heart of the economic tsunami, I proposed a list of pro-active steps to...

A SQL Server Hardware Nugget A Day – Day 15

For Day 15 of this series, I am going to talk about Power Management and its effect on processor performance....

Late April Free Training from PASS VCs

PowerShell provisioning of Hyper-V Servers
Designing Cubes for Performance
Database Standards SOP

_____________________________________________________________
PowerShell provisioning of Hyper-V Servers
April 20, 2011, 12 PM EDT (GMT...

Re-Blog – April 8-14

As I mentioned in the introductory post, I’m summarizing posts from previous years in the the past week.  Some posts...

Powershell Day 15

Day 15 Introduction to Powershell for MS Sql Server So far we have discussed several features and information about Windows...

A SQL Server Hardware Nugget A Day – Day 14

Since 2006, Intel has adopted a Tick-Tock strategy for developing and releasing new processor models. Every two years, they introduce...

Performance Tuning: Start to Finish

The very first ever SQL Rally is taking place in a little less than four weeks in Orlando Florida. It’s...

Get all SERVERPROPERTY values for SQL Server

A quick script to grab all the SERVERPROPERTY() values from a SQL instance in a table. Useful when you forget...

Be the Master of your Data Warehouse Universe at SQLRally!

Do you have a data warehouse initiative in your current organization and looking for a way to learn how to...

Re-Blogging Posts

Over the last couple months, I’ve been trying to figure out what to do with some of my old posts. ...