Save the date: SQLSaturday Iowa City
Q: True or False – Iowa has one of the world’s longest-running SQL Server conferences?
A: True! SQLSaturday #19 was held in the fall of...
2016-01-28
1,027 reads
Where in the world are Jen and Sean?
Updated with more SQL Saturdays! Well hi there, folks. A month slips by so very fast. Here is your January...
2016-01-28
1,054 reads
Reblog: Building the Script Component
SQLKover update: For some reason, this was my most popular blog post on the old LTD site. Over 110,000 views. People...
2016-01-28
875 reads
Encrypting AlwaysOn Availability Group Transport- Some thoughts!
Transport security for AlwaysOn Availability Group is an interesting topic, and any day it’s a topic which is debatable. The transport security involves encryption of packets exchanged between the...
2016-01-28
21 reads
Encrypting AlwaysOn Availability Group Transport- Some thoughts!
Transport security for AlwaysOn Availability Group is an interesting topic, and any day it’s a topic which is debatable.
The transport...
2016-01-28
2,216 reads
Migrate from on-prem SQL server to Azure SQL Database
This blog describes the various approaches you can use to migrate an on-premises SQL Server database to Azure SQL Database.
In...
2016-01-27
1,176 reads
The Importance of a Full Backup in SQL Server
This is the first of 12 posts this year in support of Tim Ford’s #iwanttohelp initiative. These will be completely...
2016-01-27
511 reads
The CONNECT permission
The CONNECT permission exists at the instance and database levels. Note: as of SQL 2012 it is CONNECT SQL at...
2016-02-03 (first published: 2016-01-27)
3,502 reads
Goodness-of-Fit Testing with SQL Server Part 4.2: The Hosmer–Lemeshow Test with Logistic Regression
By Steve Bolton
…………The last installment of this amateur series of self-tutorials was the beginning of a short detour into using...
2016-02-02 (first published: 2016-01-26)
1,558 reads
Webcast: Upgrading and Migrating SQL Server 2005 BI Features to SQL Server 2014 and 2016
Please join me on February 3rd at 10 Pacific Time for this presentation brought to you by Microsoft and SolidQ...
2016-01-26
538 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