Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Regular Columnist: Brian Kelley

SQLServerCentral.com profile

Brian Kelley is an author, columnist, and Microsoft SQL Server MVP focusing primarily on SQL Server security. He is a contributing author for How to Cheat at Securing SQL Server 2005 (Syngress), Professional SQL Server 2008 Administration (Wrox), and Introduction to SQL Server (Texas Publishing). Brian currently serves as an infrastructure and security architect. He has also served as a senior Microsoft SQL Server DBA, database architect, developer, and incident response team lead.

<< Newer    Items 21 to 40 of 43    Older >>
 

SQL Server Security: Fixed Database Roles

Brian is back with a new security article, this time working through the details of the fixed database roles. There are some important concepts here. In particular if you're not totally clear on the difference between dbo and db_owner, read this article.   Read more...
By Brian Kelley 2007/01/19 (first published: 2003/12/12) | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 60,475 reads

SQL Server Security: Server Roles

As yo probably know, Brian covers security topics for us and does a great job. This week he looks at the fixed roles and points out a few things you may not have thought about.   Read more...
By Brian Kelley 2007/05/04 (first published: 2003/10/29) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 54,114 reads

SQL Server Security: Pros and Cons of Application Roles

Application roles often interesting possibilities in theory. In practice? Brian explores how they work and some of the pros/cons you should consider before selecting them for use in your applications.   Read more...
By Brian Kelley 2008/07/25 (first published: 2003/08/27) | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 39,593 reads

SQL Server Security: Login Weaknesses

Brian writes regularly for us on sql security issues, this week he discusses the pros and cons of various authentication methods.   Read more...
By Brian Kelley 2003/08/14 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 17,375 reads

SQL Server Security: Why Security Is Important

Regular columnist Brian Kelley reviews the real world impact that inadequate security can have by reviewing some recent incidents in the sql/security world. Very much worth reading, especially if you have credit card data.   Read more...
By Brian Kelley 2003/07/31 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 7,057 reads

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.   Read more...
By Brian Kelley 2003/06/27 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 20,573 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.   Read more...
By Brian Kelley 2003/05/16 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 25,120 reads

Getting Certified

Brian spends a lot of time in our forums helping out. Based on a recent question from a reader he put together some tips he used when he was preparing for the MCSE exams. Interesting reading!   Read more...
By Brian Kelley 2003/04/30 | Source: SQLServerCentral.com | Category: certifications
Rating: |  Discuss |   Briefcase | 9,807 reads

SQL Server 2000 SP 3: What's New in Security

Service Pack 3 for SQL Server 2000 is huge. There are significant changes in it and they apply to all three products: the core SQL Server, MSDE, and Analysis Services. Because there are so many changes, this first article in the series will only focus on the security changes.   Read more...
By Brian Kelley 2005/12/09 (first published: 2003/06/05) | Source: SQLServerCentral.com | Category: service packs
Rating: |  Discuss |   Briefcase | 29,971 reads

Implementing Encrypting File System (EFS) with SQL Server

EFS provides a mechanism for encrypting files completely transparent to higher level applications such as SQL Server. In this article by Brian Kelley, he shows you how to implement this type of security in your environment.   Read more...
By Brian Kelley 2006/12/01 (first published: 2002/12/09) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 29,125 reads

Connecting With Perl Using Win32 : ODBC

Perl has been a popular language for Unix administrators for years. It is flexible, easy to learn, and capable of doing some very powerful things with relatively few lines of code. In this article by Brian Kelly, he shows you how to connect to SQL Server via Perl.   Read more...
By Brian Kelley 2006/07/28 (first published: 2002/12/03) | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 39,569 reads

Sneak Preview: Start to Finish Guide to SQL Server Performance Monitor

Get a sneak peak of some of the sections from Start to Finish Guide to SQL Server Performance Monitor. Find out what counters to watch and what their thresholds are.   Read more...
By Brian Kelley 2002/08/06 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 21,223 reads

Getting the Most Out of SQL Server 2000's Query Analyzer, Part III

In this article, Brian Kelley continues his series on Query Analyzer for SQL Server 2000. Query Analyzer offers a highly configurable integrated development environment (IDE). Some of the areas Brian looks at are how to modify the fonts and colors, set connection settings, choose scripting options, and customizing file and result set options. Learn how to make the most of the IDE and make it work for you.   Read more...
By Brian Kelley 2005/01/07 (first published: 2002/08/01) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 38,690 reads

Citrix MetaFrame, SQL Server, and the DBA

In this article, Brian looks at how Citrix MetaFrame can use SQL Server for its internal data repository. The basic operation of SQL Server in a Citrix MetaFrame installation is covered. In addition, Brian looks at how a DBA is an integral part of the support team for a successful Citrix MetaFrame farm.   Read more...
By Brian Kelley 2007/03/02 (first published: 2002/05/13) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 26,393 reads

Getting the Most Out of SQL Server 2000's Query Analyzer, Part II

Brian Kelley continues his series on getting the most out of SQL Server 2000's Query Analyzer. In this article he looks at the Object Browser and the Transact-SQL Debugger, new features in the 2000 Edition which can reduce development and troubleshooting time for DBAs and database developers.   Read more...
By Brian Kelley 2004/12/31 (first published: 2002/03/05) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 39,625 reads

Getting the Most out of SQL Server 2000's Query Analyzer, Part I

So you open up the tool a hundred times a day. In this article by Brian Kelley, he shows you how to get the most out of some of the known and unknown features.   Read more...
By Brian Kelley 2004/12/23 (first published: 2002/02/21) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 38,609 reads

Stored Procedures and Caching

One of the biggest performance gains built into SQL Server is the stored procedure. In this article by Brian Kelley, he shows you how to fully utilize, debug and monitor the caching of such objects.   Read more...
By Brian Kelley 2004/11/19 (first published: 2002/01/28) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 40,735 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.   Read more...
By Brian Kelley 2003/01/13 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 17,134 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.   Read more...
By Brian Kelley 2002/01/09 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 17,135 reads

Services for SQL Server 2000

In this article, Brian Kelley focuses on learning the various services in SQL Server. He also covers the security needed to make them work.   Read more...
By Brian Kelley 2006/05/12 (first published: 2002/01/03) | Source: SQLServerCentral.com | Category: installation
Rating: |  Discuss |   Briefcase | 49,937 reads
<< Newer    Items 21 to 40 of 43    Older >>