Press Release


External Article

New SQL Monitor Metric: Principals with Sysadmin Login

This metric counts the number of principals who are members of the sysadmin fixed server role. SQL Server relies on role-based security to manage permissions. If multiple IT system administrators have permissions to set up new SQL Server logins, they might be inclined to do so as part of the sysadmin role. Adding a normal user to the sysadmin role could pose a security risk and is not recommended unless the principal is highly trusted.

2013-11-11

3,175 reads

SQLServerCentral Article

SQL Saturday #248 Tampa

SQLSaturday BI & Big Data Edition is a free training event for everyone interested in learning about Business Intelligence & Big Data with a focus in the Microsoft SQL Server platform. This event will be held November 9th, 2013. In addition to our Saturday free event, we will also host four paid full day pre-conferences.

You rated this post out of 5. Change rating

2013-10-29

350 reads

Technical Article

SQL Saturday #255 Dallas

SQL Saturday is coming to Dallas on November 2. This is a free, one day conference for SQL Server training and networking.

On November 1, there will be a pre-conference event featuring Andy Leonard, Grant Fritchey, and Drew Minkin.

2013-10-24

3,031 reads

External Article

SQL Monitor Performance Metric: Buffer Cache Used Per Database in MB

Data pages read from disk are placed in the buffer pool with the intention that they will be reused, and accessing them from RAM is faster than from disk. Knowing how much of your RAM is committed to each database can help you provision the right amount of RAM to SQL Server, and also to identify rogue queries that draw too much data into RAM and force data from other databases out of the cache.

2013-10-15

3,478 reads

Blogs

When It’s Still Viable

By

If a technology is still viable, don’t overlook it. Don’t get caught up chasing...

T-SQL Tuesday #179: The Detective’s Toolkit

By

It’s time for the monthly T-SQL Tuesday blog party. This month a longtime friend,...

Moving T-SQL Tuesday to Jekyll

By

I got a message a few months back that Microsoft was deprecating the MySQL...

Read the latest Blogs

Forums

test new topic

By philip.scott

posting a new topic

New article

By Steve Jones - SSC Editor

Comments posted to this topic are about the item New article

Monitoring Azure Blob Storage

By arindamxs

Comments posted to this topic are about the item Monitoring Azure Blob Storage

Visit the forum

Question of the Day

Azure Data Lake Storage Gen 2

Azure Data Lake Storage Gen 2 is built on ...?

See possible answers