A Very Happy New 2015
Wishing you a very happy new year to you. May this year bring success & happiness in your life. Reference : Rohit Garg (http://mssqlfun.com/) You can find and follow...
2015-01-03
24 reads
Blog Posts
A Very Happy New 2015
Wishing you a very happy new year to you.
May this year bring success & happiness in your life.
Reference : Rohit Garg (http://mssqlfun.com/)
You...
2015-01-03
618 reads
Clustered Columnstore Indexes – part 46 (“DateTime compression and performance”)
Continuation from the previous 45 parts, starting from http://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/
At the last SQLPort event in December 2014, I have listened to...
2015-01-03
735 reads
How to pass Microsoft Certification Exams
Many times I was asked how to pass Microsoft certifications and how difficult it is. In my point of view,...
2015-01-03
1,030 reads
[SQL Snacks Video] Performance Tuning 102 – Files, FileGroups, and TempDB
Finally the arrival of Part 2 of my SQL Snack Pack on Performance Tuning! The series is dedicated to help beginners...
2015-01-02 (first published: 2014-12-30)
7,457 reads
Contained Database–A new feature in SQL SERVER 2012 TIP #81
While working on a project sometimes it happened that we need to shift the database from one server to another...
2015-01-02
494 reads
E-Book Offer – Coming to an End
Back in December just before Christmas I wrote a post about a deal that Packt publishing has on its ebook...
2015-01-02
421 reads
Friday Followup For January 2, 2015
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2015-01-02
388 reads
My 2015 Plan
I started this on Jan 1, but with family commitments, I ended up delaying it until today. I wrote about...
2015-01-02
891 reads
Reblog: December 26 to January 1
Photo credit – Jenn and Tony Bot
Sometimes old stuff is just as cool as new stuff. Over the past few years,...
2015-01-02
644 reads
Blogs
Wait… Could This Be the End of Index Maintenance?
While attending SQLCon and FabCon Europe in Barcelona, there were a lot of announcements...
Copilot on the Power BI Report Canvas vs. Modern Report Builder
By James Serra
(This is the second post in a three-part series on how AI is changing...
The #MS_DatabaseConnector## Role: #SQLNewBlogger
By Steve Jones
I had seen these roles in various instances, but never dug into the new...
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