How To Install SSAS 2019
In this article we walk through the steps to install SQL Server Analysis Services for SQL Server 2019.
2020-12-22
Additional Articles
Are your Oracle archived log files much too small?
Oracle sometimes generates smaller archived redo logs than you might expect based on the size of the online redo logs. In this article, Jonathan Lewis explains how Oracle uses online redo logs and why there might be a discrepancy in the archived log size.
2020-12-21
Tackling the challenges of hybrid, cloud, and on-premises SQL Server estates
As more organizations are managing at least some part of their data in the cloud, estate monitoring can become more complex with a mix of on-prem and cloud-based instances. Grant Fritchey discusses why businesses might move to the cloud, why they might stay on-prem, and when a hybrid approach might be best.
2020-12-21
How to Configure Amazon RDS SQL Server for Windows Authentication
This article will show how to use Windows authentication for AWS RDS SQL Server by setting up an AWS Managed Active Directory and integrate it with an AWS RDS SQL Server instance.
2020-12-18
Whitepaper: Enabling fast and easy database migrations with Flyway
High performing teams must implement a common approach to database migrations so that the database can be included in Continuous Delivery. This ‘kernel’ of Database DevOps leads to better alignment between developers and Ops teams, and increases the throughput of high quality releases. The key for many is Flyway, and this whitepaper explores how this highly configurable migrations tool enables a bespoke migrations-based deployment strategy that is easy to adopt and scale across teams
2020-12-18
Developing a backup plan
Without a good backup and recovery strategy in place, a DBA should make sure their resume is always up to date. In this article, Greg Larsen discusses what should be considered when developing a backup plan.
2020-12-17
Deploy Database Objects to Multiple SQL Server Instances Using PowerShell
In this article we look at a PowerShell script that can help you deploy database objects to multiple SQL Server instances.
2020-12-16
Effective Data Governance: Being Grown Up About Data
William Brewer explains how to make data governance a continuous organizational activity, based on well-established standards and practices, rather than a knee-jerk response, and which skills and tools will help you achieve compliance, including SQL Data Catalog for discovery and classification of data held in SQL Server.
2020-12-16
More Gems from the SQL Prompt Treasure Chest
Become the captain of your SQL Prompt ship by embarking on a voyage of discovery through the hidden treasures of the tool. You'll uncover features of the unknown that will enable you to write, format, analyze and refactor your SQL effortlessly. Join this webinar on December 16th to find out more.
2020-12-15
Normal Forms
To prevent data change anomalies, a database should be normalized. Did you know that there are 10 normal forms? In this article, Joe Celko reviews normalizing databases including commonly used normal forms.
2020-12-15
Blogs
2025 Wrapped for Steve
By Steve Jones
I’ve often done some analysis of my year in different ways. Last year I...
The Book of Redgate: Spread across the world
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
Merry Christmas
By John
Today is Christmas and while I do not expect anybody to actual be reading...
Forums
Finding Motivation
Comments posted to this topic are about the item Finding Motivation
The Last Binary Value of the Year
Comments posted to this topic are about the item The Last Binary Value of...
SQL Art, Part 2: New Year Fireworks in SSMS
Comments posted to this topic are about the item SQL Art, Part 2: New...
Question of the Day
The Last Binary Value of the Year
What does this code return?
SELECT cast(0x2025 AS NVARCHAR(20))Image 1:
Image 2: 
Image 3: 
Image 4: 
See possible answers