Is This Data Science?
An analysis of salaries uses statistics to determine significance of the data. Is this data science?
Free eBook: SQL Server Internals: In-Memory OLTP
In this free ebook Kalen Delaney introduces and explains how the 2016 In-Memory OLTP engine works. The Hekaton internals knowledge offered in this book will help you migrate existing tables or databases to Hekaton, and get faster performance from your SQL Server applications than you ever thought possible.
How to Change the File Extension for a Data File
This is a fix to primary data file that is created with a different file extension or accidentally renamed to a different file extension
It's Time to Patch and Upgrade
With bugs in our CPUs, everyone needs to plan on patching or upgrading.
Nasty Fast PERCENT_RANK
Alan Burstein discusses a better performning alternative to PERCENT_RANK that works on SQL Server versions 2005+
Questions about Data Masking That You Were Too Shy to Ask
The General Data Protection Regulation (GDPR) will be in effect in May of 2018. Data masking is one technique that can help your organization comply with this and other regulations. William Brewer answers those questions about data masking that you were too shy to ask.
Using Better Tools
Some companies don't want to use tools, but that doesn't make sense to Steve Jones.
SQL Server Machine Learning Services – Part 1: Python Basics
Python is a very popular language used for many purposes including machine learning. SQL Server 2017 supports Python with its Machine Learning Services component. Robert Sheldon explains how to get started using Python in SQL Server in the first article of this series.
How to Turn on Instant File Initialization
Not having instant file initialization turned on slows down the process of adding pages to your database, because prior to allocating the data pages to your database, SQL Server needs to zero out the newly allocated pages.
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 Cempaka Putih Raya Tlpn/wa0853.7373-7551
Tlpn/wa0853.7373-7551 Jl. Cempaka Putih Raya No.118 B,C,D, Cemp. Putih Tim., Kec. Cemp. Putih, Kota...
BCA KCP Buaran Raya Tlp/WA.(+62 821°3111°179
Tlp/WA.(+62 821°3111°179 Jl. Buaran Raya Blok A No. 100, RT.6/RW.dan 101, Wil, Kec. Duren...
BCA KCU WAHID HASYIM Tlp/WA.(+62 821°3111°179
Tlp/WA.(+62 821°3111°179 Jl. K.H. Wahid Hasyim No.183 A-B, Kb. Kacang, Kecamatan Tanah Abang, Kota...
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers