SQLMCM Training – Day 17

Today Bob spoke about Auditing, SQLCLR, XML, and Spatial Data. Because I already know these concepts very well, my study notes for today are very sparse. Auditing SQL Trace has too much drawbacks from Auditing Separate program Column Level GRANT overrides a DENY Auditing audits changes to Auditing Auditing Targets ...

Read more

SQLMCM Training – Day 16

Today Bob spoke the whole day about securing SQL Server, security itself, and encrypting data. It was really hard content, and sometimes it was really hard to follow, because of too much PowerPoint slides. I already miss Paul’s whiteboard drawings… 😉 Here are my study notes. SQL Server Setup SQL ...

Read more

SQLMCM Training – Day 15

The whole last 3 days I’ve spent almost every minute with reviewing the material from the last 2 weeks (around 38 hours in total…). Today Bob Beauchemin joined us, and talks the whole week about SQL Server Development, Security, PowerShell, and some esoteric technologies like SQLCLR, Service Broker, and CDC/Change ...

Read more

Chance to win a free seat in my Performance Troubleshooting Workshop in London!

As you might know, I’m running my “Advanced SQL Server Performance Troubleshooting Workshop” from September 12 – 14 in Central London. You can find out further information about the detailed agenda here: http://csharp.at/Registration_UK.aspx Next week you have the amazing possibility to win a free seat in that workshop! It’s very ...

Read more

SQLMCM Training – Day 11

Today Jonathan presented on Replication and Paul about Database Snapshots, and his baby called “CHECKDB” – he has been married with CHECKDB for almost 5 years at Microsoft. Module 8: Replication Distributes data to different locations Offloading reporting to another database Transactional Replication Used in server-to-server scenarios that require high ...

Read more

Copyright © 2018 by SQLpassion e.U. · Imprint · Offerings · Academy · Contact · Data Protection · Go to Top