sqlrus.com // dba // bat whisperer
Cloning things is all the rage these days…..even Storm Troopers. Anyway, by now, you probably have seen documentation on Query Store and DBCC Clonedatabase. Query Store, introduced in SQL Server 2016, is considered the “black box” or “flight recorder” of queries. It retains a history of executed queries, including run-time […]
After being immersed into the consulting world again for 6 months now, I’ve gotten to work with clients in several different areas of world, although most of them are based here in the United States. Over that time I learned every client is different and handles things differently, but that […]
DevOps. It’s one of the latest buzz words in many technical communities. Database Doing DevOps This phrase, however, is NOT heard in many technical communities. However, it really should be. Databases doing devops is probably one of the hardest things to tackle in the DevOps world. With hard work though, […]
Community. In the SQL Server community, we are basically one big #sqlfamily. This is a story of how the family helped one individual and one of the main reasons I am involved, to begin with. Meet Jerad. In happenstance, both our children attend the same school. He happened to recognize […]
In my experience, there have been occasions where SQL Server Management Studio (SSMS) becomes unresponsive for a length of time. In one particular case, this occurred while I was expanding the list of databases. SSMS just sat there and waited for some unknown reason and became frustrating. The client eventually […]
Several months ago, I was looking at a question posted on ask.sqlservercentral.com. I discovered an answer to a question regarding how to move a large amount of data around quickly. The solution was related to an aspect of table partitioning that I was not aware of. If you aren’t familiar […]
You never know when the idea for a script will make an appearance. I had to work with composite primary keys recently while working on a project for a client. More specifically, I had to create a process that would dynamically (dynamic SQL?! Say it isn’t so?!) handle composite keys […]
Ok, I’ll admit it. I like scripts that are handy and do things. Especially if the scripts make my life easier. Now, not every environment is the same. Instances get configured differently or things change just due to the nature of the business. In a previous life I would routinely […]