Blogs

DateTime is a very useful yet complex datatype in SQL. I have heard many people saying they are not comfortable when it comes dealing with Date calculations. Let us take a closer look at various functions used for date calculations. DAY Returns an integer...

After motivation from a Microsoft SQL Server Development Team Member (Maria Balsamo), I have opened a connect request (feedback) for feature addition to BIDS and SSMS which I described in my previous article that can be read from here . This connect item...

We have started the evaluation of TSQL Challenge 20 . The list of submissions we received so far are listed at http://databasechallenges.com/SQLServer/TSQL/challenge20/submissions . So far we received 170 submissions and I think this is one of the challenges...

Master Data Services (MDS) is the newest offering and the first of it's kind in SQL Server which is getting shipped with SQL Server 2008 R2 version. As it's claimed to be, it serves the purpose of Master Data Management within or across the enterprises...

You can assign value to a variable by using SET or SELECT statement and almost they work the same except that a SELECT statement has the ability to have the source value come from a column within the SELECT statement. Let's see these examples to clarify...

We are getting ready for the logic testing of TSQL Challenge 18 . The tricky data for the logic testing is published at http://databasechallenges.com/SQLServer/TSQL/Challenge18/logic_testing . We will test the solutions with SQL Server language settings...

Often I see people asking questions in the forums about finding the database name where the particular procedure exists You can use many methods to get a solution (cursor, undocumented procedure,dynamic sql,etc) The simplest are 1 Use Undocumented procedure...

The title of this article might give the first impression, that I am a too greedy person. After all this loads of features raining in SQL Server 2008 R2 version majority of which fall in the bucket of BI, if someone is still publishing a wish list then...