Compress and Decompress in SQL Server 2016
Explore using Compress/Decompress with varying types of data and examine size/storage usage
Give Up on Natural Primary Keys
With the need to remove older data, Steve thinks natural keys may be obsolete.
The Ever Expanding Data Platform
With lots of news coming out of Ignite, Steve talks about a few of the changes.
Exhuming the GDPR Bodies
Since the GDPR has gone into effect, the focus has often been on databases. There are many other ways that personally identifiable data may be stored by an organization. In this article, David Poole shows how to use Bash and PowerShell to locate that data in file shares
Using undocumented DBCC WRITEPAGE to instigate SQL Server database corruption
In this tip we look at the undocumented command DBCC WRITEPAGE to corrupt a SQL Server database and then use the command to undo the corruption.
Picking the Right Type of Tool For the Job
Do we need the right tool or just a tool? A guest editorial from Andy Warren gives a few thoughts on getting things done effectively.
PowerShell Tool Time: Building Help
Learn how you can customize the help for your library of scripts in this edition of PowerShell Tool Time.
Forwarded Fetches and Bookmark Lookups
If someone says clustered indexes slow you down, they haven't read this.
What's New in the First Public CTP of SQL Server 2019
In this article we look at the first public CTP release of SQL Server 2019 and some of the great new features that will be part of SQL Server 2019.
An Open Thank You to the Microsoft SQL Server Team
Thanks for improving the string or binary data truncated error message.
Blogs
VPN + SQL Server Connections: Why Long-Working Setups Suddenly Fail with Msg 10054 and “Connection Broken”
By Tim Radney
Over the past few weeks, I’ve been contacted by multiple customers experiencing the same...
Future IT Roles – Agentic Architect and AI Boom!!
By Vinay Thakur
These days everything is changing to AI World, IT roles are getting changed and...
Free Webinar about Columnstore Indexes
I’m doing a small series on indexing basics for SQL Server, and on May...
Forums
BCA KCP Kelapa Gading Villa TLP/WA 08218573837
By Quay thu XSMN hôm nay - quay thu MN - KETQUA.TV
Jl. Boulevard Bar. Raya No.52 Blok LC No. 51, Klp. Gading Bar., Kec. Klp....
BCA KCP Shibuya - PIK 2 TLP/WA 08216977749
Rukan Shibuya Blok STB No. 033 dan 035, Jl. Pantai Indah Kapuk No.2, Kabupaten...
BCA KCP Buaran Raya Hub.0853°5504°2311
BCA KCP Buaran Raya hub.0853°5504°2311 Jl. Buaran Raya Blok A No. 100, RT.6/RW.dan 101,...
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers