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…
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…
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…
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…