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.

SQL Server security webinar series is coming soon!

I've gotten in contact with most of the speakers who submitted SQL Server security talks for the PASS Summit. All that I've traded emails on DMs on Twitter are interested, it's just a matter of putting together some details. In addition, several folks who do talks on SQL Server… Read more

Security and SSIS webinar recording available

If you missed the webinar Andy Leonard (blog | twitter) and I presented today or you had technical difficulties, here's the recording:


SSIS and Security with Andy and Brian


It runs just about an hour and we ask questions that should be considered when building an… Read more

You Must Cross Teams for Sound Security

I've given a couple of security presentations recently where I talked about how you must keep track of how security is being managed. For instance:


  1. The best practice recommendation is that we use Windows authentication vs. SQL Server authentication.
  2. In an enterprise environment, we typically want to use Windows…

Read more

SSIS Security Presentation today, May 29th

Andy Leonard (blog | twitter) and I are teaming up to do a security presentation today on SSIS. It's scheduled for 11 AM EDT.


Register to attend the webinar!


I'm going to go ahead and post a copy of the slides here before the presentation. There's nothing earth-shattering… Read more

Giving an SSIS security webinar with Andy Leonard

Andy Leonard (blog | twitter) and I are teaming up to do a security presentation on SSIS. It's scheduled for Wednesday, May 29th, at 11 AM EDT.

Register to attend the webinar!


We're going to look at the typical ETL (Extract, Transform, Load) pipeline and consider the weak points… Read more

I'm thinking of hosting a series of webinars on SQL Server security

With the PASS Summit sessions announced, I took a quick look to see how many were what I'd consider security-centric. I know that's open to opinion, but basically, I searched on these three keywords:

  • security
  • secure
  • compliance

I then looked at what came up. Of the accepted sessions, I only… Read more

Do you check to see if an SSIS package has been modified?

Andy Leonard (blog | twitter) and I are putting together a presentation on protecting the entire ETL (Extract, Transform, Load) pipeline, specifically around SSIS. In our research on weak points along said pipeline, we've come up with an interesting question right off the bat:


Do you check whether… Read more

Speaking in Columbia and Charlotte Next Week

I'm speaking at two user groups next week.


Tuesday - Midlands PASS - May 14

I'll be giving a presentation on PowerShell to help folks get started and to further along those who are already on the path. This will be very similar to the presentation I gave at… Read more

I'm Giving a SQL Server Security Webinar on May 9, 2013

On May 9, 2013, at 3 PM EDT I will be presenting on 5 Steps Every DBA Should Take to Secure Their SQL Server. We'll look at five areas:


  • SQL Server configuration
  • Database security
  • Backup security
  • Auditing
  • Maintaining and deploying your security model


If you're interested, please register… Read more

2013 Carolina Code Camp Presentations

As promised, here are the presentations and sample code I used at the 2013 Carolina Code Camp. If you attended one of my sessions, thank you for choosing to spend your time sitting through my presentation. Hopefully I was able to share something you can use in your career.

  Read more

Speaking at the 2013 Carolina Code Camp

On Saturday, May 4, the Enterprise Developers Guild in Charlotte will hold their annual Carolina Code Camp. There's a number of great speakers across a wide range of topics, including some of us SQL Server folks like Melissa Coates, Rafael Salas, Javier Guillen, and Wayne Snyder. The location, Central… Read more

Troubleshooting SQL Server Error 15517

Last week I had the following error message repeating over and over again in the SQL Server log of one of my servers. It was repeating so much that the logs were growing very large, very fast:


An exception occurred while enqueueing a message in the target queue. Error: 15517,… Read more

T-SQL Tuesday #41: How I Got My Start in Presenting

For this month's T-SQL Tuesday, Bob challenges us to discuss how we came to love presenting. Here's my story.

I developed a love of presenting during my sophomore year at The Citadel, the Military College of South Carolina. I was a part of a group that existed pretty much… Read more

Don't Alienate Your Customer

This should go without saying, because most of us have been on the receiving end of poor customer support. However, it needs to be said because we constantly see (or commit) examples of poor customer service. For instance, there is this report from Kotaku:

Microsoft Creative Director 'Doesn't Get… Read more

Free SQL Server Training for the Week of April 1, 2013

Here are some training events you might be interested in for the coming week:


Tuesday, April 2


Thursday, April 4

Read more

Security: People Are the Weakest Link

There was an interesting conversation on Twitter today about security awareness and why the training so often fails. From my perspective, here's what I've seen:


  • Most people know the basic rules.
  • People will follow the basic rules until it interferes with something they want.


This is why security awareness generally fails.… Read more

What to Do When You Can't Wipe an Infected System

When it comes to workstations within most organizations, the solution when one gets infected is to wipe it and re-image it. However, when we're talking about servers, sometimes that's not a viable business option. I've been in that position. In those cases you do your best to remove any traces… Read more

Get Data Warehouse Training and Help a Neat School

If you're located relatively near the Atlanta, Georgia area, I wanted to bring your attention to data warehousing training on March 14th that will benefit a private, not-for-profit elementary school. Audrey Hammonds and Julie Smith of DataChix.com are offering a full day of data warehouse training at a low price:… Read more

0 comments, 1,033 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 18 February 2013

Upcoming Online Training for the Week of February 18, 2013

I used to compile a list of online training for the following week and posting it on Fridays. I stopped for whatever reason, but I've decided to start back. I'm moving it to Thursday, though, because some of the webcasts require registration. Here are the webinars I've found for next… Read more

Newer posts

Older posts