SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Attracting Non-Technical Speakers to Your SQLSat Events

Fellow DBA and community leader Peter Shore of the Columbus SQL PASS UG and SQLSat Columbus OH asked me via Twitter, "What is the best way for us to have a discussion about how you handle SQLSatBR? I am curious about the none data platform tracks, how you attract other…

Read more

0 comments, 168 reads

Posted in SQL Tact on 4 December 2017

SQLSat Organizers and UG Leaders Meetings at PASS Summit - Tips and Tricks notes

At the SQLSat Organizers and UG Leaders Meetings at PASS Summit meetings last week, we were given an opportunity to share "tips and tricks" with other leaders, and I had the opportunity to.

Now that I'm home (despite a thrilling late-night sprint through IAH to make a connecting flight) and starting…

Read more

0 comments, 137 reads

Posted in SQL Tact on 6 November 2017

The #SQLSAT Speaker Goodie Bag

Last summer, I heard about an awesome idea for speaker gifts at SQLSat Pensacola 2017 from organizer Karla Landrum and Tamera Clark (SQLSat Nashville). It was our 9th year of SQLSat Baton Rouge, we've had polo fatigue and were looking for fresh ideas for useful, memorable speaker gifts. SQLSat Nashville's…

Read more

0 comments, 203 reads

Posted in SQL Tact on 29 October 2017

VS Code: PowerShell and focusConsoleOnExecute

If you're used to the behavior of SSMS or PowerShell ISE where upon executing code in the script panel, your cursor stays in the script panel, then the behavior of Visual Studio Code's PowerShell default might be annoying. By default in Code, your cursor moves down to the PowerShell console…

Read more

0 comments, 149 reads

Posted in SQL Tact on 3 October 2017

Twilight Timezone: Date and Time Architecture in your Applications aka Use DateTimeOffset, Your Future Self Thanks You

Thanks to everyone at a joint meeting of the Baton Rouge .NET and SQL Server User Groups who joined my colleague Steve Schaneville and me for a presentation on date/time data architecture in modern applications last night.

We reviewed the SQL and .NET architecture for date/time storage an informative and…

Read more

0 comments, 184 reads

Posted in SQL Tact on 14 September 2017

SQLSat Planner's Calendar

We just completed our 9th annual SQLSaturday Baton Rouge. In my post-mortem of the event, I've updated and tweaked the living, breathing SQLSaturday Planner's Calendar that I've been crafting for a couple years now.

If you are a SQLSaturday organizer of any level of veterancy, you may find this…

Read more

0 comments, 198 reads

Posted in SQL Tact on 4 August 2017

Twilight TimeZone: Handling Time in Your App Architecture at SQLSaturday Baton Rouge

Thanks to everyone who joined my colleague Steve Schaneville and me for a presentation on date/time data architecture in modern applications. Steve and I are the principal consultants for appdev and SQL Server respectively at Sparkhound, and figured that a joint presentation on this topic would be valuable.

It was!…

Read more

0 comments, 295 reads

Posted in SQL Tact on 31 July 2017

Change RegisterAllProvidersIP setting on an existing Availability Group

Was working with a client who had an existing Availability Group, but did not have the RegisterAllProvidersIP setting enabled on their cluster. So, recent changes to their connection strings to take advantage of MultiSubnetFailover to minimize failover re-connection delay wasn't helping. Multisubnet failover needs to see both Listener IP's to…

Read more

2 comments, 1,351 reads

Posted in SQL Tact on 30 July 2017

SQLSaturday Baton Rouge at LSU on July 29

The big finale to our SQL Summer and the last of the three Gulf South 2017 SQLSat events, our 9th annual SQLSaturday features an 11-track lineup of speakers from around the country, assembled by our scheduling extraordinaire Kenny Neal.

The schedule includes a whole track of PowerBI experts,…

Read more

0 comments, 252 reads

Posted in SQL Tact on 19 July 2017

Celebrate Your Independence with Free Tools

Been working on this blog post for a while, thought I'd share today an inventory of tools I use regularly that are free to the DBA.

A nearly ubiquitous free Microsoft-provided download to provide for easy zooming, live zooming, drawing on your screen, and more. It is something…

Read more

