This article takes a look at an error that may occur depending on your use of linked servers and the use of openrowset.
Ad Hoc Queries Disabled
Category: DatabaseMasters Syndication
Syndication Feed for Database Masters
When Too Much is Not a Good Thing
Explore how to avoid unwanted results that oft occur due to lack of attention to detail, use of internet examples, misunderstanding of the requirements; and always from granting way too much access.
Who needs data access? Not You!
With a little planning and care, we can find various ways to fulfill user requests without compromising the environment.
It’s an Honor: Microsoft MVP
I am humbled to be among so many great professionals and honored at the same time for having been chosen.
Public Role Permissions – Back to Basics
If you are being serious in your role, then the amount of times you grant permissions to the public role should either be a) never, b) when you want to have a data breach, or c) you are testing in a sandbox to improve your skills.
Database Offline – Redux
A database can be offline at the time that you take over responsibility of the database. You will be asked when it was taken offline. This script will help you get a reasonable deduction for that offline event in the absence of better data.
Quick Permissions Audit
DBAs often need to figure out who has access to what. When that need arises, it is frequently adequate to just perform a quick permissions audit.
PowerShell ISE Crashes
Working with PowerShell brings a lot of advantages and power to help manage a server. The more current your PoSh version, the more efficiently you will be able to manage your server. Sometimes getting to the current PoSh versions comes with a little pain such as ISE crashes.