What does an Index mean to a Query
This post is about the importance of a right index to a query. The following simple query was considered.
SELECT
[GroupBy1].[A1] AS...
2016-11-11
274 reads
Igor Micev
What does an Index mean to a Query
This post is about the importance of a right index to a query. The following simple query was considered. [crayon-5e81b52eda1f0195410103/] Even simple, this query was causing troubles on our production...
2016-11-11
10 reads
What does an Index mean to a Query
This post is about the importance of a right index to a query. The following simple query was considered. [crayon-5e96566159ca8644006533/] Even simple, this query was causing troubles on our production...
2016-11-11
23 reads
Connect to SQL Azure database from SSMS
In this article I’ll show you how to connect to SQL Azure database instance and create a simple database. First you have...
2016-10-11
297 reads
Connect to SQL Azure database from SSMS
In this article I’ll show you how to connect to SQL Azure database instance and create a simple database. First you have to own an Azure account. In the account you...
2016-10-11
22 reads
Connect to SQL Azure database from SSMS
In this article I’ll show you how to connect to SQL Azure database instance and create a simple database. First you have to own an Azure account. In the account you...
2016-10-11
10 reads
Changing SQL Server name
This post is about how to rename a stand-alone SQL server instance. There could be some reasons to do that:...
2016-10-02
767 reads
Changing SQL Server name
This post is about how to rename a stand-alone SQL server instance. There could be some reasons to do that:...
2016-10-02
299 reads
Changing SQL Server name
This post is about how to rename a stand-alone SQL server instance. There could be some reasons to do that: You simply forgot to change the name of your...
2016-10-02
30 reads
Changing SQL Server name
This post is about how to rename a stand-alone SQL server instance. There could be some reasons to do that: You simply forgot to change the name of your...
2016-10-02
43 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