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

SQL Server 2011 (Denali) CTP3 Released!

 

I started this blog a few weeks ago when I heard rumors that CTP3 was coming soon, but figured that I should probably wait until it is released…Hit the forward button…check…Make some modifications to blog…check…

It is July 12th, 2011 and finally…After months of waiting for SQL Server… Read more

0 comments, 562 reads

Posted in BrianKMcDonald on 12 July 2011

2011 SQL Rally Evaluations - Reporting Services Boot Camp

 

I wrote this early in June, but lost it in my blog pile again and just found it…

 

First and foremost, I would like to thank each and every person who submitted a speaker evaluation at SQL Rally back in May. Getting up and presenting isn’t as easy as some… Read more

0 comments, 133 reads

Posted in BrianKMcDonald on 11 July 2011

FileLinking Using SSIS

 

A user recently asked how to generate a file link using SSIS so that it could be inserted into the database. While creating an example for him, I figured I might as well go all out and make a blog about it. So, here it is.

 

I created a flat… Read more

5 comments, 419 reads

Posted in BrianKMcDonald on 1 July 2011

Awesome Reports Webinar Tomorrow at 11AM

 

 

Here at Pragmatic Works, we enjoy putting on a show for the community. As can be seen by Training on the T’s (Tuesday’s and Thursday’s that is)! Tomorrow should be one of the most enjoyable Reporting Services webinars that you can learn some good tips using SQL Server Reporting Services… Read more

0 comments, 530 reads

Posted in BrianKMcDonald on 30 June 2011

Watermarking

 

Someone asked me a long time ago how to do watermarking in Reporting Services and I meant to write a blog about it. Then I was asked again just yesterday. So, I figured it was worth a quick blog. In this quick blog, I will show you how to use… Read more

4 comments, 1,161 reads

Posted in BrianKMcDonald on 30 June 2011

Who Am I

If you’re anything like me, you use many different machines on a daily or sometimes weekly basis. Some of these are on computers you use during working hours and some during your non-working hours. Well, let’s just call these non-working hours, non-billable-hours right? J As I tend to do quite… Read more

0 comments, 292 reads

Posted in BrianKMcDonald on 25 June 2011

PASS 2011 Pre-Conference Seminars and Spotlight Sessions Released

  

I have wanted to go to PASS Summit for the last several years, but have yet to get an opportunity to attend. This year, I “reaaalllllllyyyyyy” want to attend now that the Pre-Cons and Spotlight sessions have been revealed to the public. PASS announced the Pre-Conference seminars and Spotlight sessions… Read more

0 comments, 358 reads

Posted in BrianKMcDonald on 2 June 2011

SQL Saturday 74 Is Here! Register Now! Show Up Tomorrow!

 

Tomorrow (4/30/2011) is SQL Saturday #74 in Jacksonville Florida and once again, I am giving a talk with other well known SQL Server Guru’s. Register for the event right now…Pack up your computer tomorrow morning and head over to UNF Campus at 8:00 AM tomorrow. You will get some awesome… Read more

0 comments, 489 reads

Posted in BrianKMcDonald on 29 April 2011

Awesome Software/Training Deal!

 

Here at Pragmatic Works, we are not just a bunch of great consultants! We create software too! Some that helps organizations with migrating packages from DTS to SSIS. We also have some pretty wicked software that saves time documenting packages, cubes and databases. Furthermore, we have components and tasks… Read more

0 comments, 132 reads

Posted in BrianKMcDonald on 21 April 2011

SQL Rally Still Only $349 Until 4/30/2011

  If you're on twitter, follow the #SQLPass hash tag and @briankmcdonald for up-to-date information.

  You may have heard that PASS is introducing a new, regional conference this spring. It’s called PASS SQLRally, and it’s taking place May 11-13 in Orlando. I’m excited to be speaking, and I encourage you to… Read more

0 comments, 104 reads

Posted in BrianKMcDonald on 18 April 2011

Limit Results Based on Aggregated Threshold

 

Problem

A post was recently added to one of the forums that I monitor so that I can help users in the SQL Server community with their issues. In this problem/solution blog post I am referencing a user trying aggregate Category and Subcategory Sales values. Not to tricky so far…

Read more

1 comments, 885 reads

Posted in BrianKMcDonald on 11 April 2011

SQL Saturday 70 SSRS Deep Dive Files Uploaded

 

SQL Saturday #70 (Twitter: #SQLSat70) was another successful event! And...I had yet another full house (some even left due to space constraints) and others even sat on the floor (Jessica Moss Twitter: @jessicammoss). Although I'm not sure why someone didn't give up their seat for her. At any rate… Read more

0 comments, 137 reads

Posted in BrianKMcDonald on 19 March 2011

Hurry Up and Sign Up! SQL Saturday 70 is Here!

 

If you are anywhere within driving distance to Columbia, South Carolina, register NOW and then hop in your car Friday evening (3/18/2011) or early Saturday morning (3/19/2011) and get some free training. This is going to be another great SQL Saturday event.

 

You can find out more details at the… Read more

0 comments, 132 reads

Posted in BrianKMcDonald on 18 March 2011

Waiting For Superman

 

This site really is about business intelligence, but it is good to mix things up a bit every now and then. Also, I was told by my boss that blogs should be a way for people to get to know who we are. And sure…I work a ton, and as… Read more

0 comments, 196 reads

Posted in BrianKMcDonald on 15 March 2011

SSRS – Creating and Using Shared Schedules Part 4

 

In a previous blogs, I discussed what shared schedules were and walked you through step by step instructions on how to create shared schedules. Then I showed you how to create a standard subscription using the shared schedule. In this final post of the series, I am going… Read more

1 comments, 849 reads

Posted in BrianKMcDonald on 8 March 2011

SSRS – Creating and Using Shared Schedules Part 3

 

In my two previous blogs in this series, I discussed shared schedules and walked you through step by step instructions on how to create shared them. In this post, I am going to show you how you can create a subscription using the new shared schedule.

If you… Read more

0 comments, 326 reads

Posted in BrianKMcDonald on 3 March 2011

Make a Goal! Map it Out! And Go For It!

I can’t tell you that all of your dreams will come true. I won’t tell you that you will make it halfway there! However, I will go out on a limb and make this statement. If you don’t make a goal and make a conscious effort to do what it… Read more

0 comments, 174 reads

Posted in BrianKMcDonald on 2 March 2011

SSRS – Creating and Using Shared Schedules – Part 2

In my previous post, I discussed what shared schedules were and how you could use them. With that knowledge under your belt, I can now show you how to create one using the enhanced report manager released with 2008 R2.

Step By Step

Fire up your internet browser and connect… Read more

0 comments, 478 reads

Posted in BrianKMcDonald on 2 March 2011

SSRS – Creating and Using Shared Schedules – Part 1

As you will see by the dates in my screenshots, I wrote them quite a while back while touring the world mastering the art of Ultimate Fighting. Yes, I consider it a form of art. Maybe that is why I forgot about this in my blog pile. One too many hits… Read more

1 comments, 882 reads

Posted in BrianKMcDonald on 28 February 2011

Adventure Works Sample Database Diagrams

 

Most of my examples utilize either adhoc type of data samples or one of the versions of AdventureWorks. I do this so that the reader (you) can see and duplicate my efforts. In working with the various versions of the AW databases, I’ve often completed web searches to look for… Read more

0 comments, 930 reads

Posted in BrianKMcDonald on 27 February 2011

Newer posts

Older posts