I’m a big fan of standards specially when you know that they work. It’s like knowing that when when you’re measuring some length in the US, you know the unit would likely be in inches or feet because it is a standard unit of measurement. I was installing SQL Server “Denali” on my test environment […]
I just found out recently that SQL Server 2008 R2 Service Pack 1 has been released. Microsoft KB article 2528583 lists all of the bugs that are fixed by the service pack. SQL Server MVP Aaron Bertrand blogged a few months back about the features that were added to the database engine. Hopefully, after installing […]
If you’ve heard about PowerPivot for Excel, you may have heard about the self-service business intelligence capabilities of the tool. I guess it’s about time to explore PowerPivot for Excel. Check out this article to get started. I think this is one of the best things that came out of the collaboration between the Excel […]
I’ve setup a number of Windows Server 2008 (and higher) Failover Clusters in the past and this is the first time I’m seeing this. I’m running the Failover Cluster Validation wizard on two servers that will be used as nodes for a Windows Failover Cluster. When I run the wizard from ServerB, everything works fine. […]
After successfully upgrading a multi-instance SQL Server 2005 Failover Cluster to SQL Server 2008 R2, I got woken up today by a page from a SQL Server Agent job failure. Knowing that the job was created by one of my colleagues, I ignored it for a while since it only runs once a week and […]