On any instance you have at least 5 system databases. Master, model, msdb, tempdb and one other. First 5 points ... Continue reading
2021-11-15 (first published: 2021-11-02)
369 reads
After my post last week on sorting the list, I now have a list of files, sorted in the right ... Continue reading
2021-11-12 (first published: 2021-11-04)
442 reads
I’d just like to say a quick thank you to Redgate for hosting the Pass Summit, all of the amazing ... Continue reading
2021-11-11
28 reads
Sometimes when you are trying to figure something out you run across something really interesting. In this case I discovered ... Continue reading
2021-11-09
9 reads
Every one and again you will see people asking What skill do you think is the most important for your ... Continue reading
2021-11-05 (first published: 2021-10-28)
512 reads
I’ve got a project I’m working on at the moment and it includes a number of elements from my recent ... Continue reading
2021-11-01 (first published: 2021-10-21)
3,884 reads
In my last post I grabbed a file list but I really need it sorted alphabetically. Now, I’ve been a ... Continue reading
2021-10-26
20 reads
I’m working on a project right now where I want to add the date/time to the end of a filename. ... Continue reading
2021-10-25 (first published: 2021-10-14)
264 reads
I’m a big fan of comments (MSSQL, Powershell), so along those lines here’s an interesting way to comment an IF-THEN-ELSE ... Continue reading
2021-10-19
54 reads
CREATE DATABASE [Story]
ON PRIMARY
( NAME = N'Story', FILENAME = N'C:DataStory.mdf',SIZE = 101MB),
FILEGROUP [Line1]
( NAME = N'File1', FILENAME = N'C:Data_.It',SIZE = 102MB),
( NAME =...
2021-10-18 (first published: 2021-09-30)
500 reads
By Steve Jones
I saw a post internally that asked this question: Anyone have a handy powershell...
By Rob Sewell
The partner directory connects your agency with new customers.
I had an excellent group of people in Gothenburg Sweden when I taught there...
Comments posted to this topic are about the item GIT Configuration and Automated Release...
Hello all, Is there an easy way to output my records to a flat...
Comments posted to this topic are about the item Refactoring Databases: Evolutionary Database Design
What is the result of this code?
SELECT CONCAT(1, 2, 3) + 4See possible answers