I’m Speaking – SQL Saturday Raleigh 2018!

March 27, 2018 Jeff MlakarLeave a comment

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

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

March 13, 2018April 17, 2018 Jeff Mlakar1 Comment

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.

Migration – How To Move SQL Server Database Files to a New Location

February 26, 2018July 12, 2018 Jeff Mlakar2 Comments

Have you ever had to move databases and their files? A database migration involves some downtime and mistakes made can certainly ruin your day. You don’t want to be in the middle of a migration and be uncertain about what to do.

Read on to learn how to move SQL Server database files and also see some demos.

T-SQL Tuesday #99 – Dealer’s Choice With Passion

February 14, 2018April 17, 2018 Jeff Mlakar2 Comments

The topic for this months T-SQL Tuesday #99 (hosted by Aaron Bertrand Blog/Twitter) is:

Dealer’s Choice – write about something you are passionate about (outside of the SQL / tech community) OR write about T-SQL bad habits

I opt to share with you a passion I have had for years.

Achievement Unlocked: MCSA SQL 2016 Database Development

January 15, 2018July 12, 2018 Jeff Mlakar3 Comments

This week I accomplished something to continue my education. I obtained my MCSA in SQL Server 2016 Database Development!

UPDATE: I told you the who, what, when, and why but not the how. Added a new section below.

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

December 12, 2017April 17, 2018 Jeff MlakarLeave a comment

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.

T-SQL Tuesday #96 – Inspire to Make a Difference

November 14, 2017April 17, 2018 Jeff Mlakar2 Comments

The topic for this months T-SQL Tuesday #96 (hosted by Ewald Cress Blog/Twitter) is:

Who inspires you in the data community?

Inspire means to motivate or move to action. To many, the word conjures up images of fun, happiness, and cajoling to leisure time. That’s not what I think of when I look at those who have motivated me and impacted my career. Inspire involves both good and bad experiences.

I’m not saying that you need bad times to learn good lessons – there are more desirable ways – but they can work. To be fair, I consider both in my experiences and how they’ve impacted me for the better. Stay with me as I’m going to take a different angle on this.

Irregular Identifiers – Be Aware of Surprises

October 25, 2017 Jeff Mlakar1 Comment

Surprises exist in SQL Server. There are “gotchas” to be aware of. One thing that can trip up your code is how tables, indexes, and other objects are named. They’re called identifiers. If you step outside the bound of a regular identifier then you must be careful how it is referenced.

For example adding a datetimestamp suffix to a table – let’s see how this can cause trouble.

I’m Speaking – SQL Saturday Charlotte!

October 2, 2017October 2, 2017 Jeff MlakarLeave a comment

On Saturday October 14 I’ll be speaking at SQL Saturday Charlotte. I’m excited to be presenting a lively session about Environmental SQL Server Troubleshooting. If you want a preview you can check out some of my previous posts:

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