Running SSMS 2016 in Read Uncommitted Mode
Back in July when we received the first official release of SSMS not tied to an engine release we got a new SQL PowerShell module and we also received...
2017-01-25
15 reads
Aaron Nelson
PowerShell Virtual Group of PASS January Newsletter
We spend way too much time each month drafting the newsletters for the PowerShell Group of PASS. But hey, we’re database people, not email mavens, and the newsletter does...
2017-01-18
11 reads
PowerShell Virtual Group of PASS January Newsletter
We spend way too much time each month drafting the newsletters for the PowerShell Group of PASS. But hey, we’re database people, not email mavens, and the newsletter does...
2017-01-18
17 reads
PowerShell Virtual Group of PASS January Newsletter
We spend way too much time each month drafting the newsletters for the PowerShell Group of PASS. But hey, we’re...
2017-01-18
530 reads
Backing Up SQL Server Databases is Easier in PowerShell than T-SQL
Learn how easy the new SQLServer module makes backups of SQL Server databases.
2017-01-12
36,157 reads
T-SQL Tuesday #86 – Adding when DBCC CHECKDB last ran to the SYS.DATABASES catalog view
Brent Ozar is hosting TSQL2sDay #86 this month and in response to Brent Ozar’s Call for Important Connect Items I wanted to highlight this one about adding the date...
2017-01-10
16 reads
T-SQL Tuesday #86 – Adding when DBCC CHECKDB last ran to the SYS.DATABASES catalog view
Brent Ozar is hosting TSQL2sDay #86 this month and in response to Brent Ozar’s Call for Important Connect Items I...
2017-01-10
442 reads
T-SQL Tuesday #86 – Adding when DBCC CHECKDB last ran to the SYS.DATABASES catalog view
Brent Ozar is hosting TSQL2sDay #86 this month and in response to Brent Ozar’s Call for Important Connect Items I wanted to highlight this one about adding the date...
2017-01-10
21 reads
Refreshing the SQL Server PowerShell Provider
Sometimes SSMS gives you stale results and there you have the Refresh button to fix that. In SQL PowerShell, the same situation can arise where the SQL Server PowerShell...
2017-01-06
21 reads
Refreshing the SQL Server PowerShell Provider
Sometimes SSMS gives you stale results and there you have the Refresh button to fix that.
In SQL PowerShell, the same...
2017-01-06
550 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