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

What's New In SQL Server 2017? at the March '18 Baton Rouge SQL Server User Group

Thanks to everyone to attended the BRSSUG meeting tonight at our sponsor's location at the Baton Rouge Alliance Safety Council location and their awesome classroom training facility.

See you next month at the BRSSUG/BRDNUG meeting back at our usual location at the Technology Park.

All of our speakers recently at…

Read more

0 comments, 538 reads

Posted in SQL Tact on 14 March 2018

SQL 2017 Administration Inside Out - link dump

Hello all-

More than a year's work went into the newest Inside Out book by Microsoft Press, I was happy to see it cross the finish last year and go into publication in February.

Here's a link dump of all the things in and around the book:
  • All our sample…

Read more

4 comments, 370 reads

Posted in SQL Tact on 7 March 2018

Activate Conference 2018: Presentation info

A special hello if you're visiting this blog post during or after my workshops on Thursday afternoon, February 22 at the Louisiana Tech Park as park of the Activate Conference 2018!

Here are all the links, downloads, and more you need for these two workshops on Thursday, Feb 22:

Read more

0 comments, 313 reads

Posted in SQL Tact on 22 February 2018

Activate Conference 2018: Three days of Tech Learning

Tomorrow I'll be giving two workshops at the super-slick-branded Activate Conference 2018 in Baton Rouge at the Louisiana Technology Park, a conference filled with people and topics much cooler than me and my two database workshops on Thursday, February 22.

Activate is an event that aims to enrich our…

Read more

0 comments, 284 reads

Posted in SQL Tact on 21 February 2018

"What's New in SQL 2017?" at the Baton Rouge SQL Server UG meeting

We had a great joint meeting tonight of the Baton Rouge SQL and .NET User Groups at the Louisiana Tech Park, and I gave the first version of a growing presentation on new features of SQL Server 2017 (with quite a few new SQL 2016 features in there for good…

Read more

0 comments, 537 reads

Posted in SQL Tact on 15 February 2018

SQL Server on TLS 1.2: Checklist to disabling TLS 1.1 and 1.0

A common finding in security audits these days is the failure to conduct all communications via TLS 1.2. (Correspondingly, a common cause for sudden SQL Server application connectivity failures is a sysadmin's inadvisable, reckless deactivation of TLS 1.0 and 1.1 on a server. Been there.)

Moving SQL Server connections to…

Read more

3 comments, 27,403 reads

Posted in SQL Tact on 9 January 2018

SQL Server on TLS 1.2: XEvent session to catch TLS in use

How can you tell what version of TLS is currently used for client connections? Unfortunately there isn't a handy queryable column in sys.dm_exec_connections, which would be ideal, though there is a Connect item requesting this

For now, you can detect the TLS version with an Extended Events session 

Read more

9 comments, 1,511 reads

Posted in SQL Tact on 9 January 2018

Our SQL Server 2017 Administration Inside Out fun author survey

I was honored to be on the author team of the new SQL Server 2017 Administration Inside Out book by Microsoft Press (out in Feb 2018). While the hard work was done and 700+ pages of final edits were still being passed around, the team of four authors (and our…

Read more

0 comments, 769 reads

Posted in SQL Tact on 20 December 2017

Start/Stop Group of Azure RM VM's

For testlab purposes, I often have a group of Azure VMs to manually spin up/spin down at once. I've had this script in use for a while and decided I'd comment it up and share.

The SQL Server Availability Groups template in the Azure VM Gallery, for example, creates five…

Read more

0 comments, 352 reads

Posted in SQL Tact on 19 December 2017

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, 381 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, 321 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, 598 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, 377 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, 400 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, 375 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, 642 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, 4,237 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, 434 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, 732 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, 668 reads

Posted in SQL Tact on 30 June 2017

Older posts