The Case for Considering Git
Today we have a guest editorial from Kendra Little that looks at choosing a version control system as you adopt a Database DevOps software development process.
Editorials
Scary Data Collection
More and more data is being captured and analyzed all the time. At the same time, there are varying expectations of privacy that aren’t always shared between the subjects of data and the collectors. Steve has a few thoughts on how this will play out for data professionals.
Securing Code Early
Last year I started to get alerts from Microsoft Repos that someone had put a piece of security information in their code that pertained to one of my Azure services. At first I was worried, but then I realized this was the public version of AdventureWorks we maintain in Azure. We’ve published the login so […]
Capturing the Application Time
Most of us work with the time in a variety of ways in our applications. Temporal tables use the time on the server,but Steve notes today that we might want to capture other types of time.
Building a Database Engine
Someone tried to build a database engine from scratch. While not something Steve wants to do, it’s an interesting exercise.
Cloud Native
Building software for the cloud often requires some changes. This week Steve wonders how many of you are making the effort.
Computer Disruptions
I travel a fair amount for work to speak at various events around the world. Traveling can be quite a disruption to my life, and I do work to limit the amount of time that I’m gone. As my kids have gotten older, I’m have less commitments at home and an extra night during a […]
Understanding Your Database
Steve notes that many of us might not completely understand every part of our database, but it’s information that can be helpful in cleaning out unnecessary entities.
Code Building Code
Using code to help you write code is a time honored tradition in software development.
Blogs
ASF 021 video invitation (Star Wars Theme)
By KamilN78
Since now, we will not keep our guests in secret. We want you to...
Drop Database Objects Practically Risk-Free!
FIRST OF A TWO PART SERIES Some months ago, a fellow DBA came to...
Lengthen a Primary Key–#SQLNewBlogger
By Steve Jones
Another post for me that is simple and hopefully serves as an example for...
Forums
Protecting Data Between Services
Comments posted to this topic are about the item Protecting Data Between Services
SSIS Pkgs Run Fine on My Development PC But Fail on my SQL Server Machine
I’m out ideas on the following. Would appreciate anyone’s additional tips or suggestions if...
Generate list of working day according to rule defined.
I have table workingDates that has 3 columns wd:(type int ) This column has...
Ask SSC