Category Archives: Data
Best practices for SQL Server Availability
Microsoft, since 2012, has recommended Always-On Availability Groups as the Tier 1 solution for SQL Server databases. Here are the “Always On” Architecture guides: https://blogs.msdn.microsoft.com/sqlalwayson/2012/07/03/alwayson-architecture-guides/ In particular, this guide is thorough, is written by still-famous experts in the SQL Server world, … Continue reading
Azure SQL Database, Managed Instance!
Recently announced was general availability of Azure SQL Database Managed Instance. I am excited by how much easier it is nowadays to reduce your workload by migrating to Azure SQL Database, and lifting and shifting to Managed Instance. What is this … Continue reading
SQL Saturday Boston BI: Migrate to Azure
I will be talking at SQL Saturday Boston BI 2019 about migrating a SaaS application to the cloud, and the business and technical challenges. Continue reading
SQL Saturday Events – Yes, you should go
What are SQL Saturdays? Basically, a day of free training by qualified and enthusiastic people, surrounding the Microsoft data platform! Free? Yes. Sometimes the events charge for lunch. Know that the speakers generally are working on their own dime. Also, … Continue reading
Troubleshooting SQL Server on-premises Performance
Are you trying to figure out if you have SQL Server performance issues? Is your server overloaded? There are free tools to help you diagnose this. Generally, I would tell you to get a support case opened, but you can … Continue reading
Developer tools and training for SQL Server, Mobile Development, and cross platform. Where are they?
The following are a set of links to free tools and training that can help you get started around data, mobile, and cloud. Continue reading
Azure DataFest! March 1st, Burlington MA!
On March 1st, there will be an event, “Azure DataFest”, all day from 9-5 at Microsoft’s office at 5 wayside road, Burlington, MA. If you wish to attend, please go here. We are charging 22 dollars for this event plus … Continue reading
Upgrading to SQL 2016 (and 2017) and Windows Server 2016
A lot of engineering work has gone into easing upgrades for SQL Server and Windows at Microsoft. In general, a lot of breaking changes no longer happen especially around the database engine. But what about other components? What about Windows? … Continue reading
SQL Saturday! Albany July 29, 2017 – Come and learn Databases and BI!
SQL Saturdays are free training events, put on by volunteers who deliver great content to you, the audience, all around Microsoft SQL Server, and surrounding technologies. Continue reading
Power BI: Pro Versus Premium
I have been sharing Power BI with customers for some time now. A quick tour is here. At a high level, Power BI lets you pull together one or more data sources, and create visualizations that are interactive. With our … Continue reading
You must be logged in to post a comment.