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, 97 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, 634 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, 101 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, 2,213 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, 219 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, 80 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, 89 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, 301 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, 140 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,008 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, 235 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, 449 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, 105 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, 593 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, 59 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, 85 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, 74 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, 84 reads
Posted in SQLDownSouth on 2 September 2009



Subscribe to this blog