Phil factor find much to admire in the StackOverflow architecture. It is built on SQL Server, doesn't use microservices or the cloud. It all seems a bit retro, but it manages manage 440 million queries a day, peaking at 8500 queries per second, and never even breaks into a sweat.
Automation - done right - frees you to add real value to your team, but you've got to be careful not to shoot yourself in the foot. Join Brian A. Randell, Grant Fritchey and Steve Jones as they discuss how to get started when automating your database operations, and what activities are ripe for automation!
Learn how to generate lists of column values from multiple rows by grouping and using a recursive CTE. This is a very flexible and easy implementation, compared to using cursors or PIVOT operators.
The Power BI Designer was recently added under the Microsoft Power BI umbrella. Power BI Designer quickly builds reports or dashboards locally and deploys them to the Power BI site. In this article, Arshad Ali demonstrates how to get started with Power BI Designer.
Steve Jones talks about blogging today, how it can help your career, and how easy it can be to get started.
Challenges with integrating MySQL data in an ETL regime and the Amazing FMTONLY trick!
A collection of technologies and links that will help you learn more about SQL Server 2012.
Azure Stream Analytics aims to extract knowledge structures from continuous ordered streams of data by real-time analysis. It provides a ready-made solution to the business requirement to react very quickly to changes in data and handle large volumes of information. Robert Sheldon explains its significance.
This metric measures the amount of memory used by the total number of ad-hoc queries that are currently in the plan cache. If the value is high, it indicates memory is being wasted by storing the execution plans of queries that will never be run more than one time.
By Tim Radney
Over the past few weeks, I’ve been contacted by multiple customers experiencing the same...
By Vinay Thakur
These days everything is changing to AI World, IT roles are getting changed and...
I’m doing a small series on indexing basics for SQL Server, and on May...
Comments posted to this topic are about the item There's Too Much to Learn
Comments posted to this topic are about the item How to Calculate Distance Between...
Comments posted to this topic are about the item SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers