Viewing 15 posts - 1 through 15 (of 645 total)
@ganotedp Yes, I agree that Agile experts are very quick to come out with this as an advantage, but for an old fogey like me, being told this...
June 28, 2020 at 4:01 pm
@Rocker. I agree entirely. There seems to be no future in a Windows machine hosting a docker SQL Server container. I'm still experimenting to try to find the ideal Linux...
May 31, 2020 at 9:59 am
The strange human behaviour I'm seeing in this, or any other, pandemic is that it confirms everyone's world view, whatever their beliefs. I makes me think that the true spirit...
May 4, 2020 at 8:28 am
please feel free to translate it into Russian.
April 23, 2020 at 8:41 am
It makes a lot of sense. Once a team realises the advantages, they rarely go back to the old ways. I'm currently working on a PowerShell script that takes a...
March 18, 2020 at 4:49 pm
Yes, IsJSON() is a good start. The 'Strict' option is an excellent precaution against Typos, but neither of these tackle the issues of how your data should behave. In a...
January 27, 2020 at 5:29 pm
tsalha Yes, I'm using System.Data.SqlClient generally for this. I use a temporary stored procedure on the connection, (create or edit) and then execute it with parameters. I usually just have...
January 27, 2020 at 9:26 am
A DBA in a London Bank I remember used to occasionally carry a lightening bolt made from papier mache and painted fiery gold when the Developers did something that merited...
January 20, 2020 at 5:37 pm
Consultancy is a job for which there is almost no training or body of expertise for the newcomer to use. Few people make a go of it successfully....
January 20, 2020 at 9:15 am
@david.Poole One of my favourite articles, that one. Written with feeling. You're right about deflecting the blame from the guilty. The blame game just takes too long, though...
January 20, 2020 at 9:03 am
Thanks for the kind words, DeafEater. Much appreciated.
January 19, 2020 at 7:35 pm
given your problem, I would have done this, Steve.
IF Object_Id('dbo.sometable') IS NOT NULL DROP TABLE dbo.sometable;--we script version 1CREATE TABLE dbo.sometable ( somekey...
July 2, 2019 at 10:10 am
Some interesting thoughts there, Steve. I once wrote an article in early 2012 on using migration scripts with databases but it never occurred to me at the time that...
July 1, 2019 at 6:12 pm
I wonder if the confusion is caused by the false idea that it is somehow wrong to add migration code to object-level build scripts. I put all sorts of stuff...
July 1, 2019 at 12:47 pm
I am flattered by the comparison with Justin Beiber, Patrick.
It is difficult to remove any ambiguity from an editorial because one has to keep it short. 'Hotheads' are people who...
May 8, 2019 at 10:09 am