Microsoft announced this week that it plans to release a "General Purpose" version of its Azure Arc-enabled SQL Managed Instance (MI) at the "general availability" (GA) commercial-release stage, ...

1. Change registry key SqlCluster in HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.x\Setup\ from 1 to 0 2. Disable TCP/IP in Server Network Protocols and enabled Named Pipes from ...

As SQL Server 2008 and 2008 R2 reach the end of support in 2019, you’ll have an opportunity to upgrade to a cloud database service. Follow this step-by-step guide to manage change effectively as you ...

When Wim Coekaerts, Microsoft's vice president for open source, took the stage at LinuxCon 2016 in Toronto last summer, he came not as an adversary, but as a longtime Linux enthusiast promising to ...

A fundamental skill for DBAs is to have a firm understanding of the SQL Server database engine’s system databases. Tim Chapman discusses these system databases. A fundamental skill for DBAs is to have ...

The successful migration from purely private to public and hybrid cloud arrangements has substantially increased the level of confidence IT administrators have in the cloud. And among the top cloud ...

As you will see in this chapter, companies use SQL Server for many types of applications and on most tiers now. Gone are the days when you would second guess yourself choosing to use SQL Server over a ...

One of the most useful features in Microsoft's System Center Operations Manager (SCOM) product is its reporting engine. Even though there is nothing overly difficult about its installation process, ...

Use custom-built .NET Framework 4.0 classes to connect an ASP.NET Web application to a SQL Server 2012 database. In my recent article, I showed how to connect .NET 4.0 C# and Visual Basic applications ...

PolyBase, a data virtualization feature for SQL Server, allows users to seamlessly query data from various external sources directly using T-SQL (Transact-SQL) without the need for separate client ...