MSBI Tutor

Months: SELECT DATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE()) - 1, 0) -- First day of previous month SELECT DATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE()), -1) -- Last Day of previous month SELECT DATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE()), 0) -- First day of this month SELECT DATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE()) + 1, -1) -- Last day of this month SELECT DATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE()) + 1, 0) -- First day of next month SELECT DATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE()) + 2, -1) -- Last day of next month Quarters: SELECT DATEADD(QUARTER, DATEDIFF(QUARTER, 0, GETDATE()) -1, 0) -- First day of previous quarter SELECT DATEADD(QUARTER, DATEDIFF(QUARTER, 0, GETDATE()), -1) -- Last day of previous quarter SELECT DATEADD(QUARTER, DATEDIFF(QUARTER, 0, GETDATE()), 0) -- First day of this quarter SELECT DATEADD(QUARTER, DATEDIFF(QUARTER, 0, GETDATE()) + 1, -1) -- Last day of this quarter SELECT DATEADD(QUARTER, DATEDIFF(QUARTER, 0, GETDATE()) + 1, 0) -- First day of next q

PERFORMANCE & SCALE o         In-Memory OLTP o         Enhanced In-Memory ColumnStore for DW o         Buffer Pool Extension to SSDs o         Enhanced Query Processing o         Resource Governor adds IO governance o         SysPrep at cluster level o         Predictable performance with tiering of compute, network, and storage with Windows Server 2012 R2 HIGH AVAILABILITY o         Enhanced AlwaysOn, with 8 secondaries and Replica Wizard o         Delayed Durability o         Clustered Shared Volume support, VHDX support (Windows Server 2012 R2) o         Manage on-premises and cloud apps (System Center 2012 R2) SECURITY o         Enhanced separation of duty o         CC certification at High Assurance Level for 2014 o         Backup encryption support PROGRAMMABILITY o        Query optimization enhancements EASY ACCESS TO DATA, BIG & SMALL o        Power Query o        Windows Azure HDInsight Service o    

PERFORMANCE & SCALE o        In-Memory OLTP o        Enhanced In-Memory ColumnStore for DW o        Support for 640 logical proc. & 4 TB memory o        Support to 15,000 partitions o        Resource Governor IO governance o        Buffer Pool Extension to SSDs o        Query optimization enhancements o        SysPrep at cluster level o        Predictable performance with tiering of compute, network, and storage with Windows Server 2012 R2 HIGH AVAILABILITY o        SQL Server AlwaysOn o        Delayed Durability o        Recovery Advisor o        Windows Server Core o        Live Migration o        Online Operations enhancements o        Clustered Shared Volume support, VHDX support (Windows Server 2012 R2) o        Manage on-premises and cloud apps (System Center 2012 R2) SECURITY o        User-Defined Server Roles o        Default Schema for Groups o        SQL Server Audit o        SQL Server Fine-grai

PERFORMANCE & SCALE o        In-Memory OLTP o        Enhanced In-Memory ColumnStore for DW o        Support for 640 logical proc. & 4 TB memory o        Support to 15,000 partitions o        Resource Governor IO governance o        Buffer Pool Extension to SSDs o        Query optimization enhancements o        SysPrep at cluster level o        Predictable performance with tiering of compute, network, and storage with Windows Server 2012 R2 o        Data Compression with USC-2 Unicode support o        Backup Compression HIGH AVAILABILITY o        SQL Server AlwaysOn o        Delayed Durability o        Recovery Advisor o        Windows Server Core o        Live Migration o        Online Operations enhancements o        Clustered Shared Volume support, VHDX support (Windows Server 2012 R2) o        Manage on-premises and cloud apps (System Center 2012 R2) SECURITY o        User-Defined Server Roles o        

PERFORMANCE & SCALE o        In-Memory OLTP o        Enhanced In-Memory ColumnStore for DW o        Support for 640 logical proc. & 4 TB memory o        Support to 15,000 partitions o        Resource Governor IO governance o        Buffer Pool Extension to SSDs o        Query optimization enhancements o        SysPrep at cluster level o        Predictable performance with tiring of compute, network, and storage with Windows Server 2012 R2 o        Data Compression with USC-2 Unicode support o        Backup Compression HIGH AVAILABILITY o        SQL Server Always On o        Database Mirroring o        Failover Clustering o        Database Snapshots o        Delayed Durability o        Recovery Advisor o        Windows Server Core o        Live Migration o        Online Operations o        Clustered Shared Volume support, VHDX support (Windows Server 2012 R2) o        Manage on-premises and cloud apps (Syst