ScriptDom parsing and NoViableAltExceptions
If you have ever tried to debug a program that used the TSql Script Dom to parse some T-SQL you...
2017-03-02
49 reads
Ed Elliott's Sql Developer Blog
ScriptDom parsing and NoViableAltExceptions
If you have ever tried to debug a program that used the TSql Script Dom to parse some T-SQL you will know that the process is extremely slow and...
2017-03-02
24 reads
SqlPackage Deploy Performance - IgnoreXX are not your friend!
Following on from yesterdays blog I was wondering about the comparison of objects that were the same and how the...
2017-03-02
424 reads
SqlPackage Deploy Performance - IgnoreXX are not your friend!
Following on from yesterdays blog I was wondering about the comparison of objects that were the same and how the...
2017-03-02
49 reads
SqlPackage Deploy Performance - IgnoreXX are not your friend!
Following on from yesterdays blog I was wondering about the comparison of objects that were the same and how the...
2017-03-02
39 reads
SqlPackage Deploy Performance - IgnoreXX are not your friend!
Following on from yesterdays blog I was wondering about the comparison of objects that were the same and how the...
2017-03-02
21 reads
SqlPackage Deploy Performance - IgnoreXX are not your friend!
Following on from yesterdays blog I was wondering about the comparison of objects that were the same and how the IgnoreWhitespace, IgnoreComments, IgnoreKeywordCasing and IgnoreSemiColonsBetweenStatements flags affected the comparison....
2017-03-02
18 reads
SSDT Deploy / Publish Performance
Publishing dacpac's is a little bit of a pain when you have multiple databases, it can easily start to take...
2017-03-01
1,277 reads
SSDT Deploy / Publish Performance
Publishing dacpac’s is a little bit of a pain when you have multiple databases, it can easily start to take...
2017-03-01
44 reads
SSDT Deploy / Publish Performance
Publishing dacpac’s is a little bit of a pain when you have multiple databases, it can easily start to take...
2017-03-01
40 reads
Blogs
Wait… Could This Be the End of Index Maintenance?
While attending SQLCon and FabCon Europe in Barcelona, there were a lot of announcements...
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...
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