Subscribe to this blog
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
1 comments, 658 reads
Posted in SQL Server Soldier :: News from the frontlines of the database wars on 28 April 2010
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
3 comments, 1,098 reads
Posted in SQL Server Soldier :: News from the frontlines of the database wars on 23 April 2010
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
3 comments, 771 reads
Posted in SQL Server Soldier :: News from the frontlines of the database wars on 13 April 2010
If Metallica Offered Certifications
If Metallica offered certification, this is the one I'd want:
3 comments, 136 reads
Posted in SQL Server Soldier :: News from the frontlines of the database wars on 10 April 2010
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
6 comments, 880 reads
Posted in SQL Server Soldier :: News from the frontlines of the database wars on 10 April 2010
How do I ... Write a Backup Strategy?
How do I Write a Backup Strategy?
9 comments, 365 reads
Posted in SQL Server Soldier :: News from the frontlines of the database wars on 9 April 2010
Catching Transient CPU Spikes Using SQL Trace
11 comments, 1,502 reads
Posted in SQL Server Soldier :: News from the frontlines of the database wars on 6 April 2010
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
10 comments, 553 reads
Posted in SQL Server Soldier :: News from the frontlines of the database wars on 4 April 2010