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 Selection Process

I was thinking today about why I submit sessions to speak at the PASS Summit.

My first summit was in Denver back around 2006 or 2007. We (my boss and me) saw an ad for it on SQL Server Central. We enjoyed every minute of the Summit and… Read more

0 comments, 76 reads

Posted in The Smiling DBA on 26 June 2015

PASS Excel BI VC presents Ásgeir Gunnarsson: End to End Risk Assessment – Using PowerView

Join us today at noon central for Asgeir presenting for the Excel BI VC.

Thu, Jun 18 2015 12:00 Central Daylight Time


PASS Excel BI VC presents Ásgeir Gunnarsson: End to End Risk Assessment – Using PowerView

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

END TO END RISK ASSESSMENT – AFFORDABLE SOLUTION USING POWER BI…

Read more

0 comments, 126 reads

Posted in The Smiling DBA on 18 June 2015

SQLSaturday #408 Houston

I have been selected again to speak in Houston (Saturday, June 13th) for a SQLSaturday event and look forward to connecting with some Texas PASS members like Nancy, Alan, Jen, Sean and many others. The facilities at San Jacinto College in the Southwest part of the Houston area were great… Read more

0 comments, 149 reads

Posted in The Smiling DBA on 4 June 2015

PASS Elections and Verifying Account

It is that time of the year when PASS starts a process to help update memberships and clean up duplicate account. I just Deactivated an old account setup in 2006 I never used.

Here is some more info and links. This material is copied from PASS website and emails.

Announcing…

Read more

0 comments, 125 reads

Posted in The Smiling DBA on 7 May 2015

My Favorite FREE Reports in SSMS

Microsoft has given us DBAs/Developers/etc. a wealth of free reports integrated into SQL Server Management Studio (SSMS) in order to see what is happening in our environment. These reports are really nice because you do not need to know the DMV/DMF in order to get the results.

The first report… Read more

0 comments, 128 reads

Posted in The Smiling DBA on 7 April 2015

PASS Excel BI VC presents Devin Knight on Getting Started on PowerQuery

Come join us Thursday April 2nd for an Excel BI virtual chapter session at noon central with Pragmatic Work’s Devin Knight who will help us get started with PowerQuery.

Thu, Apr 02 2015 12:00 Central Daylight Time


Getting Started with Power Query by Devin Knight

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

GETTING STARTED WITH…

Read more

0 comments, 152 reads

Posted in The Smiling DBA on 29 March 2015

Simple-Talk Article

In December, I was asked to write an article(s) on Database Refactoring. It started as 2 topics, but then consolidated into one. I really wanted to talk about the database design issues I see with a development department. Please give some time to reading the article and comment. First, I… Read more

0 comments, 172 reads

Posted in The Smiling DBA on 3 March 2015

SQLSaturday #362 – Austin, TX – Let’s Get Weird

I used to spend the 4th of July weekend (or week) in Austin with some buddy’s when we were in our 20s. There was so much to do and enjoy while there it is exciting to go back to this great city. Not only that, but there are some really… Read more

0 comments, 236 reads

Posted in The Smiling DBA on 20 January 2015

PASS – Connect, Share and Learn

The Professional Association of SQL Server (PASS) has a slogan for what they do – CONNECT, SHARE and LEARN. So, what does this mean to me and the SQL Server professionals I have meet in this community (#SQLFamily)?

 

First, I connected. Where did that start? SQLServerCentral.Com (SSC). I started… Read more

0 comments, 168 reads

Posted in The Smiling DBA on 18 December 2014

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, 269 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, 228 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, 400 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, 235 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, 281 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

0 comments, 250 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, 193 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, 213 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, 5,120 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, 209 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, 305 reads

Posted in The Smiling DBA on 5 May 2014

Older posts