SQL Server – Kill all sessions using database

Before an existing database can be restored, there should be connections using the database in question. If the database is...

Stuff VS Replace function in SQL Server

Stuff function: - This function is used to replace string from the given start position, passed as 2nd argument with string...

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...

Usage grouped by Database: Quick Tips

Quick script just to give you an idea of how your databases are being used. Mainly useful for exploring.

select db.name...

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...

Setting your predicate arguments at run time

 
Introduction
A few days ago, I did a presentation for a Virtual Chapter meeting where I discussed SQL Server Data Access...

Choose your Hash Bucket Count very wisely in Hekaton!

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

9 points before backing up SQL Server databases

Backing up SQL Server Databases

 Backing up your SQL Server database is essential for protecting your data. The word Backup refers...

Reblog: November 15 to November 21

I’ve always been a fan of the feeling when I find an old blog post that’s got just the information...

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...