Why are you still using datetime?
It’s almost Thanksgiving time again! Let’s see, what am I thankful for? T-SQL Tuesday! Someone else get’s to pick a...
2015-11-12 (first published: 2015-11-10)
4,857 reads
T-SQL Tuesday No.72 - Is Your Data Model, Normal?
Well I’m not
a data modeler, nor do I play one in the corporate world. But it is TSQLTuesday No. 72,...
2015-11-10
2,478 reads
T-SQL Tuesday #72 - Implicit Conversion Problems
This month T-SQL Tuesday is hosted by Mickey Steuwe (blog/@SQLMickey) and her topic of choice is “Data Modeling Gone Wrong.”
(If...
2015-11-12 (first published: 2015-11-10)
1,873 reads
Implementing Partition Aware Index Optimisation Procedures
[read this post on Mr. Fox SQL blog] Continuing on with my Partitioning post series, this is part 6. The partitioning includes several major components of work (and can be linked...
2015-11-09
23 reads
Implementing Partition Aware Index Optimisation Procedures
[read this post on Mr. Fox SQL blog]
Continuing on with my Partitioning post series, this is part 6.
The partitioning includes several major...
2015-11-09
1,212 reads
What is the DLM Maturity Model?
I’ve written a few posts on the Redgate Software blog to try and show how I see the DLM model,...
2015-11-09
587 reads
Monday Morning SQL Break – November 9, 2015
It’s Monday time for this week’s blog and twitter round-up for last week. If you haven’t already, follow me on...
2015-11-09
322 reads
PASS Summit 2015 Wrap Up
Last week’s PASS Summit conference in Seattle, WA was incredible (as always). It’s my favorite tech event of the year,...
2015-11-09
461 reads
SQL Server 2016 CTP3 – new features and the JSON support improvements
SQL Server Community Technology Preview 3 has been released some days ago.
The SQL Server team added a lot of features...
2015-11-09
687 reads
How to get started with the ScriptDom
What is the ScriptDom?
The ScriptDom is an api for taking t-sql scripts, converting them into an AST or taking an...
2015-11-07
2,163 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