Mark Kimsey – Knee Deep In Data

Embedding a Report into a web page, easiest way

July 28, 2019 by Mark Kimsey

Discussion around embedding a Report into a web page

Hi Michele, the easiest way i know to bind a report into a webpage is to publish them first and then bind it in your page by using an Iframe like so: After you press on “Publish to web” you will get a code similar to this: This html-code you just have to paste in your webpage and youre ready to go.

Source: Embedding a Report into a web page, easiest way

Walkthrough of New Power BI Embedded (Embed Power BI in ISV application)

July 28, 2019 by Mark Kimsey

Interesting article talking about embedding Power BI into apps…

In my old post I described the fundamentals of old Power BI Embedded which enables ISV developers to integrate Power BI report in their applications. This meets the several needs for ISV including : integrating the existing authentication method in ISV application, not needing Power BI license for application users, data separation for each tenant (same report, but different data), etc.

Source: Walkthrough of New Power BI Embedded (Embed Power BI in ISV application)

Buffer Pool

July 18, 2018 by Mark Kimsey

Here is a curated list of Buffer Pool related links that I recommend visiting:

Buffer Pool Articles:

docs.microsoft.com
- Buffer Management
  - https://docs.microsoft.com/en-us/previous-versions/sql/sql-server-2008-r2/aa337525(v=sql.105)
    - Reading Pages
      - https://docs.microsoft.com/en-us/previous-versions/sql/sql-server-2008-r2/ms191475(v%3dsql.105)
    - Writing Pages
      - https://docs.microsoft.com/en-us/previous-versions/sql/sql-server-2008-r2/aa337560(v%3dsql.105)
SentryOne
- Nothing Is Free, Including Buffer Space – By Jason Hall
  - https://blogs.sentryone.com/jasonhall/nothing-is-free-including-buffer-space/
SimpleSQLServer.com –
- Cleaning up the Buffer Pool to Increase PLE (page life expectancy) by Steve Hood
  - http://simplesqlserver.com/2014/01/08/cleaning-up-the-buffer-pool/
- Query the Buffer Pool
  - http://www.sqlservercentral.com/blogs/simple-sql-server/2016/01/04/query-the-buffer-pool/

Buffer Pool Presentations:

Professional Association for SQL Server (requires free login)
- PASS Summit Recordings
  - http://www.pass.org/Learning/Recordings/Listing.aspx?category=Summit
    - The Great Buffer Pool Extension Mystery By John Martin
    - Field Testing Buffer Pool Extension and In-Memory OLTP Features in SS2014

Buffer Pool Articles from SQL Monitoring Tools:

Redgate’s SQL Monitor:
- Buffer pressure – By Grant Fritchey
  - http://sqlmonitormetrics.red-gate.com/buffer-pressure/
- Top buffer cache object – By Fabiano Amorim
  - http://sqlmonitormetrics.red-gate.com/top-buffer-cache-object/
Solarwinds – logicalread.com
- SQL Server Memory Buffer Pools: Understand the BasicsLink TBD: – By Pinal Dave
  - https://logicalread.com/sql-server-memory-buffer-pools-pd01/#.W06_20xFw1U

Buffer Pool Videos:

SQLPassion – SQL Server Quickie #22 – The Buffer Pool – by Klaus Aschenbrenner
- Direct YouTube Link:

SQL Masters Consulting – SQL Server 2014 – Buffer Pool Extension
- Direct YouTube Link:

SQLServer Work – What is the Buffer Pool
- Direct YouTube Link:

Baseline

July 12, 2018 by Mark Kimsey

Here is a curated list of Baseline related links that I recommend visiting:

Baseline Videos:

PASS DBAFundamentals Virtual Chapter

SQL Server Performance Monitoring & Baselining

PASS PowerShell Virtual Chapter

Maintain SQL Server Performance Baseline with PowerShell

PASS Women In Technology Virtual Chapter

SQL Server Take Over Establishing a Baseline with Lowry Kozlowski

SQL Workbooks

Collect and Baseline Wait Statistics (Dear SQL DBA Episode 14)

Always Encrypted

March 20, 2018March 20, 2018 by Mark Kimsey

