– 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 […]
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 […]
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 […]
This particular question came up while I was delivering a workshop last week on the new features in SQL Server 2014. Since transparent data encryption has been available since SQL Server 2008, why would I still need the backup encryption feature? For one, transparent data encryption is an Enterprise Edition-only feature whereas backup encryption exists in […]
“Today’s DBAs have responsibilities that go far beyond their traditional role of data custodian.” I was reading the infographic that Idera published about their accidental DBA survey results last week and wasn’t surprised at all by the results. I considered myself an accidental DBA when I was starting out in the industry and can totally […]