"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...
2018-02-15
552 reads
SQL Tact
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...
2018-01-16 (first published: 2018-01-09)
31,367 reads
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...
2018-01-09
2,475 reads
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...
2017-12-20
803 reads
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...
2017-12-19
380 reads
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...
2017-12-04
395 reads
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...
2017-11-06
330 reads
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...
2017-10-29
623 reads
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...
2017-10-03
501 reads
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
443 reads
Blogs
Measuring RAG Solutions: Are We Retrieving the Right Information?
A RAG pipeline that answers questions in the demo is not the same thing...
Advice I Like: Lots of Ideas
By Steve Jones
“A multitude of bad ideas is necessary for one good idea” – from Excellent...
Building a DBA Agent for Your SQL Server Estate with MCP
Yesterday I gave a talk for MSSQLTips called “Building a DBA Agent for Your...
Forums
Looking for New Blood
Comments posted to this topic are about the item Looking for New Blood
Server-Level Row Counts for Tables and Views
Comments posted to this topic are about the item Server-Level Row Counts for Tables...
Parameter Sensitive Plan Optimization vs. Parameter Sniffing: What SQL Server Fixes and What It Doesn't
Comments posted to this topic are about the item Parameter Sensitive Plan Optimization vs....
Question of the Day
Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers