WAN Optimization Evaluation Review–Part 1

We are evaluating a WAN optimization vendor and have so far installed the appliance at the primary site and end-user’s...

What's in a name? SQL Server Magazine becomes SQL Server Pro.

SQL Server Magazine Reveals New Name for the Brand
Did you hear the news?  SQL Server Magazine has a new...

CONCAT() – SQL Server 2012

With SQL Server 2012 a new string function is born – CONCAT(). The output is a string, as the result of...

Day 2: Log file grown high cannot shrink log file.(available size in – negative)

Description:-
Yesterday, we discussed what happen when tempdb data file grown very high, now what if log file of any user...

Day 29: Fatal Errors 823, 824, 825, 832, OS error 23

Day 29: Fatal Errors 823, 824, 825, 832, OS error 23

Error 823: IO error OS cannot read the data
Error: 823,...

DBA in Space: Behind the Scenes—Question 7

This is a continuation of my DBA in Space journal.
Episode seven is filmed at the “Animals in Space” exhibit at...

Execution plan warnings–The final chapter

In my previous posts (here and here), I showed examples of some of the execution plan warnings that have been...

New string function in SQL Server 2012 – FORMAT()

Formatting numbers in an SSRS report is a common task. For example, you may want to format a number as...

Promoted to Master Group By Thomas LaRock

SQLRockstar Thomas LaRock has updated his blogger rankings this month, and I was pleasantly surprised to see that he had...

Silly issues with SSRS

Recently I was troubleshooting a report issue where in one of the column was empty in the report. I started...