Administration

Setting MAXDOP During SQL Server 2019 Setup

• by Steve Jones

• Brent Ozar Unlimited

• Administration

• DatabaseWeekly

Just a short note – in SQL Server 2019, the setu...

2019-05-23

Event Log File Paths

• by Steve Jones

• SQLServerCentral Blogs

• Administration

• DatabaseWeekly

How does one consistently find the correct path to...

2019-05-22

SQL SERVER – Script to Enable PAGE and ROW Level Compression – Disable Compression

• by Steve Jones

• Journey to SQL Authority with Pinal Dave

• Administration

• DatabaseWeekly

Comprehensive Database Performance Health Check Cl...

2019-05-22

When Was SQL Server Last Restarted? – Interview Question of the Week #225

• by Steve Jones

• Journey to SQL Authority with Pinal Dave

• Administration

• DatabaseWeekly

Question: When Was SQL Server Last Restarted?
First appeared on When Was SQL Server Last Restarted? – Interview Question of the Week #225

2019-05-20

DIY Open Source NAS: How to Install FreeNAS

• by Steve Jones

• IT Pro - Microsoft Windows Information, Solutions, Tools

• Administration

• DatabaseWeekly

Open source NAS isn’t appropriate for every use case, but it can be ideal for lab deployments, smaller workgroups or active archive data.

2019-05-20

SQL SERVER – Fix Error – Login failed for user. Reason: Server is in script upgrade mode. Only administrator can connect at this time. (Microsoft SQL Server, Error: 18401)

• by Steve Jones

• Journey to SQL Authority with Pinal Dave

• Administration

• DatabaseWeekly

I recently had a very simple and interesting error received while I was working with Docker and Persistence Storage for my upcoming SQL Server Performance Tuning Practical Workshop. The...

2019-05-20

A Self-Serve System to Refresh Databases (Part 3)

• by Ben Kubicek

• SQLServerCentral

• .Net
• Administration
• Backup and restore

• Article

This is the wrap up of this series on a system for developers to restore production database in test. It gets pretty detailed on the web setup side.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

5 (2)

Log in or register to rate

2019-05-16

2,425 reads

• Discuss

Underused sp_WhoIsActive capabilities: @delta_interval

• by Steve Jones

• Erik Darling Data

• Administration

• DatabaseWeekly

Great Ghost In the last post, we looked at how to see if your query is misbehaving, or if things…

2019-05-10

Log File Expansion Automation

• by Steve Jones

• SQL Server Science

• Administration

• DatabaseWeekly

SQL Server Database Log file expansion can be fairly tedious if you need to make the log bigger in many reasonably-sized growth increments. It can be tedious because you...

2019-05-10

Access is denied – Using DTCPing utility between two Windows Server 2016

• by Steve Jones

• SQLServerCentral Blogs

• Administration

• DatabaseWeekly

Few days ago a client requested the configuration of MSDTC (Microsoft Distributed Transaction Coordinator). NOTE: If you want to know more about it here is a nice FAQ from...
The...

2019-05-10