Browse by Tags

The Impact of Architecture/Design Choices

I try my best to get things right the first time. So often, correcting a mistake or bad choice is costly: more costly than it would have been to take the time to do it right the first time. However, as SQL Server MVP Andy Leonard points out, sometimes you can't correct an issue . He starts with the example...

Posted to K. Brian Kelley - Databases, Infrastructure, and Security (Weblog) by bkelley on 11-05-2007
My Book is Out!

How to Cheat at Securing SQL Server 2005 I recently had the opportunity to contribute a couple of chapters to this new SQL Server security book from Syngress. The concept of the book is to provide a fundamental understanding for harried IT workers on how to use SQL Server 2005's security features to...

Posted to K. Brian Kelley - Databases, Infrastructure, and Security (Weblog) by bkelley on 10-04-2007
DDL Triggers and CREATE_LOGIN/ALTER_LOGIN

I've been doing a lot with DDL triggers in the last week or so and pulling out the relevant information from the EVENTDATA() function. One of the things I noticed was that with CREATE_LOGIN and ALTER_LOGIN events, you cannot get back the T-SQL information. This makes sense because these two DDL statements...

Posted to K. Brian Kelley - Databases, Infrastructure, and Security (Weblog) by bkelley on 07-09-2007
Latest Service Packs and Books Online

I was reading a new post at SQL Server Magazine titled The More Things Change (full version available to registered users of sqlmag.com) by SQL Server MVP Brian Moran . It revealed an experience he recently had at Tech·Ed , where some folks who work with SQL Server weren't aware of the latest service...

Posted to K. Brian Kelley - Databases, Infrastructure, and Security (Weblog) by bkelley on 07-06-2007
Midlands PASS Chapter Meeting for June 6, 2007

Our next meeting will be on Thursday, June 7th, at 6:30 PM. Training Concepts will once again be our gracious host. I'll be speaking on the following: Title: Making the SQL Server Security Model Work for You SQL Server has a very robust security model with ownership chaining, cross-database ownership...

Posted to K. Brian Kelley - Databases, Infrastructure, and Security (Weblog) by bkelley on 05-29-2007
Microsoft CRM Security Internals

On the Microsoft Dynamics CRM Team Blog , Jay Grewal has posted information about the CRM Security Model Internals . CRM is an interesting application for DBAs because it does use row-level security. It's a bit more complex than most row-level security models in that there are access checks and privilege...

Posted to K. Brian Kelley - Databases, Infrastructure, and Security (Weblog) by bkelley on 04-09-2007
SQL Server 2005 Security Best Practices Whitepaper Released

Saw this first here: SQL Server 2005 Security Best Practices . It's on the blog for Microsoft UK's SQL Server Premier Field Engineers . There's also some security-related webcast information on that blog post, so check it out! Microsoft has released a whitepaper on best practices for SQL Server 2005...

Posted to K. Brian Kelley - Databases, Infrastructure, and Security (Weblog) by bkelley on 03-19-2007
Windows Mobile Security

I'm working on a new article for SQL Server Central talking about physical security and SQL Server and I was going to include coverage outside of the data center, especially with products like Microsoft CRM 3.0 putting potentially sensitive data on a laptop. There are significant legitimate business...

Posted to K. Brian Kelley - Databases, Infrastructure, and Security (Weblog) by bkelley on 03-17-2007
Adding value to our organizations

Sean McCown writes in the latest Database Underground about how DBAs should try and make things better for users of an organization . I think Sean hits upon an important point not just for DBAs but for all IT workers. Too often IT is seen as a cost center, an impediment, as something as necessary for...

Posted to K. Brian Kelley - Databases, Infrastructure, and Security (Weblog) by bkelley on 01-09-2007
Shared Items on Google Reader

I read through a lot of blogs each day in a variety of technology categories. I've always fashioned myself as a jack-of-all-trades and that helps me a great deal with my current position. However, it does mean consuming a lot of feeds to try and stay up in all the areas I have a profound interest in...

Posted to K. Brian Kelley - Databases, Infrastructure, and Security (Weblog) by bkelley on 01-06-2007

Page 1 of 2 (14 items) 1 2 Next >