There are about a billion different technologies used to connect remotely to SQL Servers and some are better than others. Some allow file transfer, some allow sharing clipboards and some don’t. Of course, better depends entirely on your perspective. In most cases those ‘inconvenient’ things are there for a reason – security. nonetheless it’s a […]
Read More →Archive for September, 2013
An Introduction to Always On Availability Groups
The below is an extract from my presentation at SQL Saturday 252 on high availability and disaster recovery. This post covers the basics of Always On Availability Groups.
Read More →Mirror, mirror….
The below is an extract from my presentation at SQL Saturday 252 on high availability and disaster recovery. This post covers the basics of SQL Server Mirroring.
Read More →An Introduction to SQL Clustering
The below is an extract from my presentation at SQL Saturday 252 on high availability and disaster recovery. This post talks about SQL Server Failover Clustering.
Read More →How to resolve “No Global Profile Is Configured” issue in SQL Server
All you need to know to resolve a “No global profile is configured. Specify a profile name in the @profile_name parameter” error is to know that when it’s talking about a global profile, SQL Server is referring to a default profile in database mail.
Read More →How to Gain Emergency Sysadmin rights to a SQL Server
Whether you are trying to find the purpose of a SQL Server you just became responsible for, or access has been accidentally dropped, or you need to administer a vendor installed SQL instance, or a host of other reasons, from time to time you will need to get emergency sysadmin access into a SQL Server. This post talks about your options for regaining access to that rogue server.
Read More →An Introduction to Log Shipping
The below is an extract from my presentation at SQL Saturday 252 on high availability and disaster recovery. This post covers the basics of SQL Server log shipping.
Read More →