sqlrus.com // dba // bat whisperer
Unless you are living under a rock, you have most likely heard of the hurricane that is bearing down on the east coast of the United States. Some areas have mandatory evacuation and I have seen reports of 80’ plus foot waves so this hurricane is not a joke. Another […]
As data professionals, we should always strive to keep our systems updated and patched to ensure proper security of our environments. Microsoft has moved away from releasing service packs to releasing just cumulative updates and the occasional hotfixes. These hotfixes may or may not be security related, but it behooves […]
The Cloud is a fun and exciting place to be. Exciting as it may be, even in the cloud, protection of databases and the data they contain has to be forefront in your mind. If it isn’t, that is just calling for a disaster to happen. Recently, I had the […]
If you are like me, you use the SSMS GUI for various things. Though, I tend to use scripts for the management of most things, I do check on the database growth rates of files using the GUI interface. While I was recently, doing a review of a client’s environment […]
Since joining Denny Cherry & Associates Consulting, I tend to travel about once a month. This isn’t a huge amount and is usually over a weekend (except for that opportunity to go to Australia that didn’t pan out). Since I work in the IT field, security is highly important to […]
Microsoft Azure offers up a lot of technologies that you can play around with. One thing that you might not know is that they also offer up a mobile presence to help manage your Azure resource. The application is available for download for your mobile devices from the app store […]
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 […]