Category Archives: SQLServerPedia Syndication
-
Data jokes
1November 23, 2021 by Kenneth Fisher
I’m feeling a bit uninspired this week, and I plan on only doing one post this week, so I figured …
Continue reading -
Quiz & answers for my “Auditing your data and data access” session.
1November 16, 2021 by Kenneth Fisher
I was honored to speak at Pass Summit last week (Thanks again Redgate), and if you’ve ever been to one …
Continue reading -
Pass Summit 2021: A quick thank you to @Redgate.
2November 11, 2021 by Kenneth Fisher
I’d just like to say a quick thank you to Redgate for hosting the Pass Summit, all of the amazing …
Continue reading -
#PowershellBasics: The WHERE clause
Leave a commentNovember 9, 2021 by Kenneth Fisher
Sometimes when you are trying to figure something out you run across something really interesting. In this case I discovered …
Continue reading -
#PowershellBasics: Select the columns in the output.
Leave a commentNovember 4, 2021 by Kenneth Fisher
After my post last week on sorting the list, I now have a list of files, sorted in the right …
Continue reading -
SQL Homework – November 2021 – Backup, restore, and move the system databases.
2November 2, 2021 by Kenneth Fisher
On any instance you have at least 5 system databases. Master, model, msdb, tempdb and one other. First 5 points …
Continue reading -
The DBA as a helpdesk.
9October 28, 2021 by Kenneth Fisher
Every one and again you will see people asking What skill do you think is the most important for your …
Continue reading -
#PowershellBasics: Sort a list
2October 26, 2021 by Kenneth Fisher
In my last post I grabbed a file list but I really need it sorted alphabetically. Now, I’ve been a …
Continue reading -
#PowershellBasics: Get a list of files from a directory.
4October 21, 2021 by Kenneth Fisher
I’ve got a project I’m working on at the moment and it includes a number of elements from my recent …
Continue reading -
Commenting a branching IF-THEN-ELSE.
1October 19, 2021 by Kenneth Fisher
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
SQL Studies 