SQL Server 2008 Installation Strategies and Best Practices Part 2 of 5 Greetings, last week I initiated this blog series which focuses on best practices and installation strategies when deploying SQL ...

Get the lowdown on SP-1's added features, including fully supported database mirroring, bug fixes, and add-ons for SQL Express. What's more, SP1 not only contains bug fixes, but also delivers ...

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.

Is Ssms Part Of Ssdt? It is the database component of SSDT that people talk about when they ask “why should I use it over SSMS”. I usually reply that SSMS is an administration tool and SSDT ects is ...

So I have my new shiny DMZ setup with my RODC and now am trying to setup SQL 2012 on a clean Server 2008R2 server. This server only has access other machines in DMZ, including the RODC. RODC has ...

Recently organizations, fellow SQL Server MVPs and DBAs have asked me for resources on how to install a SQL Server 2008 Failover Cluster from both a SQL Server and a Windows Server 2008 perspective.

Okay, a co-worker typed this up for me to post. I am simply cutting and pasting from e-mail...<BR><BR><BLOCKQUOTE class="ip-ubbcode-quote"><font size="-1">quote ...

Ok, by now my first upgrade experience with Katmai is well-documented. So I thought I’d pass along some of my other experiences and some of the things I’ve learned. My Vista upgrade: I have a copy of ...

The Microsoft SQL Query Analyzer is part of the client tools that come with Microsoft SQL Server 2000 Enterprise Edition. It's designed to analyze the SQL queries that you or a program makes that ...

If you haven't installed SQL Server 2014 Service Pack 1, keep it that way. If you have installed the service pack, you may be regretting it. Microsoft pulled it last week after install errors surfaced ...