SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

K. Brian Kelley - Databases, Infrastructure, and Security

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

Archives: July 2007

Midlands PASS Chapter - August 2, 2007

"Database Professional Toolkit" with Brian and Jeremy
Midlands PASS Chapter - August 2, 2007 Meeting
Sponsored by Red Gate Software

The Midlands PASS Chapter is pleased to announce our first member-led "Database Professional Toolkit" which features our own members demonstrating tools they use with SQL Server. These presentations aren't sales…

Read more

ApexSQL's Industry Experts program

If you're a Microsoft MVP, ApexSQL has brought back their industry experts program. You can find out more about it here: ApexSQL Industry Experts Program. In the past they've extended it to "SQL Server VIPs" which is how I was able to take advantage of it. But basically…

Read more

A Graphical View of the Physical Allocation of a Database

First saw information about a tool called SQL Internals Viewer in a blog post here at Kalen Delaney's blog. The tool gives a graphical representation of how the data is physically allocated. It's currently in beta but has some nice functionality.

Here are the requirements:
  • Windows 2000 or higher

Read more

New version of SQL Server 2005 Best Practices Analyzer available

If you haven't seen the announcement, a new version of the SQL Server 2005 Best Practices Analyzer is available for download (dated July 2, 2007). The BPA will run on Windows XP, 2003, and Vista. It requires the Microsoft .NET Framework 2.0 as well as the SQL Server 2005 client…

Read more

The meaning of Database Administrator

In two blogs I follow, Andy Leonard's blog on SQLBlogs.com and Sheeri Kritzer's The MySQL She-BA, the question of what is a database administrator has come back up. Andy has posted twice on the topic, first with how DBAs are an enterprise requirement and then a follow-up to that…

Read more

New MySQL Entry Level Certification

Last week I received an email indicating that MySQL had made available an entry level certification, the Certified MySQL Associate. The idea is to provide a certification which shows a person has some basic knowledge of MySQL, but not at the level of a developer or DBA. That's…

Read more

Reminder: Midlands PASS Chapter Meeting Tomorrow Night

What: Midlands PASS Chapter July Meeting
Where: Training Concepts (250 Berryhill Road, Suite 502, Columbia, SC)
When: 6:15-8:00 PM

Speaker: SQL Server MVP Wayne Snyder
Topic: SQL Server Integration Services

Website: http://www.truthsolutions.com/midlandspass/

Technorati Tags: SQL Server | Microsoft SQL Server | SQL Server 2005 | SSIS | Wayne Snyder |… Read more


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…

Read more

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…

Read more

Midlands PASS Chapter July Meeting with SQL Server MVP Wayne Snyder

SQL Server MVP Wayne Snyder Speaks on SQL Server Integration Services (SSIS)

Midlands PASS Chapter - July 12, 2007 Meeting
Sponsored by AgFirst Farm Credit Bank

The Midlands PASS Chapter is pleased to announce SQL Server MVP Wayne Snyder as our speaker for our July meeting. Mr. Snyder will speak… Read more