Idempotent
There are all sorts of coding practices that produce better code. Steve Jones talks about one today.
2024-11-04 (first published: 2015-05-06)
559 reads
Editorials
PASS Summit Time
As the Simple Talk Editor, I have had the privilege of attending numerous conferences these past few years, and all of them have been somewhere between great and amazing. Still, there is something a bit more special about the PASS Summit. Even before I started this position, I have been to the PASS Summit events […]
2024-11-02
44 reads
I Need a CS Degree. I Don't Need a CS Degree
Steve has a few thoughts on how valuable education can be in your career.
2024-11-01
112 reads
The Cloud Security Problem
Cloud security can be better than on-premises, but it requires work and knowledge.
2024-10-30
130 reads
Databases for Executives
Data and databases are critical in today's world. Executives should understand that, and Steve has something you can pass along.
2024-10-28
177 reads
Knowing Your Total Reward
When you agree to work for a company, you should understand all your compensation.
2024-10-25
164 reads
When Companies Fail
The challenge of software pervading all aspects of our lives and inside many products is going to be create an interesting world when companies fail.
2024-10-23
109 reads
Tech Debt Perils
Ignoring technical debt can cause no shortage of problems for companies. Today Steve has a recent example of this.
2024-10-21
159 reads
Are We Dinosaurs?
Let's talk about the elephant in the room right up front. Yes, I'm old. I remember when Buck Woody was a little tyke on the day the last of the Tyranosaurs died (I'm older than Buck). So, I'm not asking if I'm old. Yes. I'm old. No, I'm asking if that massive meteor strike over […]
2024-10-19
276 reads
2024-10-18
113 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