Immunizations – Not Just for Kids
It’s the ‘get your flu shot’ time of the year, which is also a good time to review your immunizations....
2015-12-22
644 reads
How to Compare Tables in SQL Server
One of our customers has recently asked me the following question (I changed just the business case):
The Problem
“I have a...
2015-12-22
554 reads
Fixing Truncation Issues with T-SQL Flex
If you’ve worked with SQL Server for any length of time, you’ve run into this error:
Msg 8152, Level 16, State...
2015-12-21
1,087 reads
Goodness-of-Fit Testing with SQL Server, part 3.2: D’Agostino’s K-Squared Test
By Steve Bolton
…………In the last edition of this amateur series of self-tutorials on goodness-of-fit testing with SQL Server, we discussed...
2016-01-04 (first published: 2015-12-21)
2,130 reads
Monday Morning SQL Break – December 21, 2015
It’s Monday time for this week’s weekly blog and twitter round-up for last week. If you haven’t already, follow me...
2015-12-21
456 reads
Thanks to Rodney & Karla
Sometime in the next couple weeks Rodney & Karla Landrum are moving from Orlando to Pensacola (home). I’m happy for them...
2015-12-21
627 reads
Learning R: Hard Lessons
I’ve always found the best way to learn a new programming language is to start building stuff, solving problems, using...
2015-12-21
974 reads
What is the current database context?
Every now and again it can be very helpful to know what the current database context is when you are...
2015-12-21
681 reads
Use Compression to Combine Data Quality and Performance
We’ve been using the wrong data types for all the wrong reasons. DBAs, developers, data architects, etc. have all been...
2015-12-21
995 reads
Demystifying the Type 2 Slowly Changing Dimension with Biml
Most data warehouses have at least a couple of Type 2 Slowly Changing Dimensions. We use them to keep history...
2015-12-21
1,013 reads
Blogs
The #MS_DatabaseConnector## Role: #SQLNewBlogger
By Steve Jones
I had seen these roles in various instances, but never dug into the new...
Asking for Help Isn’t a Weakness
By Brian Kelley
During COVID, I attended training on software/enterprise architecture given by Mark Richards. One of...
The Proof of the Backup Is in the Pudding
For me, the objective is straightforward: have a backup strategy that is reliable, understandable,...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Access + ODBC Driver 18 + SQL Server 2025: ~150–250 ms per request
Has anyone encountered recurring request latency when using Microsoft Access with SQL Server 2025...
The ##MS_DatabaseConnector## User
Comments posted to this topic are about the item The ##MS_DatabaseConnector## User
Question of the Day
The ##MS_DatabaseConnector## User
On SQL Server 2025, I run this code as a sysadmin:
CREATE LOGIN Demo WITH PASSWORD = 'Demo1234567' GO ALTER SERVER ROLE ##MS_DatabaseConnector## ADD MEMBER Demo GOI then login as Demo and run this:
USE sandbox go SELECT CURRENT_USERWhat is returned? See possible answers