DocumentDB Tutorial 2 – Working with Documents
Join Eitan Blumin in the next video of his DocumentDB Tutorials. This time learn how to work with the documents...
2016-02-18 (first published: 2016-02-11)
2,097 reads
Moving to Open Live Writer
I’ve used Windows Live Writer for almost as long as I’ve been blogging (mid 2007 or so). It’s worked well...
2016-02-11
791 reads
SQL Server Security Principals Lightning Round Presentation
Thanks for attending tonight's joint meeting of the Baton Rouge .NET/SQL/PowerBI User Groups, which was sponsored by Idera!
I presented a...
2016-02-10
387 reads
Azure SQL Database monitoring
Even though an Azure SQL Database stores all data on the Azure cloud, it does not mean that your options for managing...
2016-02-10
763 reads
CROSS APPLY v InLine Functions
While working on the Advent of Code problems in SQL, I ran across something interesting. Day 4 involves hashing, which...
2016-02-10
2,178 reads
How Bad Are Your Indexes?
In my last post "Copying SSIS packages With DTUTIL" I described a "gotcha" where the dynamic management views (DMVs) had...
2016-02-10
3,144 reads
Leadership and the Data Professional
Many traits make up data professionals and the many who find themselves in leadership roles. The traits being shared in...
2016-02-17 (first published: 2016-02-10)
1,822 reads
Changing to simple recovery to clear the log.
Clearing out a full transaction log is a common problem. A quick search will find you dozens of forum entries...
2016-02-10
588 reads
View Getting Started with Power BI and Time Calculations with Dustin Ryan is Now Available!
Earlier today I had the pleasure of speaking with the PASS Business Intelligence Virtual Chapter on getting started with Power...
2016-02-09
926 reads
VMware vExpert 2016 Announcement
What an amazing week! VMware has announced the full list of VMware vExperts for the first half of the 2016 cycle, and I’m...
2016-02-09
469 reads
Blogs
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,...
T-SQL Tuesday #204 – Are blogs still relevant?
By DesertDBA
Note: This post is the invitation for T-SQL Tuesday #204 on November 3rd, 2026....
Forums
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
Importing Excel files into SQL Server, Azure Edition
Comments posted to this topic are about the item Importing Excel files into SQL...
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