Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Latest Blog Posts

MDX #42–IsEmpty? or = 0 ? or IS NULL?

In SQL, NULL means undefined value

Any SQL programmer can tell you that zero is not NULL, NULL is not zero, and NULL is not even equal to NULL either, because NULL means undefined. One undefined value cannot be equal to another undefined value.

In MDX, NULL means an empty…

Read more

1 comments, 5,175 reads

Posted in Sherry Li's BI Corner on 12 November 2014

SSRS #75 – Use RunningValue() Function and VB Script to capture discrete dates

Drill-down report is a common design

In SSRS, it’s a common design to allow users to drill down to more granular data in a same report.

In the following snapshot, users will see a summary line that shows the Call Handled 130. The two days, 11/4 and 11/5 will not… Read more

0 comments, 5,533 reads

Posted in Sherry Li's BI Corner on 11 November 2014

PASS Summit 2014 in Review

I’m finally completely recovered from a great week in Seattle last week for PASS Summit.  Now that it’s back to the grind of regular work I thought I’d put together some thoughts and tell you about my experiences from the week. 

You may have read others blogs about their experiences… Read more

0 comments, 128 reads

Posted in Devin Knight on 11 November 2014

TSQL Tuesday #60: Something Learned This Way Comes

It is once again time to come together as a community and talk about a common theme.  This monthly gathering of the community has just reached it’s 5th anniversary.  Yes, that’s right.  We have been doing this for 60 months or five years at this point.  That is pretty cool. Read more

4 comments, 142 reads

Posted in SQL RNNR on 11 November 2014

Thanks, Vets

0 comments, 144 reads

Posted in @chuckboycejr on 11 November 2014

Power Testing ETL with Power BI – The Process

This is a short blog series on using Power BI tools to support testing ETL processes. I have presented on this subject at few SQL Saturdays over the past few years and am finally succumbing to multiple request to turn it into a blog post. Realizing the amount of content… Read more

2 comments, 162 reads

Posted in DataOnWheels on 11 November 2014

T-SQL Tuesday #60 – Something New Learned

It’s been five years, and that’s amazing. Not many things last for a year, much less five, but the T-SQL Tuesday party, started by Adam Machanic (B|T)., has been amazing and lots of fun for me.

This month, Chris Yates hosts and his theme is Something… Read more

1 comments, 183 reads

Posted in The Voice of the DBA on 11 November 2014

I’m Still Not on the Board

I’m just back from the PASS Summit 2014. What a great event. But this year, it was a little different. I did a lot of the usual things, presented a pre-conference seminar to about 130 people, helped out at the Red Gate booth, presented a session on execution plans on… Read more

1 comments, 119 reads

Posted in The Scary DBA on 11 November 2014

Join me in DC for a full day of Biml

I’m excited to announce that my Linchpin People colleague Reeves Smith and I will be delivering a full day Biml preconference seminar the day before the upcoming SQL Saturday in Washington, DC.  This seminar, entitled “Getting Started with Biml”, will introduce attendees to the awesomeness of Business… Read more

0 comments, 168 reads

Posted in Tim Mitchell on 11 November 2014

T-SQL Tuesday #60 Something New Learned

So, here it is. I put the challenge out to discuss something new learned last week. I was fortunate enough to attend the PASS Summit last week in Seattle. While this post will not be my summarization of that trip (that will be another post) I did have several take-a-ways.… Read more

0 comments, 150 reads

Posted in The SQL Professor on 11 November 2014

TSQL Tuesday #60: Something New Learned – What permissions does have?

What have I learned recently? Well as it happens I learned something rather interesting recently and was actually trying to figure out how/when to post it. This month’s T-SQL Tuesday host Chris Yates (b/t) wants to know something we have learned recently so that seems like… Read more

2 comments, 173 reads

Posted in SQLStudies on 11 November 2014

How To Use the Unpivot Transform in SSIS

Moving data from columns to rows can be a tricky task and accomplished in a variety of ways. That may be through a series of unions in T-SQL, but that’s just ugly and means lots of passes at the data potentially. You could use a T-SQL unpivot, which isn’t bad… Read more

0 comments, 5,562 reads

Posted in Bradley Schacht on 11 November 2014

PASS Summit 2014 – It’s not you, it’s me

After an exciting week at the PASS Summit, I’m back home with my family.  This was my first ever PASS Summit and instead of writing about what was good or what was bad, I’ve decided to write about what I did and did not do and what I think I…

Read more

7 comments, 139 reads

Posted in TheSqlPro.com - Ayman El-Ghazali on 11 November 2014

Consuming the Output of an SSIS Package in a Client Application

Typically, making the output of an SSIS Package available to a client application for further processing is achieved by outputting the results to a Table in a Database or, maybe, to a file.

The application would then interrogate any of these sources and retrieve the data it needs.

However, what… Read more

0 comments, 331 reads

Posted in On the Fringe on 11 November 2014

#tsql2sday #60 – Something New Learned – Problem Step Recorder

What is T-SQL Tuesday?

T-SQL Tuesday is a monthly blog party hosted by a different blogger each month. This blog party was started by Adam Machanic (blog|twitter). You can take part by posting your own participating post that fits the topic of the month and follows… Read more

4 comments, 196 reads

Posted in SQL DBA With A Beard on 11 November 2014

Summit 2014

It’s hard to believe it’s over.  It felt like a whirlwind while I was in Seattle for my 7th PASS Summit, but now that I’m back home it feels like it was ages ago.  I think time moves more quickly when you’re with friends and that’s where I was, with… Read more

1 comments, 89 reads

Posted in SQL Swimmer on 10 November 2014

#SQLPASS #Summit14 Day 2 Keynote Highlights !

This was one of those days I was waiting to happen. You might be wondering whats special? Yes, this day is very special because Rimma Nehme will be giving a keynote on  Cloud Databases 101.

Rimma Nehme is one of those super smart people who works for Microsoft Gray… Read more

1 comments, 131 reads

Posted in SQLSailor.com on 10 November 2014

Let’s get started

Just back from PASS Summit 2014 and I am feeling inspired about stepping it up a notch and starting to give back to the great community that has provided me with the knowledge to build my career over the years. Hopefully, I’ll be able to help a frustrated person out… Read more

0 comments, 2 reads

Posted in Jared Zagelbaum's Blog on 10 November 2014

Last Weeks Top “Reading” Links #108

It’s Monday time for this week’s weekly link round-up.  If you want to catch these links “live” (so exciting), follow me on twitter (@StrateSQL).  And see these throughout the day as I tweet out links of things I find interesting.  While these links aren’t the answer… Read more

0 comments, 7 reads

Posted in StrateSQL on 10 November 2014

Expected Variables–T-SQL Testing

After I wrote about creating tables that contain the results I expected, I wondered if I could do the same thing with variables. I was thinking that I’d like to better self-document my tests, and I’d like to be able to do this:

declare @TimeElapsed.Expected int = 25;

It turns… Read more

0 comments, 185 reads

Posted in The Voice of the DBA on 10 November 2014

Newer posts

Older posts