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

Archives: July 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, 545 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, 818 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,157 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, 575 reads

Posted in BrianKMcDonald on 12 July 2011

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, 588 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, 152 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, 438 reads

Posted in BrianKMcDonald on 1 July 2011