Prepping for Certification, Part 1 of ?
I thought it would be good to put my thoughts down on how to prepare for a certification. I don't know how many posts I will make on this,...
2025-09-26 (first published: 2025-09-04)
534 reads
How to Avoid Knowledge Stagnation
You want the short answer? Well, the only antidote to knowledge stagnation is probably embracing the habit of lifelong learning. For the long-winded answer, read on. Have you ever...
2025-09-24 (first published: 2025-09-04)
495 reads
Demystifying Fabric Workspaces: The Nerve Center of Your Data Universe
It always starts the same way. You open your laptop on a Monday morning, coffee in hand, ready to tackle the week, only to spend the first hour hunting...
2025-09-29 (first published: 2025-09-04)
322 reads
Managing Enterprise Storage with Pure Storage Fusion in PowerShell - Building Storage Tiers
In modern IT environments, not all workloads require the same level of storage performance, protection, or cost. Some applications need high performance with aggressive data protection, while others are...
2025-09-29 (first published: 2025-09-04)
157 reads
Azure Networking: Designing for Change
Failing to plan is planning to fail. When organizations first begin implementing Azure networking, the focus is often on the immediate requirements: connectivity, security, and performance for your databases...
2025-09-22 (first published: 2025-09-03)
188 reads
The Case of the Forgotten Compatibility Mode – Scooby Dooing Episode 3
Like any good mystery, some SQL Server problems look spooky on the surface but have a very simple culprit hiding in the shadows. Every good Scooby-Doo episode starts with...
2025-09-19 (first published: 2025-09-03)
310 reads
Using Customer Docker Compose File Names
As I use containers more and more to run various things, I decided I not only wanted to set up docker compose files, I wanted to name them something...
2025-09-26 (first published: 2025-09-03)
368 reads
SQL Server Failover Cluster Instances
Old Reliable Still Matters If you’ve been around SQL Server for a while, you’ve heard of Failover Cluster Instances (FCIs). They’ve been part of SQL’s high availability toolbox since...
2025-09-19 (first published: 2025-09-03)
233 reads
How to: Regain SysAdmin Access to a SQL Server Instance Without the SA Password
Hello, reader! Today, I’m going to walk you through a scenario that many DBAs encounter: accessing a SQL Server instance when you don’t have the SA password, and no...
2025-09-17 (first published: 2025-09-02)
1,692 reads
Secure Your SQL Estate: Best Practices for Azure SQL Security
The Castle and the Keys Imagine your Azure SQL environment as a sprawling digital estate – a castle of data, with towers of insight and vaults of sensitive information....
2025-09-22 (first published: 2025-09-02)
477 reads
Blogs
A New Word: Semaphorism
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
SQL Server Linux Container Images Got Smaller: Image Size and Startup Time Across Cumulative Updates
This week I was at PASS Data Community Summit in Seattle, and I attended...
Using AI to Build Semantic Models, Ontologies, and Fabric Data Agents
By James Serra
(This is the third post in a three-part series on how AI is changing...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Layanan BCA KCP Rembang Hub/Wa. 0817-819-444
WhatsApp:0817819444 Jl. Pemuda No.3 C, Tawangsari, Leteh, Kec. Rembang, Kabupaten Rembang, Jawa Tengah 59217
Layanan BCA KCP Blora Hub/Wa. 0817-819-444
WhatsApp:0817819444 Jl. Pemuda No.57B, Blora, Tempelan, Kec. Blora, Kabupaten Blora, Jawa Tengah 58211
Question of the Day
Adding Bits I
I have a table, dbo.bittest, where I am testing an application response. This has this structure:
CREATE TABLE [dbo].[BitTest] ( [insertdate] [datetime] NULL CONSTRAINT [DF__BitTest__insertd__300F11AC] DEFAULT (getdate()), [a] [bit] NULL ) ON [PRIMARY] GOMy application runs this code:
INSERT dbo.BitTest
(
insertdate,
a
)
VALUES
(DEFAULT, 'true')
GO
See possible answers