Here is a curated list of Always Encrypted related links that I recommend visiting:

Always Encrypted Articles:

Microsoft’s “Always Encrypted (Database Engine)”
- https://docs.microsoft.com/en-us/sql/relational-databases/security/encryption/always-encrypted-database-engine
- Microsoft’s “Always Encrypted Wizard”
  - https://docs.microsoft.com/en-us/sql/relational-databases/security/encryption/always-encrypted-wizard
- Microsoft’s “Overview of Key Management for Always Encrypted”
  - https://docs.microsoft.com/en-us/sql/relational-databases/security/encryption/overview-of-key-management-for-always-encrypted
  - Microsoft’s “Create and Store Column Master Keys (Always Encrypted)”
    - https://docs.microsoft.com/en-us/sql/relational-databases/security/encryption/create-and-store-column-master-keys-always-encrypted
- Microsoft’s “Configure Always Encrypted using SQL Server Management Studio”
  - https://docs.microsoft.com/en-us/sql/relational-databases/security/encryption/configure-always-encrypted-using-sql-server-management-studio
- Microsoft’s “Configure Always Encrypted using Power Shell”
  - https://docs.microsoft.com/en-us/sql/relational-databases/security/encryption/configure-always-encrypted-using-powershell
    - Microsoft’s “Configure Always Encrypted Keys using PowerShell”
      - https://docs.microsoft.com/en-us/sql/relational-databases/security/encryption/configure-always-encrypted-keys-using-powershell
    - Microsoft’s “Rotate Always Encrypted Keys using PowerShell”
      - https://docs.microsoft.com/en-us/sql/relational-databases/security/encryption/rotate-always-encrypted-keys-using-powershell
    - Microsoft’s “Configure Column Encryption using PowerShell”
      - https://docs.microsoft.com/en-us/sql/relational-databases/security/encryption/configure-column-encryption-using-powershell
- Microsoft’s “Always Encrypted (client development)”
  - https://docs.microsoft.com/en-us/sql/relational-databases/security/encryption/always-encrypted-client-development
  - Microsoft’s “Develop Applications using Always Encrypted with the .NET Framework Data Provider for SQL Server
    - https://docs.microsoft.com/en-us/sql/relational-databases/security/encryption/develop-using-always-encrypted-with-net-framework-data-provider
- Microsoft’s “Always Encrypted Cryptography”
  - https://docs.microsoft.com/en-us/sql/relational-databases/security/encryption/always-encrypted-cryptography
- Microsoft’s “Migrate Sensitive Data Protected by Always Encrypted”
  - https://docs.microsoft.com/en-us/sql/relational-databases/security/encryption/migrate-sensitive-data-protected-by-always-encrypted

Microsoft’s SQL Security Blog
- Tag: Always Encrypted
  - https://blogs.msdn.microsoft.com/sqlsecurity/tag/always-encrypted/
- Raul Garcia – Getting Started With Always Encrypted (tutorial)
  - https://blogs.msdn.microsoft.com/sqlsecurity/2015/06/04/getting-started-with-always-encrypted/
Microsoft’s SQL Server Premier Field Engineer Blog
- Tim Chapman – Getting Started with Always Encrypted Part 1
  - https://blogs.msdn.microsoft.com/sql_pfe_blog/2016/07/12/getting-started-with-always-encrypted-part-1/
- Tim Chapman – Getting Started with Always Encrypted Part 2
  - https://blogs.msdn.microsoft.com/sql_pfe_blog/2016/07/19/getting-started-with-always-encrypted-part-2/
Database Journal
- Greg Larsen – Exploration of SQL Server 2016 Always Encrypted – Part 1
- Greg Larsen – Exploration of SQL Server 2016 Always Encrypted – Part 2
Brent Ozar – Should You Use Always Encrypted
- https://www.brentozar.com/archive/2017/08/use-always-encrypted/
Kasper – Use Always Encrypted data with SSAS and Power BI
- https://www.kasperonbi.com/use-always-encrypted-data-with-ssas-and-power-bi/
Paul Ballard – 6 things you should know about sql server 2016 always on encryption
- https://www.wintellect.com/6-things-you-should-know-about-sql-server-2016-always-on-encryption
SQL Server Central
- David Postlethwaite – Always Encrypted
  - http://www.sqlservercentral.com/blogs/sqldbauk/2017/04/24/always-encrypted/
