“How do I know my data is secure?” “A lot of companies have been hacked lately, why would I want to move to the cloud?” “We have sensitive data that can’t be moved to the cloud.” If you are a decision maker in a company you have probably raised questions and objections similar to those above. If you are someone who is architecting solutions that...
CJIS and the Microsoft Cloud
Having a cloud you can trust is important. Microsoft takes security and compliance extremely seriously in both the commercial and government clouds. An August 2016 article on the Azure blog, Not All Clouds Are Created Equal, addressed this topic in detail discussing the impact of a CJIS compliant cloud on Justice and Public Safety organizations. State and local agencies in 22 states (at the time...
Webinar Followup: New Security Features in SQL Server 2016
I recently presented a free webinar for Pragmatic Works where I discussed new security features in SQL Server 2016. You can click here to watch the recording of the webinar if you missed it. In this follow up I wanted to post the scripts I used and answer a few questions from the webinar along the way. Q: Can I use a WHERE clause on a masked column? For instance, SELECT * FROM Table WHERE SSN...
Webinar Followup: Migrating your SQL Server VMs to Azure with PowerShell
Earlier this week I presented a free webinar for Pragmatic Works where I discussed how to migrate virtual machines to Azure. You can click here to watch the recording of the webinar if you missed it. In this follow up I wanted to post the scripts I used, walk through the steps in the process and answer a few questions from the webinar along the way. We will separate this into 4 sections:...
Hyper-V The trust relationship between this workstation and the primary domain failed
Note this fix only works on Windows Server 2012/Windows 8 or later. A different method is required on Windows Server 2008R2 or earlier which involves the use of the NETDOM command. For several years now I have been using Hyper-V for building out a virtual development environment on my laptop. Since I work as a consultant I have to handle a lot of different software scenarios. Some customers use...
Preach The Gospel Always, If Necessary Use Words
I’ll be honest, I contemplated a lot about whether to write this blog or not for fear that it may come off the wrong way or just not convey the point I want, but here we are…in a hotel room typing away. In no particular order, just my thoughts as they come out. I’m not syndicating this particular blog just to get that out in the open, you will only find it here. I’m not...