SQL Server 2008 – Come Join Us

October 4, 2019October 3, 2019 Jeff MlakarLeave a comment

This July marked the end of life for Microsoft SQL Server 2008 and 2008R2. Let’s raise a glass to toast / pour some liquor out / reminisce about the past…

I’m Speaking – SQL Saturday Sacramento 2019!

August 9, 2019August 9, 2019 Jeff Mlakar1 Comment

On Saturday August 17th I will be speaking at SQL Saturday Sacramento presenting on 2 fun topics:

Database Corruption! Preventing Disaster to your Database
Environmental SQL Server Troubleshooting

Read on about my presentations…

How to Generate Scripts In SQL Server

May 31, 2019May 30, 2019 Jeff Mlakar2 Comments

There are multiple methods for exporting data from SQL Server. We will explore a few and focus on the “Generate Scripts” feature in SSMS.

Feature Image / License

SQL Server Drop Tables in Bulk – 2 Methods

May 10, 2019May 9, 2019 Jeff Mlakar1 Comment

There are times when you may find yourself needing to drop many tables in your database but not all. Some criteria defines what must go. It could be archived tables, tables before or after a certain date time stamp, dummy data tables, etc.

Let’s look at 2 simple methods for dropping lots of tables in your database.

Feature Image / License

I’m Speaking – SQL Saturday Phoenix 2019!

April 26, 2019April 25, 2019 Jeff MlakarLeave a comment

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

I’m Speaking – SQL Saturday Raleigh 2019!

April 12, 2019April 15, 2019 Jeff MlakarLeave a comment

On Saturday April 27th 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:

These are all available under the Resources menu at the top of the page.

T-SQL Tuesday #113 – What Do You Use a Database For?

April 9, 2019April 8, 2019 Jeff Mlakar3 Comments

The topic for this months T-SQL Tuesday #113 hosted by Todd Kleinhans (Blog / Twitter) is about “what do YOU use a database for”. We work all day, night, and weekend sometimes on our database craft. Todd asks:

So what do you use databases for in your personal life that you are willing to share?

Read on to hear my story.

T-SQL Tuesday #112 – Facing the Unknown With Confidence

March 12, 2019March 11, 2019 Jeff MlakarLeave a comment

The topic for this months T-SQL Tuesday #112 hosted by Shane O’Neill (Blog / Twitter) is about “dipping into your cookie jar”. This reference means “when times get tough how do you dip into your reserves to keep going”. Shane asks the following:

That is what I want from the contributors of this T-SQL Tuesday, those memories that they can think back on for sustenance. Like the humble cookie, I want a humble brag.

Read on as I share some stories…