sqlrus.com // dba // bat whisperer
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 […]
Last month in January, I participated in the Idera #sqlchat. This is a monthly chat meeting that is organized by Idera Software and hosted by a SQL Server community member. This one was hosted by Monica Rathbun (B|T) and her topic for the month was “SQL Server Bad Habits in […]
In December I wrote about working from home in which I talked about Trello. Trello is a virtual kanban board that allows me to visually manage projects & tasks. As a follow up, I subsequently did a post where I talked about Trello more in-depth and how to use it. […]
Recently, one of my clients had a need to automatically download a file from a public facing state government website. Normally this can easily be done in a manner of ways. Powershell is the first that comes to mind but you could also utilize scripting tools such as wget or […]
With the announcement of the recent security issues, namely Meltdown and Spectre, we at Denny Cherry & Associates Consulting have been focused on security awareness this entire week. To further underscore it, we are hosting a Security Webcast today, Friday January 19th, 2018 at 2:00PM EST (11:00 AM PST). Make […]
Recently, I got to work with a client on something interesting. We implemented transactional replication to send data to an Azure virtual machine. This was being done to perform some testing for a project. Given that the two machines were NOT within the same Active Directory domain, we wanted to […]