Trunk Based Database Development
Trunk based development is what many of us do with shared database servers.
Are nulls stored in a nonclustered index?
When you index a nullable field, are the rows with nulls stored in the index? It’s easy enough to find out by creating a table with a nullable field, and then creating an index on it.
Based in Dallas, TX? Join Redgate and Braumiller Law Group at their GDPR event tonight.
Join the FACC DFW for a night of innovation and European-American networking across industries. We invite you to a discussion with experts from Braumiller Law Group and Redgate Software UK to help answer your questions and learn about GDPR in copious capacities. (Use code REDGATE for member rate.)
Breaking the 4th Wall with Unity
Even when creating games, your code has access to environment variables and document files. In this article, Lance Talbert shows how to access files to convince the player that maybe the game knows more than it should.
Complimentary access to Gartner Guide
Redgate has been acknowledged as a representative vendor in the Gartner 2018 Market Guide for Data Masking. For Gartner’s insights, analysis and recommendations on data masking you can get your complimentary copy of the report from Redgate.
Indexes with Included Columns: Stairway to SQL Server Indexes Level 5
Included columns enable nonclustered indexes to become covering indexes for a variety of queries, improving the performance of those queries and with the only overhead being an increase the size of an index.
Create Azure Data Lake Linked Service Using Azure Data Factory
In this article we walk through a step-by-step example on how to create an Azure Data Lake Linked Service in Azure Data Factory v2.
Experiments with full text search
Would a crazy idea using full text thesaurus and phonetic keys actually have worked?
No More SQL Server Installs
Today, Steve wonders when we'll stop installing SQL Server on a host machine.
Blogs
Lift and shift vs modernizing your data warehouse
By James Serra
If you are migrating a data warehouse, there is a question worth asking before...
Power BI Fun With Travels
By Steve Jones
I’m back from a great vacation. I had the chance to visit two new...
DiskANN Experiment — Exploring Entry Points and Graph Neighborhoods
Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...
Forums
DML Trigger Types
Comments posted to this topic are about the item DML Trigger Types
PostgreSQL in action with Opensearch
Comments posted to this topic are about the item PostgreSQL in action with Opensearch
Choose the Second One
Comments posted to this topic are about the item Choose the Second One
Question of the Day
DML Trigger Types
How many types of DML triggers are there?
See possible answers