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, 643 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, 545 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, 711 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, 545 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, 683 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, 900 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, 624 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, 777 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, 537 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, 501 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, 572 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, 731 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, 794 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, 701 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, 527 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, 534 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, 599 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, 897 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,315 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, 701 reads

Posted in BrianKMcDonald on 12 July 2011

Older posts