Calculated Field has existed in Reporting Services since version 2005. SSRS 2005 did not have the most attractive user interface design, so this pretty useful feature stayed hidden from me until version 2008. Even in SSRS 2008, I did not pay much attent...

You can use the sp_spaceused system-stored procedure to return space usage information about a database or a table within a database. The syntax for this procedure is: sp_spaceused [@objectname=['objectname']] [,[@updateusage=['TRUE|FASLE']]] You use ...

Even though Service Pack 1 for SQL Server 2012 was released almost 2 months ago, it’s only now that I’ve had a chance to check if the FileTable security flaw was addressed. And I am pleased to report that the problem was resolved with the re...

Lets start New Year with a very simple yet useful topic. I am a big fan of out of box reporting capabilities of SSMS. Some of the reports are really useful. One of the reports which I really like is the Top Jobs report. This one can be pulled by travers...

Each login in SQL Server has a default database associated with it. When you login to SQL Server context is set to default database for login. This is set when login is created and it can be changed by using ALTER LOGIN command. If for some reason the ...

Sometimes we might get this error when we perform ALTER statements on an existing database. This error means, that particular database is being used by lot of other user connections and the present ALTER statement needs to have an exclusive lock on the ...

First of all I would like to convey my heartiest new year wishes to one and all. I wish may god bless you all with good fortunes, health and happiness. I do wish a prospective future and career for one and all. Personally, I had a very good start to 201...

Windows 8 Pro and Enterprise deliver a powerful tool: Hyper-V. Hyper-V is the platform for virtualization and was only available for server operating systems – with Windows 8 it is now also available for Pro and Enterprise versions. Since main stora...

Today’s T-SQL Tuesday is hosted by Jason Brimhall (blog|twitter). The topic this month is “Standing Firm”. This means that I should write something related to one of these words: resolve, resolution, or resolute. It’s the time of year...

When creating XML documents, you must work from a design that defines the structure of the document. This strengthens the structure and design. If you need to send the document to others, especially from other companies, they need the document format. W...