Insights
Data Infrastructure
5 articles
-
SQL Server 2016 reaches the end of extended support in July: your optionsTechnical Guidance
If a business application of yours runs on SQL Server 2016, its security updates stop in July unless you arrange otherwise. Here are the realistic routes and the questions that decide between them.
-
Choosing a database platform for a line-of-business application: questions to ask firstBusiness Advice
The database behind a new business application is usually settled in a sentence of the proposal, yet it shapes cost, skills, hosting, recovery and how easily you can leave. Here are the questions worth asking before you agree to it.
-
SQL Server performance problems that are really infrastructure problemsAdvanced Engineering
When a SQL Server workload is slow, the database team points at the disk and the storage team points at the query. Wait statistics, file latency and OS counters, read as deltas against a baseline, show which layer owns the delay.
-
Azure Data Factory in practice: where a pipeline runs and what it can reachAdvanced Engineering
A failed copy activity rarely says which machine tried to connect. This is how Data Factory's integration runtimes, managed networking, Private Link and credentials decide what a pipeline can reach, and how to find the failing hop.
-
SQL Server 2014 reaches the end of extended support in July: your optionsTechnical Guidance
If a business application of yours stores its data in SQL Server 2014, its security updates stop in July unless you arrange otherwise. Here are the routes Microsoft documents and the questions that decide between them.