In-memory tables in 60 seconds

As a SQL Server DBA or developer here is what you should know about memory-optimizedtables (in-memory tables):

Introduced in SQL Server 2014Primary...

Why I Practice Presentations

I had a new presentation to give this week at IT/DevConnections. This is a paid for conference, and I want...

Too many indexes!

Indexes are great. They speed up our queries. In fact, without them relational database systems wouldn’t work.
Different indexes work best...

My thoughts on Recertifying your MCSE through Microsoft Virtual Academy

A couple of years back I achieved the Microsoft certification MCSE – Business Intelligence. You can read all about that process in...

You don't need any Training? OK...I believe you.

This week's Super duper IT training offers are in:
If you see any that take your fancy let me know. Drop...

Microsoft Certifications

Every now and again I would navigate to Microsoft’s certification page and see what / if any changes have taken place...

A quick note comparing ISNULL vs COALESCE

There are hundreds of blogs that compare the T-SQL ISNULL function with the ANSI standard COALESCE function. There are also...

MS Access – Store a Different Value than Displayed in a Combo Box

It is occasionally usefully to display a different values in an Access combo box than what is actually stored in...

Check Database Server Workload - Batches/ Sec

Today's post is about a simple but very useful query.

One of the basic things one needs to check is the...

This Week In Data – Episode 8 (Mastering the Tech Interview)

Welcome back to another episode of This Week In Data! If you missed our previous episodes, you can watch them...