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

The Smiling DBA

Thomas LeBlanc ( MCITP 2005/2008 & MCDBA 2000) is a Senior SQL Server DBA at Turner Industries, LLC in Baton Rouge, LA. He has been in the IT field for 21 years starting as a COBOL programmer, graduating to dBase, FoxPro, Visual FoxPro, upgrading to Visual Basic versions 3-6 and even some .Net(C#). Designing and developing normalized database has become his passion. Full-time DBA work started about 9 years ago for Thomas while working at a Paper Mill in St. Francisville, LA continuing with IEM, then Amedisys. Performance tuning and reviewing database design and code was an everyday occurrence for DBAs at Amedisys. Thomas’ free time is spent helping those less fortunate and improving his relationship with his family and God.

Upcoming PASS Virtual Chapter Webcast (FREE!!!)

As always, there are many free ways to learn more about SQL Server and the Professional Association of SQL Server (PASS) free membership to Virtual Chapters is one of those ways.

Here is what I would suggest watching:

 

Next Meeting: Tue, Aug 12 2014

Bridging the Communication Gap Between…

Read more

0 comments, 102 reads

Posted in The Smiling DBA on 8 August 2014

PASS Data Arch VC presents SQL Server MVP Grant Fritchey - How to Build a Database Deployment Pipeline

Please come join the Data Architecture VC this Wednesday to get info from MVP Grant about Database Deployment something all DBAs should be doing to work with developers.

Grant Fritchey – Microsoft MVP

July 23, 2014 Noon CST

How to Build a Database Deployment Pipeline.

The pace of business accelerates…

Read more

0 comments, 100 reads

Posted in The Smiling DBA on 21 July 2014

Upcoming Free PASS VC Webcasts

Here is a list of upcoming webcast presented by various PASS Virtual Chapters that are always free. Some are recorded to view later.

 

Database Administration VC

Date: July 9

Noon Mountainhttp://www.timeanddate.com/worldclock/fixedtime.html?msg=PASS+DBA+Virtual+Chapter&iso=20140709T12&p1=75

Topic: How to be a great DBA– sponsored by Dell Software

Registration: You must register…

Read more

0 comments, 131 reads

Posted in The Smiling DBA on 8 July 2014

5 Things to Know About Indexes for SQL Server

One of the first questions I got while interviewing for a potential position as a DBA was “If there is performance problem, where is the first place you would look?”

Now at this time, I was trying to move from Software Developer to DBA, and I answered that I would… Read more

0 comments, 3,653 reads

Posted in The Smiling DBA on 19 June 2014

SQLSaturday #308 Houston, TX Saturday May 10th

This will be the second SQLSaturday in Houston I have spoken at and I am excited about talking Execution Plans and Multidimensional Analysis Services. These are 2 topics I deal with on a daily basis, so it is great I get to help others understand these technologies.

I also get… Read more

0 comments, 134 reads

Posted in The Smiling DBA on 7 May 2014

SQLSaturday #305 Business Analytics Edition Dallas–RECAP

So, I am flying home thinking about the event Saturday and many things are running through my head. No, not work on Monday. First, I would like to say that Hadoop is not going to replace SQL Server nor Business Intelligence. Second, a new thing is coming but it is… Read more

0 comments, 158 reads

Posted in The Smiling DBA on 5 May 2014

SQLSaturday #305 Dallas Business Analytics Edition

I am excited about being selected to speak and attend the May 3rd SQLSaturday BA Edition in Dallas, TX. There are a number of sessions I want to attend including Eric Mezell’s An Introduction to Hadoop, Andy Egger’s Applied Predictive Analytics, David Browne on Enterprise Business Intelligence (for lunch) and… Read more

0 comments, 158 reads

Posted in The Smiling DBA on 23 April 2014

Call for Speakers – SQLSaturday #324 Baton Rouge

Baton Rouge is now on its 6th SQLSaturday and the event grows year after year. It all started with Patrick LeBlanc back in 2009 with #17 http://sqlsaturday.com/17/eventhome.aspx and with help from local User Groups (William AssafSparkhound), it has expanded its topics and attendees. This event is… Read more

0 comments, 148 reads

Posted in The Smiling DBA on 11 April 2014

5 Tools Every DBA Should Know About

After monitoring enterprise SQL Server instances for over 10 years now, there are 5 tools that are used every day for spot check views of a system. The order here is not a countdown from 5 to 1. They are presented here in no particular order, because each has its…

Read more

4 comments, 5,054 reads

Posted in The Smiling DBA on 25 March 2014

5 Things a developer should know about databases

 

Database Normalization

Theoretical versus real-world

There is not a strong need for developers to know the theoretical definition of 1st thru 5th normal form, but there needs to be an understanding of some design practices. The keys are:

  1. No Duplicate data in columns in one table
  2. Relationships built as…

Read more

9 comments, 4,236 reads

Posted in The Smiling DBA on 9 March 2014

Jan PASS Data Architecture VC presents Ike Ellis on Tips & Tricks

Please join the PASS Data Architecture virtual chapter on Thursday Jan 30th at noon central for SQL Server Tips and Tricks presented in 5 minute lectures.

DataArch.SQLPass.org

Next Meeting

Thu, Jan 30 2014 12:00 (GMT-06:00) Central Time (US & Canada)


RSVP: https://attendee.gotowebinar.com/register/2529334496189827586

This is a SQL presentation for the YouTube…

Read more

0 comments, 136 reads

Posted in The Smiling DBA on 28 January 2014

PASS BI/DW Virtual Chapter–Analysis Services Attributes and Hierarchies

Please join the PASS BI/DW VC today January 15th at 7PM Central for a presentation on Attributes and Hierarchies in Analysis Services 2012. This is a presentation I have shown at 2 SQLSaturdays and the Baton Rouge SQL Server User Group as well as 24 Hours of PASS.

http://bi.sqlpass.org/

Next…

Read more

0 comments, 172 reads

Posted in The Smiling DBA on 15 January 2014

Jan 8th – Baton Rouge SQL Server User Group - Azure

Please join us tonight, Wednesday Jan 8th starting at 5:45PM with networking and food. The information below is from the BRSSUG Website: http://www.brssug.org/

January '14 Baton Rouge User Groups Meeting - Azure!

Topic: Microsoft Azure!

This is an all user groups on deck meeting! SQL, .net, SharePoint, IT Pro, La-WIT…

Read more

0 comments, 155 reads

Posted in The Smiling DBA on 8 January 2014

Data Architecture VC hosts Nigel Sammy: TSQL Tips and Tricks

Please join the Data Architecture Virtual Chapter as they host SQL Server MVP Nigel Sammy his take for T-SQL Tips and Tricks for developers and DBAs.

Thu, Dec 19 2013 12:00 (GMT-06:00) Central Time (US & Canada)

Nigel Sammy - T-SQL: Tips and Tricks

RSVP: https://attendee.gotowebinar.com/register/5187602867480253442

Queries are running longer…

Read more

0 comments, 209 reads

Posted in The Smiling DBA on 18 December 2013

PASS Data Architecture VC presents Steve Simon–Challenges to Designing Financial Warehouses

Please join the Data Arch VC with Steve Simon this Thursday Nov 14th at noon central for a great look at Steve’s experience while implementing a financial data warehouse.

https://attendee.gotowebinar.com/register/3299406050712061698

Next Meeting

Thu, Nov 14 2013 12:00 (GMT-06:00) Central Time (US & Canada)


Challenges to designing financial warehouses

Summary:

In…

Read more

0 comments, 145 reads

Posted in The Smiling DBA on 11 November 2013

Summit 2013 Review!!! plus SQLSaturday #237 Charlotte BI Edition

The week is over and I waiting for my flight home. I did not to get to as many sessions as past summits, but that was replaced with speaking opportunities consisting of 1 half-day session, a 75 minute regular session and speaking at the Charlotte BI SQLSaturday.

Tuesday was a… Read more

0 comments, 219 reads

Posted in The Smiling DBA on 20 October 2013

My PASS Summit Schedule this Week

Well, it is here folks. The PASS Summit 2013. If you have never been to a PASS Summit, please look in to attending one year. There is more SQL Server Learning than you could fit in a month. You just need to break it down into digestible chunks.

Monday… Read more

0 comments, 141 reads

Posted in The Smiling DBA on 14 October 2013

Houston Tech Fest 2013

I am traveling (driving) with the family to Houston to present on SSIS 2012 at Houston Tech Fest 2013 at the Reliant Center. The session in the first of the morning in the database track. SSIS 2012 has lots of new features, but this presentation focuses Change Data Capture component,… Read more

0 comments, 193 reads

Posted in The Smiling DBA on 25 September 2013

PASS Data Arch VC presents Louis Davidson Relational Database “Good Enough”

Please join us Thursday Sept 12th at noon Central for the monthly Data Architecture Virtual Chapter presentation. We will have SQL Server MVP talking about relational databases. Please don’t miss this session which is a preview to the Pre-Conference session Louis will be doing at the PASS Summit 2013 in… Read more

0 comments, 148 reads

Posted in The Smiling DBA on 10 September 2013

Baton Rouge SQLSaturday and Tech Day 2013

This will be the fifth SQLSaturday and Tech Day in Baton Rouge, LA on Saturday August 3rd, 2013.

I found a collection of SQLSaturday, SQLRally and PASS Summit shirts with various stickers collected over the last 5 or 6 years.

It is going to be hot this weekend in Baton… Read more

0 comments, 157 reads

Posted in The Smiling DBA on 1 August 2013

Older posts