Josh Smith shows how to use SQL Data Catalog to perform a 'first cut' data classification for one your SQL Server databases, identifying all columns that are likely to hold personal or otherwise sensitive data.
2020-01-17
How to use reverse regex expressions in SQL Data Generator to fill a text column in SQL Server with fake, but very realistic complaints.
2020-01-16
T-SQL window functions simplify solving many complex queries. In this article, Edward Pollack demonstrates how the functions can be used to find gaps and islands in a dataset.
2020-01-16
New Relic Infrastructure is a capable server monitoring tool but adding Integrations provides only 'bare bones' monitoring for SQL Server. Grant Fritchey argues that to "instrument" a complex system such as SQL Server, effectively, you also need a tool that is built specifically for this purpose.
2020-01-15
We asked what you make, and 1,734 of you in 63 countries answered. Altogether, you made $170,753,936 this year. Damn, y’all are bringing home the bacon!
2020-01-15
Microsoft has a new virtual core offering of Azure SQL database called serverless and this offering optimizes the price performance tradeoff and simplifies performance management for databases with intermittent and unpredictable usage.
2020-01-14
In the event of a breach of personal data, any organization must produce proof that they understand what data they hold and where, and how it is being used, and that they have enforced the required standards for access control and security. To make all this possible, it is essential to build a complete model of the data and its lineage, and a data catalog is the first step in this process.
2020-01-14
In this tip we look at how to insert and delete data via SQL Server views.
2020-01-13
As many companies consider moving data to NoSQL, Cassandra may be the choice. In this series, Shel Burkow discusses design considerations for porting a SQL Server schema to Cassandra. The first article explains the Cassandra primary key.
2020-01-10
In this tip we look at what happens if we replace the SQL Server model database with a regular user database
2020-01-09
By Brian Kelley
The concern that a particular technology is going to destroy the world seems to...
The STIG is detailed, which is a good thing, but I found myself wanting...
By Steve Jones
After my session at VSLive last week, I had a few questions from the...
Comments posted to this topic are about the item RegEx Functions III
Comments posted to this topic are about the item Optimized Locking in SQL Server...
Comments posted to this topic are about the item Finely Tuned Models
If I run the REGEXP_LIKE() function, does it match values in a case-sensitive fashion, or a case-insensitive fashion by default.
See possible answers