sqlrus.com // dba // bat whisperer
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 […]
Starting with SQL Server 2017, Microsoft introduced the ability to pause and then resume index rebuilds. This was a great feature and with the release of SQL Server 2019, we now have the ability to do the same functionality on the actual create index process. The ability to pause and then […]
Hiring consultants is like buying a new washing machine. In other words, you get what you pay for some times. A couple of months ago, my washer and dryer were going out and I have been aware of this for some time. I was hesitant to purchase new appliances in […]
If you are like me, when certain events end, it is a bittersweet time. You’ve enjoyed your time with people you consider family, got to learn some new things to help your career, and hopefully have made new connections that will last maybe even a lifetime. Today marks the last […]
In just a few days, I’ll begin my annual journey to Seattle, Washington for the PASS 2019 Summit. This is one of my favorite conferences to attend. It is usually a “family” reunion for me as I have made a significant number of connections simply by attending. While at Summit […]