General

This month’s T-SQL Tuesday #100 is hosted by Adam Machanic (B | T) who started T-SQL Tuesday 8 years ago and has invited..

Thank you Adam Machanic (B | T) not just for Hosting T-SQL Tuesday #100 but also for starting this fantastic..

HP and Microsoft have partnered together to build this consolidation appliance that has been optimized specifically for SQL Server 2008 R2. This appliance provides for your one stop private cloud.

Setting your FavIcon.ico file for your DNN site can improve the professional appearance of your site. Creating your own Icon is very simple, but changing the setting in your DNN admin settings may not work depending on the version of DNN you are running. This blog will take you through how to change your FavIcon.ico in DNN 6.

Quickly and easily reporting on all DB's in your SQL Instances on space usage is a requirement that is not that easy to achieve for multiple databases. It can be made simpler with the use of the .sql script that I have created that is available for download.

Microsoft Baseline Security Analyzer 2.2 (MBSA) is a tool that provides a streamlined method of identifying any missing security updates..

When preparing for a SQL Server installation, whether that be for a Stand-alone Instance or a clustered Instance, using a..

Are you using a version of SQL Server Express 2005, 2008, 2008 R2? Well these editions do not have the..

Previously I blogged about the release of the Compression Estimation Tool available for download from CodePlex. To read more about..

Microsoft has released a new KB article on not disabling the guest user in the MSDB. This has been released to counter the recommendations found in BOL.

SQL Server error logs can grow quite large due to an issue or from infrequent cycling of the log file. If these log files get to large then you are not able to read the contents either through SSMS or a file editor. This blog takes you through how to read the log using xp_readerrorlog.

Test connection failed because of an error initializing provider [DBNETLIB][ConnectionOpen(Connect()).] SQL Server does not exist or access denied. This message is not very meaningful and is hard to investigate. In this blog I take you through a scenario of how to identify and fix this issue.