In my recent post, Installing External Modules into SQL Server’s Python I had a look at just how simple it is to...
2018-09-18
574 reads
This month was my turn to host T-SQL Tuesday. I chose Trigger Headaches or Happiness as the topic, and I...
2018-09-18
891 reads
So, what do you really know about bots or how they can help your organization? You may be thinking, Pragmatic...
2018-09-17
167 reads
If you haven’t registered for the 2018 PASS Summit and plan to go, you might press to get registration done...
2018-09-17
870 reads
Read Scale-Out is a little-known feature that allows you to load balance Azure SQL Database read-only workloads using the capacity of...
2018-09-17 (first published: 2018-09-05)
2,541 reads
This was an interesting question I saw posted recently. Through SQL Server 2000, trying to delete a user that owned...
2018-09-17
34,333 reads
tl;dr; VIEW DEFINITION
Every now and again you’ll have a user that needs to be able to see what permissions other...
2018-09-17
340 reads
Somewhere on internet i found this question. Thought to share it with you all.
We have two tables, school_students and Class_student.
...
2018-09-17 (first published: 2018-09-04)
2,474 reads
I love the SQL Source Control product from Redgate. It’s not perfect, and it can be slow to run at...
2018-09-17
238 reads
A question that came up recently around Query Store is what happens when there are log backups in use on...
2018-09-17
220 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