Passing the 70-767 Implementing a Data Warehouse exam has been a goal of mine for a while now, and I finally achieved that on 11/30/2020! The exam is going to be retired soon (January 31st, 2021), so this was cutting it close. And since the exam is going to be retired in 62 days of starting this post, I’m not going to post in my usual format for passing an exam. If you do have questions, please feel free to leave them in the comments. (Note: I do not plan on breaking the Microsoft NDA I signed in the exam, so any content in the comments will adhere to the NDA or will be removed.)
Continue reading “Hurray! I passed my 70-767 and earned my MCSE!”Tag: SQL Server
SQL Server Database in Suspect mode
I’m going to preface by saying, I ran into a specific scenario and I strongly suggest you see if this scenario is what’s currently affecting you before you try these troubleshooting steps.
Continue reading “SQL Server Database in Suspect mode”Truncate vs Delete
There are many myths and misconceptions regarding TRUNCATE in SQL Server. I think this is heavily influenced by how other Relational Database Management Systems (RDBMS) handle TRUNCATE. Continue reading “Truncate vs Delete”
How to learn and implement Change Tracking in SQL Server
Why would you pick Change Tracking as a technology to use?
This allows you to detect changes in a lightweight manner via T-SQL functions to extract information about DML changes to Change Tracking enabled tables. Change Data Capture is more about auditing or creating a historical view utilizing the Transaction Log and Temporal Tables are the next step up from there which became available in 2016 versions of SQL Server. Change Tracking is primarily used for finding only things that have changed. Not necessarily why, how, or who changed it, but what has changed and what it is now. Continue reading “How to learn and implement Change Tracking in SQL Server”
T-SQL Tuesday #108 Learning non SQL Server technologies
This month’s T-SQL Tuesday is hosted by Malathi Mahadevan. Our topic comes during the PASS Summit, a SQL event filled with learning, networking, and the #SQL Family! So it is only fitting that our topic is regarding learning and education. Thank you Malathi for hosting this month and for the great topic!
The topic is to pick one thing that is not SQL Server that we want to or already know. How do we or did we learn this skill and how do we add it to our resume? Continue reading “T-SQL Tuesday #108 Learning non SQL Server technologies”