VS Code – Terminal crashes when formatting script
I love VS Code. I love being able to press ALT + SHIFT + F and format my code.
The Problem
Yesterday all I...
2018-02-10
467 reads
I love VS Code. I love being able to press ALT + SHIFT + F and format my code.
The Problem
Yesterday all I...
2018-02-10
467 reads
In my last blog post I showed how to run a script with the WhatIf parameter. This assumes that the...
2018-02-05 (first published: 2018-01-25)
1,414 reads
Last weekend I was thinking about how to save the tweets for PowerShell Conference Europe. This annual event occurs in...
2018-02-03
741 reads
Before you run a PowerShell command that makes a change to something you should check that it is going to...
2018-01-23
842 reads
I was going through my demo for the South Coast User Group meeting tonight and decided to add some details...
2018-01-18
369 reads
TagLine – My goal – Chrissy will appreciate Unit Tests one day
Chrissy has written about dbachecks the new up and coming...
2018-01-15
330 reads
This is just a quick post. As is frequent with these they are as much for me to refer to...
2018-01-05 (first published: 2017-12-18)
1,600 reads
In my previous posts about writing your first Pester Test and looping through instances I described how you can start...
2017-11-30
669 reads
In my last post I showed you how to write your first Pester test to validate something. Here’s a recap
Decide...
2017-11-28
364 reads
On the plane home from PAS Summit I was sat next to someone who had also attended and when he...
2017-11-27 (first published: 2017-11-10)
1,484 reads
By Steve Jones
I love Chicago. I went to visit three times in 2023: a Redgate event,...
By Brian Kelley
I have found that non-functional requirements (NFRs) can be hard to define for a...
By Kevin3NF
Can we normalize a couple of things? 1 – Trade Schools. Back in the...
Hi, I have two tables: one for headers with 9 fields and another for...
We're trying to understand how quick new versions of SQL server can be. Obviously...
hi we run 2019 std. we saw this week that someone hid 3 important...
Let’s consider the following script that can be executed without any error on both SQL Sever and PostgreSQL. We define the table t1 in which we insert three records:
create table t1 (id int primary key, city varchar(50)); insert into t1 values (1, 'Rome'), (2, 'New York'), (3, NULL);If we execute the following query, how will the records be sorted in both environments?
select city from t1 order by city;See possible answers