• Categories

  • Recent Posts

  • Archives

  • Copyright Notice

    Copyright © Nancy Hidy Wilson, 2010-2013. Unauthorized use and/or duplication of this material without express and written permission from this blog’s author and/or owner is strictly prohibited. Excerpts and links may be used, provided that full and clear credit is given to Nancy Hidy Wilson and nancyhidywilson.wordpress.com with appropriate and specific direction to the original content.

Time For a Change

Shortly after the turn of the century (Y2K anyone?), I restarted the Houston Area SQL Server User Group (HASSUG) with the help of Tyler Chessman, who has been our local Microsoft liaison the entire time and without whom I couldn’t have run the group on my own for so long. I think the first meeting was in 2001, but I no longer have records going back that far to pinpoint the exact startup date. I know we met bi-monthly for the first year or so and then moved to monthly meetings in January 2003. We became a PASS affiliated Chapter when they began that program. In 2013, we combined the meetings for the Houston Area SQL Server User Group and the Houston BI User Group (which Tyler sporadically ran) into a single meeting with 2 topic presentations, one of which is always focused on the BI stack.

So, here we are some 14+ years later, having held 160+ meetings and having executed 4 SQLSaturdays, and it is time for me to hand over the reins of the group to some new leadership. Lynn McKee and Derek Wilson (no relation!) are now the official co-leaders of the group. Lynn and Derek have been shadowing me for the past few months as “chapter leaders in training” and I am more than satisfied that they are committed and ready to take the group to the next level.

