Creating and Using Inline Table-Valued Functions

Inline Table Valued Functions (iTVFs) are one type of user defined function that is available to implement in SQL Server since SQL Server 2000.

iTVFs remain a very useful tool in our SQL armoury, so let's quickly revisit them and the different ways we can use them in our code.

Is AI human-ready?

Aleksander Madry discusses roadblocks preventing AI from having a broad impact and approaches for addressing these issues.
Continue reading Is AI human-ready?.

8 ways for banks to use AI

If a bank gets in touch with a software company and wants to know how it could use artificial intelligence (AI), that means two things. First, the bank is...

Here and now: Boosting anti-money laundering efforts with Artificial Intelligence

Anti-money laundering has been an issue for banks and financial institutions for some time. Transaction monitoring systems have been around for many years. Meeting and complying with regulations at...

Its time to accelerate the State of DevOps

Redgate is joining forces with DevOps Research and Assessment (DORA), now part of Google Cloud, as a sponsor of the 2019 Accelerate State of DevOps Report, and we're excited...

Index Column Order – Be Happy!

Ever wonder about index column order; this piece should give some insight.

Cyber Insecurity in Pakistan

Journalist Alamzeb Khan discusses recent security breaches in Pakistan that have affected millions of people and accounts.

Replicate NetSuite Data to Azure SQL (SSIS in Azure Data Factory)

With Azure Data Factory V2 Integration Runtimes (ADFv2 IR), you can deploy enterprise replication tasks to the Azure cloud.

Have Availability Groups Gotten Easier Lately?

2018 is coming to an end, and AGs have been out for 6 years. They're stable now, right?

Adding a Primary Key to a Prepopulated Table using a SQL Server Integration Services Package

In this tip we look at how you can use SSIS to build a package to add a primary key to an existing table that does not already have a primary key.