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...
2017-09-14
429 reads
Will Assaf
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...
2017-08-17 (first published: 2017-07-30)
20,897 reads
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...
2017-08-04
383 reads
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...
2017-07-31
654 reads
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...
2017-07-19
440 reads
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...
2017-07-04
769 reads
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...
2017-06-30
673 reads
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...
2017-06-29 (first published: 2017-06-21)
907 reads
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...
2017-06-23
588 reads
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....
2017-06-17
297 reads
Blogs
Don’t Miss Out – SQL Server Query Tuning Fundamentals Starts Next Monday!
Next Monday, February 9, 2026, my one-day live online training SQL Server Query Tuning...
Monday Monitor Tips: SQL Auditing Preview
By Steve Jones
One of the features we advocates have been advocating for is a better way...
SQL Server 2025 CU1 Fixes the Docker Desktop AVX Issue on macOS
Microsoft fixed the AVX instruction issue in SQL Server 2025 CU1. The container now...
Forums
25 Years of SQL Server Central
Comments posted to this topic are about the item 25 Years of SQL Server...
The Decoded Value
Comments posted to this topic are about the item The Decoded Value
Deploying SQL Server Developer Edition in Kubernetes: A Cost-Effective Alternative to RDS
Comments posted to this topic are about the item Deploying SQL Server Developer Edition...
Question of the Day
The Decoded Value
In SQL Server 2025, what is returned from this code:
DECLARE @message VARCHAR(50) = 'Hello SQL Server 2025!'; DECLARE @encoded VARCHAR(MAX); SET @encoded = BASE64_ENCODE(CAST(@message AS VARBINARY(1000))); SELECT BASE64_DECODE(@encoded)See possible answers