PowerSehll : How to suppress the table heading and remove the blank space from a text file

There are a multiple ways to suppress and remove the first line from text file. The first scenario would be writing...

Remove files from a filegroup

You have a database with one or more filegroups, and one or more of those filegroups has multiple files. You’ve...

Setting up powershell remote sessions

Hey guys, differing from usual this is a quick post on setting up powershell remote sessions. I know you can...

SQL 2016 - The Time Has Come!

Microsoft dropped it on us this morning:

Get ready, SQL Server 2016 coming on June 1st
https://media.makeameme.org/created/yes-finally.jpg

I read the article and was...

SQL Server 2016 available June 1st!

Woo hoo!  Microsoft has announced that SQL Server 2016 will be generally available on June 1st.  On that date all four...

SQL Server 2005 Modernization Checklist

As Bala Narasimhan from PernixData and I discussed in a webinar last week, SQL Server 2005 hit end of it’s...

Why you should think about upgrading to SQL Server 2016!

SQL Server 2005 is out of support and you might be (Or rather, you should be) planning an enterprise wide upgrade of SQL Server. Are you thinking of upgrading...

Why you should think about upgrading to SQL Server 2016!

SQL Server 2005 is out of support and you might be (Or rather, you should be) planning an enterprise wide...

3 Things I Wish I Knew When I Started Using Entity Framework

Entity Framework (EF) is Microsoft's object-relational-mapping tool (ORM) that allows programmers to easily map database objects to C# object models. What attracts developers to Entity Framework is the automatic...

Power BI Box and Whisker visualization vs. Box Plot chart in SSRS

[2016-Apr-30] I don't work with box plot charts very often, however when I do then it becomes a very interesting experience. First,...