sketchnote of Jes Borland’s talk ‘Minimize Data Loss with Advanced Restore Methods’

Borland, Jes - Minimize Data Loss with Advanced Restore Methods

SQLPass page for the webcast is: VC Data Architecture SQL Server Users Group: PASS Data Architecture Virtual Chapter > Meeting Detail

Jes blogs here: Less Than Dot – Blog – Jes Borland

The slides and SQL for this presentation are at: Less Than Dot – Blog – MinimizeDataLossWithAdvancedRestoreMethods

Sketchnote of Brent Ozar’s talk on ‘How to Think Like the SQL Server Engine’

Ozar, Brent - How to think like the Sql Server Engine

Brent blogs at: Brent Ozar, Author at Brent Ozar Unlimited® by Brent Ozar Unlimited®

Brent Ozar Unlimited’s upcoming events are listed here: First Aid – SQL Server Training, Performance Tuning & Other Events by Brent Ozar Unlimited®

Idera’s sponsored webcasts are listed here: Webcasts

Sketchnote of Grant Fritchey’s talk on ‘Getting Started Reading Execution Plans’

Fritchey, Grant - Getting Started Reading Execution Plans

Grant’s blog: Home Of The Scary DBA – Intimidating Databases and Code

Event web-page: PASS Data Architecture Virtual Chapter: Next Meeting

Sketchnote of Richard Scrugg’s talk on ‘Getting Started with Sql Server Compliance Auditing’

Scruggs, Richard - Getting Started with Sql Server Compliance Auditing

The Idera blog is: Expert advice on SQL server and SharePoint performance — Idera blog

A follow-up page for the talk is: Geek Sync I Getting Started with SQL Server Compliance Auditing | IDERA Community

listing database roles granted to database users in sqlserver

The output from this is unlovely, but it does the trick for the time being.


$DatabaseUsers = dir Sqlserver:\sql\$ServerName\$InstanceName\databases\$DatabaseName\Users
foreach ($User in $DatabaseUsers) {"==$User=="; $User.EnumRoles()}

The output looks like this


==[Company\service_account]==
RSExecRole
db_owner
==[Company\user1]==
RSExecRole
db_owner
db_accessadmin
db_securityadmin
db_ddladmin
db_backupoperator
db_datareader
db_datawriter
==[user2]==
==[user3]==
RSExecRole
db_owner
db_ddladmin
db_datareader
db_datawriter

Sketchnote from Grant Fritchey’s talk on SQL 2016 features ‘A partly cloudy future’

Fritchey, Grant - A partly cloudy future

Slides: SITC15_Grant-PartlyCloudyFuture.pdf

Blog: Home Of The Scary DBA – Intimidating Databases and Code

Event website: SQL in the City | Agenda

Sketchnote from Tony Davis’ talk ‘Uncovering SQL Server Query Problems with Execution Plans”

Davis, Tony - Uncovering Sqlserver query problems with Executio

Slides: SITC15_TonyDavisExecutionPlans.pdf

Twitter: https://twitter.com/TonyTheEditor

Blog: https://www.simple-talk.com/blogs/2015/10/14/sql-in-the-city-my-imminent-execution-plans/