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

Jacksonville Code Camp 2012

Hello one, hello all. It has been quite a while since I have blogged. I am looking forward to starting back up and get in full swing of the things again. This is going to be a short blog post as I am just letting you all know about a… Read more

0 comments, 597 reads

Posted in BrianKMcDonald on 4 October 2012

SQL Saturday 85 Follow Up

Last weekend I travelled down to SQL Saturday 85 in Orlando, FL. Like all of the other events that I’ve presented at, this event was great. The last I heard, there were nearly 300 attendees and it seemed that all were very pleased with the event. Check-in went smoothly especially… Read more

0 comments, 487 reads

Posted in BrianKMcDonald on 2 October 2011

Dataset with Text or Stored Procedure

As most of you already know, Reporting Services reports make use of Datasets to get data. These Datasets can get the data from Text, Table (rarely used) or a Stored Procedure. Which query type to use has been a topic on many forum boards and I’ve had this question pop… Read more

0 comments, 652 reads

Posted in BrianKMcDonald on 2 October 2011

SQL Saturday 85 – Orlando

Grab your computer and get registered for SQL Saturday 85 in Orlando. If you’re new to the SQL world and have never heard of SQL Saturday, it is a free event put on by the SQL community…for the SQL community… This is an opportunity to learn new things and brush… Read more

0 comments, 490 reads

Posted in BrianKMcDonald on 19 September 2011

Task Factory's Surrogate Key Transform

Task Factory is a software product created by Pragmatic Works. It provides many custom SSIS components which help developers creating SSIS packages become more efficient. And as we all know, when we are more efficient, we are more productive. In this nugget, I’m going to show you how to use… Read more

0 comments, 606 reads

Posted in BrianKMcDonald on 3 September 2011

Task Factory's Secure FTP Task

Task Factory is a software product created by Pragmatic Works. It provides many custom SSIS components which help developers creating SSIS packages become more efficient. And as we all know, when we are more efficient, we are more productive. In this nugget, I’m going to show you how to use… Read more

0 comments, 813 reads

Posted in BrianKMcDonald on 3 September 2011

Task Factory: Email Source and Delete Email Task

Task Factory is a software product created by Pragmatic Works. It provides many custom SSIS components which help developers creating SSIS packages become more efficient. And as we all know, when we are more efficient, we are more productive. In this nugget, I’m going to show you how to use… Read more

0 comments, 550 reads

Posted in BrianKMcDonald on 3 September 2011

Task Factory: Data Validation Transform

Task Factory is a software product created by Pragmatic Works. It provides many custom SSIS components which help developers creating SSIS packages become more efficient. And as we all know, when we are more efficient, we are more productive. In this nugget, I’m going to show you how to use… Read more

0 comments, 695 reads

Posted in BrianKMcDonald on 3 September 2011

Task Factory: Data Cleansing Transform

Task Factory is a software product created by Pragmatic Works. It provides many custom SSIS components which help developers creating SSIS packages become more efficient. And as we all know, when we are more efficient, we are more productive. In this nugget, I’m going to show you how to use… Read more

0 comments, 480 reads

Posted in BrianKMcDonald on 3 September 2011

Task Factory: Compression Task

Task Factory is a software product created by Pragmatic Works. It provides many custom SSIS components which help developers creating SSIS packages become more efficient. And as we all know, when we are more efficient, we are more productive. In this nugget, I’m going to show you how to use… Read more

0 comments, 444 reads

Posted in BrianKMcDonald on 3 September 2011

Task Factory's Address Parse Transform

Task Factory is a software product created by Pragmatic Works. It provides many custom SSIS components which help developers creating SSIS packages become more efficient. And as we all know, when we are more efficient, we are more productive. In this nugget, I am going to show you how to… Read more

0 comments, 516 reads

Posted in BrianKMcDonald on 3 September 2011

Task Factory's: Terminator Destination

Task Factory is a software product created by Pragmatic Works. It provides many custom SSIS components which help developers creating SSIS packages become more efficient. And as we all know, when we are more efficient, we are more productive. In this nugget, I’m going to show you how to use… Read more

0 comments, 618 reads

Posted in BrianKMcDonald on 3 September 2011

Task Factory: File Properties Task

Task Factory is a software product created by Pragmatic Works. It provides many custom SSIS components which help developers creating SSIS packages become more efficient. And as we all know, when we are more efficient, we are more productive. In this nugget, I’m going to show you how to use… Read more

0 comments, 714 reads

Posted in BrianKMcDonald on 3 September 2011

Task Factory: Advanced Email and SMS Task

Task Factory is a software product created by Pragmatic Works. It provides many custom SSIS components which help developers creating SSIS packages become more efficient. And as we all know, when we are more efficient, we are more productive. In this nugget, I’m going to show you how to use… Read more

0 comments, 638 reads

Posted in BrianKMcDonald on 3 September 2011

JAX Code Camp 2011 Review and Slide Deck

Yesterday, my wife (twitter: @sherrilmcdonald) and I spoke at JAX Code Camp 2011 in Jacksonville, Florida. The event was well organized and gave me the idea that a lot of time was spent in making sure that nearly all of the 300 attendees (approx.) were well taken care of.… Read more

0 comments, 478 reads

Posted in BrianKMcDonald on 28 August 2011

JAX Code Camp 2011

 

For the past 7 years, Bayer White and other Jacksonville .Net leaders have put on great Code Camps for .Net Coders. It’s that time of year again and next weekend (Saturday August 27th, 2011) is going to be jammed pack with content to get you to the… Read more

0 comments, 493 reads

Posted in BrianKMcDonald on 19 August 2011

Columbus GA SQL Server Users Group Webinar Tomorrow

I found out last week from a good friend and President of the Columbus GA SQL Server Users Group, that they needed a speaker and would love to have me talk about SSRS. Since I have given SSRS presentations for the past two years, I should be able to whip… Read more

1 comments, 553 reads

Posted in BrianKMcDonald on 25 July 2011

End Of Month Function in Denali CTP 3

 

While playing around with Denali, I came across a function that I believe should have been included in SQL for years. It is called EOMONTH and it “returns the last day of the month that contains a specified date”. You can pass in any date value and it will return… Read more

2 comments, 833 reads

Posted in BrianKMcDonald on 17 July 2011

BI Documenter: Impact Analysis and Object Lineage

 

Are you considering making a change to your view or stored procedure? Or possibly you are considering moving your database to another server and you want to know how the move would impact your SQL Server. 

With one of Pragmatic Works software tools, BI Documenter, you can easily… Read more

0 comments, 1,190 reads

Posted in BrianKMcDonald on 13 July 2011

SQL Server 2011 CTP3 (Denali) 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… Read more

0 comments, 583 reads

Posted in BrianKMcDonald on 12 July 2011

Older posts