Azure SQL DB – Failed to update database because the database is read-only
Quite an interesting situation I found myself in where I was perplexed for about 5 minutes. I was connected to...
2018-10-22
424 reads
Blog Posts
Database Fundamentals #19: JOINS
The last Database Fundamentals post introduced the SELECT and FROM commands. We’re going to start using JOIN operations shortly, but...
2018-10-22 (first published: 2018-10-08)
2,968 reads
Some Thoughts on How to Prepare to Serve on the PASS Board of Directors
From time to time I’m asked for advice and insight on running for and serving on the PASS Board. I...
2018-10-22
248 reads
SQL Server 2019 Big Data Clusters
At the Microsoft Ignite conference, Microsoft announced that SQL Server 2019 is now in preview and that SQL Server 2019 will include Apache Spark and Hadoop Distributed File System (HDFS) for...
2018-10-22
1,406 reads
SQL Server 2019 Big Data Clusters
At the Microsoft Ignite conference, Microsoft announced that SQL Server 2019 is now in preview and that SQL Server 2019 will include...
2018-10-22
2,103 reads
The Security Weak Link
I saw this cartoon, which I think is great: Data Security. It’s from John Klossner, and it perfectly shows that...
2018-10-22 (first published: 2018-10-11)
2,132 reads
This is a company that practises what they preach
How good is a company at engaging with their user base? Obviously when things are going great then it’s wins...
2018-10-22
954 reads
Time for SQL in the City Summit–Chicago
This week is the last live SQL in the City Summit this year. It’s this Friday at the Microsoft office...
2018-10-22
745 reads
Upcoming #SQLChat on Making the Most of Conferences
This month’s #SQLChat is hosted by Rie Irish (twitter | blog). It’s a timely topic: Making the Most of Conferences. With...
2018-10-22
213 reads
Last week reading (2018-10-21)
DevOps Terms – and Why They Matter to Database Specialists Find out what is Scrum, Continuous Deployment, TDD and others from...
2018-10-21
65 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