SQL Server point in time recovery
In this article, we look at how to do a point in time restore using TSQL and SSMS to recover a database to a particular point in time.
Knowing Your Technologies
When faced with choices, it's important to understand the capabilities and limitations of your options.
Technical Considerations for Data Ingestion - Part 2
In part 2, we discuss the concepts of structure, tooling, and indexing for your data ingestion pipelines.
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.
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.
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.
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.
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:
The Programming Languages We Use
Steve comments on some programming languages and how we approach those we choose to use.
Blogs
Case Studies: Real-World Success Stories of FinOps Implementation
By HeyMo0sh
Learning any kind of theory is easy, but adapting FinOps and watching it rescue...
SQL Server Security: Always Encryption
By Vinay Thakur
As discussed introduction of Always Encryption blog and initial Encryption at rest as TDE...
SQL Server Security – TDE Encryption
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
The Problem Isn't Always Your Query or Schema... Sometimes It's Hidden Assumptions
Comments posted to this topic are about the item The Problem Isn't Always Your...
Identity Defaults
Comments posted to this topic are about the item Identity Defaults
Question of the Day
Identity Defaults
What happens when I run this code?
CREATE TABLE dbo.IdentityTest
(
id int IDENTITY(10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
See possible answers