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
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
June Midlands PASS Meeting Canceled

We are canceling the June Midlands PASS meeting because the speaker (me) is still under the weather. I'll post in a later message about the July meeting. Technorati Tags: SQL Server | Microsoft SQL Server | SQL Server 2000 | SQL Server 2005 | Professional Association of SQL Server | SQLPASS

Posted to K. Brian Kelley - Databases, Infrastructure, and Security (Weblog) by bkelley on 06-07-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
Midlands PASS Chapter Meeting Tonight

Our next meeting will be on Thursday, May 3rd , at 6:30 PM. Training Concepts will once again be our gracious host. Our speaker will be Sean McLean of DBA24Hrs ( http://www.dba24hrs.net/ ) . His presentation is: DBLaunch/SQLNitro - Deployment/Management/Compression tools designed with you in mind DBA24Hrs...

Posted to K. Brian Kelley - Databases, Infrastructure, and Security (Weblog) by bkelley on 05-03-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
Daylight Saving Time and SQL Server

If you're in the United States, chances are you've already heard about Daylight Saving Time (DST) occurring 3 weeks early this year. This is due to the Energy Policy Act of 2005 , so it's not new news, but a lot of systems and applications are only now getting the updates. The Energy Policy Act of 2005...

Posted to K. Brian Kelley - Databases, Infrastructure, and Security (Weblog) by bkelley on 02-13-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 (16 items) 1 2 Next >