ASP.NET 5 Up and Running Series
In the last week or so I’ve published 2 ASP.NET 5 posts each building on top of the previous. I’ve...
2015-05-20
38 reads
Blog Posts
Coming soon: Minion Backup, featuring table based scheduling!
The MidnightDBA team is announcing the release of a new, free backup solution for SQL Server: Minion Backup arrives on June...
2015-05-20
965 reads
HealthySQL - A Comprehensive Guide to Healthy SQL Server Performance
On an otherwise uneventful, other than the normal busy,
plate full, heading towards the US holiday weekend, middle-of-the-week, over
the hump day,...
2015-05-20
1,117 reads
Is Performance Better With LEFT JOIN or RIGHT JOIN?
I tend to write my queries using LEFT JOIN. Why? Because logically I see it in my head like this:
Give...
2015-05-20 (first published: 2015-05-11)
7,060 reads
MergUi 0.1.9
What is MergeUi?
A Visual Studio Addin to create and edit MERGE statements in SSDT projects.
What have you done?
I have released...
2015-05-20
571 reads
MergUi 0.1.9
What is MergeUi? A Visual Studio Addin to create and edit MERGE statements in SSDT projects.
What have you done? I...
2015-05-20
66 reads
MergUi 0.1.9
What is MergeUi? A Visual Studio Addin to create and edit MERGE statements in SSDT projects.
What have you done? I...
2015-05-20
45 reads
MergUi 0.1.9
What is MergeUi? A Visual Studio Addin to create and edit MERGE statements in SSDT projects.
What have you done? I have released a new version of MergeUi, thanks to...
2015-05-20
3 reads
Performance Impacts of Partitioning DML Triggers
[read this post on Mr. Fox SQL blog]
Continuing on with my Partitioning post series, this is part 3.
The partitioning includes several major...
2015-05-20
589 reads
Performance Impacts of Partitioning DML Triggers
[read this post on Mr. Fox SQL blog] Continuing on with my Partitioning post series, this is part 3. The partitioning includes several major components of work (and can be linked...
2015-05-20
9 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