SQLSaturday Schedule Announced
Our one day free SQL Server event is slowly gaining momentum! Draft schedule is at http://www.sqlsaturday.com/schedule.aspx. 30 sessions total and...
2007-08-27
1,586 reads
Our one day free SQL Server event is slowly gaining momentum! Draft schedule is at http://www.sqlsaturday.com/schedule.aspx. 30 sessions total and...
2007-08-27
1,586 reads
One common need that DBAs run into is building a report that returns data in some random order. Especially if you're doing some type of contest, like giving something away at your User Group meeting. Andy Warren brings us a short article on this with a look at the performance impact of randomly ordering results.
2007-08-23
4,394 reads
Andy Warren has had a great deal of experience with SQL Server replication and just picked up a new book on the topic. Rather than the standard book review, he decided to conduct the review as an interview with the author.
2007-08-17
4,317 reads
Book reviews aren't easy and it's always hard to tell if you're telling the reader anything they can't learn from...
2007-08-17
1,363 reads
We went for a site visit Tues and I think it will really work out well for us. Good parking,...
2007-08-17
1,411 reads
We had a visitor from another group at our recent www.opass.org meeting and it was interesting that one bit of...
2007-08-09
1,352 reads
Article is at http://www.sqlservercentral.com/columnists/awarren/3135.asp. I'll have quite a few more on this subject over the next few months. As I...
2007-08-09
1,368 reads
One of the techniques that you can use for increasing performance, especially in large SQL Server tables, is partitioning. Andy Warren brings us an overview of what this is and how you can use it in your SQL Server 2005 applications.
2007-08-09
20,345 reads
Last night we had one of bi-monthly meetings of oPASS (Orlando SQL Servers User Group) and we had a pretty...
2007-08-08
1,448 reads
Ensuring that our careers grow is something that each of us must take charge of and Andy Warren brings us one of the ways in which you can do this: create a plan. Andy talks about how you can structure a plan at different stages of your career.
2007-08-07
5,352 reads
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,...
By DesertDBA
Note: This post is the invitation for T-SQL Tuesday #204 on November 3rd, 2026....
Comments posted to this topic are about the item The ##MS_DatabaseConnector## User
Comments posted to this topic are about the item Planning for Change
Comments posted to this topic are about the item Importing Excel files into SQL...
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