Check SysAdmin Role in SQL Server, SQL Server Isolation Levels and Regex CLR Function (MSSQLTips 8/21/2020)

Free SQL Server Resources [Debunking the Myths: Cloud HA and DR common misconceptions]( [Whitepaper] While the benefits of the cloud may be clear for applications that can tolerate brief periods of downtime, it is not as clear for business critical applications, such as SQL Server, Oracle, and SAP that require high availability and disaster recovery protection. [READ_COMMITTED_SNAPSHOT and SNAPSHOT_ISOLATION levels]( We are going to compare the SNAPSHOT transaction isolation level and the READ COMMITTED isolation level when the READ_COMMITTED_SNAPSHOT database option is set ON in SQL Server. As we have discussed the latter in a [previous article in detail]( we will just briefly explain it here. [Peak SQL Server Performance]( [Webcast] Attend this webinar to see how the right indexes will provide lightning-fast query execution in this fast-paced presentation. [How to Check SysAdmin Role in SQL Server with PowerShell]( As proactive SQL Server DBAs, we must have a way to know which accounts reside within our systems and which accounts have sysadmin level privileges. There might be individual accounts with this elevated privilege and we must be able to detect them. You know the risks of having logins with a high privilege level, so the objective of this module is to give you a quick glance across all the instances under your support, so that you can act accordingly. [Improve the Data Quality for Healthcare, Clinical and Life Sciences]( For healthcare, clinical and life sciences organizations, merging, reconciling and enhancing data is challenging for electronic medical records, clinical trials and pharmaceutical applications. How can the technology teams at healthcare and life sciences organizations adopt a framework to improve the data quality for complex data sets for the medical professionals they support? [SQL Server Regex CLR Function]( You would like to extend the capability of a scalar function to be apply to apply regex expressions in your SQL Server database. Advantages to implementing this in a scalar function can help utilize regex search patterns to identify, clean and parse existing SQL Server data. [Optimize SQL Server Monitoring]( Balancing operational consistency and performance monitoring is imperative for large SQL Server environments. Generally, this is a time-consuming and overwhelming undertaking for any size team. Often it can feel like a constant uphill battle with many of the underlying issues never truly being solved. The SQL Server Team is pulled in many directions based on who is complaining the most, and not necessarily toward the most critical needs of the organization. More on MSSQLTips: [Tips]( [Tutorials]( [Webcasts]( [tag] You are receiving this email as a subscriber of MSSQLTips.com. [Manage MSSQLTips Subscriptions | Unsubscribe](. Edgewood Solutions LLC | PO Box 682 | Wilton, NH 03086 | [Privacy Statement]( Sent to this e-mail address: {EMAIL}