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

Archives: September 2009

SQL Lunch Starting at 11:30 CST

If you are available for lunch today don’t forget to sign in and watch Thomas LeBlanc talk about Historical DMV information.  To attend the meeting use this URL:  https://www.livemeeting.com/cc/usergroups/join?id=F7DRFD&role=attend.  Also, if you would like to receive notifications about upcoming SQL Lunches register here:  http://www.tsqlscripts.com/SQLLunch.aspx

See you at Lunch Read more

0 comments, 158 reads

Posted in SQLDownSouth on 28 September 2009

Reporting Services - Disable Loop Back Check

I have been installing and configuring SSRS since the initial release.  I have always encountered several different caveats when upgrading to a newer version or adding a new server to a scale-out deployment.  In some cases there have been consistencies, but in many these differences vary.  These variances may have… Read more

0 comments, 1,180 reads

Posted in SQLDownSouth on 28 September 2009

Upcoming SQL Lunch – Historical DMV Information

Date: 9/28/2009

Time: 11:30 AM

Meeting URL: https://www.livemeeting.com/cc/usergroups/join?id=F7DRFD&role=attend

Presenter: Thomas LeBlanc. Thomas is a Database Administrator for Amedisys, Inc in Baton Rouge, LA. He has been in the IT field for 20 years starting as a COBOL programmer, graduating to dBase, FoxPro, Visual FoxPro, VB 3 thru 6 and… Read more

0 comments, 156 reads

Posted in SQLDownSouth on 25 September 2009

Trace Flag 1118

Yesterday morning around 6AM, my Blackberry started going off.  The subject line of every email was, “SQL Timeouts”.  In the past, this was a direct result of my Index Rebuild or Defrag nightly process.  However, since I have implemented a process that is able to recognize when the Index job… Read more

2 comments, 3,451 reads

Posted in SQLDownSouth on 25 September 2009

SQL Lunch – Pick your favorite Logo

We have been working on the logo for a month now, but instead of making the final decision I have decided to leave it up to the public.  I have posted it out on my FaceBook page and sent out a few emails.  We have narrowed the choices to the… Read more

1 comments, 278 reads

Posted in SQLDownSouth on 23 September 2009

TSQLScripts.com – Script of the Week

After about 3 weeks of digging through .css files and html code I finally found the problem with the site.  The Master page was missing a small tag at the end that stopped the Content Area from expanding to 100% in height.  Now that all of that is fixed, I… Read more

0 comments, 149 reads

Posted in SQLDownSouth on 21 September 2009

Upcoming SQL Lunch (Live Meeting) – Historical DMV Information

The next SQL Lunch is scheduled for Monday, September 28.  See below for details

Date: 9/28/2009

Time: 11:30 AM

Meeting URL: https://www.livemeeting.com/cc/usergroups/join?id=F7DRFD&role=attend

Presenter: Thomas LeBlanc. Thomas is a Database Administrator for Amedisys, Inc in Baton Rouge, LA. He has been in the IT field for 20 years starting as… Read more

0 comments, 157 reads

Posted in SQLDownSouth on 21 September 2009

SQL Server 2008 R2 August CTP – Utility Control Point (UTP)

I finally carved out some time in my day to try and get the August CTP of SQL Server 2008 R2 installed.  I really decided to get this done after a read the short blurb in the latest eWeek Magazine titled, First Look At Microsoft SQL Server’s Future, which led… Read more

1 comments, 481 reads

Posted in SQLDownSouth on 18 September 2009

Article of the Week – Kevin Kline “Social Media Scene”

This weeks article is written by Kevin Kline, which is titled “Getting Up-to-Speed on the SQL Server Social Medial Scene”.  This article is published in the latest edition of Database Trends and Applications.  In the article Kevin discusses the new social media or networking sites that are available.  Kevin… Read more

3 comments, 219 reads

Posted in SQLDownSouth on 16 September 2009

Windows Internal Database

This past Friday I received a call from our systems team stating that they were running low on Disk Space on a SQL Server server that their team used for Share Point.  He stated that there was an .LDF file that was really large, and could he just delete it. … Read more

7 comments, 1,723 reads

Posted in SQLDownSouth on 14 September 2009

Today’s SQL Lunch - Oracle-CDC for SQL Server Integration Services

Join us today for a SQL Lunch

Date: 9/14/2009

Time: 11:30 AM

Reserve your seat: https://www1.gotomeeting.com/join/509742840

Presenter: Jeff Cole. Jeff has been designing and building information technology systems for over 20 years. He has experience across many industries including banking & finance, health care and telephony… Read more

0 comments, 329 reads

Posted in SQLDownSouth on 14 September 2009

.Net SQLConnectionStringBuilder ApplicationName Property

We have several “Home Grown” applications at my current place of employment.  This provides our development staff with a great deal of flexibility.  We are allowed to upgrade to new versions of software at our own schedule.  We have full control of the source code and can modify it to… Read more

3 comments, 693 reads

Posted in SQLDownSouth on 11 September 2009

SQL Lunch - Oracle-CDC for SQL Server Integration Services

We have been working hard trying to get speakers to complete the year for our SQL Lunch schedule. I am excited to announce the beginning of the Learning Series. Our next meeting is on 9/14/2009 at 11:30 AM.  If you would like to receive updates about upcoming SQLLunch meetings go… Read more

0 comments, 188 reads

Posted in SQLDownSouth on 10 September 2009

SQL Server 7.0 – Transaction Log Not Backing Up

I have not worked with SQL Server 7.0 in a loooong time.  So when I received a call from a client complaining about their Transaction Logs not backing up, I was stuck for a few minutes.  My initial thought was check the recovery model, but as I jogged my memory… Read more

3 comments, 882 reads

Posted in SQLDownSouth on 9 September 2009

Speaking to Association of Information Technology Professionals (AITP)

On Monday August 1st I had the pleasure of speaking to a group of college students that all belong to the AITP.  I always enjoy talking to college students because they are always inquisitive.  They all want to know how to find jobs.  Unfortunately, that is a tough question to… Read more

0 comments, 120 reads

Posted in SQLDownSouth on 4 September 2009

Speaking At SQL Saturday #21

Well looks like I will be packing my bags for Sunny Orlando.  I Just found out that my abstract was selected for SQL Saturday #21 in Orlando, FL.  Last week or maybe the week before I decided to submit a session, Using the CLR to monitor Disk Space.  My… Read more

2 comments, 139 reads

Posted in SQLDownSouth on 4 September 2009

TSQLScripts.com and IE 8

Wow, I just got an email from a registered member of www.tsqlscripts stating that it is not compatible with IE 8 and Firefox.  I am going to spend the weekend working on this and I will hopefully have it resolved by Monday.  Thanks for the heads up.

Talk to you… Read more

0 comments, 126 reads

Posted in SQLDownSouth on 2 September 2009

Article of the Week – SQL Server 2008 T-SQL Enhancements

I have been following this series of articles since the first article was published on SQLServerCentral.  The author, Arshad Ali, has written several articles on SQL Server 2008 T-SQL Enhancements.  The latest of the five articles was one of the featured articles on Monday, August 31st ( Read more

0 comments, 206 reads

Posted in SQLDownSouth on 2 September 2009