Speaker of the Month: January 2015
I love it that my first post of the new year is going to be Speaker of the Month. I’m...
2015-01-02
430 reads
Blog Posts
Building Debug Symbols – Troubleshooting symbol building
Recently,I have been working with the Debugger Symbols for SQL Server to generate call stacks and learn more about the internals of SQL Server. I approached one of...
2015-01-01
29 reads
Building Debug Symbols – Troubleshooting symbol building
Recently, I have working with the Debugger Symbols for SQL Server to generate call stacks and learn more about the...
2015-01-01
650 reads
How to insert value in Identity column ? TIP #80
Happy new year 2015 .
Suppose you have a source table and one destination table (Which is exact replica of source...
2015-01-01
294 reads
I’m an MVP: now what?
Today when I checked my mailbox I found an amazing surprise: I joined the ranks of the Most Valuable Professionals...
2015-01-01
430 reads
Powershell – Copy the Latest Backup
I got an email recently where someone asked me how they can refresh a dev environment with Powershell. I guess...
2015-01-01 (first published: 2014-12-29)
9,392 reads
Tracing call stacks in SQL Server – Installing the Debugging Tools for Windows (WinDbg) on Windows 8.1 and generating debug symbols for SQL Server binaries
Where to get the debugger tools To generate the needed symbols you will need the “Windows Software Development Kit (SDK) for Windows 10” download here: https://dev.windows.com/en-us/downloads/windows-10-sdk and click “Download the standalone SDK” ...
2015-01-01
27 reads
Tracing call stacks in SQL Server – Installing the Debugging Tools for Windows (WinDbg) on Windows 8.1 and generating debug symbols for SQL Server binaries
Where to get the debugger tools
To generate the needed symbols you will need the “Standalone Debugging Tools for Windows (WinDbg)” download here: http://msdn.microsoft.com/en-us/windows/hardware/hh852365
How to...
2015-01-01
890 reads
[SQL Snacks Video] Performance Tuning 103 – T-Logs and VLFs
Finally the arrival of Part 3 of my SQL Snack Pack on Performance Tuning! The series is dedicated to help beginners understand...
2014-12-31
1,244 reads
2014 – A year in review.
TweetG’day,
And so another year passes, and as I’ve never wrote a “year in review” post before now seems like a...
2014-12-31
1,359 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