About me
I have been developing software from my early teens and stayed with technology after leaving school. Initially focussing on software development, networking and IT support type roles, I found...
2017-05-03
14 reads
I have been developing software from my early teens and stayed with technology after leaving school. Initially focussing on software development, networking and IT support type roles, I found...
2017-05-03
14 reads
The other day I needed to test some HADR requirements on my local machine so using VirtualBox, I created a...
2017-04-19
2,643 reads
The other day I needed to test some HADR requirements on my local machine so using VirtualBox, I created a 2 server Windows 2012 R2 failover cluster with shared...
2017-04-19
3 reads
Another year, another blog update lol!... Last year I remember doing a significant version upgrade for my self-hosted Orchard CMS...
2017-04-12
223 reads
Another year, another blog update lol!… Last year I remember doing a significant version upgrade for my self-hosted Orchard CMS software on the DiscountASP hosting platform and it all...
2017-04-12
6 reads
This is a quick post to apologise in advance if all my historical blog posts get republished.
Recently it appears that...
2017-04-06
316 reads
I have spent a fair amount of time researching the Olcot and Arratoon ancestry and I am very interested in the family tree, especially pre 1900 in India. If...
2017-04-03
7 reads
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
191 reads
Edit (11-Sep-2016) See comment that pricing tiers have been adjusted since this blog post I’ve been aware of Pluralsight for a couple of years and as I’m always looking...
2016-09-11
6 reads
I was going through some really old blogging ideas and I stumbled over this one and seeing as I love...
2016-06-23
1,034 reads
By Steve Jones
I hosted this month’s T-SQL Tuesday party with my invitation asking about tracking permissions....
By Steve Jones
I was asked to do some a little thinking and brainstorming recently. Rather than...
By alevyinroc
It seems like no matter how long you work with a system beyond a...
Hi we run 2019 ssas std. Yesterday i imported my tabular project to vs...
Code for mssql 2008 DECLARE @CompanyID TINYINT DECLARE @MemNo decimal DECLARE @MemberFrom Integer DECLARE...
I have an execute task(has server list from a table) pointing to foraeachloop foreachloop...
I have a complex database with a few filegroups and files. Can I run a backup command like this? (assume file/filegroup names are valid).
BACKUP DATABASE [complex] FILE = N'thirdone' , FILE = N'thirdtwo' , FILEGROUP = N'second' TO DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL16.SQL2022\MSSQL\Backup\complex.bak' WITH NOFORMAT, NOINIT, NAME = N'complex-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10 GOSee possible answers