Kubernetes HELM chart for MSSQL Server 2017 on Linux.
January Release Available
We are excited to announce the January release of SQL Operations Studio is now available. Download SQL Operations Studio and review the release notes to get started...
This tutorial shows how to deploy a SQL Server high availability solution with Kubernetes on Azure Container Service.
Announcing SQL 2017 CU3, 2016 SP1 CU7 with Meltdown/Spectre Attack Mitigations - SQLServerUpdates.com
The Meltdown and Spectre attacks are newly announced ways of hacking CPUs, and they’re causing all kinds of urgent patches this week in operating systems, hypervisors, and apps. SQL Server 2017 CU3 SQL Server 2016 SP1 CU7 Go get ’em, tiger. Other improvements & fixes include some really awesome ...
Microsoft article on DW strategies and patterns
This article provides an overview of the Microsoft Azure SQL Data Warehouse architecture. This platform-as-a service (PaaS) offering provides independent compute and storage scaling on demand. This document provides data loading guidelines for SQL Data Warehouse. Several common loading options are d...
Temporal Tables are generally useful in scenarios that require tracking history of data changes.We recommend you to consider Temporal Tables in the following use cases for major productivity benefits.
TSQL Code must work properly and efficiently. That's not enough though. Unless you are working alone, have perfect memory and plan to never change job, then you need to comment and document your code, it must be inherently readable, well laid out, use informative and obvious names, and it must be ro...
I've been working in the business intelligence field since 2008 and I've loved every second of it! Whether I'm modelling a data warehouse, overcoming some tricky ETL problems, designing an SSAS cube or Tabular model or coming up with just the right Power BI solution, I'm happy to be doing what I do.