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

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, 139 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, 196 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

0 comments, 315 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, 194 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.

ZoomIt
https://technet.microsoft.com/en-us/sysinternals/zoomit.aspx
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, 291 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, 219 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, 313 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, 661 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, 130 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, 210 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, 121 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, 154 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, 197 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, 220 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, 164 reads

Posted in SQL Tact on 16 March 2017

Actual Chats: RIGHT OUTER joins in the wild

Colleague:
I think I just encountered my first Right join
*shocked* 
Me:
huh. weird.
a rare Right Join has appeared!
Colleague:
catch it!
Me:
You use ON. It's super effective! 
Colleague:
haha
how often do you see them? 
Me:
I've used RIGHT join maybe twice in 10 years. 
Colleague:
lol

Read more

5 comments, 2,710 reads

Posted in SQL Tact on 6 December 2016

SQL SSRS Express Edition Cannot Connect to Azure SQL Databases

This has bit a couple of clients recently, figured I'd put out a PSA.

Express editions of SQL Server Reporting Service, from SQL 2016 on down, cannot connect to Azure SQL Databases. Turns out, getting something for free does have some significant limitations.

For example, you'll see an error message…

Read more

2 comments, 1,223 reads

Posted in SQL Tact on 25 September 2016

"SQL Server Permissions and Security Principals" at SQLSaturday #560 Charlotte 2016

I'm proud to have been a part of SQLSaturday Charlotte 2016 this year, and happy that I was joined by a number of my colleagues from Sparkhound. We're establishing a presence in Charlotte and already have a couple big clients in the area, so Sparkies from both Baton Rouge and…

Read more

0 comments, 235 reads

Posted in SQL Tact on 17 September 2016

"SQL Server Permissions and Security Principals" at SQLSaturday Charlotte This Weekend!

I'll be presenting my talk on SQL Server Permissions and Security Principals this weekend at SQLSaturday #560 Charlotte, NC.

As a SQLSat veteran and organizer, I regularly receive feedback that there needs to be "more" content at the elementary level for new folks in the field, students, etc. I try…

Read more

0 comments, 258 reads

Posted in SQL Tact on 15 September 2016

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, 411 reads

Posted in SQL Tact on 9 August 2016

Older posts