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, 617 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,064 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, 730 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, 132 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, 823 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, 351 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,425 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, 531 reads
Posted in SQL Server Soldier :: News from the frontlines of the database wars on 4 April 2010