Brian Kelley

SQL Server Security: Security Admins

As we mentioned before, Brian will be writing a column covering all facets of security. Turns out that there is so much to cover, he has agreed to write two columns per month! This article talks about the principle least privilege, why it doesn't always work, and some good info about removing the Builtin\Admin account.

5 (3)

2003-06-27

20,606 reads

SQL Server Security: The db_executor Role

Brian will be writing a monthly column for us on SQL Security, definitely a hot topic these days! He starts off by discussing the need for a built in db_executor role and how to grant permissions manually to achieve the same effect. Terrific concept, as granting table access can lead to bad things! If there is a security topic you'd like to see more info on, post a note to the article or email us at articles@sqlservercentral.com.

4.71 (7)

2003-05-16

27,259 reads

A Normalization Primer

For most DBAs, normalization is an understood concept, a bread and butter bit of knowledge. However, it is not at all unusual to review a database design by a development group for an OLTP (OnLine Transaction Processing) environment and find that the schema chosen is anything but properly normalized. This article by Brian Kelley will give you the core knowledge to data model.

5 (3)

2003-01-13

17,377 reads

Information Schema Views

SQL Server DBAs are often curious about the inner-workings of SQL Server. Indeed, it can save your job during disasters to know what's going on inside SQL Server. This article shows you how to use some of the SQL Server internal views to view some meta data about your servers.

5 (1)

2002-01-09

17,198 reads

Report Locking on Specific Database

This Script reports locking on a particular database either to the console or to a database table. It also allows filtering based on a minimum locking level (say Page or Table and higher). Included is the CREATE TABLE statement to build the reporting table. This table can reside in any database but needs to be […]

2002-01-06

943 reads

Design Oversight - Preliminary Review

We all know what the ideal application design environment is for building a database back-end: an experienced DBA takes inputs from end users and developers and creates the database design in order to support the application being developed. But in reality, we don't get the opportunity to do application design like this very often. This article covers how to quickly find and fix problems in a design.

2001-08-20

8,189 reads

Blogs

Idera GeekSync: SQL Security Principals and Permissions 101

By

Thanks to Idera and all 239 of you who joined the Idera GeekSync webinar...

Arrays in PowerShell–#SQLNewBlogger

By

Another post for me that is simple and hopefully serves as an example for...

Passwords = A Good Thing

By

Those my friends are, in my opinion, one of the single most wonderful things...

Read the latest Blogs

Forums

Fixing MLS Python Services to Load the Runtime

By Emmitt Albright

Comments posted to this topic are about the item Fixing MLS Python Services to...

The Real REAL

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Real REAL

Looking for simple non-aggregate version of PIVOT to transpose Rows into Columns

By YSLGuru

I know I've found the answer to this before but I'm having trouble now...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

The Real REAL

See possible answers