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...

Thoughts on DBA Professional Development

As a DBA, we have a lot to work on and also we have a lot to learn about. The...

Win a Ticket to the “Advanced Programming” Course

We are opening another class of the “Advanced Programming in SQL Server” course on 28/08. You can find all the...

Attach database without log file and rename database

Assuming the database was detached successfully , this t-sql code will attach a mdf file  without a log file . It will also...