Loading CSV Files Using Dynamic SQL
In this article, we will see of a quick way to load CSV files from a directory on your computer.
Azure SQL Database High Availability
Site-wide or region-wide disasters, while undoubtedly more impactful, happen considerably less frequently than downtime resulting from scheduled maintenance events or isolated hardware and software faults. This article provides an overview of the high availability features of Azure SQL Database that mitigate risks affecting services within an individual Azure datacenter, rather than an entire Azure region.
Check your default constraints
Default constraints can lead to assumptions about the values in a column. Combine a check constraint to avoid slip ups.
We Need Data Privacy Consistency
Steve talks about the disparate regulations we face for data privacy and protection.
Examples and Function for Using SQL Server LIKE Operator and Wildcard Characters
In this tip we look at different examples of how to use the LIKE operator to get the correct results when strings contain wildcard characters. We will also look a function to make this easier to do.
How Do You Setup Your Instances?
This week Steve wonders if you have a process for setting up your new instances.
Single-Column-Key Missing Index Recommendations are Usually Wrong.
When Clippy suggests an index with only one key, look closer.
Blogs
Monday Monitor Tips: A New Analysis Page
By Steve Jones
We have multiple teams (8) working on Redgate Monitor. Some work on the Standard...
Case Studies: Real-World Success Stories of FinOps Implementation
By HeyMo0sh
Learning any kind of theory is easy, but adapting FinOps and watching it rescue...
SQL Server Security: Always Encryption
By Vinay Thakur
As discussed introduction of Always Encryption blog and initial Encryption at rest as TDE...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
The Problem Isn't Always Your Query or Schema... Sometimes It's Hidden Assumptions
Comments posted to this topic are about the item The Problem Isn't Always Your...
Identity Defaults
Comments posted to this topic are about the item Identity Defaults
Question of the Day
Identity Defaults
What happens when I run this code?
CREATE TABLE dbo.IdentityTest
(
id int IDENTITY(10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
See possible answers