Data Rendering Eye Opener SSRS

Hi Folks

Greetings to everyone!!!

So last week one of the report was having a performance issue. It had 10 datasets ,5...

Find blocking using sp_who in SQL Server

Hi friends, in this blog I will tell you how can we find blocking using sp_who system stored procedure. Also,...

Handling Mixed Format Data Files in SSIS

Some time back I wrote about how to use the script component to parse out ragged data files in SSIS....

How Do Blind People Use SQL Server?

#SQLNewBlogger
I can just see people skimming that and doing a knee-jerk reaction, “What a cruel and mean title! You should...

Instances and Ports with PowerShell

Just a quick post and a day late for #SQLNewBlogger There are some excellent posts on that hashtag and I...

Optimizing the Modern Data Platform with SQL Server 2014

Join Jason Strate and Pragmatic Works in Minneapolis on May 7. Learn about Optimizing the Modern Data Platform with SQ Server...

Overview of Published Articles – 2015Q1

Here is an overview of the articles I published in the first quarter of 2015.
INTENSE SCHOOL
MCSE Prep: Overview of T-SQL Windowing...

Padding Fields for Fixed-Position Data Formats

Fixed-position data formats will seemingly be with us forever. Despite the relative ease of parsing CSV (or other delimited formats), or even XML, many data exchanges require a fixed-position...

SQL Sentry Pro Explorer is worth it...

UPDATE: 2015-04-28 15:49

- I created a few autohotkey scripts and solved the problem of collapsing panes and a few other...

SQL Sentry Pro Explorer is worth it…

UPDATE: 2015-04-28 15:49 – I created a few autohotkey scripts and solved the problem of collapsing panes and a few other...