SharePoint SSRS “The permissions granted to user ‘Domain\User’ are insufficient for performing this operation”
Not too long ago I ran into a crazy situation where just about everything that could have gone wrong with...
2013-08-27
1,578 reads
Blog Posts
Specify the Parameter Names for Stored Procedures
I just ran across a case where a script was failing. Here's the part that's failing:
EXEC sp_addrolemember 'MyDomain\MyGroup', 'SomeRole';
GO
Do...
2013-08-27 (first published: 2013-08-23)
4,494 reads
Winner of the worst recruiter of the year!
Every week I get a bunch of emails from recruiters about jobs that I am not qualified for (see Low-rate...
2013-08-27
1,147 reads
Cumulative Update – 9 for SQL Server 2012 RTM Is Now Available !
The 9th cumulative update release for SQL Server 2012 RTM is now available. Cumulative Update 9 contains all the hotfixes...
2013-08-26
755 reads
Execute SSIS Packages with a Macro in BIDS
When running SSIS packages in BIDS it is common to click on the green arrow at the top of BIDS...
2013-08-26 (first published: 2013-08-19)
2,065 reads
Last Weeks Top “Reading” Links #46
It’s Monday, it’s time for weekly round-up #46. As an introduction, if you follow me on twitter (@StrateSQL), you’ll know that throughout the...
2013-08-26
769 reads
SQL – Identify & Drop Duplicate Index
This post explains the simple steps to identify a duplicate indexes in all the databases. The duplicate index are more than...
2013-08-26
893 reads
SQL Saturday 223 OKC
This past weekend I made the relatively short (about 3 hours) trip to the Oklahoma City area to attend and...
2013-08-26
812 reads
SQL Server – Script to get Service Account for all local instances
Earlier on my blog I posted on How to get SQL Server Service Account using T-SQL. That works on a...
2013-08-26
232 reads
SQL Server – Script to get Service Account for all local instances
Earlier on my blog I posted on How to get SQL Server Service Account using T-SQL. That works on a...
2013-08-26
1,276 reads
Blogs
Microsoft Fabric Data Agents: Bringing Structured and Unstructured Data Together
By James Serra
Most enterprise questions do not live neatly in one place. The numbers may be...
Keeping Redshift System Table History Past 7 Days with S3 Tables
Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine...
Updating the Data API Builder
By Steve Jones
I was updating my session for the Data API Builder (DAB) recently, mostly to...
Forums
Parameter Sensitive Plan Optimization vs. Parameter Sniffing: What SQL Server Fixes and What It Doesn't
Comments posted to this topic are about the item Parameter Sensitive Plan Optimization vs....
Hyperscale Replicas I
Comments posted to this topic are about the item Hyperscale Replicas I
The End of Summer
Comments posted to this topic are about the item The End of Summer
Question of the Day
Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers