Importance of Best Practices in database programming
For any programming language, just writing the code is not well enough. It should be written using the best practices....
2015-02-01
4,150 reads
Blog Posts
Friday Followup For January 30, 2015
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2015-01-30
925 reads
I May Not Shake Your Hands
I’m traveling next week to the SQL Konferenz in Germany, and then on to Red Gate in the UK.
However,...
2015-01-30
1,367 reads
More Azure SQL Database Enhancements – Meet RLS (cloud first debut)
TweetG’day,
Well, it was only a few days ago that I blogged about some major Azure SQL Database enhancements. Primarily, in...
2015-01-30
2,320 reads
My First Board Meeting
Parents, you know that feeling you get after you’ve brought home that brand new baby (or in my case, babies) where...
2015-01-30 (first published: 2015-01-26)
6,352 reads
Outlier Detection with SQL Server, part 3.4: Dixon’s Q-Test
By Steve Bolton
…………In the last three installments of this amateur series of mistutorials on finding outliers using SQL Server, we...
2015-01-30
2,546 reads
Reflections as a consultant
Let’s just start with the last three years have been fantastic! This blog post is a slight deviation from the technical content on my blog. We’re going to focus...
2015-01-30
4 reads
Reflections as a consultant
Let’s just start withthe last three years have been fantastic! This blog post is a slight deviation from the technical...
2015-01-30
739 reads
Virtualization for SQL Server DBAs – SQL Saturday Phoenix Precon
I am pleased to announce that I have an upcoming preconference training session on Friday, February 27th, the Friday before...
2015-01-30
1,154 reads
When Do You Ask for Help?
Reading Time: 3 minutesBeing on the edge of a cliff is a common feeling when running a small business
Stepping Back
I...
2015-01-30
1,239 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