- SQLEspresso – How to get started with Always Encrypted for beginners part 1
  - http://www.sqlservercentral.com/blogs/sqlespresso/2017/11/29/how-to-get-started-with-always-encrypted-for-beginners-part-1/
- SQLEspresso – How to get started with Always Encrypted for beginners part 2
  - http://www.sqlservercentral.com/blogs/sqlespresso/2017/12/13/how-to-get-started-with-always-encrypted-for-beginners-part-2/
- SQLEspresso – How to get started with Always Encrypted for beginners part 3
  - http://www.sqlservercentral.com/blogs/sqlespresso/2018/01/17/how-to-get-started-with-always-encrypted-for-beginners-part-3-one-two-punch/
mssqltips
- Aaron Bertrand – sql server 2016 always encrypted
  - https://www.mssqltips.com/sqlservertip/4011/sql-server-2016-always-encrypted/

Always Encrypted Presentations:

Professional Association for SQL Server (requires free login)
- 24 Hours of pass
  - http://www.pass.org/Learning/Recordings/Listing.aspx?category=webinars24Hours
    - Ooops, Data breach? Not with Always Encrypted by Dan de Sousa
    - Hackers Move Away, We are Always Encrypted by Reinaldo Kibel
- PASS Summit Recordings
  - http://www.pass.org/Learning/Recordings/Listing.aspx?category=Summit
    - Protecting Sensitive data using Always Encrypted by Jakub Szymaszck and Rebecca Zhang

Always Encrypted Articles from SQL Tool Providers:

Redgate:
- Robert Sheldon – SQL Server Encryption: Always Encrypted:
  - https://www.red-gate.com/simple-talk/sql/database-administration/sql-server-encryption-always-encrypted/
SentryOne:
- Aaron Bertrand – SQL Server 2016 : Performance Impact of Always Encrypted
  - https://sqlperformance.com/2015/08/sql-server-2016/perf-impact-always-encrypted
- Aaron Bertrand – SQL Tuesday #69 : Always Encrypted Limitations
  - https://blogs.sentryone.com/aaronbertrand/t-sql-tuesday-69-always-encrypted-limitations/

Always Encrypted Videos:

Channel 9 – MSDN – Data Driven SQL Server 2016
- Jakub Szymaszek – Keeping Sensitive Data Secure with Always Encrypted
  - https://channel9.msdn.com/events/DataDriven/SQLServer2016/AlwaysEncrypted

Microsoft Ignite
- Make it real with Always Encrypted, Stretch Database and Temporal Tables

Pragmatic Works
- New Security Features in SQL Server 2016

PASS Security Virtual Chapter
- Deep Dive on Encryption in SQL Server/SQL Database by Raul Garcia

DBAFundamentals
- SQL Server Encryption

AlwaysOn

March 20, 2018March 1, 2018 by Mark Kimsey

Here is a curated list of AlwaysOn related links that I recommend visiting:

AlwaysOn Articles:

Microsoft’s “Overview of Always On Availability Groups (SQL Server)
- https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/overview-of-always-on-availability-groups-sql-server
Microsoft’s AlwaysOn Professional – Home of the MS SQL Server AlwaysOn Support Team
- https://blogs.msdn.microsoft.com/alwaysonpro/
Microsoft’s SQL Server AlwaysOn Team Blog
- https://blogs.msdn.microsoft.com/sqlalwayson/
Brent Ozar – SQL Server AlwaysOn Availability Groups
- https://www.brentozar.com/sql/sql-server-alwayson-availability-groups/
  - Note: this link contains a lot of supporting information like Checklists, .pdfs, videos, links to further reading, training courses, too much to list here…
