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.
Thank you to everyone who participated in T-SQL Tuesday #198! When I wrote the...
Efficient query performance in Amazon Redshift often comes down to how well you manage...
By gbargsley
Welcome back to PowerShell Strikes Back. We’re three weeks in, and the training is...
Recently, our dev teams approach me for advice on improving their huge heap table...
Whatsapp 087781685647 Jl. Gajah Mada No.112 B-C-D, RT.1/RW.1, Krukut, Kec. Taman Sari, Kota Jakarta...
After upgrading 2 Merge Replicated databases to SQL 2022 and re-establishing the Merge Replication...
What are the distance metric algorithms that can be used in VECTOR_DISTANCE()?
See possible answers