CI

External Article

Database Continuous Integration

  • Article

Have you ever longed for a way of making the delivery of databases more visible, predictable and measurable? Do you ever wish that they would be of better quality, quicker to change, and cost less? Grant Fritchey explains some of the secrets of doing Continuous Integration for Databases to relieve some of the pain-points of the Database Delivery process.

2016-02-23

4,082 reads

External Article

Implementing Continuous Integration for Databases

  • Article

Continuous integration (CI) is becoming more and more common in application development. It ensures code and related resources are integrated regularly and tested by an automated build system, and highlights problems early in the development process. But what about database development? Can the same advantages of CI be applied to production databases? Where do you start? How do you tackle it? Sjors Takes relates his experience.

2015-11-09

2,651 reads

Technical Article

RE: Question of the Day for 20 Sep 2004

  • Reply

Excellent question! I am a big fan of any question that exposes weaknesses in T-SQL and/or the SQL pseudo-implementation of the Relational Model. A practitioner who is aware of these deficiencies is much less likely to be bitten by the problems they introduce.Adam - are you the author of this question? How does one determine […]

2004-09-20

Technical Article

RE: Transferring Logins

  • Reply

The users within a database have a SID column which matches to the SID value of the login.If you transfer your logins first then restoring your database will maintain your user to login relationship.The sp_change_users_login procedure is great when autofixing a username that is identical to the login name but otherwise you have to know […]

You rated this post out of 5. Change rating

2004-09-13

Technical Article

RE: Tracking User Activity

  • Reply

As I layed in bed this morning not wanting to get up I came up with the following. Note that this involves maintaining individual connections for each user for the life of an IIS session or similar control which I understand to be bad coding practice. I believe scalability was the main problem with this […]

2004-08-25

Blogs

Small Data SF 2024

By

I can’t remember how I heard about Small Data SF 2024, but it caught...

A New Word: Moledro

By

moledro – n. a feeling of resonant connection with an author or artist you’ll...

Snowflake + Azure blob

By

Let’s go back to data platforms today and I want to talk about a...

Read the latest Blogs

Forums

7 sept, scheduled book

By philip.scott

Comments posted to this topic are about the item 7 sept, scheduled book

7 sept, schedlued article

By philip.scott

Comments posted to this topic are about the item 7 sept, schedlued article

6 sept, published book

By philip.scott

Comments posted to this topic are about the item 6 sept, published book

Visit the forum

Question of the Day

Azure Data Lake Storage Gen 2

Azure Data Lake Storage Gen 2 is built on ...?

See possible answers