Denali–IIF and CHOOSE
In Denali CTP3, we have a new of new functions to play with. For this post, im going to focus...
2011-07-19
814 reads
A Big Milestone-SQLSaturday #100
Just announced yesterday, SQLSaturday #100 will be held in Brazil on November 26, 2011. Just a little over four years...
2011-07-19
779 reads
SQL Server – SET STATISTICS [IO|TIME] ON
My colleagues and I often joke around with “If it takes less than a second, then it’s okay!”. The reason...
2011-07-19
1,492 reads
The SQLSaturday Sensation - Celebrating the 100th Event!
The SQLSaturday Sensation!
Congratulations, Brazil! You are the recipient host country for SQLSaturday #100!! On Saturday, November 26, 2011, when the...
2011-07-19
2,443 reads
A Guest at the Ranch
From the other side of the world, I had a guest at the ranch today.
Pinal Dave, a friend from...
2011-07-19
826 reads
Microsoft SQL Server 2008 SP2 Cumulative Update 5 Released
Microsoft has released Cumulative Update 5 for SQL Server 2008 Service Pack 2. This CU has ten fixes listed in...
2011-07-18
1,587 reads
SQLServerCentral.com Track at SQL Server Connections This Fall in Las Vegas
As has now become a regular tradition, SQLServerCentral.com is providing an educational track at SQL Server Connections (part of DevConnections)...
2011-07-18
2,255 reads
Search Argument Case Study: WHERE the year was 2002…
Content Rating: Beginner, Tips
It’s entirely possible that you’re fiddling with your search arguments too much, and missing out on the...
2011-07-18
817 reads
SQL Server “Denali”: Details on the next version of SSIS
CTP3 of SQL Server Code Name “Denali” was made available recently, and it offers a lot of new features for...
2011-07-18
1,261 reads
Event: NJSQL UG Tomorrow 7/19 - Management Data Warehouse
If you're in the local NY/NJ Tri-State area, and planning on attending, this is a reminder from the New Jersey...
2011-07-18
699 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