Today Steve looks at a research project from Microsoft that provides some better protection from firmware security issues.

Monitor Current Analysis Services Activity

by Pablo Echeverria

SQLServerCentral

Although not every business has SSAS (SQL Server Analysis Services) installed nor use it extensively, the ones who do also care about their database responsiveness. If it is slow, what else is running that may be causing the slowness? Are there any locks? What commands are being run, who is running them, from where? How […]

Test data provisioning for development – free whitepaper

by Additional Articles

Redgate

Compare the most common approaches to provisioning test data to database development teams and see how they stack up.
Learn why traditional approaches like restore from backup are no longer suitable, and how successful organizations are implementing a combined data masking and data virtualization approach.

Update only Year, Month or Day in a SQL Server Date

by Additional Articles

MSSQLTips.com

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.