K. Brian Kelley - Databases, Infrastructure, and Security

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

Syndication

News

Links

Browse by Tags

All Tags » Microsoft SQL Server (RSS)
August Charlotte SQL Server User Group Meeting Announcement
The Charlotte SQL Server User Group meeting will be held online on August 20th at 12 Noon (EDT). They'll have as the speaker SQL Server MVP Brad McGehee . From the front page: Don't miss our August 20th online meeting with renowned SQL Server...

Posted 15 August 2008 19:56 by bkelley | with no comments

SQL Server 2008 RTM - Community Thoughts & Resources
As has widely been announced in the SQL Server community, SQL Server 2008 has RTM'ed. It's now available for download from MSDN and TechNet. Here are some readings from around the community: Buck Woody : On-Demand webcast for installation and...

Posted 07 August 2008 15:29 by bkelley | with no comments

Panel Interview Part III Posted
As a follow-up to yesterday's post , Part III of the SQL Server panel interview has been posted on-line. A name I left off the original post who was on the panel (which I'll go back and edit): Brent Ozar A couple of community comments: StatisticsIO...

Posted 30 July 2008 10:57 by bkelley | with no comments

SQL Server Panel Interview
I was asked by Odin Jobs to participate in an email interview on SQL Server. Joining me on the panel were: Cristian Lefter Andrew Fryer Namwar Rizvi Brent Ozar Denny Cherry Chris Shaw Pinal Dave Odin Jobs has done this before with PHP . The first couple...

Posted 29 July 2008 16:20 by bkelley | 1 comment(s)

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

SQL Saturday in Orlando
The dates for Microsoft's TechEd 2008 are fast approaching here in North America. Sandwiched between the two weeks of this year's TechEd is the SQL Saturday Tweener , which will also be held at the Orange County Convention Center. Unfortunately...

Posted 23 May 2008 08:40 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

Technical Podcasts I Listen To
There are a few podcasts I tend to listen to as I have time. Since I work with a wide range of technologies, I've tried to group them together into a semblance of order. There are a few others I am evaluating, but since I haven't listened to a...

Posted 19 May 2008 11:20 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

SQL Compare 7 Beta
Red Gate's schema comparison tool, SQL Compare , is in beta for the newest version, SQL Compare 7. You can find details and a link to download here: Red Gate Forums: SQL Compare 7 Beta This version does include support for SQL Server 2008 (through...

Posted 07 April 2008 09:34 by bkelley | with no comments

SQL Server Forensics Book
I logged into Safari today to download some chapters I want to be able to review when I'm offline. I saw in the new titles there's a forthcoming book called SQL Server Forensics Analysis and it's by one of my co-authors from How to Cheat at...

Posted 05 April 2008 10:41 by bkelley | with no comments

More Posts Next page »