SQLServerCentral.com – Stairway to AlwaysOn by Perry Whittle
- Main Page:
  - www.sqlservercentral.com/stairway/112556/
    - Stairway to AlwaysOn Level 1: What is “SQL Server AlwaysOn”?
      - www.sqlservercentral.com/articles/Failover+Clustered+Instance+(FCI)/107536/
    - Stairway to AlwaysOn Level 2: Storage 101
      - www.sqlservercentral.com/articles/always+on/107537/
    - Stairway to AlwaysOn Level 3:Infrastructure 101
      - www.sqlservercentral.com/articles/cluster/107538/
    - Stairway to AlwaysOn Level 4: Analyse and Deploy a Windows Server Failover Cluster
      - www.sqlservercentral.com/articles/cluster/107539/
    - Stairway to AlwaysOn Level 5: Analyse and Deploy a Failover Cluster Instance
      - www.sqlservercentral.com/articles/cluster/107540/
    - Stairway to AlwaysOn Level 6:Analyse & Deploy an AlwaysOn Availability Group
      - www.sqlservercentral.com/articles/stairway/107542/
    - Stairway to AlwaysOn Level 7:Combining FCIs with Availability Gruops
      - www.sqlservercentral.com/articles/High+Availability+(HA)/109978/
    - Stairway to AlwaysOn Level 8: Segregate Mirror Traffic in AlwaysOn
      - http://www.sqlservercentral.com/articles/always+on/131901/
Brent Ozar – AlwaysOn Article Archives
- https://www.brentozar.com/archive/category/high-availability/alwayson-availability-groups/
  - Note: this links contains a number of articles on the subject.
Kendra Little Articles:
- 3 Ways Availability Groups Beat Database Mirroring
  - https://littlekendra.com/2015/12/17/3-ways-availability-groups-beat-database-mirroring/
- Why is My Transaction Log Growing in My Availability Group? (Dear SQL DBA Episode 36)
  - https://littlekendra.com/2017/03/30/why-is-my-transaction-log-growing-in-my-availability-group-dear-sql-dba-episode-36/
FPweb.net – “Understanding AlwaysOn & Mirroring with SQL Server 2012”
- https://www.fpweb.net/sharepoint-blog/understanding-alwayson-mirroring-with-sql-server-2012/#.V4kQpaLseI5
Manvendra Singh’s “Add a SQL Server Database to an Existing Always On Availability Group”
- https://www.mssqltips.com/sqlservertip/5283/add-a-sql-server-database-to-an-existing-always-on-availability-group/
Amit Banerjee’s “Chasing the Ghost Cleanup in an Availability Group”
- https://troubleshootingsql.com/2014/07/25/chasing-the-ghost-cleanup-in-an-availability-group/

AlwaysOn Presentations:

SentryOne – Monitoring and Performance Tuning for AlwaysOn by Kevin Kline
- Direct SQLbits.com Link:
  - http://sqlbits.com/Sessions/Event11/Monitoring_and_Performance_Tuning_for_AlwaysOn
  - Note: this is a direct video embedded in the SQLBits Site, I believe you can download the video and the slide deck…
Professional Association for SQL Server (requires free login)
- PASS Summit Recordings
  - http://www.pass.org/Learning/Recordings/Listing.aspx?category=Summit
    - SQL Server 2016 on Flash: Fast Track DW, SOFS, Columnstore, & AlwaysOn by Brian Walters
    - AlwaysOn in SQL Server 2016 by Kevin Farlee
    - Install an AlwaysOn Failover Cluster and Availability Group by Ryan Adams
    - SQL Server AlwaysOn QuickStart by Ryan Adams
    - Introduction to AlwaysOn Availability Groups by Adam Belebczuk
    - SQL Server 2014 AlwaysOn (High Availability and Disaster Recovery) by Kevin Farlee
    - Troubleshooting AlwaysOn Availability Groups in SQL 2014 by Trayce Jordan
    - Into the Blue: Extending AlwaysOn Availability Groups by Joseph D’Antoni
    - AlwaysOn in SQL Server 2014 by Luis Vargas
    - CAT: AlwaysOn Customer Panel – Lessons Learned & Best Practices by Ayad Shammout, David Smith, Michael Steineke, Sanjay Mishra, and Thomas Grohser
    - and many, many, more…

AlwaysOn Articles from SQL Monitoring Tools:

Redgate’s SQL Monitor:
- General SQL Monitor Page:
  - https://www.red-gate.com/products/dba/sql-monitor/resources/articles/sql-server-availability-group-monitoring
