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
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
Learn about how to implement a simple bucket sort algorithm using Python code to sort a list of array values.
2023-01-16
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
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
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
A subquery is a type of query that is embedded—or nested—into a data manipulation language (DML) statement. The subquery itself is typically a SELECT statement, although you can also use a TABLE statement or VALUES statement. Even so, the SELECT statement continues to be the most common choice for subqueries, and that’s the one I focus on in this article.
2023-01-11
In this article, we look at how to create transactions when using Snowflake along with several commands specific to working with transactions.
2023-01-11
In this tip, we guide you through the setup of Azure Synapse Link so you can query Azure Cosmos DB data with the Synapse Serverless.
2023-01-09
If only the entire world used UTC, wouldn’t life be so much easier? We can dream, can’t we? While some software applications can live in an ecosystem where all dates and times can be stored in a single time zone with no conversions needed, many cannot.
2023-01-09
By Steve Jones
Redgate Monitor is growing to include more than just Microsoft SQL Server monitoring. We...
By Steve Jones
Experience is overrated. Most breakthrough accomplishments were done by people doing them for the...
By Brian Kelley
As you begin the new year, if you don't already have time set aside...
Hello, At my work place I recently migrated our test environment to SQL Server...
So we have local sp in which remote table is udpated.this remote query part...
So we have local sp in which remote table is udpated.this remote query part...
What formats of API endpoints can the Data API Builder present to clients when exposing the database?
See possible answers