SQL SERVER – SQL Server Configuration Checking – A Must Do for Every DBA – Notes from the Field #004

Originally posted on Journey to SQL Authority with Pinal Dave:
[Note from Pinal]: This is a fourth episode of Notes from...

SQL Server Data Tools (SSDT) – October 2013 update

Since my last post about the SSDT update for August, there have been two updates, each containing one fix:
The September...

The World Needs More A/B Testing

Have you ever been told that it’s ok to fail? Did it ever feel like it was really ok to...

Things I've Learned In Regards To Fill Factor:Quick Tips

I don't have much today... It's been a good week so far. I think I'm becoming a bit obsessed with...

An application error occurred on the server running on SQL server

AdvertisementsRecently one of my application website went down.
 

I checked all the basic connectivity troubleshooting and seem everything was looking and...

Case Statement/ Expression in SQL Server

Case Statement/ Expression in SQL server 
 
Sometimes we need to get one result output from multiple possible outcomes based on the...

Fill Factor, Why Do You Taunt Me? Part 3

Let's look at something a bit more in depth. Let me start by saying, "Please don't arbitrarily change any default...

Finding the metadata for a query

You know I occasionally find it interesting how I learn new things. I was running through a practice test for...

Free Online SQL Server Training for the Week of November 24, 2013

If you’re a training provider and I’ve missed you, please drop me a line at brian {dot} kelley {at} sqlpass...

How Hekaton will impact the RTO of your database

(Be sure to checkout the SQLpassion Online Academy, where you get High-Quality SQL Server Trainings with Instant Access!)
Over the weekend...