I need to build a new box to go in our DMZ to run SQL 2008 R2. SQL will have a processor license. The Windows build will be covered by our DataCenter license. So long as SQL authentication is used for ...

We have our SQL server configured to only allow Windows accounts (i.e. not mixed). However, in some cases we are connecting from non-domain boxes and we want to specify a domain account to connect to ...

SQL Server is one of the best products to come out of Microsoft, but not every professional knows how to use it effectively. For example, some might find it difficult to create a stored procedure but ...

With the official release of Microsoft's latest database offering, let's see what was improved and what still needs some work. Today, at Ignite, Microsoft announced the general availability of SQL ...

Despite its steep licensing costs, SQL Server continues to prove its worth over open-source alternatives in some key areas. SQL Server is an expensive part of your IT stack -- SQL Server Enterprise ...

SQL development is evolving fast, and Microsoft.Build.Sql is leading the charge. This next-generation SDK brings flexible project structures, better source control integration, automated build-time ...

One is on-premise, the other in the cloud. Right now, they serve different needs, but one day they could merge Windows Small Business Server had its start in 1997 as BackOffice SMS 4.0 and included ...