SQL Saturday 94

SQL Saturday 94 in Salt Lake City is fast approaching.  Will you be there?  I submitted three sessions in hopes of maybe getting one selected.  Last year, I only...

SQL Saturday 94

SQL Saturday 94 in Salt Lake City is fast approaching.  Will you be there?  I submitted three sessions in hopes...

SQL Server – sys.dm_db_persisted_sku_features tells you about edition-specific features

sys.dm_db_persisted_sku_features lists all features which are utilized by the database. Features specific to Enterprise/Developer edition are:

- Compression,
- Partitioning,
- TDE and...

Tracking down KPI error in PerformancePoint

On a few occasions, I have opened up my PerformancePoint scorecard on SharePoint to see an error staring at me:

So...

T-SQL to find Fragmented Indexes

Fragmentation of Indexes is one of the reason for low performing queries resulting in a poor application performance.
Today, I will...

Why You Should Attend SQL Saturday 97

Reposted from :http://sqlaj.wordpress.com/2011/08/19/why-you-should-attend-sql-saturday-97/

By AJ Mendo
Free Training
Part of the mission statement of SQL Saturday (read the full statement here) is to...

Chance to win a free seat in my Performance Troubleshooting Workshop in London!

As you might know, I'm running my "Advanced SQL Server Performance Troubleshooting
Workshop" from September 12 – 14 in Central London. You...

Pull Performance Data from Perfmon Logs with PowerShell

For the last year and a half or so I've been presenting a session on how to gather perfmon data...

What Will Be New for Reporting Services in 2012?

Drum roll, please!   We’re in the throws of refreshing the Wrox Professional Series book on Reporting Services and, as we...

ORDER BY Clause with clustered index

One thing that I have seen repeatedly is that (too) many people believe that if you have a clustered index...