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

Muting the Immutable

• by Phil Factor

• SQLServerCentral.com

• Editorial

Phil Factor on dealing with "immutable" domain data during database development and deployment.

Vagrant and SQL Server 2017 on Linux

• by David Poole

• SQLServerCentral.com

• Virtualization, containers, and k8s

Vagrant provides a mechanism to build and configure a virtual Linux box running SQL Server 2017

Simple SQL Change Automation Scripting: Connections, iProjects and Builds

• by Additional Articles

• Redgate

• SQL Change Automation

Phil Factor delves into some of SQL Change Automation's data objects, or artifacts, covering the DatabaseConnection, iProject and iBuildArtifact objects. He explains the useful information they contain and how to use them in a PowerShell-automated database delivery process.