2018-12-14
813 reads
Configuration
2016-09-21
1,198 reads
Target Recovery Interval and Indirect Checkpoint
Indirect checkpoint is the recommended configuration, especially on systems with large memory footprints and default for databases created in SQL Server 2016.
2016-07-21
11,046 reads
Quick SQL Server Configuration Summary Report
This script will detect and display a quick summary of your SQL Server installation.
2016-08-03 (first published: 2015-01-29)
9,497 reads
Context Is Everything - Check Your Settings
Check 96 server and database settings to make sure they match your expectations in your databases with this script.
2014-05-06
4,729 reads
How to Document and Configure SQL Server Instance Settings
There are around seventy SQL Server instance settings, and a DBA needs to be aware of the effect that many of them have. Brad McGehee explains them in enough detail to help with most common configuration problems, and suggests some best practices.
2012-02-13
4,300 reads
Configure Windows Firewall to Work with SQL Server
Windows Firewall is an OS level software firewall. It can be a crucial part of OS level security if you are not using other firewall hardware or software. Since I do not have another firewall I have a need to enable Windows Firewall for my SQL Server database server. In this article I go through the process of configuring Windows Firewall for different scenarios along with the associated considerations.
2010-02-11
4,068 reads
SQL Server Configuration
The importance of correct configuration. Which default configuration options to change. Common mistakes.
2009-10-22
4,609 reads
How to move a SQL Server database within the same instance without losing settings
I want to move my database on my SQL Server 2005 system to a new drive, but I have database options, like cross-database ownership chaining, that I don't want to lose or have to remember to re-apply. How can I do this?
2009-02-26
2,969 reads
2008-12-03
3,703 reads
Blogs
Did You Really Name That Default?
By alevyinroc
Ten years (and a couple jobs) ago, I wrote about naming default constraints to...
Monday Monitor Tips: A New Analysis Page
By Steve Jones
We have multiple teams (8) working on Redgate Monitor. Some work on the Standard...
Case Studies: Real-World Success Stories of FinOps Implementation
By HeyMo0sh
Learning any kind of theory is easy, but adapting FinOps and watching it rescue...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
The Problem Isn't Always Your Query or Schema... Sometimes It's Hidden Assumptions
Comments posted to this topic are about the item The Problem Isn't Always Your...
Identity Defaults
Comments posted to this topic are about the item Identity Defaults
Question of the Day
Identity Defaults
What happens when I run this code?
CREATE TABLE dbo.IdentityTest
(
id int IDENTITY(10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
See possible answers