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

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

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

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

Expert? Ha!

How do you define an expert? My personal definition: An expert is the person that is a chapter ahead of...

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

Networking Dinner at the PASS Summit 2011

We’re repeating our event this year, a low key no sponsor dinner for those that arrive early and want to...

Get your AD information with .NET

.NET has a useful class called system.DirectoryServices to query LDAP such as Active Directory
Here is some example code to retrieve...

[Speaking] Lots of Speaking Engagements in September and October

As Adam Machanic said, Fall is the busy season for speaking, and it will be for me. Here's a brief...