What Exactly Is a CTE in T-SQL? A Comprehensive Guide with 7 Examples
Learn how to use CTEs through the use of a number of examples.
Learn how to use CTEs through the use of a number of examples.
Learn about the different tables that can be created using Azure Databricks with a dive deep into the importance of Delta Lake tables.
The SQL Server Database Engine processes queries on various data storage architectures such as local tables, partitioned tables, and tables distributed across multiple servers. The following sections cover how SQL Server processes queries and optimizes query reuse through execution plan caching.
Steve has had to change his security, which is good, but annoying.
In this second level of the Stairway to Database DevOps, we learn to use Redgate's SQL Source Control to save and updates changes to objects, as well as tracking data in certain tables.
Several data management patterns have emerged for microservices and cloud-native solutions. Learn important patterns to manage data in a distributed environment.
Learn about the evolutionary journey of ETL (Extract, Transform, Load) from traditional processes to modern cloud solutions.
In this first level of the Stairway to DevOps, you will learn how to get version control set up on your local machine and connect to an Azure DevOps repository.
Code reviews are a part of many software development processes, but not used that often with database work. Today Steve has a few thoughts and asks if you have any formal code review process.
In this article, we look at execution plans and performance of a natively compiled stored procedure versus a traditional stored procedure.
By Steve Jones
The season 1, seventh episode of Simple Talks is out. Check it out, with...
By Steve Jones
the McFly Effect – n. the phenomenon of observing your parents interact with people...
At a recent conference I was asked how I executed code during my presentation....
I would like to discuss Modvigil 200 mg with you. Honestly, I can't say...
There is a table tblItems with below structure ( i cannot change the below...
Invoke-Sqlcmd -Query "ALTER AVAILABILITY GROUP $AAG REMOVE DATABASE $DB " -ServerInstance $Instance Invoke-Sqlcmd :...
I have disabled the LoggerCI index on the dbo.Logger table. How do I enable it?
See possible answers