Dataset with Text or Stored Procedure

As most of you already know, Reporting Services reports make use of Datasets to get data. These Datasets can get...

SQL Saturday 97 has ended

Well it isn’t quite over for me just yet, I still have a flight home tomorrow and can’t wait to...

An Informal Compendium of SSAS Errors, Part 3: Unresolved Errors

This is the second in a series of posts on some SQL Server Analysis Services (SSAS) errors for which there...

Live Blogging SQL Saturday #97 Austin (hashtag #sqlsat97)

Hello and welcome to my live blog/recap of SQL Saturday #97 in Austin! Wes Brown and the crew from CACTUSS...

How to find out which Table is not having rows in SQL Server?

Introduction
Many times while tuning our production databases we might try to find out the list of tables not having even...

October Question: What one thing do you feel has the greatest impact on SQL Server’s performance?

When it comes to databases, many DBAs obsess over performance, and for good reason, as when user’s begain to complain...

24 HOP recordings

For all of you, that you have missed any session from the last 24 HOPass - you can check here

24 Session...

SQL Saturday 97 starts in 7 hours

I flew into Austin Texas today and got to spend time with a lot of great people.  The journey started...

Come For The Education Stay For The Networking

OMG! SQLSATURDAY #97 IS HERE!
I am really excited about SQLSaturday #97! In just a few short hours we will be...

How to find a string value in all the string columns of a table/view in SQL Server ?

 
Introduction
I am sure many times we all might have come across situations where we need to search/find a string value...