In addition to trying to get better at SQL Server, Redgate Software, and all the various aspects of my job, I'm also trying to get better at this whole human interaction thing AND I'm working on trying to learn PostgreSQL much more deeply. Whew! Yeah, may not seem like a whole lot, but I assure […]
2021-10-16
271 reads
Using a list to keep track of what you should work on is only as good as the plan or goal behind it.
2021-10-15 (first published: 2017-08-07)
233 reads
GE is using lots of data, and machine learning to predict when specific systems will fail by nurturing digital twins.
2021-10-13 (first published: 2017-07-19)
190 reads
2021-10-11 (first published: 2017-07-27)
210 reads
This year PASS Data Community Summit is a free virtual event, and I encourage you to register even if you are interested in just a handful of sessions. One of the Learning Pathways might be just what you are looking for, from Query Basics to Power BI to DevOps. What I’m most excited about this […]
2021-10-09
120 reads
SQL Server 2016 SP3, the last service pack ever is out. Steve comments on how the world of software patches has changed.
2021-10-08
545 reads
Steve notes that there are differences between state based development and migration based development, but neither is necessarily better.
2021-10-06
412 reads
The world of public data is scary for Steve, even when the data is aggregated. It appears that keeping information private is becoming harder, and perhaps, impossible.
2021-10-04
157 reads
It's almost time for Brent Ozar's annual salary survey. Steve reminds you that you can influence the questions, but more importantly, take the survey and provide data for all of us.
2021-10-02
321 reads
Many organizations are struggling to hire staff these days. In addition, it seems that many technology groups feel they can't find staff with the right skills.
2021-10-01
287 reads
Every organization I talk to has the same problem dressed up in different clothes....
By DataOnWheels
I am delighted to host this month’s T-SQL Tuesday invitation. If you are new...
By alevyinroc
Ten years (and a couple jobs) ago, I wrote about naming default constraints to...
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