My Experiences Tech Editing Pro SQL Server on Linux
The Opportunity Earlier this year I received an email from Jonathan Gennick, an editor at Apress books. The subject of the email was “Tech edit a book” and he...
2018-09-26
2 reads
Blog Posts
My Experiences Tech Editing Pro SQL Server on Linux
The Opportunity
Earlier this year I received an email from Jonathan Gennick, an editor at Apress books. The subject of the...
2018-09-26
272 reads
sqlhelp: limit the x-axis of a geometry line graph
I have a #sqlhelp question that requires some code. So hey, blog post time! TL;DR: the geometry::STGeomFromText graph provides too wide...
2018-09-26
367 reads
Steps for SQL DB Geo Replication
Unless you are living under a rock, you have most likely heard of the hurricane that is bearing down on...
2018-09-26 (first published: 2018-09-14)
2,570 reads
Why you should always build an Azure based VM in a Resource Group
This blog post is based on conversations I witnessed between MVPs around commissioning and more importantly de-commissioning virtual machines (VMs)...
2018-09-26
753 reads
Azure Cognitive Services – Knowledge APIs
This week’s Azure Every Day posts are focused on the different APIs available within Azure Cognitive Services. Today I’ll focus...
2018-09-25
188 reads
Notes from the September 2018 SQLOrlando Meetup
Notes:
30 registered, 11 attended. No weather or traffic issues. Same as the last meeting we did not send a day...
2018-09-25
249 reads
Power BI Monthly Digest – September 2018
In this month’s Power BI Digest with my friend Manuel Quintana [Blog | Twitter] and I will again guide you through...
2018-09-25 (first published: 2018-09-12)
2,106 reads
Practical Refactoring
Today I hosted a webinar with Gene Kim (@RealGeneKim) and we had a fantastic discussion. I was slightly star struck...
2018-09-25
246 reads
Query Store Best Practice and Configuration
In my previous blog post I have talked about What is the Query Store and How to setup the Query Store. In this blog post today, I will explain...
2018-09-25
52 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