Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

SQL UG Leaders: Reach Out to Your .NET Friends

In Baton Rouge we make no secret that our user groups and our 578-person SQLSaturday combines the volunteers and attendees of our local PASS chapter with our neighborly Baton Rouge .NET User Group. It's not just SQL folks attending our monthly meetings and annual event.

When discussing this, I've…

Read more

0 comments, 218 reads

Posted in SQL Tact on 9 August 2016

SQLSaturday Baton Rouge 2016!

Free SQL Server, SharePoint and .NET training

SQLSaturday is a global event to bring Information Technology speakers and professionals together for a community-driven, community-attended free day of technical training. The Baton Rouge SQLSaturday event is sponsored by the Baton Rouge SQL Server and .NET User Groups, and will be our…

Read more

0 comments, 149 reads

Posted in SQL Tact on 16 July 2016

Training To-Do List for New DBA

Are you an entry-level DBA, or looking to make the career switch? Feel like you are looking up from the bottom of a very tall ladder? Don't have much of a budget for training?

Here's a list of resources I'd recommend, in no particular order.

EDIT: I presented this content,…

Read more

5 comments, 3,286 reads

Posted in SQL Tact on 12 July 2016

SQL Server Admin Best Practices with DMV's at SQLSaturday Pensacola 2016

Great attendance and awesome questions from my 1130AM session on "SQL Server Admin Best Practices with DMV's". As promised, all the script files, including the demos we skipped for sake of time, and the entire info-packed slidedeck are available for download here on the official SQLSaturday Pensacola 2016 website.

Read more

0 comments, 243 reads

Posted in SQL Tact on 5 June 2016

SQLSaturday Pensacola Up Next For Me, Baton Rouge on the Horizon

Looking forward to the triumphant return of SQLSaturday Pensacola on June 4, thrilled that this start-of-summer tradition is back! This has been in the past a pilgrimage that the wife and I enjoyed in early June, and we'll both be there again now that the event is returned for the first…

Read more

0 comments, 183 reads

Posted in SQL Tact on 20 May 2016

Hello SQLSaturday Houston!

I've been looking forward to speaking at SQLSaturday Houston again all year!

Big thanks to the organizing crew behind this great event, poised to be Houston's biggest ever.

I'll be giving a presentation on SQL Server Permissions and Security Principals at 8:30am in room 148.

Also don't miss my colleague…

Read more

0 comments, 203 reads

Posted in SQL Tact on 13 May 2016

SQL Server 2016 at the BRSSUG Meeting on May 11

Looking forward to the BRSSUG/BRPBIUG meeting this Wednesday night May 11, I'll be giving a presentation all about SQL 2016!

This user group is sponsored by a free SQL 2016 sampler book from Apress, which is available for download for free from BRSSUG.org.

As have all meetings…

Read more

0 comments, 156 reads

Posted in SQL Tact on 9 May 2016

Columnstore Indexes: Finally Awesome in SQL 2016

Columnstore indexes are amazing for optimizing the performance of large rowcount queries that would otherwise look like a SCAN operation in an execution plan. Introduced in SQL Server 2012, they render the table read-only, however, and needed to be dropped (not even disabled) in order to insert/update/delete rows.

If you…

Read more

0 comments, 253 reads

Posted in SQL Tact on 21 April 2016

SSRS 2016 then SQL Jeopardy! tonight at BRSSUG!

See you tonight for our special SQL Jeopardy! competition where I will be your Trebek and three lucky user group participants will be our contestants!

Also a "special appearance" by our BRSSUG founder and Microsoft architect Patrick Leblanc, who will do a lightning round presentation on What's New in SSRS…

Read more

0 comments, 165 reads

Posted in SQL Tact on 13 April 2016

SQL Server PerfMon Counters Not Listed in dm_os_performance_counters

Had an issue with a new Azure VM install of SQL Server, but have had this issue in other, older places as well. SQL Server's performance counters in dm_os_performance_counters and/or perfmon have gone missing. How to get them back?

You might see a small subset of all performance counters here…

