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.

PASS Summit: Blogger Q&A with Board of Directors Executive Committee

On Thursday, I was invited as a blogger to attend an intimate conversation (Q&A) with the PASS Board of Directors: Adam Jorgensen (EVP – Executive Vice President), Denise McInerney (VP Marketing) and Thomas LaRock (President). I started to try to understand why I was asked, but gave up due to… Read more

0 comments, 149 reads

Posted in The Smiling DBA on 7 November 2014

PASS Summit 2014

Well, it is that time of year again. The Professional Associations for SQL Server (PASS) annual summit. This year we go back to Seattle where Microsoft mostly lives and hope we can get lots of their employees to visit and talk shop.

One of my main goals is to Network… Read more

0 comments, 105 reads

Posted in The Smiling DBA on 29 October 2014

Can’t Create A Timeline in Excel on Multidimensional Cube

Excel 2013 - We can’t create a Timeline for this report because it doesn’t have a field formatted as Date.

After getting excited about the Timeline object in Excel 2013, I tried to add this cool feature of Excel 2013 and got an error – “We can’t create a Timeline… Read more

0 comments, 131 reads

Posted in The Smiling DBA on 15 October 2014

PASS got it right

This morning I received an email (really 3 emails) about an extension for voting for the Board of Directors giving anyone registered with PASS before June of 2014. I think this is fair and gives those that have been active, but did not update their profile a chance to… Read more

2 comments, 158 reads

Posted in The Smiling DBA on 27 September 2014

PASS Summit 2014 Announcements

In case you do not receive the PASS connector, here are some announcements for this year’s summit on Nov 3rd – 7th.

Day 2 Keynote -  Dr. Rimma Nehme from Jim Gray’s System Lab

Apparently, Dr. Mehme is a Polybase and query optimization expert from Microsoft and she will be… Read more

0 comments, 161 reads

Posted in The Smiling DBA on 3 September 2014

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

2 comments, 159 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, 132 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, 153 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, 4,187 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, 162 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, 206 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, 223 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, 187 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,249 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,400 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, 159 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, 202 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, 192 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, 242 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, 175 reads

Posted in The Smiling DBA on 11 November 2013

Older posts