Dealing with Failure
A minor disaster in Colorado reminds Steve about the need to prepare, and think about the failure points in our preparations.
The V1 Team’s Doomed Redesign
A new version of an existing application doesn't always provide an upgrade.
What are Inline Indexes?
New releases of SQL Server arrive at a quick pace, and it's difficult to keep up with the many features introduced in each version. In this article, Phil Factor reviews a feature you may have missed, inline indexes. He covers the syntax and the many ways they can be used and then performs some performance tests to see if they can make a difference with table variables.
Create Power BI Connection to Azure SQL Database
Learn how to use Power BI to retrieve data from an Azure SQL Database.
What should you do about memory dumps?
A SQL Server monitoring tool is warning you that you’re getting memory dumps, and you’re wondering what that means.
Building Better Stored Procedures
In a followup, this article includes discussion of more advanced features of using stored procedures.
Introduction to SQL Server Security — Part 3
SQL Server supports partially contained databases. This gives you the option of adding database users with a password inside the database. This makes the database easier to move to another instance or participate in an Always On Availability Group. In this article, Robert Sheldon explains how to work with users in contained databases.
Badly Encrypted Databases
Database encryption is hard, and somewhat controversial. Steve thinks we ought to do a better job of it.
Using Client Tools - Level 4 of the Stairway to SQL Server on Linux
In the next level of the Stairway to SQL Server on Linux learn about the client tools available to connect to your instance.
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
BCA KCP Kedungmundu. Tlp:08218168235
Jl. Kedungmundu No.121, Tandang, Kec. Tembalang, Kota Semarang, Jawa Tengah 50274
BCA KCP Jembatan Merah TLP/CS 08216977701
Jl. Raya Mangga Besar No.177 C, Mangga Dua Sel., Kecamatan Sawah Besar, Kota Jakarta...
Bank BRI UNIT Situbondo 2 WhatsApp 08980343752
Jl. Pb. Sudirman No.5, Karangasem, Patokan, Kec. Situbondo, Kabupaten Situbondo, Jawa Timur 68354
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