Conditionally Returning Rows Based On Query Results
While I normally prefer formatting my query results in a downstream app/reporting layer, sometimes I can’t get around adding some...
2018-10-29 (first published: 2018-10-16)
2,654 reads
Blog Posts
Free Training: Videos from Tim Mitchell
I’m always on the looking our excellent training, especially free training. Tim Mitchell, Microsoft Data Platform MVP, (twitter | website) has...
2018-10-29
272 reads
PASS Summit 2018 - Let's Hang Out! Where to Find Me
In addition to being an amazing opportunity for both technical and professional development, PASS Summit is a #sqlfamily reunion and a huge networking event. Catching up with old friends,...
2018-10-29
5 reads
Step-by-Step: How to Trigger an Email Alert when a Specific Windows Service Starts or Stops on Windows Server 2016
Introduction
In my last post. Step-by-Step: How to Trigger an Email Alert from a Windows Event that Includes the Event Details using...
2018-10-29
2,146 reads
T-SQL Tuesday 108 Invitation- Non SQL Server Technologies
I am proud and honored to be hosting T-SQL Tuesday again. This monthly blog party started by SQL Guru Adam...
2018-10-29
322 reads
Here Comes the New Blog. Same as the Old Blog.
Welcome to the new home of my blog! I’ve had this domain for over a year but with PASS Summit 2018 coming up soon I decided it was time...
2018-10-28
4 reads
Step-by-Step: How to Trigger an Email Alert from a Windows Event that Includes the Event Details using Windows Server 2016
Introduction
Setting up an email alert is as simple as creating a Windows Task that is triggered by an Event. You...
2018-10-28
1,239 reads
Azure SQL Database Hyperscale
At Microsoft Ignite, one of the announcements was for Azure SQL Database Hyperscale, which was made available in public preview October 1st,...
2018-10-26 (first published: 2018-10-16)
2,267 reads
Overview of the SQL Insert statement
This article on the SQL Insert statement is part of a series on string manipulation functions, operators and techniques. The...
2018-10-26
374 reads
Why Did a Plan Get Removed From Cache?
I was recently asked if we could tell why a plan was removed from cache. If you read this blog,...
2018-10-26 (first published: 2018-10-22)
1,901 reads
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