What Smart Database Developers Know About Database Connectivity

When I got started with computer programming, I immediately jumped into database programming. I wanted the application that I am writing to interact with a database so I can create, update and delete (CRUD) records. Every database developer knows that the first thing they need to learn is how to connect to a database – […]

Four Challenges That You Need To Address For A Successful Database Migration

–Hurdles Start by Robert Voors – With less than a year before SQL Server 2005 extended support ends, customers can start planning on upgrading their databases to SQL Server 2014 or even SQL Server 2016 when it is released. In a previous blog post, I talked about how to integrate Microsoft Product Lifecycle and Support Policies […]

Confessions of a Junior SQL Server DBA

– Photo by Milada Vigerova – Wayne was getting ready to meet the director of engineering, the person responsible for hiring him. They spoke briefly over the phone for the scheduled interview. The director happened to be from Romania but spoke very good English that you’ll think he grew up in America. The role: Windows engineer. This […]

Running a SQL Server Failover Clustered Instance on Microsoft Azure

When I started working with virtual machines on Microsoft Azure last year, one of the first test that I did was to configure SQL Server Availability Groups in a hybrid configuration. The configuration consists of a failover clustered instance on production data center for local high availability and an Availability Group replica on Microsoft Azure […]

Video: How To Simplify Installation and Configuration of a 2-node Multi-Subnet/Geographically Dispersed SQL Server (2012 and higher) Failover Clustered Instance

In a previous blog post, I’ve demonstrated how to install and configure a 2-node SQL Server 2012 failover clustered instance (FCI.) As a follow-up, below is a video on how to install and configure a multi-subnet/geographically dispersed SQL Server 2012 (and higher) FCI. When SQL Server 2012 introduced the support for multi-subnet clustering, there have been […]