SQL Census helps users understand who has access to their SQL Servers (including Active Directory groups) and simplify existing SQL Server permissions. A new feature reworks discrete user permissions into database roles, giving users the same effective rights in a more controllable structure. Download and use SQL Census (in preview) for free.
Google and Microsoft have plans for dealing with data incidents. Steve thinks you should as well.
In this tip we demonstrate how to use dynamic SQL and stored procedures to simplify the computation with SQL of one-way and two-way tabulations.
Access OS event viewer and read it from a SSIS package using WMI Data reader task
It seems that many companies are implementing AI into their systems. Steve notes that this isn't always a good idea.
A new error message in SQL Server 2019 will make your life much easier!? Learn more...
Privacy regulations, ranging from GDPR to HIPAA, among many others, put strict compliance requirements on the storage and use of personal and sensitive data. In this article Grant Fritchey explains how the data masking technology in SQL Provision can help you protect credit card data while maintaining characteristics and distribution of the real thing.
Organizations have many choices when it comes to database platforms. Choosing the right one for an application should be based on the application’s characteristics and the platform’s features. In this article, Pushpa Sekhara explains why the Apache Cassandra database might be a good choice and how to get the most from it.
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
Komplek, Ruko Kemang Pratama, Jl. Kemang Pratama Raya No.1A Blok AN, RT.004/RW.001, Bojong Rawalumbu,...
Ruko Tomang Tol, Blk. A1 No.21-22 Raya Blok, Kedoya Sel., Kec. Kb. Jeruk, Kota...
CSTelpon : 0853-73737551 Ruko Permata Junction, Jl. Jababeka Raya Blok A2-3, Cikarang, Cikarang Sel.,...
In the new VECTOR_DISTANCE() function in SQL Server 2025, the first parameter is the distance_metric. What is this?
See possible answers