Azure Sphere
The Azure Sphere project is a great piece of research at Microsoft that might help us data professionals with security.
Understanding Auctions
We participate in auctions all the time even when we don’t realize it. In this article, Joe Celko discusses the many different types of auctions and how they work.
Best Option for Working with Files in SSIS
This time we will compare different solutions to copy system folders using different SSIS tasks.
DR Priority
Today Steve asks about HA and DR. What compromises and choices do you make in your environment and how do you ensure your clients can get to their data.
Recover SQL Server Resource Database
SQL Server Post Update Failure | Troubleshooting - In this tip we look at the steps to recover missing SQL Server mssqlsystemresource database files that cause SQL Server not to startup. This can occur when an update to SQL Server does not complete successfully therefore making these files absent from the folder where they need to reside.
SQL Clone PowerShell Scripting: The Basics
Phil Factor demonstrates some simple examples of how to use SQL Clone's PowerShell library to pass objects between cmdlets, and simplify common tasks, such as creating and deploying clones from various images. He then documents the objects and cmdlets, and illustrates their inputs and outputs.
How to Think Like the SQL Server Engine: Using Statistics to Build Query Plans
Every index has a matching statistic with the same name, and each statistic is a single 8KB page of metadata that describes the contents of your indexes. Stats have been around (and been mostly the same) for forever, so this is one of the places where SQL Server’s documentation really shines: Books Online has a ton of information about statistics. You honestly don’t need to know most of that – but if you wanna make a living performance tuning, there’s a ton of great stuff in there.
Large estate monitoring at BMW
Managing 100s of business-critical servers across multiple continents became a struggle for BMW. SQL Monitor provided a fast and powerful solution that allowed them to scale to their business needs. Availability has since increased to 100% and doubled the speed of delivery. Learn how here.
Blogs
T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes?
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
Understanding Fabric MCP
By James Serra
Model Context Protocol, or MCP, is one of those technical ideas that sounds more...
AWS RDS Aurora - our first approach
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
Forums
Adira Finance,Telpon/wa 0822-7774-3331
Jl. Raya Jakarta-Bogor No.8, Cirimekar, Kec. Cibinong, Kabupaten Bogor, Jawa Barat 16917
ADIRA Finance Pangandaran,Telpon/wa 0822-7774-3331
8M98+J42, Babakan, Kec. Pangandaran, Kabupaten Ciamis, Jawa Barat 46396
Adira Finance Cabang Sukabumi - Surya Kencana,Telpon/wa 0822-7774-3331
Jl. Surya Kencana Ruko D5-D6, Gunungparang, Kec. Cikole, Kota Sukabumi, Jawa Barat 43111
Question of the Day
May the Fourth Be With You Fun
In honor of May the fourth and Star Wars (may the force be with you), finish this quote:
"Do, or do not. ..."See possible answers