SQL Server – Logical Disk Read Bytes/sec and disk io

In the SAN environment , the Logical Disk Performance objects counters monitor the logical partitions.
 I use the Logical Disk Read Bytes/sec ...

SSRS - Embedded Custom Code

When developing reports in Reporting Services you will often use the built-in
expression language to make report data and formatting...

Check Version of SharePoint 2010 Currently Installed

There are several ways to check the version of SharePoint 2010 currently installed in your environment. That about sums up...

Choosing the right professional

I’m writing this blog post from my bed, you may think that’s a little too much information there is a...

Houston Area SQL Server User Group Presentation

Thanks for everyone who attended my presentation “How To Make a LOT More Money as a Consultant” at HASSUG.
Here is...

Normalizing Your Database

If you’ve been working with databases for any length of time, you have heard the term normalization.
Normalization is the process...

SQL Server – Backup to NUL trick - read throughput

A neat test for read speed backup throughput is to use the Backup to NUL .
NUL is a special “file”. It's...

System Stored Procedures

I've been using 4 alerts for corruption now for about 2 years for Errors 823, 824, 825 and 9100.  Basically...

Video/Voice conferencing and Microsoft Lync

Since I work mostly from home, video/voice conferencing and IM are of major importance to me, and using the right...

FIRST_VALUE() Analytic Function–SQL Server 2012

Given a customer table:
CREATE TABLE Customers
(CustId INT, OrderDate DATE, OrderAmount MONEY) ;
INSERT Customers VALUES
(1, ’2011-12-03', 12500)

, (1, ’2011-10-07', 15000)

, (1,...