These days I’m digging into how to collect and analyze wait events on SQL Server database. So I simply have created a stored procedure to collect wait event information and have set it on SQL Agent job to run every 5 or 10 minutes. Then using same procedure with different parameter, I was able to … [Read more…]
SQL Server 2016 has improved the HA/DR solution – AlwaysOn, and also adds this great feature in Standard Edition with some limitation. AlwaysOn in SQL Server 2016 Standard Edition is very similar with the mirroring feature which was deprecated on SQL Server 2012. This is the some limitation of AlwaysOn in SQL Server 2016 Standard … [Read more…]
— Create Test DB CREATE DATABASE [DBName] GO — Take the Database Offline ALTER DATABASE [DBName] SET OFFLINE WITH ROLLBACK IMMEDIATE GO — Take the Database Online ALTER DATABASE [DBName] SET ONLINE GO — Clean up DROP DATABASE [DBName] GO
The SQLOS was introduced in SQL 2000 and CLR intregration occurred in SQL Server 2005. The database engine has been stable for many releases with few fundamental changes. SQL Server 2016 includes the integration of an R language processor as an external process callable from the SQL Server database engine in much the same way … [Read more…]
If you go to Tools menu choice then Options, you should see a Source Control on the Tree View on left. On Plug-in Selection you should be able to choice TFS, it not then the TFS connection might have been installed before you setup SSDT. Your software keeper should be able to give you the … [Read more…]
How to automate backups of SSAS cubes! This article provides how to automate backups of SSAS cubes using Windows PowerShell. 1. Create text files and scipts on C:\Scripts\ a. CubeList.txt EnterpriseDW TrackingDW ETLDW b. Backup_SSAS.ps1 $ServerName=”localhost” $loadInfo = [System.Reflection.Assembly]::LoadWithPartialName(“Microsoft.AnalysisServices”) | Out-Null ## Add the AMO namespace [Microsoft.AnalysisServices.BackupInfo]$serverBackup = New-Object ([Microsoft.AnalysisServices.BackupInfo]) [Microsoft.AnalysisServices.Server]$server = New-Object Microsoft.AnalysisServices.Server $server.connect($ServerName) … [Read more…]