Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Using SELECT INTO with UNION Statements

On occassion, I need to take a number of different result sets and combine them into a single output, which I then want to store in a temporary table. I’ve done this while developing solutions for business needs and when analyzing performance for different environments. Sometimes I just need to… Read more

2 comments, 209 reads

Posted in StrateSQL on 11 March 2016

Monday Morning SQL Break – February 22, 2016

It’s Monday time for this week’s weekly blog and twitter round-up for last week. If you haven’t already, follow me on twitter (@StrateSQL). This is a good chance to catch up on data platform technology and career related information I’ve shared in the last week and activity on… Read more

1 comments, 169 reads

Posted in StrateSQL on 11 March 2016

PASS Cloud Virtual Chapter – Call for Presenters

The cloud is calling to you. Or more specifically, Jody Roberts (b | @) and I (b | @) are looking to the community to find some presenters interested in presenting to the PASS community on building or using data platforms and solutions in the… Read more

0 comments, 189 reads

Posted in StrateSQL on 10 March 2016

Monday Morning SQL Break – March 7, 2016

It’s Monday and time for this week’s blog and twitter round-up. If you haven’t already, follow me on twitter (@StrateSQL). This is a good chance to catch up on data platform technology and career related information I’ve shared in the last week and activity on this blog.

Most…

Read more

1 comments, 48 reads

Posted in StrateSQL on 7 March 2016

Monday Morning SQL Break – February 15, 2016

It’s Monday time for this week’s weekly blog and twitter round-up for last week. If you haven’t already, follow me on twitter (@StrateSQL). This is a good chance to catch up on data platform technology and career related information I’ve shared in the last week and activity on… Read more

0 comments, 72 reads

Posted in StrateSQL on 15 February 2016

Monday Morning SQL Break – February 8, 2016

It’s Monday time for this week’s weekly blog and twitter round-up for last week. If you haven’t already, follow me on twitter (@StrateSQL). This is a good chance to catch up on data platform technology and career related information I’ve shared in the last week and activity on… Read more

1 comments, 59 reads

Posted in StrateSQL on 8 February 2016

Monday Morning SQL Break – February 1, 2016

It’s Monday and time fora round-up of last week’s blog and twitter activity – and even an on-time post for all of this. If you haven’t already, follow me on twitter (@StrateSQL). This is a good chance to catch up on data platform technology and career related information… Read more

0 comments, 183 reads

Posted in StrateSQL on 1 February 2016

Monday Morning SQL Break – January 25, 2016

It’s Monday and time for this week’s blog and twitter round-up. If you haven’t already, follow me on twitter (@StrateSQL). This is a good chance to catch up on data platform technology and career related information I’ve shared in the last week and activity on this blog.

Most…

Read more

0 comments, 78 reads

Posted in StrateSQL on 25 January 2016

Monday Morning SQL Break – January 18, 2016

It’s Monday time for this week’s blog and twitter round-up for last week. If you haven’t already, follow me on twitter (@StrateSQL). This is a good chance to catch up on data platform technology and career related information I’ve shared in the last week and activity on this… Read more

1 comments, 164 reads

Posted in StrateSQL on 25 January 2016

Monday Morning SQL Break – January 11, 2016

It’s Monday time for this week’s weekly blog and twitter round-up for last week. If you haven’t already, follow me on twitter (@StrateSQL). This is a good chance to catch up on data platform technology and career related information I’ve shared in the last week and activity on… Read more

1 comments, 177 reads

Posted in StrateSQL on 25 January 2016

2016 Polar Plunge

In just a few weeks… on January 30th, I’m going to be jumping into White Bear Lake in Minnesota. Now it’s cold in Minnesota. The average temperture range for this time of year is 8 F to 27 F, though a couple years ago January 30th was part of a… Read more

0 comments, 167 reads

Posted in StrateSQL on 5 January 2016

Monday Morning SQL Break – January 4, 2016

It’s Monday and time for this week’s blog and twitter round-up for last week. If you haven’t already, follow me on twitter (@StrateSQL). This is a good chance to catch up on data platform technology and career related information I’ve shared in the last week and activity on… Read more

1 comments, 161 reads

Posted in StrateSQL on 4 January 2016

Monday Morning SQL Break – December 21, 2015

It’s Monday time for this week’s weekly blog and twitter round-up for last week. If you haven’t already, follow me on twitter (@StrateSQL). This is a good chance to catch up on data platform technology and career related information I’ve shared in the last week and activity on… Read more

1 comments, 189 reads

Posted in StrateSQL on 21 December 2015

Monday Morning SQL Break – December 28, 2015

It’s Monday and time for this week’s blog and twitter round-up for last week. If you haven’t already, follow me on twitter (@StrateSQL). This is a good chance to catch up on data platform technology and career related information I’ve shared in the last week and activity on… Read more

0 comments, 78 reads

Posted in StrateSQL on 18 December 2015

Monday Morning SQL Break – December 14, 2015

It’s Monday time for this week’s weekly blog and twitter round-up for last week. If you haven’t already, follow me on twitter (@StrateSQL). This is a good chance to catch up on data platform technology and career related information I’ve shared in the last week and activity on… Read more

1 comments, 159 reads

Posted in StrateSQL on 14 December 2015

Monday Morning SQL Break – December 7, 2015

It’s Monday time for this week’s weekly blog and twitter round-up for last week. If you haven’t already, follow me on twitter (@StrateSQL). This is a good chance to catch up on data platform technology and career related information I’ve shared in the last week and activity on… Read more

0 comments, 172 reads

Posted in StrateSQL on 7 December 2015

Monday Morning SQL Break – November 30, 2015

It’s Monday time for this week’s blog and twitter round-up for last week. If you haven’t already, follow me on twitter (@StrateSQL). This is a good chance to catch up on data platform technology and career related information I’ve shared in the last week and activity on this… Read more

0 comments, 151 reads

Posted in StrateSQL on 30 November 2015

Tuesday Morning SQL Break – November 24, 2015

It’s Tuesday time for this week’s one day late blog and twitter round-up for last week. If you haven’t already, follow me on twitter (@StrateSQL). This is a good chance to catch up on data platform technology and career related information I’ve shared in the last week and… Read more

0 comments, 232 reads

Posted in StrateSQL on 24 November 2015

Download Analytic Platform System Tools and Books Online

Photo Credit – Mario Klingemann

Microsoft’s Analytic Platform System (APS) has been a favorite platform of mine over the last few years.  It provides a solution to many of the scale and performance concerns that exist with right-sizing a data warehouse for today and tomorrow.  One of the interesting nuances… Read more

2 comments, 1,285 reads

Posted in StrateSQL on 17 November 2015

Monday Morning SQL Break – November 16, 2015

It’s Monday time for this week’s weekly blog and twitter round-up for last week. If you haven’t already, follow me on twitter (@StrateSQL). This is a good chance to catch up on data platform technology and career related information I’ve shared in the last week and activity on… Read more

0 comments, 160 reads

Posted in StrateSQL on 16 November 2015

Newer posts

Older posts