The Importance of Consistent Server Setup
In larger shops with multiple database servers, it is very important to have consistency.
Trigger Happy
This article looks at using triggers to audit and to prevent the performing of unintended actions.
Finding & Fixing Statistics Without Histograms
Men Without Hats were awesome. Statistics without histograms are terrible, but now they're easy to find and fix.
Collecting Data with Elastic Database Jobs in SQL Azure
In this tip we look at how to collect data for Elastic Database Jobs and easily store the data in a central location for analysis and review.
Fifty Different Ways to Enact Data Privacy Laws?
Now that the GDPR has gone into effect, many are wondering what will happen in the United States. California is the first state to enact similar legislation, called the California Consumer Privacy Act of 2018 (CCPA). In this article, William Brewer explains the history of the law, what it means for companies doing business with California residents, and how it compares to the GDPR.
Free Encryption
Free SQL Server 2000 Encryption for your data!!! Author Michael Coles has put together a tolljit and some XPs that you can use to encrypt your data with the Blowfish algorithm. It is hard to write good applications that encrpyt data and manage the keys and security. This will give you a great headstart on protecting your data.
Normal Data
More and more people are starting to perform data analysis, including DBAs, but they should be aware of what normal means for data.
Get SQL Server Row Count and Space Used with the sp_rows
Check out this stored procedure sp_rows to get a listing of space used and rows counts for your SQL Server database tables.
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 City Center TLP/WA 08216977701
Kawasan Terpadu Pusat Kota, Gedung Perkantoran Tower One, Lantai Dasar, Jl. KH Mas Mansyur...
BCA KCP Menara Imperium TLP/WA 08216977701
Jl. H. R. Rasuna Said No.Kav. 01, Guntur, Kecamatan Setiabudi, Kota Jakarta Selatan, Daerah...
BCA KCP Semanggi TLP/WA 08216977701
Wisma GKBI, Jl. Jend. Sudirman No.28 14, RT.14/RW.1, Tikungan. Hilir, 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