Read more

0 comments, 206 reads

Posted in SQL Tact on 5 April 2016

Azure ML and R at This Week's BRSSUG/BRPBIUG

This Wednesday night, not only are we going to be showcasing the technology of the internet with an online presenter from the other side of the world, but we're going to be seeing the first BRSSUG/BRPBIUG presentations on Azure Machine Learning and native R in SQL Server!

Really…

Read more

0 comments, 164 reads

Posted in SQL Tact on 7 March 2016

SQL Server Security Principals Lightning Round Presentation

Thanks for attending tonight's joint meeting of the Baton Rouge .NET/SQL/PowerBI User Groups, which was sponsored by Idera!

I presented a lightning round to the combined user groups on SQL Server Security Principals, which was a shortened version of a presentation I've given several times in the past. For this…

Read more

0 comments, 184 reads

Posted in SQL Tact on 10 February 2016

Easy Installing .NET 3.5 for SQL Admins

Rule "Microsoft .NET Framework 3.5 Service Pack 1 is required" failed.

This is a common problem and relatively easy fix for SQL admins installing a new SQL Server instance going back a few years, so it's about time to put all my notes about the solution into a single…

Read more

0 comments, 1,107 reads

Posted in SQL Tact on 21 January 2016

Announcing the Baton Rouge Power BI User Group

Baton Rouge is home to one of the inaugural Power BI User Groups, starting up soon! I'll be serving as its initial organizer, but I've already received a lot of feedback from the community and hope to form a new leadership team for the group soon.

Power BI is…

Read more

0 comments, 214 reads

Posted in SQL Tact on 5 November 2015

Congratulations New 2015-2016 BRSSUG Officers!

We elected new officers tonight for the Baton Rouge SQL Server User Group Official PASS Chapter, the second year in a row we've made an effort to do so.

We departed from a singleheaded user group mostly on the shoulders of a single volunteer. Prior to 2014, making things…

Read more

0 comments, 240 reads

Posted in SQL Tact on 14 October 2015

Presentation Downloads from SQL Saturday Columbus GA 2015

Thanks for joining us at SQL Saturday Columbus today on a gorgeous day to go inside and learn about SQL Server! And even bigger congrats to those of you who use Google maps and were still able to find the brand new event location at the Troy State University Riverfront…

Read more

0 comments, 297 reads

Posted in SQL Tact on 3 October 2015

Why I Don't Use the Architect Title

I get nervous when I see the title "architect" in IT job roles.

I've had this title before as an employer's standard, but lobbied against it. I instead prefer separating job titles from project roles.

Why?

"Architect" as an IT role descriptor carries an appropriate level of technical expertise and…

Read more

2 comments, 215 reads

Posted in SQL Tact on 28 September 2015

I Was Once a Very Crappy Carpenter + SQL Bolts to Buzzwords

Tonight I spoke to Dr. Alkadi's CMPS 411 class, which was hijacked by the Hammond .NET User Group onsite at Southeastern University! Thanks once again to Sparkhound who sponsored!

Here's the slide deck for my presentation, which combined two topics I wanted to talk about. The first, I Was Once…

Read more

0 comments, 302 reads

Posted in SQL Tact on 24 September 2015

Houston TechFest Presentation Downloads

Thanks for joining me at Houston TechFest 2015 at the NRG Center in Houston, TX! Big congrats to Michael and his crew of dedicated volunteers who once again put forward a first-rate free Saturday training event. I hope everyone enjoyed my presentations, our Sparkhound lunch session, our collar toss game…

Read more

0 comments, 267 reads

Posted in SQL Tact on 13 September 2015

SQL Saturday Baton Rouge 2015 Recap

SQL Saturday Baton Rouge 2015 was our 7th annual event, but we're still learning lessons. Here's my official Planning Committee Chair's recap of the event.


Here's one of the big new things we did this year:
  • We have a large, four-building facility for our event with multiple entry points. We…

Read more

0 comments, 411 reads

Posted in SQL Tact on 28 August 2015

Older posts