Murder In Utah
I am about to set sail on a new venture with my next official whistle stop. This year has been...
2014-10-14
597 reads
Blog Posts
Some Thoughts On Running a Chapter
Last week I spent some time after my presentation to Space Coast SQL talking to Kathleen Branch, the chapter leader,...
2014-10-14
880 reads
SQL Server Checksum
Use SQL Server Checksum in Data Warehousing
When building data warehouses you often need a fast way to know if the...
2014-10-14
2,386 reads
The Question – Why?
The question I get asked a lot by other data professionals at conferences, events, speaking engagements, family, friends, etc. is...
2014-10-14 (first published: 2014-10-06)
5,964 reads
T-SQL – Scripting Stored Procedure to Create backup copy on same database
This post is one of the request from OP.
Download SQL Backup SP in the same database
The probelm statement 1:-
Create a...
2014-10-14
904 reads
T-SQL Tuesday #59 – My Hero!
It always amazes me how fast these T-SQL Tuesday block parties come about; it seems like we just finished one...
2014-10-14
610 reads
T-SQL Tuesday #59: My Hero
This month’s T-SQL Tuesday is hosted by Tracy McKibben (blog | twitter) and is all about heroes (not the TV show).
Ada...
2014-10-14
1,197 reads
TSQL Tuesday #59: My Hero, My Inspiration, My Wife
TSQL Tuesday is a blog party started by Adam Machanic (b/t) almost 5 years ago. This month Tracey McKibben (b/t)...
2014-10-14
1,171 reads
T-SQL Tuesday #59–My Hero
It’s October, and another busy fall is underway for me. It’s also the second Tuesday, so it’s T-SQL Tuesday time...
2014-10-14
702 reads
Configure SQL Server Database Mirroring
1) Take Full backup of database at Principle Server BACKUP DATABASE USERDB1 TO DISK = ‘H:USERDB1.BAK’ 2) Take Log Backup at Principle Server BACKUP LOG USERDB1 TO DISK =...
2014-10-13
20 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