Muting the Immutable
Phil Factor on dealing with "immutable" domain data during database development and deployment.
2019-08-16 (first published: 2016-01-18)
381 reads
Phil Factor
- Interests: Motorbikes, Beer, gardening, conservation, Local history.
The Sequel to SQL
Phil Factor tacks a few new buzzwords onto his CV and looks forward to joining the new wave of "digital innovators".
2019-08-10
687 reads
Data Transfer Strategies between MongoDB and SQL Server
There are a variety of days to move data between MongoDB and SQL Server. This article covers some of your options and gives you ideas on which method might work best for you.
2019-07-22
13,910 reads
Over-thinking Database Build Scripts
With SQL Server we tend to build databases, when necessary, from one or more build scripts. If making changes to existing versions of the database, we then script the required changes. Usually, a synchronization tool will create a script that can be tweaked to work; although occasionally it will require something more complicated, as when […]
2019-06-29
332 reads
Databases made for Ops, not 'Oops!'
Just as you write a unit test before writing the code, so you must devise the means to monitor a database, to ensure its smooth operation, before creating the database.
2019-06-01
200 reads
The Blast Radius of a database
Phil Factor feels that the database gets the short shrift in any outage - it's time to stop saying "the database has gone down" and time to start thinking about the resilience of the entire system.
2019-05-04
481 reads
Guest editorial: SQL Code Metrics
In which Phil Factor toys with the thought of producing quality metrics for SQL code, before dismissing the idea as foolhardy.
2019-04-30 (first published: 2009-02-17)
629 reads
Why should SQL Server 2019 excite developers?
Phil Factor is excited for SQL Server 2019 and is keen to tell you why.
2019-04-06
683 reads
SQL Server Dynamic Online Catalog: Why Should You Care? Stairway to Exploring Database Metadata Level 1
In this first level, we look at the overview of what metadata is contained in each database, gain some understanding of the different types of information, and examine a few basic examples.
2019-03-26 (first published: 2016-08-03)
6,082 reads
Using SQL Server Dynamic Online Catalog to Explore Keys and Relationships: Stairway to Exploring Database Metadata Level 4
This level introduces keys, constraints, and relationships.
2019-03-26 (first published: 2016-10-19)
3,147 reads
Blogs
Save Azure PostgreSQL Backup to Storage
This may or may not be helpful in the long term, but since I’m...
The Book of Redgate: What’s Great about Redgate?
By Steve Jones
“I’m sick of hearing about Red Gate.” The first article in the book has...
SQL Server Performance – What IT Leaders Need to Know
By Kevin3NF
IT leaders have a lot on their plates! Budgets, staffing, security, uptime, and keeping...
Forums
Dynamic T-SQL Script Parameterization Using Python
Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...
Widespread New Technology Adoption
Comments posted to this topic are about the item Widespread New Technology Adoption
Multiple Sequences
Comments posted to this topic are about the item Multiple Sequences
Question of the Day
Multiple Sequences
In SQL Server 2022, I run this code:
CREATE SEQUENCE myseqtest START WITH 1 INCREMENT BY 1; GO CREATE TABLE NewMonthSales (SaleID INT , SecondID int , saleyear INT , salemonth TINYINT , currSales NUMERIC(10, 2)); GO INSERT dbo.NewMonthSales (SaleID, SecondID, saleyear, salemonth, currSales) SELECT NEXT VALUE FOR myseqtest , NEXT VALUE FOR myseqtest , ms.saleyear , ms.salemonth , ms.currMonthSales FROM dbo.MonthSales AS ms; GO SELECT * FROM dbo.NewMonthSales AS nmsAssume the dbo.MonthSales table exists. If I run this, what happens? See possible answers