My book on SQL on Azure succintlly released

I feel extremely excited to share the latest release of my book on SQL on Azure Succintly with Syncfusion publications which talks about the deployments of SQL Server to Azure. You can download the latest version of the ebook from the following link http://www.syncfusion.com/resources/techportal/details/ebooks/sqlazure In recent years, we have witnessed how information technology has contributed… Continue reading My book on SQL on Azure succintlly released

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 experienced DBAs. Infact the person, installing SQL Server may not be even a DBA. I… Continue reading SQL Server Deployment Checklist

Failed to join the instance to the availability group while configuring AlwaysON

As SQL 2012 is in it’s RC0 phase, I was trying to configure AlwaysON on my 2-node WSFC with node and disk majority.Next I installed Default instance of SQL Server in parallel ( to save some time ) on both nodes of the WSFC.Next I enabled my instances for AlwaysON from SQL Configuration Manager for… Continue reading Failed to join the instance to the availability group while configuring AlwaysON

Powershell script to script all the Jobs from the given instance of SQL Server

Following is the powershell script to script out all the Jobs in one go. param($sqlserver) [System.Reflection.Assembly]::LoadWithPartialName(“Microsoft.SqlServer.Smo”) | Out-Null $srv = New-Object “Microsoft.SqlServer.Management.Smo.Server” $sqlserver $srv.JobServer.Jobs | foreach {$_.Script()} You can copy the above code in a notepad and save it as .ps1 file in some location on server. Next from the Object Explorer in SQL Management… Continue reading Powershell script to script all the Jobs from the given instance of SQL Server