K. Brian Kelley - Databases, Infrastructure, and Security

IT Security, MySQL, Perl, SQL Server, and Windows technologies.

Syndication

News

Links

Browse by Tags

All Tags » SQL Server 2005 (RSS)
Avoid Domain Admin level accounts for SQL Server
Every so often I see a post in the forums where someone has stated they've used a Domain Admin level account to run the SQL Server service. The implications are that anyone who is a member of the sysadmin fixed server role is effectively a domain...

Posted 12 June 2008 19:30 by bkelley | with no comments

Security Issue with SQL Server Reporting Services 2008
I have a CTP of SSRS 2008 deployed to one of my servers. Today I built a couple of reports and from one of my systems, they all tested fine. However, this system, because it is a testing server, doesn't receive the Group Policy Object (GPO) controlling...

Posted 30 May 2008 14:57 by bkelley | with no comments

Pictures from Midlands PASS Chapter Meeting
Last night the Midlands PASS Chapter had the pleasure of hosting SQL Server MVP Brian Knight . I was able to capture a few pictures from last night though they aren't the best quality. Our next meeting is scheduled for July 10 and we are hosting John...

Posted 28 May 2008 08:33 by bkelley | with no comments

Reminder: Midlands PASS Chapter Meeting with Brian Knight
Tuesday, May 27, 2008 Speaker: SQL Server MVP Brian Knight The Midlands PASS chapter will hold a special meeting on Tuesday, May 27, 2008, to host SQL Server MVP Brian Knight . Brian will be giving a presentation on Data Mining using SQL Server. The meeting...

Posted 23 May 2008 08:51 by bkelley | with no comments

Review of How to Cheat at Securing SQL Server 2005
SQL Server MVP Frank Kalis has posted a short review on How to Cheat at Securing SQL Server 2005 , a book I was able to contribute two chapters to last year. The chapters I focused on were related to Authentication and DDL Triggers . It was a great experience...

Posted 20 May 2008 15:45 by bkelley | with no comments

Setting Static Ports when dealing with Named Instances and Kerberos
I ran across this a week or so ago. There were a couple of SQL Servers running named instances that we wanted to setup Kerberos authentication against (in the event we would use Kerberos delegation). Here is how the ports were set according to SQL Server...

Posted 17 May 2008 11:58 by bkelley | with no comments

Midlands PASS May Meeting - Speaker Brian Knight
Tuesday, May 27, 2008 Speaker: SQL Server MVP Brian Knight The Midlands PASS chapter will hold a special meeting on Tuesday, May 27, 2008, to host SQL Server MVP Brian Knight . Brian will be giving a presentation on Data Mining using SQL Server. The meeting...

Posted 15 May 2008 15:55 by bkelley | with no comments

Thoughts on SQL Saturday in Jacksonville
I was able this Saturday to head down to Jacksonville and speak at the SQL Saturday there. There were a lot of folks, a lot of good presentations, and the area in and around Jacksonville was gorgeous. I gave two presentations, both of them security related...

Posted 07 May 2008 11:38 by bkelley | 1 comment(s)

Jacksonville SQLSaturday less than a month away!
The SQLSaturday in Jacksonville, Florida, will be held May 3, 2008. I'm on track now to give two security based presentations: Protecting Your SQL Server From Treasure Seekers : This presentation is geared for system administrators, DBAs, and developers...

Posted 05 April 2008 03:42 by bkelley | with no comments

Configuring SPN for SQL Server Browser service
Going through the Microsoft KnowledgeBase updates, I saw this one: An SPN for the SQL Server Browser service is required when you establish a connection to a named instance of SQL Server 2005 Analysis Services or of SQL Server 2005 The situation occurs...

Posted 04 April 2008 15:05 by bkelley | with no comments

Errata for SQL Server Certification Books
Back in this blog post , I indicated which books I was using to complete the MCITP certifications for SQL Server. Of course, there are always mistakes found after a book goes to press. I've gone ahead and tracked down the errata pages for them (some...

Posted 19 February 2008 21:46 by bkelley | with no comments

Kalen Delaney SQL Server Internals DVD
I did end up pre-ordering the first DVD on SQL Server internals by SQL Server MVP and SQL Server internals expert, Kalen Delaney . If you haven't pre-ordered the DVD yet, there's only a few days left to do so at the pre-order price: Pre-Order...

Posted 12 February 2008 01:39 by bkelley | 2 comment(s)

Preparing for SQL Server 2005 Certification
I never did complete my MCDBA . As I was preparing to, I transitioned to my systems architect role, meaning I had to deal a lot more with security, server configurations, and Active Directory. So my focus shifted, just as I was preparing to go after that...

Posted 05 February 2008 12:52 by bkelley | with no comments

Ask for SQL Server 2005 SP3
In case you haven't seen this elsewhere, if you want Microsoft to release SP3 for SQL Server 2005. It's time to start rattling the cages, as they don't feel there has been enough customer demand to warrant a service pack release. Huh? That's...

Posted 03 February 2008 22:32 by bkelley | 4 comment(s)

The Importance of Verifying Database Backups Regularly
Yesterday, as I was pulling into my driveway, my front left tire gave. Thankfully, I was going really slow and I was right at my house. I did the requisite email to my boss that I was going to be in late and the check to see what time the tire place was...

Posted 31 January 2008 17:28 by bkelley | with no comments

More Posts Next page »