SQL 2008 Auditing Presentation in NJ by the MAK!
If you are a regular to the sql server community sites, forums and blogs, then you know about the awesome stuff brought...
2010-03-15
1,054 reads
Robert Pearl
Article in SQL Server Magazine on SQL IO Stastics.......
Article on I/O tips appearing on SQLMag.com
If you've followed my blog, you know I've written on various topics, including I/O...
2010-02-26
1,952 reads
Why Use SSAS?
After a great presentation from Brian Knight at the NYC User Group, Robert Pearl summarizes some information about SSAS and when it makes sense to use this subsystem. And why you might want to attend that next user group meeting.
2010-02-19
10,675 reads
SQLSaturday#39 in NYC!
If you can't make #33 in NC, there's always #39 in NY -
SQLSaturday#39 in NYC!
It's shaping up to be another...
2010-02-17
650 reads
RedGate Releases SQLSearch - FREE!
RedGate Releases SQLSearch - FREE!
SQL Search - Released
My friends at RedGate have released a new FREE Tool. Please read on to learn...
2010-02-02
831 reads
SQL Server 2008 - Top Reasons to Upgrade.....
OK, you've seen many of these before, but if you haven't figured out its TIME to upgrade your SQL Servers to...
2010-01-21
1,222 reads
SQL Server Waits and Queues
Recently, I was asked to do an extensive sql server performance audit and review. I will be sharing some of...
2010-01-15
9,757 reads
SSIS Package Credentials
What do you do when you run an SSIS package and it works, but it fails when scheduled? You might have a credential problem. Robert Pearl brings us a solution to a cryptic message that prevents you from scheduling a package.
2009-12-10
10,412 reads
SSIS Package Credentials - Featured article on SSC.com
Today, on SQLServerCentral.com, SSIS Package Credentials, is the featured article on the site.
I originally drafted this article as a blog post, and...
2009-12-10
699 reads
A CIO's Voice....
As you know if you follow this blog, Pearl Knows is the creator of the monitoring software SQLCentric, and offers...
2009-12-07
603 reads
Blogs
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,...
T-SQL Tuesday #204 – Are blogs still relevant?
By DesertDBA
Note: This post is the invitation for T-SQL Tuesday #204 on November 3rd, 2026....
Forums
The ##MS_DatabaseConnector## User
Comments posted to this topic are about the item The ##MS_DatabaseConnector## User
Planning for Change
Comments posted to this topic are about the item Planning for Change
Importing Excel files into SQL Server, Azure Edition
Comments posted to this topic are about the item Importing Excel files into SQL...
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