People often ask me what’s the number one thing to look out for when running SQL Server on Kubernetes…the answer is memory settings. In this post, we’re going to...
2019-10-04 (first published: 2019-09-28)
916 reads
I’m off to Memphis today for SQL Saturday #870. I’m excited as I’ve never been to Memphis and hope to wander around and see something while I’m there. I...
2019-10-04
43 reads
This is part of a demo series I did for a customer workshop. I’m adding a little more detail and explanation of the demos of products I gave. A...
2019-10-04 (first published: 2019-09-30)
404 reads
Let’s get straight to the point. From official documentation it states that “To secure your storage account, you should first configure a rule to deny access to traffic from...
2019-10-03
37 reads
While the CROSS JOIN is not used much, and, depending on the size of your data it can be dangerous, there are some uses for it. For example, you...
2019-10-03 (first published: 2019-09-23)
1,035 reads
Bench marking your environment is an important step when introducing new hardware, which is accomplished by running a test workload against the hardware. There are multiple ways to...
2019-10-03 (first published: 2019-09-27)
776 reads
This is the seventh interview we have done. This time our guest is Joe Sack! Joe is Principal Program Manager for Azure SQL Database with a focus on query...
2019-10-03
6 reads
There are two new options for automating your SQL Notebooks with your SQL Servers. Earlier this month, the Insiders build of Azure Data Studio received the ability to add...
2019-10-02 (first published: 2019-09-23)
805 reads
After nearly a year of work, starting with the proposal that I finished writing in a hospital last year the book is finished and off to be published and...
2019-10-02
43 reads
After nearly a year of work, starting with the proposal that I finished writing in a hospital last year the book is finished and off to be published and...
2019-10-02
3 reads
By alevyinroc
Ten years (and a couple jobs) ago, I wrote about naming default constraints to...
By Steve Jones
We have multiple teams (8) working on Redgate Monitor. Some work on the Standard...
By HeyMo0sh
Learning any kind of theory is easy, but adapting FinOps and watching it rescue...
Comments posted to this topic are about the item The day-to-day pressures of a...
Comments posted to this topic are about the item The Problem Isn't Always Your...
Comments posted to this topic are about the item 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