SQL Saturday Cleveland #SQLSat473
On February 6, 2016, Cleveland is hosting a free training event for SQL Server. This has a lot of the...
2016-01-11
539 reads
2016-01-11
563 reads
SQL Server 2016 – whats new…lets see
Hey friends. I am here again with what’s new blog … Things are changing quite frequently and requirement is also changing....
2016-01-11
440 reads
Sudoku by SQL Part 2 of 3
The Challenge
Since I came across the first sudoku I was wondering if it could by solved by SQL using queries...
2016-01-10
373 reads
New Year Wish List for SQL Server Features
With SQL Server 2016 to be officially released this year, I want to make a wish list for the features...
2016-01-15 (first published: 2016-01-10)
1,716 reads
Sudoku by SQL Part 3 of 3
The Challenge
Since I came across the first sudoku I was wondering if it could by solved by SQL using queries...
2016-01-09
381 reads
Sudoku by SQL Part 1 of 3
The Challenge
Since I came across the first sudoku I was wondering if it could by solved by SQL using queries...
2016-01-09
455 reads
Creating a Matrix in Power BI With Multiple Values on Rows
This week I was asked to create a matrix in a Power BI report that looks like this:
Matrix with Values on...
2016-01-09
1,320 reads
We Want You!
It seems like PASS Summit 2015 was just yesterday and here we are again, getting ready for Summit 2016 already. ...
2016-01-08
427 reads
Advent of Code Day 1, Puzzle B
As I continue through the Advent of Code, albeit slowly, I’m solving each puzzle 3 days. I worked through 6...
2016-01-08
753 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
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
Planning for Change
Comments posted to this topic are about the item Planning for Change
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