If your development team needs to work on anonymised copies of the current production database, and if changes are being delivered rapidly as well, that could mean a lot of time and routine DevOps work copying databases. SQL Clone was designed for tasks like this. Grant Fritchey investigates whether you save time, effort and scripting over the more traditional approach, and at what point it makes sense to use it.
In a long career in IT, Phil Factor cannot recall a 'major incident', where the failure or breach was due to a single 'Achilles Heel', or even a single team of people. They are always due to a whole plethora of slack and ignorant practices.
Erik Darling shows that if you take SQL Server's word when it asks for an index, things can go horribly awry.
This tip will show eight ways to export the results of a query to a text file.
This Friday Steve Jones wants to know what you think of testing code and why you don't do it.
SQL Server Integration Services (SSIS) is the integration and ETL (extract – transform – load) tool in the Microsoft Data Platform stack. SSIS is typically used in data warehousing scenarios, but can also be used in common data integration use cases or just to move data around. SSIS is used behind the scenes in the Maintenance Plans of SQL Server and in the Import/Export wizard.
Steve Jones talks about learning, teaching, and the need to not waste anyone's time.
There are several obvious problems with poor SQL Coding habits. It can make code difficult to maintain, or can confuse your team colleagues. It can make refactoring a chore or make testing difficult. The most serious problem is poor performance. You can write SQL that looks beautiful but performs sluggishly, or interferes with other threads. A busy database developer adopts good habits so as to avoid staring at execution plans. Rob Sheldon gives some examples.
Steve Jones notes that we often solve problems better the second time around.
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...
If you are looking for India’s best FSSAI Third Party Auditing Services in India....
If you are looking for India’s best FSSAI Third Party Auditing Services in India....
Recently, our dev teams approach me for advice on improving their huge heap table...
What are the distance metric algorithms that can be used in VECTOR_DISTANCE()?
See possible answers