Training DBA from other countries

Technology is a universal language so training DBAs from other countries is not really a challenge when covering technical aspects. But here are a few things to keep in mind. Time zones- lunch breaks are different for different people. Office hours – Availability of daylight usually impacts office hours and typically there is a difference…

What’s next?

Here are lists of topics we are planning to include in the upcoming blogs. If you would like to see any topics added or covered sooner, please vote for it. Performance Resource Governor OLTP in Memory Tables Identifying IO Bottle necks Optimistic Concurrency Understanding execution plans Security Contained Databases SQL Injection Protecting against SQL Injection…

SQL 2014 licensing

As with any installation of SQL server we start with the licensing of SQL Server 2014. Most DBAs are unaware of the implications of licensing costs on the overall project. But over the years these costs have been increasing more importantly the options have been decreasing as well. Like with SQL 2012 we still have…

SQL Server Replication Series: – Removing Replication

Most times we do not remove replication from a server once it’s been setup but there are occasional scenarios where it may be required. E.g. when decommissioning a server or changing the high availability plan for a particular database server. Removing replication is much easier than setting it up and can be done within a…

Network connectivity issues AWS SQL Express instance

Amazon is one of the premier cloud solutions providers out there and they offer development houses a number of solutions and features that cater to almost any requirement that a business can have. One of the most common setups I have seen is to have an EC2 (the equivalent of running your own virtual machine…

SQL Server Replication Series Part 1

This blog is the first in a series on the topic of SQL Server replication. The topics are the same for the most part for SQL Server 2008 R2 or 2012. In case there are any obvious differences we will call them out as we go along. Replication is one of Microsoft SQL Servers high…