In this tip we look at how to change specific parts of a date such as the Year, Month or Day for data stored in a SQL Server table.

SQL Server performance issue after an upgrade

by Kanishka Basak

SQLServerCentral

Recently, I came across a problem where the client reported severe performance degradation of their OLAP system. Most of the reports that were running were either timing out or were returning data after a long time. The problem started right after the client had undergone an upgrade, that included the following, Software change, that includes […]

A Toolbox Every DBA Should Have

by Additional Articles

Database Journal

As a DBA it is important to have a toolbox that supports the work you do. You need to have a toolbox that allows you to work smarter instead of harder. Read on to learn about some key tools every DBA should have in their toolbox!

Controlling how SQL Prompt Formats your Code: The Knobs and Dials

by Additional Articles

Redgate

Phil Factor explores and discusses the current state of the art in SQL Formatting, as done automatically by SQL Prompt.

The harsh reality of charitable IT work

by Phil Factor

SQLServerCentral

At work in IT, we can wander around looking important with no apparent useful skills whatsoever. When working outside the bubble of the industry, things are different.

A New Recovery Tool for Your Toolbelt

by Steve Jones

SQLServerCentral.com

Editorial

Learning a new skill is always helpful, especially for backup and restore. Steve Jones talks about an idea from the SQLCAT team.

Azure Text Analytics and Power BI

by Additional Articles

MSSQLTips.com

In this tip we look at how to analyze textual data to gain insight from freeform text using Azure Text Analytics and Power BI.

Deploying Data and Schema Together with SQL Compare or SQL Change Automation

by Additional Articles

Redgate

You want to use SQL Compare or SQL Change Automation (SCA) to create or update a database, and at the same time ensure that its data is as you expect. You want to avoid running any additional PowerShell scripting every time you do it, and you want to keep everything in source control, including the data. You just want to keep everything simple. Phil Factor demonstrates how it's done, by generating MERGE scripts from a stored procedure.