SQL Server 2005 has added many new T-SQL commands, one of which is the OUTPUT command. Longtime SQL Server author Dinesh Asanka brings us a short look at how you can use this command.

Integrating Redgate SQL Code Guard with SonarQube

by Additional Articles

Redgate

SQL Change Automation

Greta Rudžioniene provides a step-by-step guide to running SQL code analysis checks, as defined by SQL Code Guard, in SonarQube, a general-purpose code quality tool that can perform continuous code analysis on a variety of languages.

A Self-Tuning Fill Factor Technique for SQL Server – Part 1

by Mike Byrd

SQLServerCentral

Introduction So what’s all the fuss about Fill Factor? It is a SQL Server parameter I’ve ignored for 20+ years. The main reason was/is I’ve had no idea about what value to use. There is just no documented definitive guidance. Back in April at SQL Saturday #830 - Colorado Springs, I attended two sessions by […]

IT Staffer Fired

by Steve Jones

SQLServerCentral

An IT staffer is fired after a security incident.

Using SQL Monitor to manage a growing server estate

by Additional Articles

Redgate

SQL Monitoring

The State of SQL Server Monitoring report found that monitoring is key to managing large estates, and as estates continue to grow the need for a monitoring solution that is scalable is increasing. German IT Service Provider Fiducia & GAD IT AG implemented Redgate’s SQL Monitor to better manage the performance of its growing SQL Server estate.

Memories of DR testing

by MVDBA (Mike Vessey)

SQLServerCentral

With the introduction of the GDPR, a lot of our prospective clients are demanding more and more information regarding data disposal, retention and usage practices. Both our new and existing clients want to look at our internal ecosystem and understand how we manage it. This means that I finally got a budget for a disaster […]

Phishing Defenses

by Steve Jones

SQLServerCentral

Security

Steve has a few ideas on how to protect yourself from phishing scams.

Simple SQL Change Automation Scripting: The Release Object

by Additional Articles

Redgate

SQL Change Automation

Once you understand the SCA data objects, it can give you a certain glow of to discover, suddenly, that SCA can do some complicated and time-consuming tasks with just a few lines of code. Phil Factor demonstrates how to get the most of SCA's Release object.

Lots of data in RAM

by Steve Jones

SQLServerCentral

Hardware

I remember buying my first computer after college. At the time I was working part time and in graduate studies part time. My aging high school era Apple II wasn't capable of handling the load, not to mention its 300baud modem wasn't a lot of fun. I could likely have gotten a faster modem with […]