Suppressing the FOMO
I saw a post recently on Twitter/X/whatever we call it. It was for a DevOps in a Day from Redgate taking place in Jacksonville. I’ve been a part of...
2023-10-27
28 reads
Blog Posts
Handling physical deletes from the source and continue populating your analytical data store
(2023-Oct-15) When something important disappears, it's natural to start asking questions and looking for answers, especially when that missing piece has had a significant impact on your life.Similarly, when data...
2023-10-25 (first published: 2023-10-16)
336 reads
The Evolution of Database Administration: From Administration to Database Reliability Engineering
In the fast-paced world of IT, where trends like DevOps and Infrastructure as Code (IaC) dominate the landscape, the concepts of Reliability and Observability have seamlessly woven themselves into...
2023-10-25 (first published: 2023-10-10)
509 reads
T-SQL Tuesday #167 – Encryption and Data Protection
I missed September since I was gone half the month in Europe and busy with a roadshow. And, I missed October, since I was busy this month and lost...
2023-10-25
48 reads
Common Mistakes in SQL Server – Part 4
Last week we have discussed how Null Values can cause a trouble in Common Mistakes in SQL Server – Part 3. This week I would like to draw your...
2023-10-23 (first published: 2023-10-09)
930 reads
Common Mistakes in SQL Server – Part 6
In SQL Server, there are various scenarios in which you may want to consider recompiling a query or a stored procedure to ensure optimal query performance. Recompilation generates a...
2023-10-23
23 reads
Speaking at #DataWeekender 6.5
Super excited to share that I have been selected to speak at Data Weekender 6.5 on Saturday, November 4, 2023. I will be presenting my session, Can Microsoft Purview...
2023-10-23
33 reads
Using the Pure Storage PowerShellSDK2 - Part 2 - Working With Data
Welcome back to the second installment of our series using the Pure Storage PowerShell SDK2. In this post, we’ll dive into working with object data using Pure Storage PowerShell...
2023-10-23 (first published: 2023-10-05)
181 reads
A New Word: Gobo
gobo – n. the delerium of having spent all day in an aesthetic frame of mind, taking photos across the city, getting lost in an art museum – which...
2023-10-20
32 reads
How to Downgrade Or Recover a SQL Server Database To A Previous Version Using SqlPackage.exe?
How to Downgrade a SQL Server Database To A Previous Version?
Upgrading a SQL Server database to a newer version is one of the core duties...
2023-10-20 (first published: 2023-10-06)
964 reads
Blogs
Setting Up a Mac for Data Engineering and AI Work
If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...
Want to look at cloud reporting but not sure what the costs will be?
By ChrisJenkins
Have you been thinking about migrating your reporting to Microsoft Fabric or Snowflake but...
The Joyful Craftsmen and the Revolt BI join forces
The Joyful Craftsmen has become the new owner of Revolt BI. The merger creates...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
Alamat Kantor BCA KCP Galuh Mas Telp:08218154398
WhatsApp:0821-8154-398 Area Street Festival, Ruko No 1 & 1A, CBD, Jl. Galuh Mas Raya,...
Alamat Kantor BCA KCU PONDOK INDAH Telp:08218154398
WhatsApp:0821-8154-398 Wisma BCA Pd. Indah, Jl. Metro Pondok Indah No.10, RT.3/RW.17, Pd. Pinang, Kec....
Question of the Day
Multiple Values Inserted
I have this code on SQL Server 2022. What happens when it runs all at once?
DROP TABLE IF EXISTS dbo.Commission GO CREATE TABLE dbo.Commission (id INT NOT NULL IDENTITY(1,1) CONSTRAINT CommissionPK PRIMARY KEY , salesperson VARCHAR(20) , commission VARCHAR(20) ) GO INSERT dbo.Commission ( salesperson, commission) VALUES ( 'Brian', 12 ), ( 'Brian', 'None' ) GOSee possible answers