This is about a long term goal that I’ve had which isn’t posted on here, and that’s to eventually be a technical trainer in some capacity. The fact of the matter is I love to teach. I learned that when as a…
K. Brian Kelley - Databases, Infrastructure, and Security
Archives: September 2009
The old INNER JOIN syntax vs. the new INNER JOIN syntax
I was in a presentation last week where the presenter was talking about the ANSI/ISO SQL standards. For the most part the information was correct, but one of the things that was left ambiguous was whether or not the old INNER JOIN syntax was valid (and thus, the audience would be left to assume… Read more
70 comments, 38,973 reads
Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 30 September 2009
Midlands PASS Chapter October Meeting
Next Meeting - October 6, 2009
Speaker - SQL Server MVP Brian Kelley
Trigger Happy Database Security
In this presentation we'll look at the use of triggers for added database security. We'll start with the typical DML triggers used to audit changes to data and best and worst practices with… Read more
0 comments, 1,797 reads
Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 29 September 2009
One Step Closer to Being a Technical Trainer
2 comments, 899 reads
Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 27 September 2009
Trust Is Crucial in Security
Yesterday we were greeted to a ComputerWorld column talking about how Apple had betrayed the Enterprise's trust by having a device report that it supported on-device encryption when it really did not. And while this allowed the older versions of the iPhone interact with Exchange 2007 systems with policies requiring… Read more
1 comments, 703 reads
Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 16 September 2009
First Meeting of the Charleston PASS Chapter
The first meeting of the Charleston PASS Chapter will take place Thursday night, September 17, starting at 6 PM. The first topic will be an intro to SSIS for 2005/2008. You can find more information and register on the web site:
0 comments, 719 reads
Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 15 September 2009
PASS Chapter Starting Up in Charleston, SC
Woo hoo! Charleston, SC is starting up a Professional Association for SQL Server official chapter. It is being started up by Boyd Evert. The site will be here:
Right now the sample site is still up as it just got turned on, but I expect… Read more
2 comments, 1,072 reads
Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 14 September 2009
Remember the Milk: Smart Adds
A while ago, Brent Ozar pointed me to Remember the Milk to help with task tracking. It's a web-based task tracking system. Some of the nice things about it is it lets you categorize tasks, it lets you set tags, it lets you prioritize tasks, and it lets you set due… Read more
4 comments, 964 reads
Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 8 September 2009