What’s new in SQL Server 2017 presentation
I just uploaded a new presentation called “What’s new in SQL Server 2017”. It covers all the new features in...
2017-10-06
747 reads
I just uploaded a new presentation called “What’s new in SQL Server 2017”. It covers all the new features in...
2017-10-06
747 reads
Many product announcements were made this week at Microsoft Ignite, and I wanted to give a quick overview of all...
2017-09-28
975 reads
In SQL Server, scaling out reads (i.e. using Active secondary replicas via AlwaysOn Availability Groups) is a lot easier than scaling out...
2017-09-21
746 reads
Last week Microsoft released a public preview of a new service called Azure Archive Blob Storage, offering customers a lower-cost...
2017-08-31
1,048 reads
Data virtualization goes by a lot of different names: logical data warehouse, data federation, virtual database, and decentralized data warehouse....
2017-08-24
919 reads
I previously blogged about Microsoft certification changes, and since then there have been some new Microsoft Big Data certifications exams released:
Already...
2017-08-08
689 reads
Microsoft has released a preview of the Azure Analysis Services web designer. This is a browser-based experience that will allow...
2017-08-02
695 reads
Azure SQL Data Sync has been ignored for quite some time, but has finally gotten an update (it’s in public...
2017-07-20
601 reads
Microsoft has introduced two new disk sizes for Azure IaaS VMs in P40 (2TB) and P50 (4TB) for both managed...
2017-07-07
1,062 reads
I have blogged before about data lakes (see What is a data lake? and Why use a data lake?), and wanted to provide...
2017-06-29
4,603 reads
By Brian Kelley
During COVID, I attended training on software/enterprise architecture given by Mark Richards. One of...
For me, the objective is straightforward: have a backup strategy that is reliable, understandable,...
By DesertDBA
Note: This post is the invitation for T-SQL Tuesday #204 on November 3rd, 2026....
Comments posted to this topic are about the item The ##MS_DatabaseConnector## User
Comments posted to this topic are about the item Planning for Change
Comments posted to this topic are about the item Importing Excel files into SQL...
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