Blog Redirected
I have moved my blog over to here, expect exciting posts about the things that interest me my previous blog was at: http://sqlserverfunctions.wordpress.com.
I hope you find something you enjoy...
2014-10-20
4 reads
Blog Posts
Creating a Reporting Services Subscription
Subscriptions are a great feature in Reporting Services that will run a report unattended and deliver it to users either...
2014-10-20 (first published: 2014-10-13)
8,068 reads
Database Maintenance Plans: A Primer
Databases and newborns have a lot in common. They both require constant care. They both require constant monitoring. They also...
2014-10-20 (first published: 2014-10-14)
7,033 reads
DevDev
There has been a gigantic shift in attitudes between development and operations, the devops movement, to create a streamlined, automated...
2014-10-20
38 reads
DevDev
There has been a gigantic shift in attitudes between development and operations, the devops movement, to create a streamlined, automated...
2014-10-20
51 reads
DevDev
There has been a gigantic shift in attitudes between development and operations, the devops movement, to create a streamlined, automated and high performing team of developers and infrastructure techs...
2014-10-20
6 reads
Last Weeks Top “Reading” Links #105
It’s Monday time for this week’s weekly link round-up. If you want to catch these links “live” (so exciting), follow...
2014-10-20
738 reads
Minion Reindex arrives this Friday!
Edit: Minion Reindex has arrived, and it’s getting fantastic notes! The MidnightDBA team is announcing the release of a new,...
2014-10-20
1,127 reads
SQL Server Security Benchmarks
If you’re not familiar with the Center for Internet Security, here’s the organization’s mission statement:
The Mission of the Center for...
2014-10-20
868 reads
Webinar: Presenting to the PASS Database Administration Virtual Chapter
In this Webinar, Prakash will walk you through design considerations, accompanied with a script demo using PowerShell to generate a...
2014-10-20
803 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