0 comments, 391 reads

Posted in SQL Tact on 4 July 2017

SQL Server Permissions and Security Principals on UserGroup.tv

You can now watch my presentation on SQL Server Permissions and Security Principals from SQLSaturday Houston 2017 on UserGroup.tv, a site dedicated to capturing presentations just like this, run by Shawn Weisfeld, Sr Technical Evangelist from Microsoft. Thanks Shawn!

Thanks again to the organizers of the very successful SQLSaturday Houston…

Read more

0 comments, 321 reads

Posted in SQL Tact on 30 June 2017

A Big July Planned in Baton Rouge

Three big events planned in Baton Rouge this year that everyone can be a part of:

User Groups Networking Night at the Louisiana Technology Park on July 12

Attendees from all Baton Rouge User Groups (SQL Server, .NET, Power BI, IT Pro, SharePoint, and Women in Technology, students, and the…

Read more

0 comments, 385 reads

Posted in SQL Tact on 23 June 2017

Registrant Job Title Data from SQLSaturday Baton Rouge events 2014-2016

In a blog post on the Sparkhound website, I laid out the strong case for a sponsor's Return on Investment (ROI) for sponsoring local SQLSaturday events. Part of my argument in favor of sponsoring SQLSaturday events are the diversity of attendees and their responsibilities, and particularly, the presence of…

Read more

0 comments, 727 reads

Posted in SQL Tact on 21 June 2017

Great to see you at SQLSaturday Houston 2017

Great to see all of you at #SQLSatHouston today, an awesome event put on by a great crew of volunteers. I presented in the first timeslot of a stacked schedule, and met and made a lot of friends.

My talk on SQL Server Permissions and Security Principals had a…

Read more

0 comments, 180 reads

Posted in SQL Tact on 17 June 2017

SQLSaturday Houston 2017 - I'll be there, will you?

Looking forward to combining a work trip with a SQLSaturday trip to Houston this week!

Will be happy to see the #SQLFamily on Friday night and Saturday! So many faces I only get to see once a year, too many!

I'll be presenting in the very first time slot on…

Read more

0 comments, 246 reads

Posted in SQL Tact on 12 June 2017

SQLSat Pcola 2017 Security Principals and Permissions

Great attendance and awesome questions from my afternoon session on "SQL Security Principals and Permissions". As promised, both the demo script files, and the entire info-packed slidedeck are available for download here on the official SQLSaturday Pensacola 2017 website.

If you have any questions or would like to get…

Read more

0 comments, 150 reads

Posted in SQL Tact on 5 June 2017

SQLSaturday Pensacola 2017

It's the start of a SQLSat summer for me, with Pensacola this weekend on Saturday June 3, then Houston two weeks later, then the rampup to my hometown SQLSaturday Baton Rouge on July 29. Hopefully everyone in the region can make it out to all three Gulf Coast region…

Read more

0 comments, 247 reads

Posted in SQL Tact on 30 May 2017

Connect with your SQL Community on Slack

Slack is a popular tool for team interaction. To describe it quickly, it's a feature-rich persistent chat room, with threads, multimedia, alerts, etc. There is a web interface, a desktop app, and a mobile app.

In addition to Twitter, which is also extremely popular in the SQL Server community, there…

Read more

0 comments, 245 reads

Posted in SQL Tact on 4 May 2017

Why SQLSaturday? A SQLSat Career Case Study

We all know that SQLSaturday events are good for career networking, professional development, and technical education. Sometimes the perfect story presents itself as a real testimonial.

When fellow Baton Rouge SQL Saturday organizer Adrian Aucoin Jr. and I heard about John Wells' (@SQLServerDBA318) story of making a career…

Read more

1 comments, 284 reads

Posted in SQL Tact on 10 April 2017

Return to Birmingham for SQLSaturday Bham 2017!

It's been 2.5 years since I last spoke at SQLSaturday Birmingham, and I'm eager to make a return, this time with two more Sparkhound colleagues in tow and an amazing secret raffle prize to giveaway at the end!

We'll see you there on Saturday!

Sparkhound speakers in the lineup

Read more

0 comments, 204 reads

Posted in SQL Tact on 16 March 2017

Older posts