Creating a Linked Server - SQL School Video
Linked Servers allow SQL Server to access data on other systems, SQL Server, Oracle, Access, Excel, and others. MVP Andy Warren shows how to set one up in this SQL School video.
2009-04-07
6,741 reads
Linked Servers allow SQL Server to access data on other systems, SQL Server, Oracle, Access, Excel, and others. MVP Andy Warren shows how to set one up in this SQL School video.
2009-04-07
6,741 reads
Minimalist design can easily be confused with laziness, and also sometimes hard to tell the difference between minimalist and downright...
2009-04-07
372 reads
As I've covered in my two earlier posts I've been investing a little time to figure out how to make...
2009-04-06
506 reads
Many of us make a living by working on tasks while monitoring email, taking a few calls, and in non...
2009-04-05
478 reads
I found How to Start a Conversation and Make Friends on the clearance rack at the local bookstore, but you...
2009-04-02
502 reads
Just head from Greg Larsen yesterday that he just ran out of time to put things together. As I've mentioned...
2009-04-02
300 reads
Further off topic than usual, but I ran across this as I browsed Springwise after a friend suggested it might...
2009-04-01
603 reads
Announced today on his blog at http://scarydba.wordpress.com/2009/04/01/mvp/. Well earned in my opinion between his participation with PASS, SSC, and his...
2009-04-01
427 reads
Recently I posted LinkedIn (part 1) about my efforts to better understand and use it as a networking platform. It...
2009-04-01
520 reads
There's been a lot of bad press about 'corporate jets' in the news over the past year. Not that planes themselves have issues, but rather many questions about whether corporations are spending shareholder dollars appropriately. It's not a simple topic, but clearly there did seem to be a lack of awareness about how those kinds of things would be perceived in difficult financial times.
2009-04-01
919 reads
By Steve Jones
I had seen these roles in various instances, but never dug into the new...
By Brian Kelley
During COVID, I attended training on software/enterprise architecture given by Mark Richards. One of...
For me, the objective is straightforward: have a backup strategy that is reliable, understandable,...
Comments posted to this topic are about the item Pay for Performance, which is...
Has anyone encountered recurring request latency when using Microsoft Access with SQL Server 2025...
Comments posted to this topic are about the item 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