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

Databases – Infrastructure – Security

Brian Kelley is an author, columnist, and Microsoft SQL Server MVP focusing primarily on SQL Server security. He is a contributing author for How to Cheat at Securing SQL Server 2005 (Syngress), Professional SQL Server 2008 Administration (Wrox), and Introduction to SQL Server (Texas Publishing). Brian currently serves as an infrastructure and security architect. He has also served as a senior Microsoft SQL Server DBA, database architect, developer, and incident response team lead.

Rescheduled Performance Troubleshooting Webinar

With Hurricane Florence no longer a hurricane, we have rescheduled the webinar for next Wednesday, September 26, 2018.

Free sign up for the webinar!

Here is what I’ll be covering:

How do go about finding poorly performing SQL Server queries in your environment? And once you find them, what can… Read more

0 comments, 130 reads

Posted in Databases – Infrastructure – Security on 19 September 2018

Midlands PASS Reboot!

If you’re in or near the Columbia, SC area, we are rebooting the Midlands PASS Chapter. Here is our first meeting information.

Oct 2, 2018

5:30 PM – Meet & Greet
6-8 PM – Technical Presentation by K. Brian Kelley

Location:

WeKnowIT
440 Knox Abbott Drive Suite 425
Columbia/Cayce, SC… Read more

0 comments, 513 reads

Posted in Databases – Infrastructure – Security on 19 September 2018

Thursday Webinar Postponed due to Hurricane Florence

Hello! The webinar I was going to give this coming Thursday with MSSQLTips.com has been postponed. When we have a new date, I will post on here. Unfortunately, it’s hurricane season here in the United States and we have a monster one bearing down on the East Coast. If you’re… Read more

0 comments, 146 reads

Posted in Databases – Infrastructure – Security on 11 September 2018

Talking Data: Six Word Stories

In six words, can you give a compelling description of your data?

I’m taking the Microsoft DAT248x course as part of the Data Science curriculum. This is one of the new courses added, and it’s about telling a story with the data. The point being made is we often only… Read more

0 comments, 160 reads

Posted in Databases – Infrastructure – Security on 30 August 2018

Upcoming Performance Tuning Webcast

On September 13, 2018, at 3 PM Eastern (USA), I’ll be giving a webcast for MSSQLTips.com on finding and correcting poorly performing queries.

Sign up link: SQL Server Performance Troubleshooting and Query Tuning

This is a 100-level webcast, but we’ll be looking at what we have within SQL Server to… Read more

0 comments, 131 reads

Posted in Databases – Infrastructure – Security on 28 August 2018

Midlands PASS Restart – October 2, 2018

The Midlands PASS Chapter, a local group of PASS, will restart on October 2nd, 2018. We will be meeting at our former meeting place, WeKnowIT, in West Columbia/Cayce, South Carolina. From here on we’ll be meeting on the first Tuesday of each month where possible.

Look for more… Read more

0 comments, 118 reads

Posted in Databases – Infrastructure – Security on 20 August 2018

ISACA Class: Auditing SQL Server in Every Way Possible

At this year’s TechnoSecurity and Digital Forensics Conference I gave a 1 hour presentation on auditing SQL Server. There were a lot of things I covered only in the conceptual, such as building a framework using Extended Events. The SC Midlands Chapter of ISACA is giving me the opportunity to… Read more

0 comments, 162 reads

Posted in Databases – Infrastructure – Security on 9 August 2018

New at Simple-Talk: Principles of Data Protection

My latest article, Principles of Data Protection, has been published at Simple-Talk! I address the basic problem and how we have to realize that technology alone can’t solve the issue (and why). I then delve into what we can do from a SQL Server perspective.

Read more

0 comments, 280 reads

Posted in Databases – Infrastructure – Security on 2 July 2018

I’m published at Simple-Talk!

My first article has gone live at Simple-Talk! Thanks to Aunt Kathi for the opportunity!

Detecting Data Breaches

I’m also still writing at MSSQLTips. I’m currently writing a series covering DMOs. The latest is on sys.dm_exec_sessions.

Read more

0 comments, 249 reads

Posted in Databases – Infrastructure – Security on 12 June 2018

New Article: Return SQL Server Connections Information Using sys.dm_exec_connections

