Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Information about SQL Server security.
SQL Server Transparent Database Encryption (TDE)
Overview of TDE with some details on major administrative issues. Many people who've played around...
Date: 10/01/2013
SQL Server 2012 Virtual Labs
Want to try SQL Server 2012 without even installing it? Easy... use SQL Server 2012 Virtual Labs at...
Date: 10/23/2012
Managed Service Accounts
Doh! Never mind the post below. If I had read more thoroughly (or if I had tested using MSAs with...
Date: 09/04/2012
Alert On Low Disk Space, Including Mount Points
A common task for many database administrators (DBAs) is to set up alert emails to notify themselves...
Date: 08/01/2012
Enabling SSL on SQL Server Connections on Failover Clusters
With high-security SQL Server configurations we usually want to encyrpt the data-in-transit between...
Date: 07/05/2012
SQL Server Ports
Quick cheat sheet for port numbers used by SQL Server services or services that SQL Server may...
Date: 07/03/2012
Capture Custom Events in Profiler for Troubleshooting
User configurable events have been available in SQL Server since at least version 2000, but aren't...
Date: 06/21/2012
Note to self on AlwaysOn...
I came up with the idea that perhaps we could let clients connect to a database in an AlwaysOn...
Date: 05/09/2012
Installing SQL Server in a High-Security Domain, Part II
In this article, I pointed out some of the most common permissions failures when installing SQL...
Date: 04/04/2012
SQL Server Installation Center 2012
As a reminder for myself when I can't fire up the Installation Center, here are the screen shots. To...
Date: 03/07/2012
Does the DoD STIG require Transparent Database Encryption (TDE)?
Does the DoD STIG require Transparent Database Encryption (TDE)? The short answer is: It depends on...
Date: 02/23/2012
SQL Server 2012 release date: March 7, 2012
It's official, SQL Server 2012 goes on the market on Wednesday, March 7th, 2012! Update on Feb 27,...
Date: 01/24/2012
SQL Server Accounts
Sometimes I run into established DBA's who have a little confusion regarding the different types of...
Date: 01/09/2012
Get Rid of Deadlocks
Locks are used by relational database management systems to increase user concurrency (more users)...
Date: 12/12/2011
The Database STIG's System Security Plan
The Database STIG requires a written System Security Plan, and it's the responsibility of the...
Date: 11/10/2011
Securing SQL Server Integration Services (SSIS)
I was recently asked about securing SQL Server Integration Services, and I knew next to nothing...
Date: 11/08/2011
SQL Server and PowerShell Security
Sometime back, I heard that Microsoft was going to start using PowerShell scripts to monitor and...
Date: 10/04/2011
Separation of Duties for DBA's
Someone recently asked me about the principle of separation of duties (aka segregation of duties) as...
Date: 09/12/2011
SQL Server, the DoD, and Common Criteria
Common Criteria is an international standard for a set of security characteristics, and the U.S....
Date: 08/12/2011
Free SQL Ranger Training
When I first heard about "SQL Rangers" I wasn't sure what it was, but I definitely wanted to be one....
Date: 07/20/2011
Conditionally Updating Statistics
SQL Server's query optimization engine uses statistics on indexes to determine the most efficient...
Date: 07/19/2011
PFE vs. Consultant
Well, it's almost the end of June and none of my draft posts are close enough to finishing to meet...
Date: 06/28/2011
Test SharePoint Mirror Without Down-Time
Here's a ??SQL Server PFE war-story to give one example of one of the kind of work we might do. Most...
Date: 05/19/2011
Changing Domains on a SQL Server
Someone recently asked me what issues might arise when changing a server's ___domain and the server is...
Date: 04/02/2011
Do You Need MSDTC?
STIG requirement DG0016 specifies that you should not install any service you do not need, and if...
Date: 03/09/2011
The Easiest Way To Rebuild The master Database
If your SQL Server master database becomes corrupt, such as from its disks losing power while SQL...
Date: 02/01/2011
How To STIG a Database System
This post is to provide a little enlightenment to folks who have never STIG'd a database system...
Date: 01/18/2011
Summary of Audit-Specific STIG ID's
The DoD Database Security Technical Implementation Guide (STIG) has quite a few requirements in the...
Date: 12/04/2010
File-Sizing
One of the primary areas of responsibility for DBA's is maintenance, and one of the primary...
Date: 11/06/2010
Failover Cluster Concepts
This post is primarily an online note for myself, which I'll make public in case someone else might...
Date: 10/18/2010
Primary DBA Responsibilities
SQL Server is so well-behaved it's often installed by 3rd party applications in an organization or...
Date: 10/01/2010
DG0155: Trusted file check
The DoD Database STIG includes DG0155 (CAT II): The DBA will ensure all applicable DBMS settings are...
Date: 09/16/2010
SharePoint/SQL Server Hierarchy
Where do SQL Server databases fit into the SharePoint architecture? Here's my non-expert...
Date: 09/14/2010
Defragmenting Indexes
Last update to script 1Nov2011. Maintaining indexes is a primary duty of Database Administrators,...
Date: 08/31/2010
Agent Schedules
The SQL Server Management Studio has a "Job Activity Monitor" which provides a lot of useful...
Date: 06/28/2010
List of SQL Server Service Names
In the tables below, services that can have multiple instances on the same server have the default...
Date: 05/31/2010
SQL Server Runaway Transaction Logs
When SQL Server is used without a qualified DBA, runaway transaction logs are by far the most common...
Date: 05/29/2010
Enabling Transparent Data Encryption (TDE)
Transparent Data Encryption (TDE) is a feature added in SQL Server 2008 which allows you to encrypt...
Date: 05/10/2010
The Myth of Unstructured Data
There's no such thing as "unstructured data." Yes, you hear that term all the time in the database...
Date: 03/26/2010
Public Not Granted Server Permissions
The pre-defined policies that come with SQL Server 2008 include one called "Public Not Granted...
Date: 03/19/2010
Import the Default PBM Policies
There are 50 Microsoft-defined policies and 71 conditions for Policy Based Management (PBM) that get...
Date: 03/19/2010
DG0116 and DG0121: DBA Privileges Via Roles
The generic DoD database STIG requirement DG0116 states that the Information Assurance Officer (IAO)...
Date: 02/16/2010
Remove Public and Guest Permissions
You can't get rid of the "public" role and by default in SQL Server 2005 and 2008 many objects have...
Date: 02/04/2010
Permissions for SQL Server Agent Proxy for SSIS Maintenance Plans
The DM6140 requirement in the SRR Checklist SQL Server v8R1 for the Database STIG can be a little...
Date: 01/27/2010
SharePoint User Connections
A long time ago I learned a SQL Server performance guideline: User Connections should be well under...
Date: 01/21/2010
Hyper-Cluster
Last year about this time I set up a completely virtualized cluster (only one physical computer)...
Date: 01/19/2010
SQL Server Index Key Performance Indicators
It's common for PFE's to get involved with performance tuning issues, and for SQL Server, indexes...
Date: 01/14/2010
Installing SQL Server 2008 Services in a High-Security Domain
If you need to install the SQL Server 2008 Database Engine (SS08) or the SQL Server Reporting...
Date: 12/17/2009