administration

Testing categories. Please ignore

• by Phil Factor

• SQLServerCentral

• @@OPTIONS
• Edward Testing
• Edward Testing 2

• Article

Ignore this. It's a test for debugging purposes.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2023-02-03 (first published: 2023-02-02)

6 reads

• Discuss

Building blocks of Extended Events data collection

• by Additional Articles

• SimpleTalk

• Database Administration

• Article

Extended Events have been part of SQL Server since 2008. In this article, Ed Pollack explains the building blocks of Extended Events data collection.

2021-10-04

SQL Server and hyperconvergence

• by Additional Articles

• SimpleTalk

• Database Administration

• Article

To be efficient and save money, many organizations are looking at hyperconverged infrastructures for SQL Server. In this article, Robert Sheldon explains what to consider for SQL Server and hyperconvergence.

2021-07-09

SQL Server performance tuning: Nine best practices

• by Additional Articles

• SimpleTalk

• Database Administration

• Article

SQL Server performance tuning can seem overwhelming when you don’t know where to start. In this article Robert Sheldon explains 9 best practices for performance tuning.

2021-06-16

How to Find Unused Databases in SQL Server

• by Additional Articles

• MSSQLTips.com

• Database Administration
• SQL Server

• Article

In this article we look at how to identify if SQL Server databases are not being used and a process to take these unused databases offline.

2021-06-14

Great Power(Shell)...Great Responsibility

• by Cláudio Silva

• SQLServerCentral

• Administration
• Automation
• dbatools
• PowerShell
• SQLServer

• Article

-WhatIf you could see what would happen if you ran a command?

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

5 (3)

Log in or register to rate

You rated this post out of 5. Change rating

2020-10-23

3,541 reads

• Discuss

Execute on DMVs without user having View Server State

• by inkosi_dba_dev

• SQLServerCentral

• Administration
• T-SQL

• Script

Wanted to share this script to the community just in case anyone out there may be search for a way to allow a hosted customer the ability to query certain DMVs for information without granting them View Server State. There are some other options out there, but this worked better for me after going through […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

5 (1)

Log in or register to rate

You rated this post out of 5. Change rating

2020-09-24

1,191 reads

• Discuss

Storage 101: The Future of Storage

• by Additional Articles

• SimpleTalk

• Database Administration

• Article

Robert Sheldon wraps up his series on storage by discussing the latest storage innovation and ideas.

2020-09-14

SQL Server Problems We Don’t Have Anymore

• by Additional Articles

• Brent Ozar Unlimited Blog

• Database Administration

• Article

There are a whole slew of problems that we had to worry about ten years ago, and they just hardly ever come up today.

2020-08-28

Storage 101: Data Security and Privacy

• by Additional Articles

• SimpleTalk

• Database Administration

• Article

No discussion about storage is complete without thinking about security of the data. In this article, Robert Sheldon explains what must be considered to protect data in today's world.

2020-08-10