Update duplicate xml attribute values to unique value
I was going through some really old blogging ideas and I stumbled over this one and seeing as I love...
2016-06-23
535 reads
SQL Server Rocks!
Update duplicate xml attribute values to unique value
I was going through some really old blogging ideas and I stumbled over this one and seeing as I love finding creative solutions in XQuery, I’m not sure why...
2016-06-23
7 reads
Recertification, too easy?
3 years I was awarded the MCSE: Data Platform certification and as per the recertification rules, I needed to recertify...
2016-03-28 (first published: 2016-03-21)
1,793 reads
Recertification, too easy?
3 years I was awarded the MCSE: Data Platform certification and as per the recertification rules, I needed to recertify...
2016-03-21
201 reads
Recertification, too easy?
3 years I was awarded the MCSE: Data Platform certification and as per the recertification rules, I needed to recertify this year to keep it active. So shortly after...
2016-03-21
7 reads
UK Contractors - As you were, for now at least
I think there were are few sighs of relief around the country yesterday after the chancellor finished giving his autumn...
2015-11-26
904 reads
UK Contractors - As you were, for now at least
I think there were are few sighs of relief around the country yesterday after the chancellor finished giving his autumn...
2015-11-26
449 reads
UK Contractors – As you were, for now at least
I think there were are few sighs of relief around the country yesterday after the chancellor finished giving his autumn financial statement to parliament. For the past few weeks...
2015-11-26
8 reads
Indexed views on any core SQL server edition–The video
A few months back I created a blog post showing that you can indeed create and use indexed views on...
2015-10-10
451 reads
Indexed views on any core SQL server edition-The video
A few months back I created a blog post showing that you can indeed create and use indexed views on...
2015-10-10
192 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