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.
Azure Data Factory is a cloud based data integration service. This helps you to define, schedule and manage data pipelines to transfer and transform the data from disparate on premise and cloud data sources. Read on to learn more.
In this article we will learn to use Data Factory to import table from SQL Server to Azure SQL Data Warehouse.
By HeyMo0sh
Working in DevOps, I’ve seen FinOps do amazing things for cloud cost control, but...
Every organization I talk to has the same problem dressed up in different clothes....
By DataOnWheels
I am delighted to host this month’s T-SQL Tuesday invitation. If you are new...
Comments posted to this topic are about the item The day-to-day pressures of a...
ashes over you, making you forget the relentless sun outside. Instantly, your energy lifts,...
Comments posted to this topic are about the item Creating a Simple and Flexible...
When thinking about the identity property and sequence objects, which of these can be used with numeric and decimal data types?
See possible answers