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

Why I Do What I Do #tsql2sday

I didn’t originally want to go back into IT after 15 years in the career field. It was 1999 and I had just left active duty with the US Air Force. My designation was a Communications-Computer Systems Officer but I had served as a hybrid IT support/project manager/Airman wrangler throughout… Read more

0 comments, 116 reads

Posted in Databases – Infrastructure – Security on 12 February 2019

Midlands PASS Meeting for April 2019

The Midlands PASS April 2019 meeting will be held on April 2nd and we’ll be welcoming Matt Gordon (twitter | website)!

Meeting Details and RSVP Link: https://www.eventbrite.com/e/democratizing-data-analysis-howwhy-of-social-sentiment-scoring-tickets-56039146596

Here is the talk he’ll be giving:

Democratizing Data Analysis: How/Why of Social Sentiment Scoring

The job of a data professional… Read more

0 comments, 116 reads

Posted in Databases – Infrastructure – Security on 6 February 2019

Midlands PASS Meeting for March 2019

The March meeting for Midlands PASS will be held on March 5, 2019, from 5:30-7:30 PM. Brian Kelley and Paul Shearer, both local to Columbia, will be speaking on SQL Server in the Cloud.

RSVP Link: https://www.eventbrite.com/e/sql-server-in-the-cloud-tickets-55991994563

Description:

More and more organizations are looking to move workloads into the cloud.… Read more

0 comments, 100 reads

Posted in Databases – Infrastructure – Security on 5 February 2019

Midlands PASS Meeting – February 5, 2019

Midlands PASS (Columbia, SC) will be hosting Shannon Lowder on February 5, 2019, from 5:30-8:00 PM. He will be speaking on his journey as a data scientist. If you are going to be in the area, here is the registration link:

https://www.eventbrite.com/e/becoming-a-data-scientist-tickets-53066926606

What’s the Talk About?

You’ve all heard about… Read more

0 comments, 114 reads

Posted in Databases – Infrastructure – Security on 29 January 2019

Data Modeling Webcast Rescheduled

Unfortunately, due to a last minute scheduling conflict on my side, we’ve had to reschedule the data modeling webcast with MSSQLTips. It is now for next Wednesday, January 23rd, at 3 PM Eastern.

Register for webinar (free)

I apologize for the change in schedule. If you’re unable to make the… Read more

0 comments, 117 reads

Posted in Databases – Infrastructure – Security on 16 January 2019

Developing Presence

At SQL Saturday Nashville, I didn’t do a good job explaining the concept of presence. This is in reference to the Women in Technology presentation at lunch. Part of the discussion was around how height can influence being noticed. I agree that it does play a huge role. At 5’7″,… Read more

2 comments, 1,792 reads

Posted in Databases – Infrastructure – Security on 14 January 2019

Donating Hair Again

There are several organizations which take hair donations, but the one I prefer to donate to is Wigs for Kids, whose focus is children who need wigs due to cancer. Steve Jones asked for before and after pictures, so here they are. Total length was about 14 in use.… Read more

1 comments, 148 reads

Posted in Databases – Infrastructure – Security on 10 January 2019

Midlands PASS Meeting tonight with Andy Leonard

If tonight you’re in or can get to the Columbia, SC area, we have a treat for you! Former SQL Server MVP and current BIML Hero Andy Leonard will be presenting on Azure Data Factory. Meet and greet will start at 5:30 PM with Andy beginning his talk around 6… Read more

0 comments, 146 reads

Posted in Databases – Infrastructure – Security on 8 January 2019

Webcast: Data Modeling Scenarios and Best Practices

On January 17, 2019, I will be giving a webcast with MSSQLTips on data modeling best practices. It’s scheduled for 3 PM EST (8 PM UTC). Here’s the link to register:

Register for Data Modeling Scenarios and Best Practices (free)

Here’s what I’ll be talking about:

In this session we’ll… Read more

0 comments, 1,263 reads

Posted in Databases – Infrastructure – Security on 28 December 2018

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, 178 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

1 comments, 1,765 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,738 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, 267 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, 236 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, 213 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, 187 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, 186 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, 603 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, 208 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, 264 reads

Posted in Databases – Infrastructure – Security on 30 August 2018

Older posts