-->
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.

Midlands PASS Meetings for January and February 2019

Midlands PASS won’t be holding a meeting in December. Too much going on! However, we are hosting meetings in January and February.

January 8, 2019 – Moving Data with Azure Data Factory

Andy Leonard (twitter | website) joins us to discuss Azure Data Factory. Learn from one of… Read more

0 comments, 130 reads

Posted in Databases – Infrastructure – Security on 27 November 2018

Meetings: Have a Point of Focus

Have you ever been in a meeting where the attendees seemed to go down one rabbit trail after another? At the end of that meeting, likely everyone left wondering why they were there. Those meetings are failed meetings. Meetings should move things forward. Otherwise, what’s the point? And that gets… Read more

0 comments, 1,677 reads

Posted in Databases – Infrastructure – Security on 16 November 2018

Ethics in Data Science and Artificial Intelligence

Microsoft redid its Data Science Track not too long ago and they added several courses and new progress points. One of those progress points is Apply Ethics and Law in Analytics and the course to cover this point is Microsoft DAT249x: Ethics and Law in Data and Analytics, offered… Read more

2 comments, 2,632 reads

Posted in Databases – Infrastructure – Security on 8 November 2018

How do I ask for SQL Server help on Twitter?

For those of us who have been on twitter for a long time, we are familiar with the #sqlhelp hashtag. However, I was giving a presentation to a user group last night and came across a case where folks in the room didn’t know about the hashtag. I mentioned this… Read more

0 comments, 225 reads

Posted in Databases – Infrastructure – Security on 7 November 2018

Free Training: Videos from Tim Mitchell

I’m always on the looking our excellent training, especially free training. Tim Mitchell, Microsoft Data Platform MVP, (twitter | website) has a number of great videos available on YouTube around SSIS and ETL. Definitely spend some time checking them out!

Tim Mitchell’s YouTube Channel

Tim is a great… Read more

0 comments, 181 reads

Posted in Databases – Infrastructure – Security on 29 October 2018

Slides and Scripts from IT/Dev Connections

If you attended either of my presentations for this past IT/Dev Connections, here are the promised slides and scripts.

As I mentioned at the presentation, there’s nothing special about the scripts, so feel free to use them as you’d like.

Top Down SQL Server Security (.zip file – 815 KB) Read more

0 comments, 176 reads

Posted in Databases – Infrastructure – Security on 23 October 2018

Upcoming #SQLChat on Making the Most of Conferences

This month’s #SQLChat is hosted by Rie Irish (twitter | blog). It’s a timely topic: Making the Most of Conferences. With the PASS Summit just around the corner, this is a great way to get you thinking about your activities and how to get as much out of… Read more

0 comments, 136 reads

Posted in Databases – Infrastructure – Security on 22 October 2018

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, 162 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, 564 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, 176 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, 216 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, 162 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, 148 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, 194 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, 315 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, 287 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, 283 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, 227 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, 283 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, 316 reads

Posted in Databases – Infrastructure – Security on 21 March 2018

Older posts