sqlrus.com // dba // bat whisperer
Foreign keys help to ensure referential integrity between tables. In other words, parent records cannot be deleted if there are child records present. This is a great thing and if you aren’t using foreign keys currently, you really should be. While very helpful with referential integrity foreign keys can introduce […]
I’ll admit it, sometimes I’m wrong. Recently I blogged about the usefulness of a newer feature that was enhanced with the release of SQL Server 2019. Resumable Indexes operations was introduced with SQL Server 2017 however it was limited to only REBUILD operations. With the release of SQL Server 2019, […]
Happy New Year!! Yes, I know it was two days ago but I’m still pseudo-on-vacation-not-really so just another simple blog post wishing you prosperity, health, and good tidings this new year. I hope that 2020 brings you warmth and joy throughout the year and may it be better than 2019! […]
Christmas was this week so nothing technical today, just a simple blog post wishing you and your family blessings and good tidings during this holiday time. May the holidays bring you peace and joy!
Some of the most eagerly anticipated features now available in SQL Server 2019 relate to expanded data virtualization capabilities. Data virtualization enables you to bring all your data together when you query it instead of using complex ETL procedures to physically move the data into one place. In other words, […]
While at PASS Summit 2019, I gave a session on designing Azure Disaster Recovery Strategies for the Data Platform. In that session, I talked about Azure storage and the various redundancy options that are available to the storage, one of them being geo-redundant (GRS). Geo-redundant storage asynchronously replicates your data […]
A few weeks ago I attended the annual PASS Summit conference in beautiful Seattle, Washington. This is an event that I look forward to every year. Being able to share my knowledge as a speaker, reconnect with friends and family of the sql persuasion, meet new people, and learn new […]
Yesterday was Thanksgiving for those of us living in the United States. If you celebrate this particular holiday, I hope that it was a day full of love and care with the ones closest to you. I was fortunate to spend the holiday visiting family and spending time with my […]