Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Guest Columnist: John F. Tamburo

SQLServerCentral.com profile

   Items 1 to 12 of 12   
 

SQL Authentication Via AD Groups Part III: What About Orphaned Users?

With AD Authentication via groups, SQL Server is vulnerable to orphaned Windows users' logins being added to SQL Server at a later date. This article gives an improved user audit script that detects orphaned DB Users and also a delete script.  Read more...
By John F. Tamburo 2016/07/18 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 1,310 reads

The Bleeding Edge Versus N Minus One

Risk-averse managers are reticent to upgrade to the latest and greatest. Why is this the case and how can the savvy DBA make the case for and get ready for a newer version of SQL Server?  Read more...
By John F. Tamburo 2016/06/28 | Source: SQLServerCentral.com | Category: risk management
Rating: |  Discuss |   Briefcase | 1,711 reads

How Long Before Your Database Runs Out of Space?

Almost all SQL Server databases grow in size over time. Capacity planning is an important activity for the DBA. You need to know how long before you run out of space long before you actually do. Here are some helpful tips and tricks.  Read more...
By John F. Tamburo 2016/06/09 | Source: SQLServerCentral.com | Category: capacity planning
Rating: |  Discuss |   Briefcase | 2,751 reads

The DBA's Essential Index Monitoring and Maintenance Tasks

Indexes can be the most critical part of any database. they can drastically improve performance or they can ruin it. Wise management is the key to success.  Read more...
By John F. Tamburo 2016/02/15 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 4,764 reads

SQL Authentication Via AD Groups Part II: Who has what access?

In a previous article, we discussed how to liberate the DBA from SQL Logins with AD Groups. A good point was raised: How can the DBA know who has what access? Here is a solution.  Read more...
By John F. Tamburo 2016/02/18 | Source: SQLServerCentral.com | Category: active directory
Rating: |  Discuss |   Briefcase | 3,457 reads

Packaged-Application Database Nightmares - A Horror Story.

The business decides on a packaged application and buys it. After installation, you look at the schema and realize that is is a nightmare. How do you manage this nightmare?  Read more...
By John F. Tamburo 2015/12/22 | Source: SQLServerCentral.com | Category: packaged applications
Rating: |  Discuss |   Briefcase | 4,253 reads

Understanding Peer-to-Peer Transactional Replication, Part 3

We've gone through the basics of Peer-to-Peer Transactional Replication (PPTR). Now, we will blow it up! We will then fix it and show you how you how to triage and repair PPTR. When you remain calm and take some easy steps, you can stabilize PPTR with ease.  Read more...
By John F. Tamburo 2016/01/07 | Source: SQLServerCentral.com | Category: replication
Rating: |  Discuss |   Briefcase | 2,094 reads

Liberating the DBA from SQL Authentication with AD Groups

It's 15 years after the beginning of the century. Time to eliminate the security exposure of SQL logins, and implement integrated security. Active Directory Groups make this easy for the DBA.  Read more...
By John F. Tamburo 2015/12/21 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 5,204 reads

A Single-Parameter Date Range in SQL Server Reporting Services

Many reports you will generate in SSRS will need to report within date ranges, and most of those will need a date range parameter. Here's an way to make an easy-to-use date range parameter.  Read more...
Rating: |  Discuss |   Briefcase | 6,357 reads

DBAs and the ITIL Framework

Most IT departments are moving toward ITIL-aligned practices. Gain a general understanding of the ITIL framework and how Database Administrators can take advantage of it.  Read more...
By John F. Tamburo 2015/10/26 | Source: SQLServerCentral.com | Category: itil
Rating: |  Discuss |   Briefcase | 5,749 reads

Understanding Peer-to-Peer Transactional Replication, Part 2

As the Peer-to-Peer series continues, we set up an example topology in Peer-to-Peer Transactional replication and test it.  Read more...
By John F. Tamburo 2015/11/05 | Source: SQLServerCentral.com | Category: replication
Rating: |  Discuss |   Briefcase | 2,520 reads

Understanding Peer-to-Peer Transactional Replication, Part 1

There are times when you need to share tables between servers, where the table may be updated in both places. Peer-to-Peer Transactional Replication gives you the ability to create a solution. I explain the benefits and the downfalls.  Read more...
By John F. Tamburo 2014/01/13 | Source: SQLServerCentral.com | Category: replication
Rating: |  Discuss |   Briefcase | 4,736 reads
   Items 1 to 12 of 12