I will still be around – attending meetings and presenting when needed (like in July and again in August!). I also promised Allen Kinsel (who took the lead on the past two SQLSaturday Houston events) that I’d help with the next SQLSaturday, too. And now he has it in writing, in public, for all to see! Leading the local chapter has given me the opportunity to meet so many wonderful people in our SQL Server community (aka #SQLFamily) – and not just locally. Participating in the Chapter Leader meetings at PASS Summit every year I look forward to engaging with other leaders from around the world. Over the past 15 years that I’ve attended Summit, so many of them are #SQLFamily to me now, too. It has been a great run and part of me will miss it, but I’m excited to be passing the torch to Lynn and Derek. They have some great ideas for the future and I hope you will give them your full support. After all, this is a volunteer job – we all do it for the love of the community.

If you’d like to volunteer to speak, sponsor, or otherwise help with the group, you can continue to use the HASSUG@sqlpass.org email account to contact Lynn and Derek. Follow the @HASSUG and @SQLSatHou Twitter accounts for info and keep an eye on the website for upcoming meeting info.

See you at the next meeting!

SQLSaturday #423 Baton Rouge – I am Speaking

I’m honored to be presenting again at SQLSaturday Baton Rouge on August 1, 2015. My topic is “Managing SQL Server in the Enterprise with TLAs”. What are TLAs, you ask? Why Three-Letter-Acronyms, of course! The TLAs which I will be discussing that you should be utilizing are CMS, PBM, and EPM. Come to my session in Room 1220 at 12:15pm and find out how using these features will improve your productivity!

If you are involved in almost any kind of IT work within driving distance of Baton Rouge, you should consider attending this free day of learning. Although using the SQLSaturday branding, there are more topics to be covered than just SQL Server. In addition to the traditional SQL Server AppDev, DBA, and BI tracks, there are tracks for .NET developers, SharePoint, Web/Mobile Development, Windows Server & Virtualization, Career Development, IT Managers, and more!

Check out the entire schedule, including low-priced Pre-con sessions on Friday, and register today to join more than 600 IT workers taking advantage of this free training!

If you can’t attend this event, then check here for all the currently scheduled SQLSaturdays in the US and around the world! There is likely one occurring near you soon!

TSQL2sday #68 – Just Say No to Defaults

T-SQL Tuesday (aka #TSQL2sday) is a monthly SQL Server blogger event started back in late 2009 by Adam Machanic (blog | twitter). For more info on its beginning and purpose see the origin of TSQL2sday. Each month a different SQL Server blogger is the host (announces the theme and compiles a recap). This month’s event is hosted by Andy Yun (blog | twitter) and the selected theme for this month is “Just Say No to Defaults”.

This is really embarrassing, but I’ve had a blog post started for this topic for years and somehow never got around to finishing it! Thanks, Andy, for giving me a reason to finally address a couple of my “must change” defaults.

Ease of installation is definitely a feature that has helped SQL Server to proliferate. You can have a functional system just by running setup and clicking Next, Next, Next….Finish! Without having to make any real decisions about what you are doing, you can be up and running in no time.

When installing the database engine component, the first change to be considered from the defaults presented during setup is the location of the various file types – however, I’m going to save that for others to address and may come back to it in a future post.

Today, I’m going to address a default that you can’t change during the setup dialog or via configuration file parameters. It must be adjusted post-install and is for SQLAgent.

Ever go to review the job history for a job and find nothing or only a couple of recent entries and you know the job has been running for weeks or even months? So, where is all that history? Sorry, you were the victim of the ridiculous defaults shown below which limit the total number of rows in the msdb.dbo.sysjobhistory table as well as set a max number of history rows per job.

To find this dialog in SSMS, right-click on SQLAgent, then select Properties, then select History.

SQLAgentHistoryProperties

These are defaults that you definitely want to change. In fact, instead of just increasing the number of maximum rows for the table and per job, I’d recommend that you decide on the time frame that you want to keep your SQLAgent job history and uncheck the “Limit size of job history log” option and check the “Remove agent history” option and specify the desired time frame instead as shown below. Many companies already have specifications for how long to retain activity logs, so using the time period that meets or exceeds those requirements should be helpful when it comes audit time.

SQLAgentHistoryProperties_ByTime

Depending on the number of jobs and the frequency at which each is run, you may also need to keep a close watch on the size of msdb after changing this setting to find the optimum size for your msdb files to allow the sysjobhistory table to grow to its expected size without causing autogrow of your files. Remember to manage msdb just like any other application database with appropriate purges, backups, and other maintenance.

I can’t wait to see what others say “no” to in Andy’s round-up for this event. I’ll be looking for my other must change items and if I don’t see them, then I will be posting more soon!

SQLSaturday #408 Houston – Announcement

As Chapter Leader of the Houston Area SQL Server User Group, I’m happy to announce that we are having our 4th SQLSaturday in Houston; and we are returning to the great facility we used last year at San Jacinto College – South! Coordinating the event again this year is Allen Kinsel along with a host of other volunteers. Set aside Saturday, June 13, 2015, for a day of free SQL Server training.

The schedule is now posted and we have 48 sessions covering Database Administration, Application Development, Business Intelligence, Cloud, and Professional Development. We also have a great range of speakers presenting all those topics from local gurus to Microsoft MVPs. And, of course, we are having Texas BBQ again (there will be a vegetarian option) for lunch. Plus, during the lunch break our Gold Sponsors will be holding additional sessions where you can go learn more about their product offerings.

So, register today (last year we had a waitlist!) and join 400 other SQL Server professionals in a great day of networking and learning! You’ll be requested to pay $10 via PayPal when you register to help defray the cost of lunch and snacks, but otherwise, this is a free event.

If you are wondering about the #408 – each SQLSaturday event gets assigned a number when it goes on the schedule. Our first SQLSaturday back in 2011 was #57, so there have been approximately 350 other SQLSaturdays held around the world in the past 4 years! That’s a lot of awesome free training!

Oh – and did I mention that at the end of the day, our sponsors will have lots of great prizes they’ll be raffling off! So, plan to stay until the end!

SQLSaturday #362 Austin – I’m Presenting

SQLSaturday is finally happening again in Austin (technically in Round Rock) on January 31, 2015 and I’m glad to announce that I will be presenting. My topic is “CIS Benchmarks: Your Guide to Consensus Security”. The Austin SQL folks have been great participants at the past SQLSaturdays that we’ve held in Houston, so I’m glad to promote and participate in their event. There is a great lineup of speakers and topics which you can see here. There are also a couple of pre-conference seminars on Friday. Check out all info for content and registration here.

If you aren’t familiar with SQLSaturday, this is a FREE training event put on by local SQL Server User Groups. The event concept has grown greatly over the past several years and on almost every Saturday of the year, there is one or more SQLSaturdays occurring somewhere in the world.

There are just a few more days to register – hope to see you there!

SQLSaturday #308 Houston – Selected Sessions Final

Thanks to everyone who submitted sessions for SQLSaturday #308 in Houston on May 10th. I think this was definitely the most difficult selection process of the 3 SQLSaturdays that we have held. Lots of great sessions were submitted from a really large pool of speakers. For those who were not selected – PLEASE do not take this personally! It primarily came down to a balance of session topics spread across as many speakers as possible – we have 48 speakers for 60 sessions.

If you only submitted one session and we had multiple similar sessions to choose from then if your abstract didn’t really stand out in that category, it may not have been selected. If you only submitted one session on a topic that no one else submitted and we did not select it, it may be because we thought the topic was too narrow or the abstract didn’t clearly express what you planned to present. If you think it may be your abstract keeping you from being selected, check out any of several posts that Brent Ozar has done over the years on Abstract writing for tips to improve. And, in the future I would recommend submitting at least 2 topics for program committees to choose from to improve your chances!

So, with that all said, here are the selected sessions alphabetized by speaker last name.

Last Name First Name Session Title
Adams Ryan SQL 2012 AlwaysOn Quickstart
Adams Ryan How Active Directory affects SQL Server
Bansal Amit R S Mind your IO: Resource Governor shows you How
Barnes Bill Fill Factor: Performance or Nuisance?
Bell Chris The Spy Who Loathed Me – An Intro to SQL Security
Bertrand Aaron T-SQL : Bad Habits & Best Practices
Bertrand Aaron Top 5 Ways to Write Effective triggers
Bourgon Michael SQL Watchdog – find out instantly when SQL changes in production
Brown Wesley Fundamentals of SAN, NAS and IP Storage
Chaves Warner The Super Trace: Introduction to Extended Events
Cherry Denny Storage For the DBA
Clark Tamera 45 min to build your first SSRS report
Cook John SQL Server 2012 Analytic Functions
Costello Tim Windowing Functions
Costello Tim Pro Tips: Tuning the data flow in SSIS
Curnutt Mindy SQL Server Bingo – Install, Migration & Config
Cutshall Aaron The Lost Science of Set Theory and Relational Algebra
D’Antoni Joseph SQL Server–All About HA and DR
D’Antoni Joseph In-Memory Columnstore Indexes–Make Your Data Warehouse Fly
Edmondson Garret Measuring Data Warehouse Performance
Edmondson Garret Data Warehouse ETL
Edwards Lori SQL Server Statistics – What Are The Chances?
Gable Glenda Data Warehouse Indexes
Harp Vicky Edge Case Testing for the Database Professional
Harp Vicky Care and Feeding of Your System Databases
Hays Mike Troubleshooting Your Network Connections
Herold Amy Making the Leap from Developer to DBA
Hokanson Kris Beyond the Where: Full Text Search tips and tricks
LeBlanc Thomas Attributes & Hierarchies in Analysis Services 2012
LeBlanc Thomas Execution Plan Basics – Beginners
Lopez Carlos The Transaction Log Internals
Lopez Karen Database Design Contentious Issues
Lopez Karen Windows Azure SQL Database Design: Concepts and Trade-offs
Loski Russ Introduction to BIML and BIMLScript
Loski Russ SSIS project deployments with multiple developers
McCown Jennifer T-SQL Code Sins
McCown Sean DIY Performance Reporting
McCown Sean & Jennifer DBA Career Roadmap
Mendo AJ DBA Survival Guide: Daily Checklist and Server Monitoring
Mitchell Tim Scripting in SSIS
Mitchell Tim 15 Quick Tips for SSIS Performance
Moreign Valentino and Anthony {Tex} The Cloud and I
Murphy Jim Mission Possible: Interactive Performance Troubleshooting – Indexes
Norman Tom Converting Unreliable Deployments Into Consistent Releases
Parekh Aashish Speed, Depth & Flexibility – Having it all with real-time SSAS
Rodarte Rudy Expand your TSQL: Intersect, Except, and Apply
Schilling Dane Taming the T-Log
Serra James Best Practices to Deliver BI Solutions
Serra James Enhancing your career: Building your personal brand
Speshock Carl Microsoft Predictive Analytics/Data Mining Overview
Stein David Writing Your First BimlScript
Sterrett John Table Partitioning: the Secret Weapon for your Big Data Problems.
Sterrett John Proactive Monitoring with PBM and CMS
Stewart Robert SSAS – An Introduction to Multidimensional Cubes
Tidwell Lance SQL Server Agent: The life preserver for the drowning DBA
Wilson Derek Tabular Data Visualized by PowerView
Wong Jason Ah, ha, how do you automate database administration?

If you are thinking there are some pretty big topics missing from the above list, you are correct! We will be having 3 additional sessions presented by TechEd speakers on PowerBI, Hybrid Cloud, and In-Memory.

The final schedule will be posted on the SQLSaturday #308 website in the next few days! So stay tuned!

 

SQLSaturday #308 Houston – Speaker Selections #3

Today (March 21, 2014) is the final day for speakers to submit their sessions for SQLSaturday #308 in Houston on May 10.  We are already building up a great slate of speakers (announced here and here) and today we are pre-announcing that the following MVP speakers will also be presenting:

  • John Paul Cook (website)   – SQL Server 2012 Analytic Functions
  • Tim Mitchell (twitter | website) – to be determined SSIS topic
  • James Serra (twitter | website) – BI/DW or Professional Development session topic still to be determined

Stay tuned for the complete slate and schedule to be finalized soon!

Spread the news to your colleagues and register to attend this free training event now as space will be limited!

Follow

Get every new post delivered to your Inbox.

Join 472 other followers