VirtualBox SQL FCI - Given Network Name Is Unusable
The other day I needed to test some HADR requirements on my local machine so using VirtualBox, I created a...
2017-04-19
1,688 reads
SQL Server Rocks!
Moved blog to Ghost
Another year, another blog update lol!... Last year I remember doing a significant version upgrade for my self-hosted Orchard CMS...
2017-04-12
211 reads
Apologies in advance
This is a quick post to apologise in advance if all my historical blog posts get republished.
Recently it appears that...
2017-04-06
301 reads
Pluralsight = Essential Training
Edit (11-Sep-2016) See comment that pricing tiers have been adjusted since this blog post
I've been aware of Pluralsight for a...
2016-09-11
174 reads
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
783 reads
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
214 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,776 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
190 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
889 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
441 reads
Blogs
Adding a Check Constraint to a Table–#SQLNewBlogger
By Steve Jones
Another post for me that is simple and hopefully serves as an example for...
Azure SQL Database Elasticity – Presentation Notes
By DataOnWheels
This blog covers the content and points to the code used to create the...
How To: Create Schema Only Database Copies
By gbargsley
Have you ever been asked to make a schema only copy of a database?...
Forums
Joining 2 select results into a single row
select( select name,enabled, case when enabled = 1 then 'active' else 'notactive' end as...
Ask SSC