The First Rule

• by Steve Jones

• SQLServerCentral

• software development

Steve has a good rule for anyone that's designing software or databases.

Free eBook: SQL Server Execution Plans, Third Edition

• by Press Release

• Redgate

• Execution Plans

If a query is performing poorly, and you can't understand why, then that query's execution plan will tell you not only what data set is coming back, but also what SQL Server did, and in what order, to get that data. It will reveal how the data was retrieved, and from which tables and indexes, what types of joins were used, at what point filtering, sorting and aggregation occurred, and a whole lot more. These details will often highlight the likely source of any problem.

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

• Performance and Tuning
• Rebuild
• Rebuild Index
• Rebuilding indexes

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

• Career
• Security

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

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