Stairway to Database Containers Level 4: Using a Docker Compose File
In the next level of the Stairway to Database Containers, let's learn to use a compose file to specify a number of options for our container.
Is your DevOps strategy missing a vital link?
Database DevOps practices can help you ship features faster, but how do you safely enable this, and ensure those updates will successfully deploy? Redgate Test Data Manager was developed to resolve bottlenecks and challenges, helping organizations ship deployments they can trust by enabling developers and testers to self-serve test data that walks and talks like production with sensitive customer data taken care of. Read more on the blog.
Microsoft Fabric Warehouse Security: Object-Level, Column-Level and Row-Level
Learn about object-level, column-level, and row-level security in Microsoft Fabric Warehouse and how this can be implemented to limit access to data.
Big Northwind with AI
As part of my work with Redgate, I wanted to do some testing on our subsetting and masking tools. Subsetting needs a big data set, and while Stack Overflow is big, it's kind of simple. I wanted something a little different. Since our engineers use Northwind to do a lot of demos, I decided to […]
Less Junior Staff
One of the strange side effects of AI might be junior staff struggle to get hired and get experience. Where does that leave the industry when senior staff retires?
Stairway to Advanced T-SQL Level 9: Compare, Modify, Derive and Validate Date and Time Values
When you build applications that store data in SQL Server you will most likely have to store dates and times, and you’ll call functions to do date manipulations. It is important to understand the different date and time data types, and when to use one data type over another. In this level I will be exploring the different date and time data types and discussing when each type is appropriate.
Days of the Week, Bitwise Edition
I recently had to help support synchronization and distribution of workloads between multiple servers.
Outside Interests
I'm a little excited because tomorrow I'm going to my first maker's faire. I'll be volunteering with our local radio club (100 year old, W5IAS, oldest radio club in Oklahoma). In addition, I'll be showing off a few controller chips & Raspberry Pis that I use with my radios for APRS, satellite tracking, and digital […]
Iteration and Conditional Activities in Azure Data Factory
Learn about the different iterator activities in Azure Data Factory.
Your Computer Science Education
Steve wants to know how and what you learned about computing, as well as what was missing.
Blogs
Can You See Who Forced a Plan
I had an excellent group of people in Gothenburg Sweden when I taught there...
Monday Monitor Tips–Finding CUs for My Instance
By Steve Jones
How can I quickly get a CU patch for a system that’s out of...
Why Data Analysts Love PostgreSQL (and You Will Too!)
Data analysis is all about wrangling massive datasets. To do that efficiently, you need...
Forums
GIT Configuration and Automated Release for Azure Data Factory
Comments posted to this topic are about the item GIT Configuration and Automated Release...
workaround for problems that cant be try caught
hi a peer of mine recalls an error in an edi app that often...
How to commit transaction log during a large ETL process
Hello SSC! First, I would like to thank everyone who has responded to my...
Question of the Day
Trigger Order III
I have created these triggers in SQL Server 2022:
CREATE TRIGGER triggertest_tri_1 ON dbo.triggertest FOR INSERT AS PRINT 'one' GO CREATE TRIGGER triggertest_tri_2 ON dbo.triggertest FOR INSERT AS PRINT 'two' GOI want to be sure that the trigger with "1" runs first. I decide to run this:
EXEC sp_settriggerorder@triggername = 'triggertest_tri_1', @order = 'first'What happens? See possible answers