Modern Development
In some ways, development tasks haven't changed much in decades, but in others the way we build software has changed a lot, especially with regards to data.
2023-10-11
175 reads
Editorials
How Much Code Can You Review?
Code reviews are a part of many developers' lives, but is there a limit to what you can do effectively?
2023-10-09 (first published: 2017-01-27)
255 reads
Confidence
Today, I want to blog about something I have only limited knowledge of … confidence. Okay, I understand what confidence is, and I have seen it before in the real world and not just in biographical movies. In fact, I have met quite a few highly confident people. In almost every case, it was immediately […]
2023-10-07
85 reads
2023-10-06 (first published: 2017-01-30)
461 reads
Building Bonds with Entertainment
Over the years I've had the chance to work in a lot of companies, and I've seen a lot of different team-building attempts take place. In restaurants, these were often nights out with too many adult beverages. At a power station, we had some large outdoor BBQs, where again, sometimes there were too many adult […]
2023-10-04
113 reads
The Need for DevSecOps
DevOps is great, but Steve thinks we need to ensure we include security is a part of what we do when building and deploying software.
2023-10-02
137 reads
Community at PASS Summit
Last Saturday, September 23, was the first day of Fall. Regardless of how much has happened and changed over the last three and a half years, time keeps marching forward. And yet, there's exciting familiarity every time I see November approaching because I know something special is about to happen for those of us in […]
2023-09-30
48 reads
A Staffing Disaster
An Azure datacenter had a failure after an incident, partially because they didn't have enough people. Steve notes that staffing is a challenge in many ways.
2023-09-29
171 reads
Running a Service
The way we view our jobs might change how we do them. Steve has some advice on how to think about the work you do.
2023-09-27
109 reads
Are You Worried About AI?
Many people are worried for their future career prospects with the growth of Artificial Intelligence (AI) in many situations. Steve doesn't think that AI is going to take over the world, but it might affect your future opportunities.
2023-09-25
155 reads
Blogs
Deployment Pipelines in Fabric – What Are They?
By HeyMo0sh
In the realm of software development and content creation, the deployment pipeline serves as...
TempDB Internals – What’s New (SQL Server 2016 to 2022)
By Vinay Thakur
I wrote about TempDB Internals and understand that Tempdb plays very important role on...
Forums
A Quick Restore
Comments posted to this topic are about the item A Quick Restore
Guarding Against SQL Injection at the Database Layer (SQL Server)
Comments posted to this topic are about the item Guarding Against SQL Injection at...
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
Question of the Day
A Quick Restore
While doing some testing of an application, I wanted to reset my environment after doing some testing with this code:
USE DNRTest BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO /* Bunch of stuff tested here */RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance. See possible answers