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

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

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

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