Articles

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.

2020-02-04

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

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(3)

You rated this post out of 5. Change rating

2020-02-03

9,689 reads

Discuss

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.

2020-02-03

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.

2020-02-03

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.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(3)

You rated this post out of 5. Change rating

2020-01-31 (first published: 2017-04-17)

33,530 reads

Discuss

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.

2020-01-31

Power BI Advanced Q&A

by Additional Articles

MSSQLTips.com

Power BI

What advanced features are available in the Power BI Q&A functionality? Also, how does the new Q&A visual work?

2020-01-31

Export/Import Data using BCP - SQL Server on Linux

by Carlos Robles

SQLServerCentral

In this article you will learn how to use BCP for SQL Server on Linux to export and import data using the BCP command line utility.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(5)

You rated this post out of 5. Change rating

2020-01-30

10,836 reads

Discuss

Cloning all the Databases on a Server

by Additional Articles and Phil Factor

Redgate

Phil Factor shows uses SQL Clone and PowerShell to automatically create images of all databases on an instance, if they don't already exist, and then create or refresh clones of each one, on all your development servers.

2020-01-30

SQL Server Attach and Detach Database Examples

by Additional Articles

MSSQLTips.com

In this article Dinesh Asanka looks at how to detach and attach a SQL Server database using the SSMS GUI and using T-SQL commands.

2020-01-30

Articles

Static data in SQL Change Automation SSMS plugin

Analysis Services : OLEDB Error while processing in SSAS

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

How to Create an Ubuntu PowerShell Development Environment – Part 1

The Connection to the Primary Replica is not Active

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

Power BI Advanced Q&A

Export/Import Data using BCP - SQL Server on Linux

Cloning all the Databases on a Server

SQL Server Attach and Detach Database Examples

Blogs

The Book of Redgate: Spread across the world

Merry Christmas

Self-Hosting a Photo Server the Whole Family Can Use

Forums

Happy Holidays, Let's Do Nerdy Stuff

UNISTR Escape

Celebrating Tomorrow

Question of the Day

UNISTR Escape