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

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, 149 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, 121 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, 90 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, 166 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, 90 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, 100 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, 149 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, 175 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, 121 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,669 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,150 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, 211 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, 235 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, 372 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, 279 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, 4,151 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, 389 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, 267 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, 337 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, 256 reads

Posted in SQL Tact on 9 May 2016

Older posts