News
CRM Data Source Connection Error
This article takes us to the edge with a couple of CRM related errors after changing the service account to a more secure Managed Service Account. Despite the CRM reports working properly within Report Manager (via SSRS), the reports would fail in CRM.
Related Posts:
- SHUTDOWN SQL Server December 3, 2018
- Failed to Create the Audit File December 31, 2017
- Audit Domain Group and User Permissions December 29, 2017
- Cannot Open Backup Device January 1, 2020
- The Gift of the SPN December 10, 2019
Where is that Mask?
In this article, I share one easy script that could help eliminate one database feature as a culprit to an anomalous data masking suddenly getting enabled.
Related Posts:
- Encrypting a Database Never Finishes December 20, 2018
- Parse Dynamics AX Context Info January 30, 2017
- Capture Index Maintenance Operations December 20, 2017
- Common Tempdb Trace Flags – Back to Basics January 5, 2018
- Synonyms in SQL Server – Good and Bad December 14, 2018
Ad Hoc Queries Disabled
This article takes a look at an error that may occur depending on your use of linked servers and the use of openrowset.
Related Posts:
- Linked Servers and Stats October 17, 2017
- How Long is That Event Taking November 20, 2018
- Maintenance Plan Owner – Back to Basics December 13, 2018
- Implicit Conversion Fail May 31, 2019
- Common Tempdb Trace Flags – Back to Basics January 5, 2018
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.
Related Posts:
- Public Role Permissions – Back to Basics June 17, 2019
- Who needs data access? Not You! December 12, 2019
- SQL Server Permissions – Database Roles March 2, 2017
- SQL Server Fixed Role Permissions March 6, 2017
- SQL Server User Already Exists – Back to Basics January 24, 2018
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.
Related Posts:
- SQL Server User Already Exists – Back to Basics January 24, 2018
- Extended Events Permissions December 25, 2017
- Synonyms in SQL Server – Good and Bad December 14, 2018
- Last Restore of a Database – Back to Basics December 19, 2016
- Lost that SQL Server Access? May 30, 2018
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.
Related Posts:
- How to be an MVP Book November 28, 2018
- You Deserve to be an MVP July 25, 2016
- To Influence or Be Influenced? December 11, 2018
- My Book Contributions November 30, 2018
- T-SQL Tuesday #102: Giving Back May 8, 2018
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.
Related Posts:
- SQL Server Fixed Role Permissions March 6, 2017
- SQL Server User Already Exists – Back to Basics January 24, 2018
- Extended Events Permissions December 25, 2017
- Easy Permissions Audit January 21, 2019
- SQL Server Permissions – Database Roles March 2, 2017
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.
Related Posts:
- Monitor Database Offline Events November 15, 2018
- Audit Database Offline Events November 13, 2018
- Capture Index Maintenance Operations December 20, 2017
- Automatic Tuning Monitoring and Diagnostics January 4, 2019
- Extended Event Help Queries July 19, 2016
Scalar UDF Inlining in SQL Server 2019 – Simpler functions
Scalar UDF Inlining, introduced in SQL Server 2019, promises to improve the performance of Scalar UDFs. Let’s look into the performance gains this offers.
The post Scalar UDF Inlining in SQL Server 2019 – Simpler functions appeared first on Wayne Sheffield.
Read MoreScalar UDF Inlining in SQL Server 2019
SQL Server 2019 introduces Scalar UDF Inlining, which is supposed to improve the performance of Scalar UDFs. This post investigates this new feature.
The post Scalar UDF Inlining in SQL Server 2019 appeared first on Wayne Sheffield.
Read More