I’ve started a new series at MSSQLTips.com walking through the various Dynamic Management Objects we have available to us in SQL Server. A couple of encounters with some folks in recent months showed a need as more than one person responsible for managing SQL Servers didn’t know about these helpful… Read more

0 comments, 252 reads

Posted in Databases – Infrastructure – Security on 18 May 2018

Speaking at Idera’s Live Virtual Conference

Have you heard about Idera’s Live Virtual Conference? It is being held on May 16, from 9 AM to 3 PM Central Time. The conference is completely free to attend.

I’m speaking on SQL Server security basics. Where do you start? What should you definitely do? Where do you go… Read more

0 comments, 189 reads

Posted in Databases – Infrastructure – Security on 1 May 2018

Webinar: Auditing with Extended Events

I’m giving a webinar today, April 5th, at 3 PM Eastern, on using Extended Events to audit your SQL Servers. I’ll be covering the basics of why you should migrate from Profiler to Extended Events, what Extended Events are and how they are structured, as well as some initial use… Read more

0 comments, 248 reads

Posted in Databases – Infrastructure – Security on 5 April 2018

Webinar: Identify and Eliminate SQL Server Performance Issues

I’m giving a webinar tomorrow, March 22, 2018, at 3 PM Eastern.

Free Registration Link

Here’s what I’ll be covering:

Are you struggling with pesky SQL Server performance issues that are impacting your business? Are you not sure where to turn next to focus your efforts to resolve the issue? Read more

0 comments, 273 reads

Posted in Databases – Infrastructure – Security on 21 March 2018

Speaking at the 2018 Techno Security and Digital Forensics Conference

One of my favorite conferences is held in Myrtle Beach, SC, in June. It’s a security and digital forensics conference which I try to make each year.

This year I’ve been selected as a speaker. Here is the talk I’m currently scheduled to give:


Auditing SQL Server in Every Way… Read more

0 comments, 237 reads

Posted in Databases – Infrastructure – Security on 1 March 2018

Settings Goals Professionally

I was reminded of this topic after yesterday’s #SQLChat. Have you set professional goals for yourself? If so, have you set them professionally? What do I mean?

There’s a difference between a wish and a goal. A wish is something we want to happen but we don’t make any effort… Read more

0 comments, 1,958 reads

Posted in Databases – Infrastructure – Security on 8 February 2018

Tinker as You Learn

In recent weeks I’ve seen my brother from another mother, Andy Leonard (twitter | blog), write or post about his learning activities. In one case he remarked that he liked it when he went to complete a learning lab exercise and it didn’t work as expected the first… Read more

0 comments, 1,856 reads

Posted in Databases – Infrastructure – Security on 24 January 2018

WIT: A Quick Thought

I recently had the opportunity to be a Dungeon Master (DM) at a gaming convention. It was my first time. I loved it. So what does that have to do with Women in Technology (WIT)?


The young lady standing up also DMed her first convention. She’s my daughter and she’s… Read more

3 comments, 1,485 reads

Posted in Databases – Infrastructure – Security on 22 January 2018

DevOps Does Not Make Admins Obsolete

As a follow up to my tweet, I stand by my belief that DevOps does not make administrators obsolete. I include Database Administrators in my statement. The core point of embracing DevOps is to determine what is repeatable and see if you can automate it. Why?

  • You’re trying to move…

Read more

0 comments, 981 reads

Posted in Databases – Infrastructure – Security on 3 January 2018

BK’s Professional Learning Plans for 2018 #tsql2sday

With 2018 coming, I’ve thought about the question, “What do I want to be when I grow up?” I ask this question every few years because it helps me develop a plan of attack with respect to learning and opportunities to pursue. As a result, this T-SQL Tuesday topic comes… Read more

1 comments, 1,336 reads

Posted in Databases – Infrastructure – Security on 12 December 2017

Learning to Give Presentations Well (Part 3)

See Part 1 and Part 2.

Perfect Practice Makes Perfect

I can remember my Air Force ROTC class on communications skills where we had to put together a “talking paper” and give a presentation to the class. We were advised to practice with our peers before the… Read more

0 comments, 1,356 reads

Posted in Databases – Infrastructure – Security on 11 December 2017

Older posts