Saving disk space by choosing the correct data type
"Database is almost 4 TB in size, user is complaining on long times for DEV data refresh and high storage...
2018-07-03
1,737 reads
Blog Posts
Congrats to DCAC Staff on MVP Renewals
July 1st is a day all Microsoft Most Valuable Professionals (MVP) wait patiently at their computers hitting F5 over and...
2018-07-02
331 reads
Database Superhero Adventures, July 2018
Sorry readers, I was having some many adventures there was no June edition. In May, I had SQLSaturday Dallas where...
2018-07-02
447 reads
Database Superhero Adventures, July 2018
Sorry readers, I was having some many adventures there was no June edition. In May, I had SQLSaturday Dallas where...
2018-07-02
62 reads
Introduction to Docker and Docker Toolbox
The article gives some knowledge about getting started and utilizing Docker containers. The focus is all about understanding Docker and...
2018-07-02
499 reads
Mastering Index Tuning–Day 2
This is a short series of posts on the courses I took with Brent Ozar. I actually completed the courses...
2018-07-02
945 reads
Microsoft Azure – Enable Geo replication of data – Cosmos DB Part 2
In this article, we will learn how to replicate the data to any Azure region globally. Global Distribution Azure Cosmos...
2018-07-02
373 reads
Microsoft Most Valuable Professional – Data Platform for 2018-2019
Today, I’m proud to announce that I have been renewed as an Microsoft MVP – Data Platform for the 2018-2019 award year, my second MVP award. This is an truly an honor and...
2018-07-02
4 reads
Microsoft Most Valuable Professional – Data Platform for 2018-2019
Today, I’m proud to announce that I have been renewed as an Microsoft MVP – Data Platform for the 2018-2019 award year, my second...
2018-07-02
333 reads
New at Simple-Talk: Principles of Data Protection
My latest article, Principles of Data Protection, has been published at Simple-Talk! I address the basic problem and how we...
2018-07-02
362 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