My Current Training Courses on Pluralsight!
Here’s a run down of the Linux training that I have available on Pluralsight!
Just getting started!
Understanding and Using Essential Tools...
2018-10-13
407 reads
Blog Posts
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 a very long post, and it ends with me...
2018-10-13
5 reads
Azure Cosmos DB Free Trial – walk through of Gremlin API for Graph
After the 2018 Microsoft Ignite event, Microsoft announced a free trial of Azure Cosmos DB. For those who are eager...
2018-10-12 (first published: 2018-10-01)
2,450 reads
I’m Speaking – Denver Dev Day Fall 2018
Denver Dev Day Fall 2018 is a free event organized by volunteers and hosted at the Microsoft campus in the DTC. It’s a full day to learn from industry...
2018-10-12
9 reads
It’s a wrap – SQL Saturday Denver #774
SQL Saturday Denver #774 has come and gone. It’s hard to believe how quick things went – well there were a...
2018-10-12
374 reads
The Developer’s Guide to Azure–A Good Overview
Someone sent me a link a few weeks back about a free book from Microsoft. It’s the Developer’s Guide to...
2018-10-12 (first published: 2018-10-03)
2,480 reads
Auto-Scaling Azure SQL DB
When I was presenting my Azure SQL Database session at DataRelay (used to be SQLRelay) I was asked (over coffee)...
2018-10-11
964 reads
Power BI Dashboards, Reports, and Datasets with the SQL Chefs
This week I had the opportunity to learn about dashboards, reports, and datasets in Power BI using the best kind...
2018-10-11 (first published: 2018-10-02)
2,994 reads
The SQL Agents’ view of SQL Server
I recently came across a really odd issue with the SQL Agent, there were two agent jobs attached to one...
2018-10-11 (first published: 2018-10-02)
2,858 reads
Which is faster? IN (list) or IN (SELECT FROM Temp)
If you’ve done much with IN (list) then you’ve realized that it basically translates out to
col=val1 OR col=val2 OR...
2018-10-11
2,484 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