How do you go about making a big decision?
This article explores the author's way of making big decisions.
SQL Login Password Audit
Audit your SQL logins to find passwords that have never been changed or that are very weak.
Using DBCC CLONEDATABASE and Query Store for Testing
Erin Stellato demonstrates how to use the new DBCC CLONEDATABASE feature, in combination with Query Store, to test index and query changes.
Step by Step Configuring AlwaysOn with Log Shipping
In this article, I will show you a procedure to combine SQL Server AlwaysOn with logshipping and to make log-shipping to work even in case of failovers between availability replicas in primary site.
The Ideal Agile Database
The ideal Agile database needs to be secure, recoverable, transactional, resilient, and versatile enough to allow easy migration paths when you need to delegate tasks elsewhere, for scalability. Sounds like a relational database to Phil Factor.
Migrating a Disk-Based Table to a Memory-Optimized Table in SQL Server
The feature formerly known as Hekaton, now In-Memory OLTP can provide very useful performance gains where you carefully select the tables to become memory-optimised. How do you set about the job of converting existing tables to become memory-optimised tables? the process isn't entirely straightforward but the benefits that an In-Memory OLTP table delivers is worth your effort. Alex Grinberg takes you through the basics.
A Single-Parameter Date Range in SQL Server Reporting Services
Many reports you will generate in SSRS will need to report within date ranges, and most of those will need a date range parameter. Here's an way to make an easy-to-use date range parameter.
Working with Windows Containers and Docker: The Basics
When you begin to work with containers, you will notice many similarities between a container and a virtual machine; but, in fact, these are two quite different concepts. Containers are going to change the way that we do Windows-based development work in the coming year, and they already underpin much of the devops work of speeding the delivery process. Nicolas Prigent explains how to use the Windows Containers feature.
Performing a Right and Comprehensive Age Calculation Part 2
Age Calculation gets implemented as an Inline table Valued function with a parameter defining which date parts must be counted.
Blogs
PlanTrace Now Supports PostgreSQL
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
A New Word: the Kinder Surprise
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
Crash-Consistent Snapshot Cloning - Hyper-V Edition
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
Forums
BCA KCP Arkadia CSTelpon : 0853-73737551
Gedung Perkantoran Hijau Arkadia, Tower C - Ground Floor, unit C103, Jl. TB Simatupang...
BCA KCP Pasar Kebayoran Lama CSTelpon : 0853-73737551
CSTelpon : 0853-73737551 Jl. Raya Kby. Lama No.174, Cipulir, Kec. Kebayoran Lama, Kota Jakarta...
BCA KCP Cilandak KKO CSTelpon : 0853-73737551
CSTelpon : 0853-73737551 Jl. Raya Cilandak / Margasatwa RT 006, RW 06 No. 12....
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers