I have been struggling with getting SQL Server 2012 SP2 Express installed. It gets through the installer but fails at the end with the following error. I have made ...

Despite the plentiful information in Books Online and on the official “SQL Server 2000 Security” document Microsoft offers online, setting up a truly secure SQL Server remains a difficult task. In ...

Fix SQL Server connection problems If you are a developer experiencing “Connect to Server” errors using SQL Server Management Studio on your local machine or development box, consult the checklist ...

Learn tips for administering SQL Server securely.Of course, you might not have a domain at all. In this case, each server maintains its own SID database of users and objects. If users want access to ...

A new feature of Windows Server 2008 is the ability to install the “Server Core”. This minimal server installation supports only the basic server roles like DHCP, DNS, File and Print Services and ...

A step-by-step guide to deploying, configuring, and testing a multi-AZ, multi-region SQL Server FCI in the Azure cloud, complete with a PowerShell script that handles the networking configuration.

Helping & empowering business owners for over 15 years, helping them to understand how to protect own interests, build bridges to amplify joint ventures, adapting new business practices and solutions.