Kendra Little sat down with the SQL Change Automation Dev Team to get some insight into how they build the product with the customers in mind. SQL Change Automation 4.1 included adding support for the tracking of static data tables to the SSMS extension. This was a direct result of the communication and work the team have carried out with their customer base. Read Kendra’s blog to find out more about the release and the work that goes into delivering these updates.

Analysis Services : OLEDB Error while processing in SSAS

by aveek22

SQLServerCentral

Problem This is one of the errors that I frequently encounter while deploying or processing SSAS OLAP cubes on the client's computers or on a remote server. Recently, one of my team members also faced the same issue and so I thought to write a resolution for the issue. The error is something like this: […]

Rock and Roll

by Grant Fritchey

SQLServerCentral

Compliance

Today, Grant Fritchey talks about discussing compliance with management.

Changing SET options in a Procedure or Trigger leads to Recompilation (PE012)

by Additional Articles and Phil Factor

Redgate

SQL PROMPT

Phil Factor delves into SQL Prompt's performance rule, PE012, which will advise you if it detects the use of the SET statements within a stored procedure or trigger, which might cause unnecessary recompilations, though the issue extends to other types of batches.

How to Create an Ubuntu PowerShell Development Environment – Part 1

by Additional Articles and Robert-Cain

SimpleTalk

DevOps and Continuous Delivery (CI/CD)

Since SQL Server now runs in Linux, more database professionals will begin to learn this operating system. In this article, Robert Cain demonstrates how to set up an Ubuntu virtual machine for learning.

Why Getting Data Right Matters

by drsql@hotmail.com

SQLServerCentral

Database Weekly

An InfoWorld article from 2017 suggests that 80 percent of a data scientist’s job is cleaning and transforming data, and I believe this is probably only true for organizations that spend at least an average effort in designing and implementing their data storage. These persons who have trained to analyze data using complex math formulas […]

The Connection to the Primary Replica is not Active

by Ganapathi varma Chekuri

SQLServerCentral.com

always on

In this article, I’m going to talk an issue that I found when joining replica or database on secondary replica to availability group.

Why I Don’t Like Shared Development Databases

by Kendra Little

SQLServerCentral

DevOps and Continuous Delivery (CI/CD)

Today, Kendra explains why she doesn't like shared development databases.

Do you want the chance to win Redgate goodies and books?

by Press Release

Redgate

Competition

Visit the Redgate Forums today to enter the competition to win a Redgate goodie bag including a copy of Grant Fritchey’s SQL Server Executions Plans (Third Edition), plus your choice of the classic novel about DevOps, The Phoenix Project, or the follow-up book, The Unicorn Project.