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.
2020-09-08
22,576 reads
Today Steve thinks about what to do when planning for your digital assets after you pass.
2020-07-17
108 reads
Aleksander Madry discusses roadblocks preventing AI from having a broad impact and approaches for addressing these issues.
Continue reading Is AI human-ready?.
2019-04-17
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...
2019-04-16
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...
2019-04-15
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...
2019-04-11
Ever wonder about index column order; this piece should give some insight.
2020-12-04 (first published: 2019-02-28)
6,963 reads
Journalist Alamzeb Khan discusses recent security breaches in Pakistan that have affected millions of people and accounts.
2019-01-31
3,554 reads
With Azure Data Factory V2 Integration Runtimes (ADFv2 IR), you can deploy enterprise replication tasks to the Azure cloud.
2020-07-17 (first published: 2019-01-02)
2,343 reads
2018 is coming to an end, and AGs have been out for 6 years. They're stable now, right?
2018-12-28
2,749 reads
For one reason or another data security and encryption has been coming up quite...
By Steve Jones
As we try to get through these strange times in the world, I am...
By Will Assaf
Geeked to be speaking 2x on Saturday May 14, my second time speaking at...
Hello, How can I import a CSV file in SSIS (2016) at the same...
Recently we experienced a sudden surge in disk I/O every twenty minutes or so....
We use group managed service accounts for running the SQL Server 2017/2019 sqlserver.exe processes...
Ask SSC