Red Gate’s running a half-day training workshop at their UK head office in Cambridge on Aug 8. It’ll show you how to link your database source control repository to your build system as the starting point for continuous integration.
A lot of numbers that we use everyday such as Bank Card numbers, Identification numbers, and ISBN codes, have check digits. As part of the routine data cleansing of such codes we must check that the code is valid- but do we? Dwain Camps shows how it can be done in SQL in such a way that it could even be used in a constraint, and keep bad data out of the database.
The SSC team has put together a little quiz on database source control to go with Rob Richardson, Robert Sheldon, and Tony Davis' new book, SQL Server Source Control Basics. Do you daydream about source control... or daydream to avoid it?
This article demonstrates a method of importing a data file directly into a temporary table and selectively inserting data from the temporary table into a SQL Server table, all in a single set of SQL commands.
A good DBA needs to have good technical skills but he also has to have good personal skills. In this article, Greg Larsen discusses the personal skills a DBA should have.
Phil Factor explains that being a consultant in the latest IT hot topic is a worthy role. Someone has to do it, and Phil explains why.
In this lesson we will learn the basics of DMX and create some samples.
By Steve Jones
los vidados – n. the half-remembered acquaintances you knew years ago, who you might...
By Brian Kelley
I will be leading an in-person Certified Information Systems Auditor (CISA) exam prep class...
EightKB is back again for 2026! The biggest online SQL Server internals conference is...
Hi everyone I am looking at building a query to determine how much time...
Comments posted to this topic are about the item SQL Server Transactional Replication from...
Comments posted to this topic are about the item Hidden Heroes
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which are explicitly linked to increment a number in a table when a new row is added?
See possible answers