Today, Kendra talks about why version control for databases is important and how to get started.

Building SQL Server Indexes in Ascending vs Descending Order

by Additional Articles

MSSQLTips.com

Indexes

In this tip we look at the impact of building SQL Server indexes in ascending versus descending order and the impact.

Static data in SQL Change Automation SSMS plugin

by Additional Articles

Redgate

SQL Change Automation

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 […]