Real-time moving averages for IoT with R
Computing an average over all your data is easy, but what if your data arrives incrementally and you need to be able to compute real-time averages on the fly? That's what we are going to look at.
SQL Server Security Part 2
In part one Chris Kempster covered a variety of security recommendations primarily for production systems. In Part two of this series he continues to explore security at a variety of levels where you may not realize you are vulnerable.
Database Build Blockers: Cross-Server Database Dependencies
Phil Factor demonstrates how to tackle builds when databases make cross-server references. The technique uses synonyms to represent the remote objects, and local 'stub' objects to overcome the problems caused by 'missing references' when building the individual objects.
Entity Framework Core Raw SQL Queries Examples
In this article we look at how to run SQL Server queries with Entity Framework Core using the DbSet.FromSql method, parameterized queries, stored procedures and using the Database.ExecuteSqlCommand property.
Getting a List of the Striped Backup Files
If you have a list of striped backup files, how can you find the latest backup set? Steve Jones uses dbatools and PowerShell to automate this process.
SQL Server 2019 Graph Database and SHORTEST_PATH
With SQL Server 2019 on the way, it’s time to begin learning about all the new features. In this article, Dennes Torres demonstrates how to use the new SHORTEST_PATH function that is part of the Graph Database feature.
You just Build It don’t you? 12 Common Database Build Blockers
Database deployments, like the sheep of exasperated hill-farmers, often find strange and unexpected ways to self-destruct. Phil Factor describes the most common things that can go wrong, and how a reliable automated database build process can prevent messy accidents.
Searching for Answers Inside
Learning how an organization, or even just a codebase, works can be a challenge for new employees.
Azure Data Factory If Condition Activity
In this tip we look at how to use an If Condition activity in an Azure Data Factory pipeline for conditional logic.
Blogs
VPN + SQL Server Connections: Why Long-Working Setups Suddenly Fail with Msg 10054 and “Connection Broken”
By Tim Radney
Over the past few weeks, I’ve been contacted by multiple customers experiencing the same...
Future IT Roles – Agentic Architect and AI Boom!!
By Vinay Thakur
These days everything is changing to AI World, IT roles are getting changed and...
Free Webinar about Columnstore Indexes
I’m doing a small series on indexing basics for SQL Server, and on May...
Forums
BCA KCP Mal Taman Anggrek Tlpn/wa0853.7373-7551
Tlpn/wa0853.7373-7551 Jl. Letjen S. Parman No.Kav. 21 Lower Ground Lot. C 07, Slipi, Kec....
BCA KCU TANJUNG PINANG TLP/WA 08216977749
Jl. Sunaryo, Kemboja, Kec. Tanjungpinang Bar., Kota Tanjung Pinang, Kepulauan Riau 29112
There's Too Much to Learn
Comments posted to this topic are about the item There's Too Much to Learn
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers