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
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
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
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
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
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
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
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
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
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
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…
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
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
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
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
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
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
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
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
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
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