Adventures In Foreign Keys 4: How Should I Index These Things?
This week, we’re all about foreign keys. So far, we set up the Stack Overflow database to get ready, then tried to set up relationships, and encountered cascading locking issues. Dawn Of The Data I don’t know how long the recommendatio …
T-SQL Decommenter Part II
Demonstration of the T-SQL Decommenter removing comments from a sample T-SQL batch.
SOX and Database Administration – Part 3
Database administrators are typically responsible for the security and availability of financial data. In this article, Robert Sheldon discusses SOX, passed in 2002, that governs financial data of publicly traded companies in the US.
SQL SERVER – Steps to Change IP Address of SQL Server Failover Cluster Instance
There have been many questions in my mailbox asking about exact steps to change the windows cluster and SQL failover cluster IP address to the new VLAN. In this blog, I would outline the steps which are needed to perform this migration. If we look at t …
AMD EPYC 7371 Processor in Q1 2019
At the Supercomputing 2018 Conference, AMD announced a special high-frequency SKU in their first-generation 14nm AMD EPYC “Naples” line of server processors that will be the AMD EPYC 7371 processor. This upcoming processor will have 16 core …
IEPUM2017: Immersion Event on Planning and Implementing an Upgrade/Migration to SQL Server 2017
We’ve just announced the next round on live, online training classes for the first quarter of 2019. Paul has more details about all six classes that we are offering here. I will be teaching IEPUM2017: Immersion Event on Planning and Implementing …
Six new 2019 Q1 live online classes open for registration!
Due to the popularity of our live, online classes this year, we’re presenting six more in the first three months of 2019! Each class will be delivered live via WebEx or GoToMeeting over three days (roughly 12-13 hours of content includi …
New live online training class in March: Columnstore Indexes
Continuing our series of live, online classes, Jonathan will be delivering his new IECS: Immersion Event on Columnstore Indexes in March! The class will be delivered live via WebEx or GoToMeeting on March 26-28 (roughly 12-13 h …
Adventures In Foreign Keys 3: A Cascade Of Badness
Legendreary In the last post, I looked at some issues with implementing foreign keys with cascading actions. Namely that, well, it fell apart pretty quickly just trying to set up. I didn’t even get to the point where I wanted to test all those re …
Stairway to SQL PowerShell Level 11: SQL Server Maintenance Using SQL PowerShell
This level will demonstrate simple techniques to perform a few important SQL Server maintenance tasks using PowerShell. We’ll barely scratch the surface of what’s possible but I hope it will whet your appetite.
The Benefits of Adopting Compliant Database DevOps at PASS
The GDPR presented a challenge for PASS – a community of over 250,000 data professionals with almost 300 Local Groups around the world and 24 Virtual Groups. This whitepaper shows how PASS were able to introduce compliance by default with the new data …
Video – Bert & Pinal Troubleshoot a Slow Performing SQL Server
Earlier last week, I had the opportunity to attend my 10th SQL PASS. Yes, It has been 10 years since I have been visiting the PASS conference. This year, I had the opportunity to present 1 pre-con, 2 general sessions, 1 lightning talk. I really had a b …
Adventures In Foreign Keys 2: Difficulties, Difficulties, Difficulties
This week, we’re all about foreign keys. Yesterday’s post covered scripts to set up the Stack Overflow database to get ready, eliminating data that would violate FK relationships. You Had Two Jobs! Let’s say I wanted to implement …
Overview of In-Memory Technologies of Azure SQL Database
Azure SQL Database offers a straightforward approach to controlling its performance through vertical scaling. Despite its simplicity, scaling up has obvious pricing implications and, while it is an online operation, it might result in rollback of in-fl …
CosmosDB Change Feed Processing
This article was created to help readers understand CosmosDB change feed processing.