Phil Factor answers some questions you've been itching to ask about SQL Prompt, covering ranked code completion suggestions and auto-fixing SQL code smells, and suggesting where in the tool to find other nuggets of hidden treasure.

Automate MSBI deployments Using PowerShell

by Kunal Rathi

SQLServerCentral.com

MSBI

There are various ways we can deploy MSBI project deliverable. This article will give you an idea to automate MSBI deployments using Windows PowerShell.

The Forever Technology War

by Steve Jones

SQLServerCentral.com

Editorial

The differences in our understanding of technologies can make for some communication challenges.

Git Anatomy

by Additional Articles

SimpleTalk

In this article, Dino Esposito gives an overview of git explaining repository, commit, and branch.

Maintaining Data in a Flow

by Steve Jones

SQLServerCentral

DevOps and Continuous Delivery (CI/CD)

One of the challenges of using scripts is maintaining them and ensuring the adapt over time.

Explore the Role of Normal Forms in Dimensional Modeling

by Additional Articles

MSSQLTips.com

Database Design

In this tip we walk through an exercise of developing a data model based on the characteristics of the data requirements.

Free eBook: Troubleshooting SQL Server: A Guide for the Accidental DBA

by Press Release

Redgate

Troubleshooting

Three SQL Server MVPs (Jonathan Kehayias, Ted Krueger and Gail Shaw) provide fascinating insight into the most common SQL Server problems, why they occur, and how they can be diagnosed using tools such as Performance Monitor, Dynamic Management Views and server-side tracing. The focus is on practical solutions for removing root causes of these problems, rather than "papering over the cracks".

Monitoring Amazon RDS SQL Servers with SQL Monitor v11

by Additional Articles

Redgate

Vendors/3rd-party Products

SQL Monitor v11 introduces native support for SQL Server instances hosted on Amazon Web Services (AWS) Relational Database Service (RDS) platform. In this post we'll explore the metrics you need to keep an eye on with Amazon RDS SQL Server monitoring, how a monitoring tool will help you manage the process of migrating databases to the Amazon cloud, as well as measures its success, and how SQL Monitor allows you to monitor all your SQL Server instances, wherever they are hosted, through a single pane of glass.