Considerations for Configuring Log Shipping for a cross-domain clustered instance of SQL Server over a Firewall

Last week, one of my customers had engaged me for consulting to configure Log Shipping on clustered instance of SQL Servers which are running in different domains. In other words, the primary and secondary servers are in different domains. While … Continue reading →

SQL Server Deployment Checklist

While most experienced DBAs would maintain their checklist before installing and setting up SQL Server in the production environment. However SQL Server is a product which is very commonly used by Small and Medium Enterprise who do not necessarily have … Continue reading →

SQL Server Predeployment IO Stress Testing using sqlio

While there are some really good in-depth whitepapers and blogs (specifically by CSS Team and Brent Ozar & his team) to address this topic. However the information in these blogs,whitepapers is kind-off scattered and for a novice the information in … Continue reading →