New CREATE OR ALTER statement in SQL Server 2016 SP1
Ahmad Yaseen explains what SQL Server 2016 SP1's new CREATE OR ALTER statement does, and how to use it.
Using EXCEPT to Determine Row Differences
How to use the EXCEPT statement to perform row differences.
Introduction to SAP HANA on Azure
Microsoft and SAP share a long history of working together on a variety of interoperability solutions, including SAP Fiori and Office 365. In recent years, this trend has been exemplified by advancements in support for SAP-based solutions on Microsoft Azure. Marcin Policht provides an overview, focusing in particular on support for SAP HANA on Azure.
vCenter Server fails to start, Purge and Shrink Vcenter SQL Database
In this article, you will learn how to troubleshoot If your vCenter Server fails to start and and manually purge the Vcenter database if required.
Lists With, or Without, Ranges in both T-SQL and PowerShell
Whether you are working in a procedural language like PowerShell or in T-SQL, there is something slightly bothersome about having to deal with parameters that are lists, or worse with ranges amongst the values. In fact, once you have a way of dealing with them, they can be convenient, especially when bridging the gulf between application and the database. Phil Factor shows how to deal with them.
SQL Server vs SQL Server v.Next
An introduction to the basics of current SQL Server vs v.Next Performance Testing.
What Would You Do if Your Company Was Targeted?
Today we have a guest editorial that asks what you might do if you knew a hacker was coming after your organization.
Compression and its Effects on Performance
Erin Stellato takes a look at the new COMPRESS and DECOMPRESS functions, comparing their impact on space and performance to traditional data compression.
Quality Provides Traction/Velocity
Quality is a driver for productivity. Or so say I. What do you think.
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 Kapuk Kamal Telpon/wa.085373737699
BCA KCP Kapuk Kamal Telpon/wa.085373737699.No. 1A, Jl. Kapuk Kamal Raya Blok DEF, Kamal Muara,...
Alamat Kantor BCA KCU THAMRIN Telp/WA.0821°3111°179
Telp/WA.0821°3111°179 Menara BCA, Grand Indonesia, Jl. M.H. Thamrin No.1, Menteng, Kec. Menteng, Kota Jakarta...
BCA KCP Iskandar Muda CSTelpon : 0853-73737551
Jl. Iskandar Muda No.123, Sei Sikambing D, Kec. Medan Petisah, Kota Medan, Sumatera Utara...
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers