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
In part 2, we discuss the concepts of structure, tooling, and indexing for your data ingestion pipelines.
2023-01-18
2,730 reads
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,092 reads
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
Learn about how to implement a simple bucket sort algorithm using Python code to sort a list of array values.
2023-01-16
2023-01-13
516 reads
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
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,268 reads
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
Steve comments on some programming languages and how we approach those we choose to use.
2023-01-13
199 reads
By Chris Yates
For decades, enterprises have approached data management with the same mindset as someone stuffing...
Truncate Table Pitfalls Truncating a table can be gloriously fast—and spectacularly dangerous when used carelessly....
You can find all the session materials for the presentation “Indexing for Dummies” that...
Comments posted to this topic are about the item Technological Dinosaurs or Social Dinosaurs?
Comments posted to this topic are about the item DBCC CHECKIDENT
Comments posted to this topic are about the item Distributed Availability Group Health: T-SQL...
What is returned as a result set when I run this command without a new seed value?
See possible answers