K. Brian Kelley - Databases, Infrastructure, and Security
Archives: May 2013
SQL Saturday Charleston!
Finally.... SQL Saturday has come back to... South Carolina! (with apologies to The Rock)
After the last SQL Saturday in Columbia, Bobby Dimmick (blog | twitter) and I decided to step back and see if somewhere else near us wanted to host a SQL Saturday. Charleston,… Read more
0 comments, 1,883 reads
Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 30 May 2013
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
0 comments, 2,513 reads
Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 30 May 2013
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
0 comments, 932 reads
Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 29 May 2013
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:
- The best practice recommendation is that we use Windows authentication vs. SQL Server authentication.
- In an enterprise environment, we typically want to use Windows…
0 comments, 1,052 reads
Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 29 May 2013
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
0 comments, 822 reads
Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 29 May 2013
DR planning article up at MSSQLTips!
My latest article is up at MSSQLTips.com:
Disaster Recovery Planning for Microsoft SQL Server - Getting Backups and Restores Right
For more of my articles:
0 comments, 826 reads
Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 23 May 2013
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
0 comments, 1,019 reads
Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 23 May 2013
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
3 comments, 2,743 reads
Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 22 May 2013
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
0 comments, 2,277 reads
Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 22 May 2013
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
0 comments, 1,018 reads
Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 10 May 2013
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
0 comments, 1,184 reads
Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 7 May 2013
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.
2 comments, 989 reads
Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 6 May 2013