SQL Saturday Raleigh 2018 Logo

I’m Speaking – SQL Saturday Raleigh 2018!

On Saturday April 14th I’ll be speaking at SQL Saturday Raleigh. I am excited to be presenting a lively and practical session about Environmental SQL Server Troubleshooting.

When called in to diagnose a performance issue what are the 1st things you review? Many DBAs and developers make the mistake of diving straight into the code looking for an answer. However, often times the solution is not in the code but rather in the overall environment.

Environmental troubleshooting is often a quick and overlooked method for discovering and configuring SQL Server to perform at a higher level without the need for application change controls.

In this session we will discuss both performance pitfalls and optimizations that can be made to the system outside of code changes. We will diagnose configurations commonly misapplied and review best practices in SQL Server, Windows Server, and VMware!

If you want a preview of the talk and some supplemental info please look at these:

There are about 40 different sessions scheduled ranging from beginner to advanced – something for everyone.

I wrote about last year’s event: Raleigh SQL Saturday 2017 – Amazing Professional Community

Read More »

T-SQL Tuesday Logo

T-SQL Tuesday #100 – The Future of SQL Server 2026

The topic for this months T-SQL Tuesday #100 (hosted by Adam Machanic Blog/Twitter) is:

“…put on your speculative shades and forecast the bright future ahead. Tell us what the world will be like when T-SQL Tuesday #200 comes to pass.”

Big thanks to Adam for starting this monthly blog party and keeping the energy going!

Let’s predict the future of SQL Server! I will share with you my best guesswork about how it will be to work with SQL Server 2026.

Read More »

T-SQL Tuesday Logo

T-SQL Tuesday #97 – Setting Learning Goals for 2018

The topic for this months T-SQL Tuesday #97 (hosted by Malathi Mahadevan Blog/Twitter) is:

Setting Learning Goals for 2018

I like to think of year end goal setting in terms of inhaling and exhaling. Reflecting back on the year and planning ahead for the next year is exciting to me. I think a lot about these things – sometimes too much. Like breathing there is a balance between thinking about something and taking action to do it.

Let’s see about a healthy balance by looking first at 2017 then ahead to 2018.

Read More »

Knowledge Based Authentication and Data Breaches – Your Security Questions Are Belong to Us

All your security questions are belong to us

Troy Hunt recently testified before the US Congress about Data Breaches. The focus was how data breaches affect knowledge based authentication. Identity verification in a post breach world is more challenging than ever.

His testimony is available on his blog. It is worth a read – I’ll wait here until you return.

You can watch the hearing on YouTube. (1.5 hours)

Much of his talk comes from his experience running a website tracking data breaches. If you have not already checked your information in Have I Been Pwned take a look. You can have it notify you if your account has been in a data breach.

Read More »