Re-blog – June 24-June 30
As I mentioned in the introductory post, I’m summarizing posts from previous years in the the past week. Some posts...
2011-07-01
531 reads
Blog Posts
School Data Move Done!
A brief mention that we are done with the school year flip process for transitioning to the new school year.
I...
2011-07-01
818 reads
SQL Server “Denali”: SQL Server Developer Tools, codename ‘Juneau”
Juneau is the code name for the new SQL Server Development Tool (SSDT), to be released along with the next...
2011-07-01
1,273 reads
SQL Statistics – another Spin
I was reading a blog by Pinal Dave that was about using catalog views to obtain information about stats for the entire database. While reading the blog, I was...
2011-07-01
36 reads
SQL Statistics – another Spin
I was reading a blog by Pinal Dave that was about using catalog views to obtain information about stats for...
2011-07-01
678 reads
SQLDIY: Gathering A Data Dictionary
In this installment we are looking at assembling a basic data dictionary from the column level meta data stored in...
2011-07-01
1,001 reads
What's In A Blog? - BlogLock
Hi, ALL. Today's Blog is much ado about nothing? A totally free-form blog entry, with random thoughts on a passing scene.
Sometimes, it...
2011-07-01
708 reads
70-450 Study Guide
In my last post concerning my certification journey I said I may post a study guide. I have thought it over and a sweetened condensed version of some of...
2011-06-30
13 reads
70-450 Study Guide
In my last post concerning my certification journey I said I may post a study guide. I have thought it...
2011-06-30
4,779 reads
Arggghhhhh
I have a new tune stuck in my head now. It got stuck there this afternoon shortly after my computer was forced into a reboot. I was in the...
2011-06-30
14 reads
Blogs
Copilot on the Power BI Report Canvas vs. Modern Report Builder
By James Serra
(This is the second post in a three-part series on how AI is changing...
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...
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