It’s been an interesting ride, optimizing SQL Server, figuring out best use cases for the different flavors of SQL Server that we have come to rely on, and we’re seeing those choices pay off in terms of management, performance, and cost savings. The “flavors” I’m speaking of? AWS RDS SQL Server, Azure SQL DB specifically. Our event platform is based […]
Tag: azure
Troubleshooting SQL Server 2017 backup/restore problems
Troubleshooting SQL Server 2017 backup/restore problems If you have problems with SQL Server 2017 backup/restore, review this troubleshooting checklist to find potential solutions. 1. Check that you have appropriate permissions to make backup/restore. To backup database or transaction log, you should have BACKUP DATABASE or BACKUP LOG permissions granted to you, or you should be a member of the sysadmin...
Cloud Services a Commodity?
We have a number of services that are hosted with cloud providers – from this site’s hosting to our virtual event platform and others, it’s interesting to see cloud evolve and provide some killer support for deploying cool solutions. One of the things that we’ve been seeing more and more though is a “yeah, us too!” type of approach to […]
Data Flow and Capacity… and Knowing All The Variables
Data sources are certainly something that should be on nearly everyone’s radar. With more devices, more analysis and more utility coming from information than ever before, it’s pretty obvious that our pendulum associated with being a data professional will have yet more swings in the direction of managing performance as things expand. This post from was interesting as they tried […]
U-SQL
So you like the simplicity of the SQL Language. What if you could use SQL syntax against data that is not structured? Well, that is U-SQL. To get started using U-SQL you can find an introduction with links to more tutorials at https://docs.microsoft.com/en-us/azure/data-lake-analytics/data-lake-analytics-u-sql-get-started. We already have the ability to work with data that may not be contained in an SQL Server […]
Important Questions Moving to the Cloud
Pro-Center Video Programming for IT Professionals
Microsoft Trusted Cloud
Pro-Center Video Programming for IT Professionals
Azure AD authentication for SQL Database V12
Pro-Center Video Programming for IT Professionals
Pairing SQL Server with Azure Storage
Pro-Center Video Programming for IT Professionals
Azure SQL Database Cost and Performance
Pro-Center Video Programming for IT Professionals