DbUp is a great tool to manage changes to our database schemas. While its strength is with changing tables, we can use DbUp to insert seed data as well. It even works with binary data, if we use the right settings and find the correct method of SqlCommand. Accept code for migrations While it …
I needed to find all columns with an underscore (_) in their name and came up with this query:
|
1 2 3 4 5 6 7 |
SELECT TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME like '%_%' ORDER BY TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME |
But instead of showing me columns with a _ in their name, I got every column back that exists in my database. When I replace _ with anything else, I got the expected result. What …
I had an interesting problem to solve: How long did a task take to complete? The challenge was that our task history table contains one row for the start and another one for the end of a task: Id TaskId Action Timestamp 1 100 Start 2022-08-01 08:00:00.000 2 101 Start 2022-08-02 07:30:00.000 3 100 Stop …
After I wrote last year about 3 Database Viewers for SQLite, one of the maintainers of Beekeeper Studio pointed me to their database manager. I was interested, but unfortunately there where too many bugs that made it impossible to work with my demo database. I liked what I saw, but it needed more time to …
While cleaning up a project, I needed a list of all the views in the database. SQL Server Management Studio provides a menu for this, but I needed a way to get this data in text form. In SQL Server, you can get this information from the INFORMATION_SCHEMA.TABLES view. In this view, you get a …
With SQL Server 2016 SP1 came a small but helpful new statement to create views: OR ALTER. If you add this to the create script for a view, SQL Server will figure out if it should run the CREATE or the ALTER statement:
|
1 2 3 4 5 6 7 8 9 10 11 |
CREATE OR ALTER VIEW EmployeeReport AS SELECT p.FirstName, p.MiddleName, p.LastName, e.HireDate, e.JobTitle FROM Person.Person p JOIN HumanResources.Employee e ON p.BusinessEntityID = e.BusinessEntityID |
This feature is especially helpful when you incrementally develop your views. …
We are currently migrating our larger databases to SQL Server 2019. While the migration went smoothly for the small databases, there was an unexpected problem with the last server: the backup was incredibly slow. The first larger database we moved to the new server took 10 times longer to back up than on the old …
Dev containers are not only for old software. They are also a great help when you plan a migration and need a new technology stack. Let’s look how SQL Server 2019 works nicely with our dev containers. SQL Server 2019 on Linux If you want to use SQL Server 2019 in a container you …
If you work with web technologies these days, there is no way around JSON. Today we look at the basic operations to serialize our objects to JSON and turn JSON back into objects. This post is part of my journey to learn Python. You can find the other parts of this series here. You find …
Sometimes the collection of data takes a lot longer than processing it. Wouldn’t it be great if you could store whole Python objects? If something goes wrong, we can restart the analytics part and don’t need to recreate the data. This post is part of my journey to learn Python. You can find the other …