Choosing Between SQL Server Integration Services and Azure Data Factory
In this article we look at the similarities and differences of SSIS and Azure Data Factory and provide some insight as to when you would use one over the other.
2022-01-21
Articles
The Redgate Advocates Predict… 3 Key Challenges to Overcome in 2022
Read what Grant, Steve and Kathi predict will be the biggest challenges for data professionals to overcome this year.
2022-01-21
Playing popular game of Wordle using T-SQL
Popular and addictive game of Wordle is now written in Transact SQL script. With this script, you can now play this game on Microsoft SQL Server, using your favourite editor - SSMS, ADS, VS Code, and enjoy playing the game during free time, or whilst waiting for the other SQL query to complete.
2022-01-19
4,583 reads
Playing popular game of Wordle using T-SQL
Popular and addictive game of Wordle is now written in Transact SQL script. With this script, you can now play this game on Microsoft SQL Server, using your favourite editor - SSMS, ADS, VS Code, and enjoy playing the game during free time, or whilst waiting for the other SQL query to complete.
2022-01-19
737 reads
Reporting on Changes Made by Flyway Migration Scripts
Phil Factor demonstrates some PowerShell tasks that will produce a high-level overview, or narrative, of the main differences in the metadata between two versions of a database, during Flyway Teams migrations.
2022-01-19
SQL Identity Column Gaps and Conversion in SQL Server, Oracle and PostgreSQL
Learn about identity column sequence gaps and changing an existing column to an identity column in SQL Server, Oracle and PostgreSQL.
2022-01-19
SQL Server Dacpac in Azure Data Studio
Introduction This article will introduce you to the SQL Server Dacpac in Azure Data Studio. We will also learn about the Bacpac. In the Azure Data Studio, we have an extension named SQL Server Dacpac which allows us to deploy, extract Dacpacs, create a database from a Bacpac and export a schema and data to […]
2022-01-17
13,542 reads
Power BI Zoom and Focus
In this article we look at how to add the zoom feature to your charts and graphs in Power BI reports for a better user experience.
2022-01-17
Where's the best place to live as a DBA?
Got wanderlust? We thought it would be fun to look at where the best place to live in the world is as a DBA. Find the winners and weigh in on the debate here!
2022-01-17
Performance Tuning Using Free Tools, Part 2
You can do essential performance tuning on your SQL Server databases using a FREE toolkit!
2022-01-14
5,597 reads
Blogs
A New Word: Gnossienne
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
Exploring DiskANN: Part I: Understanding the Algorithm before the disk
How I used AI for this postChatGPT to generate images based on info specifically...
Learning Tool – Deepstash
By Brian Kelley
A few months ago I started using Deepstash. Deepstash breaks books into the key...
Forums
Alamat Kantor BCA KCP Kramat Jati Tlp:08218200233
Telp/WA 62 8218200233 Jl. Raya Bogor No.19, RT.1/RW.4, Wil, Kec. Kramat jati, Kota Jakarta...
Alamat BCA KCP Jatinegara Timur Tlp:08218200203
Telp/WA 62 8218200203 Jl. Jatinegara Timur No.37 Pav, RT.8/RW.4, Bali Mester, Kecamatan Jatinegara, Kota...
Alamat Kantor BCA KCP Pulogadung Tlp:08218200174
Telp/WA 62 8218200174 Jl. Raya Bekasi No.B-C Km.19 No.30, RT.1/RW.6, Wil, Kec. Pulo Gadung,...
Question of the Day
The Data API Builder MCP Server Tools
The Data API Builder MCP Server, v2.x, includes a number of tools. What actions can these tools perform in your database?
See possible answers