SQL Server string functions for Data Munging (Wrangling)
In this article, you’ll learn the tips for getting started using SQL string functions for data munging with SQL Server....
2018-09-13
353 reads
Blog Posts
Azure Storage – Hot, Cold, Archive
There’s a lot of talk about storage options. When working with customers, I often introduce them to Azure through storage,...
2018-09-12
717 reads
Bulk insert issue with UTF-8 fixed-width file format
Fellow Canadian Doran Douglas brought this issue to my attention recently, and I wanted to share it with you as...
2018-09-12
291 reads
Did Not Know That - Redirecting CMD to the Clipboard
One of the items I frequently deal with as a Production DBA is drive alarms. I have written previously about...
2018-09-12 (first published: 2018-09-04)
2,862 reads
MAXDOP and Azure SQL DB
The infamous setting that we all know and love – MAXDOP. Did you know that you can actually control MAXDOP when...
2018-09-12
557 reads
Moving a SQL Server Availability Group to a different Subnet
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...
2018-09-12 (first published: 2018-09-03)
2,825 reads
SQL Server Operations Studio and VSCode: The wrong default datetimeoffset format
This post is to answer the question: “You are used to seeing in the format of yyyy-MM-dd right?” that I...
2018-09-12
425 reads
T-SQL Tuesday #106 – The Trouble with Triggers
For this month’s T-SQL Tuesday Steve Jones asks us to talk about our experiences with Triggers:
https://voiceofthedba.com/2018/09/03/t-sql-tuesday-106-trigger-headaches-or-happiness/
In my post I’m going...
2018-09-12
258 reads
Azure Hybrid and Security
Data Security. These words are in the forefront of many people’s minds and just hearing them may bring on an...
2018-09-11
150 reads
Back up Encryption
Nowadays security breaches happen way to frequently. As DBA’s we should all take extra care with sensitive data and ensure we...
2018-09-11 (first published: 2018-09-05)
2,084 reads
Blogs
Did You Really Name That Default?
By alevyinroc
Ten years (and a couple jobs) ago, I wrote about naming default constraints to...
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...
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