- SQL Backup Pro 8.0 Documentation
  - https://documentation.red-gate.com/display/SBU8/AlwaysOn+Availability+Groups
- Monitoring SQL Server Failover Cluster Instances and AlwaysOn Availability Groups hosted in Azure IAAS
  - https://documentation.red-gate.com/sm7/configuring-sql-monitor/adding-and-configuring-servers/adding-servers-to-monitor/monitoring-sql-server-failover-cluster-instances-and-alwayson-availability-groups-hosted-in-azure-iaas
SentryOne and Performance Advisor:
- General SentryOne Page:
  - https://www.sentryone.com/sql-server/alwayson
- Always On Availability Groups & VMs by John Martin
  - https://blogs.sentryone.com/johnmartin/availability-groups-vms/
- Monitoring and Performance Tuning For AlwaysOn
  - Direct SQLbits.com Link:
    - http://sqlbits.com/Sessions/Event11/Monitoring_and_Performance_Tuning_for_AlwaysOn
    - Note: this is a direct video embedded in the SQLBits Site, I believe you can download the video and the slide deck…
Solarwinds’ Database Performance Analyzer
- How to Register and Monitor an Availability Group
  - https://support.solarwinds.com/Success_Center/Database_Performance_Analyzer_(DPA)/Register_and_monitor_an_Availability_Group
- Interactive Demo:
  - http://database.demo.solarwinds.com/iwc/login.iwc

AlwaysOn Videos:

PASS – High Availability Disaster Recovery Virtual Chapter – Microsoft SQL Tiger Team – Availability Group Troubleshooting Improvements
- Direct YouTube Link:

Grant Fritchey’s Availability Group Monitoring in SQL Monitor
- Direct YouTube Link:

PASS – High Availability Disaster Recovery Virtual Chapter’s “TroubleShooting AlwaysOn Availability Groups in SQL Server 2015” by Trace Jordan
- Direct YouTube Link:

24Hours of PASS
- SQL Server 2016 AlwaysOn Availability Groups Enhancements by Jimmy May
  - Direct YouTube Link:

24Hours of PASS
- SQL Server AlwaysOn Quickstart by Ryan Adams
  - Direct YouTube Link:

24Hours of PASS
- AlwaysOn in Microsoft SQL Server 2014 by Luis Vargas
  - Direct YouTube Link:

Virtual Group Webinars
- SQL Server 2016: Always On Enhancements by Percy Reyes
  - Direct YouTube Link:

Virtual Group Webinars
- Migration to SQL Server AlwaysOn lessons learned
  - Direct YouTube Link:

Virtual Group Webinars
- AlwaysOn Multi-Site configurations by John Martin
  - Direct YouTube Link:

Virtual Group Webinars
- Install an AlwaysOn Failover Cluster and Availability Group by Ryan Adams
  - Direct YouTube Link:

Virtual Group Webinars
- Troubleshooting AlwaysOn Availiablity Groups in SQL 2014
  - Direct YouTube Link:

Virtual Group Webinars
- Is AlwaysOn the Right high Availability and Disaster Recovery Plan for me? by Ryan Adams
  - Direct YouTube Link:

Pragmatic Works
- What’s New in AlwaysOn Availability Groups in SQL Server 2016
  - Direct YouTube Link:

Pragmatic Works
- How to video: AlwaysOn Availability Groups
  - Direct YoutTube Link:
    - https://youtu.be/a7SFS4TvRWM (Video would not embed into page, must navigate manually or search the above title in YouTube…)

Brent Ozar
- AlwaysOn Availability Groups Quiz and FAQ
  - Supporting Q/A Link:
    - https://www.brentozar.com/archive/2015/02/alwayson-availability-groups-faq/
  - Direct YoutTube Link:

SentryOne
- AlwaysOn Monitoring with Performance Advisor
  - Direct YouTube Link:

SentryOne
- Monitoring and Performance Tuning For AlwaysOn
  - Direct SQLbits.com Link:
    - http://sqlbits.com/Sessions/Event11/Monitoring_and_Performance_Tuning_for_AlwaysOn
    - Note: this is a direct video embedded in the SQLBits Site, I believe you can download the video and the slide deck…