SQL Saturday 277 RVA Lessons Learned
Once again it is an honor to attend such a great event and meet up with other like minded geeks....
2014-03-24
484 reads
TheSqlPro.com - Ayman El-Ghazali
[SQL Snacks Video] The Basics of Joins
This is a special edition for SQL Snacks. It is one (of many hopefully) SQL Snacks that has been recorded...
2014-03-10
926 reads
SQL Saturday #277 Richmond – Covering new ground
SQL Saturday has been a fantastic experience for me here in the DC area (I blogged about it here) and...
2014-03-04
602 reads
[SQL Snacks Video] The What, Why, and How of Instant File Initialization with SQL Server
Instant File Initialization (IFI) is an interesting topic with regards to how SQL Server works with storage. It is an...
2014-02-11
654 reads
[SQL Snacks Video] Importance of COPY_ONLY Backups
There are many features/options we sometimes overlook and then wonder later what went wrong. The COPY_ONLY option with backups is...
2014-01-29
699 reads
[SQL Snacks Video] Tail Log Backup and Recovery Demo
In December 2013 I presented at a SQL Saturday event in Washington DC. My presentation was about Backup and Recovery...
2014-01-16
648 reads
[SQL Snacks Video] Introducing SQL Snacks! A healthy alternative to boring learning!
To snack lovers every where now you can consume SQL Learning the same way, in Snack Size! Introducing the new...
2014-01-16
574 reads
[Video] ApexSQL Log – Software Review
Today I will be reviewing the product ApexSQL Log which is a tool designed for Transaction Log discovery and recovery....
2014-01-08
816 reads
SQL Server 2012 ???? ??????? ????? ??
??????? ??????? ?? ??????! ?????? ????? ? ???? ???? ? ?????? ???? ??? ???? ??????? ????? ?? SQL Server 2012....
2013-12-18
2,222 reads
TheSQLPro YouTube Channel
That’s right, it’s time to take this blog up a notch! Last week I posted a video about using Hyper-V...
2013-12-11
616 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