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

Last Weeks Top “Reading” Links #59

Monday morning and it’s time for weekly round-up.  If you follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet...

Reverse or Mirrored Bar Chart in SSRS

There are some pretty charts out there and most of them can be done in Reporting Services. There is one...

Skills I Used Last Week #2

Back in September I wrote the first version of Skills I Used Last Week, so I thought I’d loop back...

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

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

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

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