Technical Considerations for Data Ingestion - Part 2
In part 2, we discuss the concepts of structure, tooling, and indexing for your data ingestion pipelines.
2023-01-18
2,796 reads
Articles
Dealing with the Bits of a Binary Value in SQL Server
In this article, I want to talk about a topic that you may never need. The only time I have really had need to look at the bits in a byte pattern. In (what is now) ancient versions of SQL Server didn't have such self-describing columns like in its metadata objects like it does now.
2023-01-18
Understanding Windows Server Cluster Quorum Options
If you're deploying SQL Server, you are likely running business-critical applications on it and you need to ensure it's protected from downtime and data loss.
2023-01-18
How to work with web information, maps, and images in Power BI
In this article, you will learn how you can add the map and image visuals to your Power BI report and have them update as you select different data values.
2023-01-16
2,126 reads
Bucket Sort Algorithm in Python to Sort a List of Array Values
Learn about how to implement a simple bucket sort algorithm using Python code to sort a list of array values.
2023-01-16
How to Find Missing Rows in a Table
When someone says, “Find all the rows that have been deleted,” it’s a lot easier when the table has an Id/Identity column. Let’s take the Stack Overflow Users table:
2023-01-16
Using pre-commit to prevent simple mistakes
Git hooks are a useful way of triggering code quality scripts. The pre-commit tool provides us with a way of doing this and tapping into the huge library of scripts already in existence to ensure our code complies with general linting and formatting good practice.
2023-01-13
6,698 reads
Database Sharding to help Improve Performance and Maintenance Tasks
In this article, we will review the benefits and drawbacks of using database partitioning (sharding) to help improve performance and maintenance tasks.
2023-01-13
How to Create a Box and Whisker Plot in Power BI Desktop
In this article, we look at how to build a box and whisker plot chart using Power BI Desktop with a step-by-step walkthrough.
2023-01-13
Translate Text Data using Azure Cognitive Services
Learn the basics of the Text Translation services in Azure Cognitive Services.
2023-01-11
3,255 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 BCA KCU VETERAN 082225313145 WA CS
WhatsApp 082225313145 Jl. Veteran No.18-24, Krembangan Sel., Kec. Krembangan, Surabaya, Jawa Timur 60175
Alamat BCA KCU GALAXY 082225313145 WA CS
WhatsApp 082225313145 Jl. Dr. Ir. H. Soekarno No.37-39, Klampis Ngasem, Kec. Sukolilo, Surabaya, Jawa...
Alamat BCA KCP Dewi Sartika Tlp:08218200233
Telp/WA 62 8218200233 Jl. Dewi Sartika No.189, RT.1/RW.5, Wil, Kec. Kramat jati, Kota Jakarta...
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