MSSQLTips Monday Mission - SysAdmin Members

[MSSQLTips.com logo]( [View email in your browser]( TODAY'S NEWS FROM MSSQLTips Learn something new every day! [mssqltips image]( [SQL Server DDL Trigger to Capture for Create, Alter and Drop Commands]( This article will show how to create a SQL Server DDL trigger to capture any DDL commands issued like Create, Alter, Drop, and then send an email notification.... [Read Now]( [mssqltips image]( [Why Clustering for SQL Server High Availability]( This white paper covers the basics of high availability for SQL Server- what it is, what it is not and how to leverage clustering to achieve your requ... [Read Now]( [mssqltips image]( [SQL ALTER TABLE Examples]( In this article, we look at how to make changes to SQL Server table structures using T-SQL commands to add, delete and change columns in a table.... [Read Now]( TODAY'S SCRIPT ON MSSQLTips MSSQLTips Monday Mission - SysAdmin Members On MSSQLTips, our goal is to help you best manage your Microsoft Data Platform - on-prem, in a data center or in the cloud. Limiting access to SQL Server is one step to help ensure your data is safe. Permissions should be granted at the most granular level to safeguard intellectual property, client data and more. Unfortunately, permissions sometimes get granted for temporary needs, team members leave the organization or change roles, but SQL Server security is not reviewed or forgotten. Today's mission, should you choose to accept it, is to validate the members of the SQL Server SysAdmin role are appropriate on your servers. -- Purpose: This query will show all sysadmins on the instance. Is there anyone here that doesn't belong? -- -- More Information: -- SELECT [name] FROM sys.syslogins WHERE IS_SRVROLEMEMBER ('sysadmin',name) = 1; GO Learn more and share your feedback: [SQL Server Fixed Server Roles]( RECOMMENDED READING ON MSSQLTips [mssqltips image]( [Find Problematic SQL Server Queries]( Learn how to conduct deep SQL Query optimization with SQL Grease with the Enterprise dashboard, historical data, troubleshooting SQL Server Wait Stats, capturing anomalies and intelligent notifications.... [Read Now]( [mssqltips image]( [SQL Server Reporting Services Tutorial]( In this tutorial, learn about how to configure SSRS 2017 and about SSRS development tools.... [Read Now]( [mssqltips image]( [Email Validation Simplified with Web API and SSIS]( Email based validation is more than just a simple RFC check, this is where Melissa's Global Email Verification with a web-based API and SSIS delivers valuable data to SQL Server Professionals.... [Read Now]( [Manage MSSQLTips Subscriptions | Unsubscribe]( Edgewood Solutions LLC PO Box 682 | Wilton, NH 03086 [Privacy Statement]( Sent to: {EMAIL} [tag]