Adjusting Model
This Friday Steve Jones looks at the topic of defaults and whether you use the model database to adjust yours.
2015-09-04
109 reads
This Friday Steve Jones looks at the topic of defaults and whether you use the model database to adjust yours.
2015-09-04
109 reads
2015-09-04
1,679 reads
A few years ago Andy Warren had this idea for a networking dinner. We had been chatting about all the...
2015-09-03
876 reads
When is it worth upgrading your SQL Server? It's a question Steve Jones explores today.
2015-09-03
234 reads
2015-09-02
2,164 reads
I’ve been working more with SQL Data Generator (SDG) because it solves some problems that many software developers have with...
2015-09-01
917 reads
It seems the software industry doesn't do a good job of planning and estimating software development efforts.
2015-09-01
193 reads
2015-09-01
1,450 reads
Does it make sense to avoid FKs for use other architectures in software development? Steve Jones isn't sure a a general rule this is the case.
2015-08-31
343 reads
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2015-08-31
1,899 reads
By ChrisJenkins
Have you been thinking about migrating your reporting to Microsoft Fabric or Snowflake but...
By Steve Jones
It’s Prime Day. A few of my recommendations, since I want to do some...
With Fabric Mirroring, Microsoft is promoting a nice and appealing story for operational reporting...
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
Comments posted to this topic are about the item Concurrency and Baseline Control: Level...
Comments posted to this topic are about the item Spending Time in the Office
I have this code on SQL Server 2022. What happens when it runs all at once?
DROP TABLE IF EXISTS dbo.Commission GO CREATE TABLE dbo.Commission (id INT NOT NULL IDENTITY(1,1) CONSTRAINT CommissionPK PRIMARY KEY , salesperson VARCHAR(20) , commission VARCHAR(20) ) GO INSERT dbo.Commission ( salesperson, commission) VALUES ( 'Brian', 12 ), ( 'Brian', 'None' ) GOSee possible answers