This post will be updated with new information as we make announcements. Each year I help organize the SQL Saturday in Jacksonville, FL. We have an awesome group that helps organize and put the event on each year. There are a few changes to the date and location compared to past years, so if you are in the area and plan on attending pay close attention. If you are interested in speaking at the...
We previously looked at Archiving Azure SQL Database to a BACPAC and in today’s post we are going to address how to look at that data by restoring or importing it to a local SQL Server. As discussed in the previous post this discussion arose in a conversation with a customer who needed to keep monthly archives of their data for a 10 year time period to comply with industry regulations and...
UPDATE: The other half of this scenario has been posted. Check out Importing a BACPAC to SQL Server. Azure SQL Database is a managed database platform as a service (Paas) offering available from Microsoft in the Azure cloud. One of the advantages to Azure SQL Database is all the file management, server maintenance and backups are taken care of automatically. Point in time recovery is built...
Here we are, 7 years working with SQL Server and Microsoft BI tools. Sure in the grand scheme of things that’s not a long time but when you consider that all of those years have been in consulting it’s more experience than many people will get in an entire career. I’ve been on easy engagements where I built SSRS reports for two weeks and I’ve been on difficult engagements...
“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...
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...
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...
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:...
Each week Pragmatic Works hosts a free training session. The topics include SQL Server internals, Business Intelligence, cloud services and even big data. On Tuesday November 17th, 2015 I will be presenting the free training session on Azure Virtual Machines. Devin Knight (Twitter | Blog) and I presented on this topic recently and it received a great response. Whether you are already using Azure...
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...
Bradley Schacht is a Principal Program Manager on the Microsoft Fabric product team based in Jacksonville, FL. Bradley is a former consultant, trainer, and has authored 5 SQL Server and Power BI books, most recently the Microsoft Power BI Quick Start Guide. As a member of the Microsoft Fabric product team, Bradley works directly with customers to solve some of their most complex data problems and helps shape the future of Microsoft Fabric. He frequently presents at community events around the country, is a contributor to sites such as SQLServerCentral.com, and is a member of the Jacksonville SQL Server User Group (JSSUG).