Happy Thanksgiving

It’s Thanksgiving again here in the United States. Throughout the years, the IT community has been awesome. I have been blessed by you all. I can certainly point to milestones in my career and list the folks who have helped me get to each one. 

But outside of work and technology, there are some folks I first met in the tech community that have been there when I and my family needed someone. I’m not going to embarrass anyone, as I’ve thanked them privately over and over again. 
Thanks, all. You make this community fun and rewarding. 

Webinar Available On Demand – Building an Auditing Framework for SQL Server

Recently I gave an introductory webinar on how to build an auditing framework for SQL Server. The focus was for those tasked with auditing SQL Server on a regular basis and needing some ideas of how to get started. I talk through some of the challenges as well as what to audit and what tools will be helpful if you don’t have a budget to go out and get 3rd party tools (or even if you do). You can find the archive here (registration required):

Webinar Archive: Building an Auditing Framework for SQL Server

Webcast Tomorrow: Building an Auditing Framework for SQL Server

Faced with auditing SQL Server on a regular basis with no 3rd party tools? Where do you start? That’s what this webcast is on. Come watch on October 13, 3 PM Eastern time. 

Webcast: Building an Auditing Framework for SQL Server
There will be some code samples, but this is about how to get started and what you need. 

Reminder: Webinar today

This is a reminder that I’ll be giving a webinar today on managing SQL Server Agents jobs in a SQL Server Farm. Here are the details:

Webinar: Managing SQL Server Agent Jobs Across Your SQL Server Farm

On Thursday, September 8, at 3 PM EDT, I’ll be doing a webinar with MSSQLTips.com on handling SQL Server Agent jobs across your SQL Server Farm. This presentation is born out of my recent experience auditing shops that are using SQL Server Agent heavily and the clutter and confusion that can occur when proper management standards are not in place and enforced.

Register here for the webinar (free)

Reminder: #SQLChat at lunch today

This is a reminder that we’ll having a #SQLChat this afternoon at 12 PM EDT. Here are the details:

SQLChat: Do You Manage Multiple Servers?

On Wednesday, September 7, at 12 PM EDT (11AM CDT), we’ll be doing a #SQLChat covering managing multiple SQL Servers and how people handle dealing with a SQL Server farm. Everyone is welcome to participate. More information is here:

Do you Manage Multiple Servers? Participate in our September #SQLChat!

SQLChat on Wednesday, Webinar on Thursday!

I’m participating in two community activities this week. One is a #SQLCchat on Twitter and the other is a webinar through MSSQLTips.

SQLChat: Do You Manage Multiple Servers?

On Wednesday, September 7, at 12 PM EDT (11AM CDT), we’ll be doing a #SQLChat covering managing multiple SQL Servers and how people handle dealing with a SQL Server farm. Everyone is welcome to participate. More information is here:

Do you Manage Multiple Servers? Participate in our September #SQLChat!

 

Webinar: Managing SQL Server Agent Jobs Across Your SQL Server Farm

On Thursday, September 8, at 3 PM EDT, I’ll be doing a webinar with MSSQLTips.com on handling SQL Server Agent jobs across your SQL Server Farm. This presentation is born out of my recent experience auditing shops that are using SQL Server Agent heavily and the clutter and confusion that can occur when proper management standards are not in place and enforced.

Register here for the webinar (free)

 

I wrote a SQL Server auditing whitepaper!

I recently collaborated with Idera to produce a short whitepaper on the top 5 things to audit in SQL Server (database engine). You can grab it for free here (registration required):

Whitepaper: Top 5 Items to Audit in SQL Server

None of this is earth shattering. The whitepaper contains the the first set of things I look at when auditing the internal security of SQL Server. Part of what spurred this effort was a series of conversations I had with friends of mine who are internal auditors, developers, and system administrators who had been audited by an outside firm recently. The results provided by the outside auditors were less than satisfactory.

If you have an auditor come into your organization and he or she doesn’t cover these items, you probably aren’t getting your money’s worth. Really, these are the starting point and a good audit should cover much more. However, grab the whitepaper, audit yourself, and take care of the “low hanging fruit.”

Previous Older Entries