SQL IS NULL and SQL IS NOT NULL Examples
This article looks at how to use SQL IS NULL and SQL IS NOT NULL operations in SQL Server along with use cases and working with NULL values.
2024-12-02
Additional Articles
Demystifying Continuous Integration vs. Continuous Delivery: Part 2
Welcome to part 2 of our Demystifying Continuous Integration vs. Continuous Delivery series.
2024-11-29
Execute Stored Procedures in the Microsoft GraphQL API
This tip explores leveraging existing SQL Server stored procedures within the Microsoft GraphQL API.
2024-11-27
Transactions
By now, pretty much everyone has heard the stories about the first computers. They were huge, cost a fortune, required incredible amounts of air conditioning, and perhaps more importantly, ran batch jobs submitted on punched cards and magnetic tape. But even before we had these dinosaurs, there were E.A.M (electric accounting machine) units.
2024-11-22
Should That Be One Update Statement or Multiple?
Let’s say we have a couple of update statements we need to run every 15 minutes in the Stack Overflow database, and we’ve built indexes to support them:
2024-11-20
Explore Pandas in Python to Analyze and Manipulate Tabular Data
Learn how to use Pandas an open-source library for analyzing and manipulating tabular data in Python along with several examples.
2024-11-18
Making Temporal Databases Work, Part 3: Saving Data
In part three of this series, Boris Novikov looks at how data is saved and modified in a temporal database and what kind of integrity constraints are needed for temporal tables. If you haven’t seen parts one and two, don’t worry! Links are provided in the article, and we recommend checking them out first.
2024-11-15
Relationships with Microsoft Fabric GraphQL API
Learn how to join tables together when using the GraphQL API with Microsoft Fabric in this step-by-step article.
2024-11-13
How Many Indexes Is Too Many?
Let’s start with the Stack Overflow database (any size will work), drop all the indexes on the Users table, and run a delete:
2024-11-11
How To Embed Your Azure Logic Apps in a Metadata-driven Data Platform
In this article, I am going to explain how you can dial your productivity up to 11 when you’re dealing with a lot of Azure Logic Apps in your data platform.
2024-11-08
Blogs
From Planning to Practice: Setting Up Your FinOps Framework
By HeyMo0sh
As someone who works in DevOps, I’m always focused on creating systems that are...
“We love to debate minutiae”
By Brian Kelley
I am guilty as charged. The quote was in reference to how people argue...
Advice I Like: Knots
By Steve Jones
Learn how to tie a bowline knot. Practice in the dark. With one hand....
Forums
Restoring On Top II
Comments posted to this topic are about the item Restoring On Top II
SQL Art 2: St Patrick’s Day in SSMS (Shamrock + Pint + Pixel Text)
Comments posted to this topic are about the item SQL Art 2: St Patrick’s...
Breaking Down Your Work
Comments posted to this topic are about the item Breaking Down Your Work
Question of the Day
Restoring On Top II
I have a database, DNRTest, that has a number of tables and other objects in it. The other day, I was trying to mock up a test and ran this code on the same server:
-- run yesterday CREATE DATABASE DNRTest2 GO USE DNRTest2 GO CREATE TABLE NewTable (id INT) GOToday, I realize that I need a copy of DNRTest for another mockup, and I run this:
-- run today USE Master BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO RESTORE DATABASE DNRTest2 FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens? See possible answers