Whirlwind Tour of Azure SQL Database
I have finally uploaded my Azure SQL Database presentation, apologies for the delay. I am already working on an improved...
2018-10-24
804 reads
Blog Posts
DAX – Cumulative Total and Blank Handling
When developing DAX measure, you should be aware that Blank value behavior might be similarly insidious as NULL value in...
2018-10-23
419 reads
Setting Variables in Azure Data Factory Pipelines
(2018-Oct-15) Working with Azure Data Factory you always tend to compare its functionality with well established ETL packages in SSIS. Data...
2018-10-23 (first published: 2018-10-15)
13,928 reads
Slides and Scripts from IT/Dev Connections
If you attended either of my presentations for this past IT/Dev Connections, here are the promised slides and scripts.
As I...
2018-10-23
245 reads
SQL Saturday Lincoln Precon this Friday Oct 26
I’m presenting an exciting preconference training session on Friday, October 26, ahead of the SQL Saturday in Lincoln, Nebraska. This...
2018-10-23
193 reads
SQL Server on Linux – External Memory Pressure with 2019 CTP2
In this blog post we’re going to revisit how SQL Server on Linux responds to external memory pressure. This is...
2018-10-23 (first published: 2018-10-13)
1,680 reads
Unexpected Shorthand Date Implicit Conversions
I do my best work in the mornings. Evenings are pretty good too once I get a second wind.
Late afternoon are my nemesis for getting any serious technical or...
2018-10-23
7 reads
Unexpected Shorthand Date Implicit Conversions
I do my best work in the mornings. Evenings are pretty good too once I get a second wind.
Late afternoon are my nemesis for getting any serious technical or...
2018-10-23
5 reads
Webinar: The end of support for SQL Server 2008
Coeo is a partner with Redgate Software. Tomorrow they are hosting a webinar on what your position will be if...
2018-10-23
395 reads
ASF 015: Kalen Delaney interview
Introduction Kalen Delaney has been working with SQL Server since 1987 when she joined the Sybase Corporation in Berkeley, California....
2018-10-22
102 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