SQL Server

How to set up AlwaysOn Availability Group in SQL Server 2016

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 on »

SQL Server TSQL – Take a database offline and online

— 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  

Read on »

SQL Server database engine architecture

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 on »

How to connect to Source Control from SSDT

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 on »

Automate backups of SSAS cubes

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 on »