sqlrus.com // dba // bat whisperer
Sometimes the brilliance of a solution is lost in its simplicity. Full disclaimer, this was Joey D ’Antoni’s (B|T) idea, however, he has given me permission to blog about it. Recently, Joey and I were helping a client to reconfigure their production SQL Server instances to have a new and […]
My day to day work machine is a Windows 10 HP laptop. It remains docked at my desk where it happily helps me to go about my daily business. However, my backup machine, is an Apple MacBook Pro. It’s small footprint and ease of use allows me to easily shift […]
Some of us have been lucky enough to have already been working from home (WFH) prior to the world events. This has allowed most of us the ability to easily ready our homes to fit our needs. For those that have suddenly been plunged into the working from home lifestyle, […]
Microsoft offers several options for moving your SQL Server workloads to Azure. If you’re looking to host modern cloud applications, your best option is Azure SQL Database Service. For an overview of the business benefits of using data infrastructure services in the cloud, download “Future-Proof Your Data Infrastructure with Azure: […]
Sometimes a swift kick in the rear is needed to become motivated. Recently, I was the recipient of the business end of a boot and it drove me to take a serious look at how I write abstracts for new sessions that I would like to teach. After reviewing things, […]
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! […]