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.
Understanding Your Value
Data can help you understand the value you bring to a company as a data professional.
Create Size-based Backups for SQL Server 2017
Jeffrey Yao explains how to generate backups based on the amount of data that has changed for differential and transaction log backups.
PowerShell Tool Time: Controlling Our Tools
The next installment of the Powershell Tool Time series shows you how to manage backup files by
Blogs
A Cloud Dependency Failure from Amazon
By Steve Jones
I went to sleep while reading a Kindle book on my phone. I know...
Deploying AI in logistics (the unfiltered version)
A conversation with Jan Laš, CIO at HOPI, about what deploying a data agent...
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...
Forums
BCA KCP Ambengan TLP/WA 083800209966
Pert. Ambengan Plaza, Jl. Ngemplak 30 Blok A.15, Jl. Ambengan No.15, Ketabang, Genteng, Surabaya,...
BCA KCU KEBAYORAN BARU Telpon/wa:0813.7887.595
BCA KCU KEBAYORAN BARU Telpon/wa:0813.7887.595.Jl. Melawai Raya No.Blok B, RT.7/RW.5, Kramat Pela, Kec. Kby....
BCA KCP Pucang Anom TLP/WA 083800209966
Jl. Pucang Anom Tim. No.18, Kertajaya, Kec. Gubeng, Surabaya, Jawa Timur 60282
Question of the Day
Creating a JSON Document III
I have this data in a table called dbo.NFLTeams
TeamID TeamName City YearEstablished ------ -------- ---- --------------- 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960 5 49ers San Francisco 1946 6 Broncos Denver 1960 7 Seahawks Seattle 1976 8 Patriots New England 1960If I run this code, how many rows are returned?
SELECT TOP 2
json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers