With the next release of SQL Server, data analysis is going to go through a major change with the PowerPivot add-in for Excel and SharePoint. If you haven’t been keeping up with these changes to Business Intelligence, SSWUG.org has an opportunity for you to get up to speed. On January 22, 2010 there will be … Continue reading Pushing Excel Through A Wormhole
I’ve blogged about certifications a number of times in the past. One of the certifications that I really want to obtain in the future is the Microsoft Certified Master (MCM) for SQL Server 2008. This is a great certification that really dives in deep and requires classroom training and labs as part of the certification … Continue reading MCM Reading List – A New Years Resolution
It’s a very good question. One that might not seem to insidious. Nothing that should be able to bring down the system and cause failures. Or will it? I’ve been to a number of clients and done it myself before where I start to check out a stored procedure with some performance issues and sitting … Continue reading Does Your Stored Procedure Grant Itself Permissions?
I got to work with deadlocks quite a bit recently. There were quite a few interesting ones that came up that I had the chance to research. Since I like easy, I’ll start with the one that I forgot to grab the deadlock details for. Well, maybe not all of the details… in this case … Continue reading Deadlocks on exchangeEvent and threadpool
Strate SQL 