Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: April 2010

Undocumented Capabilities of Extended Event Objects

Undocumented Capabilities of Extended Event Objects

The extended event objects (objects exposed by an event package) are listed in the system catalog sys.dm_xe_objects. This dynamic management view is documented in Books Online, but it does not adequately document the capabilities_desc column. I understand from a member of the SQL… Read more

Looking forward to Optimize for Ad hoc Workloads in Sql Server 2008

Looking forward to Optimize for Ad hoc Workloads in Sql Server 2008

 

One of the features of SQL Server 2008 that I think my application will be able to take advantage of once we migrate is Optimize for Ad hoc Workloads. In short, what this feature does is not… Read more

T-SQL Tuesday #005: Smart Card Login Breaks SQL Server 2008 Reporting Services

T-SQL Tuesday #005: Smart Card Login Breaks SQL Server Reporting Services 2008

This blog entry is participating in T-SQL Tuesday #005, hosted this month by Aaron "@SQLVariant" Nelson (Blog|Twitter). You are invited to visit his blog to join the party and read more blogs participating in… Read more

If Metallica Offered Certifications

If Metallica offered certification, this is the one I'd want:

Read more

5 Random Thoughts on the SQL Server MCM Program

5 Random Thoughts on the SQL Server MCM Program

I've had some random thoughts running through my head since I finished the MCM that I wanted to share, but I couldn't quite think up enough on any one of them to dedicate a topic to them. So here is a… Read more

How do I ... Write a Backup Strategy?

How do I Write a Backup Strategy?

DBA's harp about the need to have backups. The first thing many DBA’s do when they inherit a new SQL Server is to check to see that the databases have backups. I’m not backing off of that assertion now. I’m offering advice on how to determine…

Read more

Catching Transient CPU Spikes Using SQL Trace

Catching Transient CPU Spikes Using SQL Trace
 
If there was one thing I wish everyone who works with SQL Server would learn, it would have to be to use server-side SQL Traces instead of the client application SQL Server Profiler. Is Profiler really that bad? On a live production…

Read more

SQL Server 2008 MCM Results

SQL Server 2008 MCM Results

3 weeks of intense training, intense studying, 3 written tests, and one 6 hour lab exam. And let me just say that 6 hours wasn't enough time to complete everything!! I came pretty darn close, but not quite complete. One person -- Brent Ozar (blog Read more