2019-01-07
138 reads
Ben Kubicek
- Interests: Jesus, playing guitar singing, most sports, running, biking, triathlons
2018-11-15
701 reads
Using your critical eye to see something positive
As DBA's we are often looking for issues and hole is things, but it is also important to see positives and seek a better solution.
2018-10-18
71 reads
Using Redgate API to compare data in the same table
I needed to speed up some regression testing. Redgate Sql Data compare API helped me do it.
2018-10-16
1,364 reads
The Importance of Consistent Server Setup
In larger shops with multiple database servers, it is very important to have consistency.
2018-10-12
163 reads
What is the best way to on-board (train) a new junior employee?
It is important to train new people, so what is the best way to go about doing it?
2018-09-06
364 reads
Why not take a risk and try something new?
When we risk failure, we also have the opportunity for success, so try something new today.
2018-08-30
83 reads
When someone asks you what you do for work, how do you answer?
In many ways job titles matter, just not when telling a stranger what you do for work.
2018-07-30
451 reads
How much database normalization is enough?
Normalization is important for relational databases, but sometimes too much of a good thing can be bad.
2018-07-23
2,465 reads
2018-05-17
109 reads
Blogs
How to Parameterize Fabric Linked Services in Azure Data Factory for Azure Devops Deployment
Quite the title, so let me set the stage first. You have an Azure...
Deployment Pipelines in Fabric – What Are They?
By HeyMo0sh
In the realm of software development and content creation, the deployment pipeline serves as...
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