#PowershellBasics: Get-Help -Online
One of the other things I learned from the Powershell class I’m taking this week is that there is an ... Continue reading
2019-11-01 (first published: 2019-10-21)
474 reads
SQLStudies
#PowershellBasics: Multiple run spaces in ISE
As you know from the last few posts, I’m in a class on Powershell. One of the first things we ... Continue reading
2019-10-23 (first published: 2019-10-16)
426 reads
#PowershellBasics: The Windows Powershell icon in the task bar also lets you run Powershell ISE.
I don’t know about you, but I like having the tools that I’m likely to use on my taskbar. That ... Continue reading
2019-10-14
97 reads
#PowershellBasics: Powershell vs Powershell Core
I’m taking a Powershell class this week and I have to say the teacher is one of the best I’ve ... Continue reading
2019-10-10
366 reads
Using 3rd party tools. T-SQL Tuesday #119
It’s that time again! Alex Yates (b/t) has asked us to discuss a time in tech when we’ve changed our ... Continue reading
2019-10-11 (first published: 2019-10-08)
460 reads
SQL Homework – October 2019 – Code review (self and peer)
Every database person I’ve ever met writes at least some code at some point in their career. That code might ... Continue reading
2019-10-14 (first published: 2019-10-02)
551 reads
2019-09-30
37 reads
Blogging and coding best practices
I had a discussion a while back, I think it was with Grant Fritchey (b/t) but I just can’t remember. ... Continue reading
2019-09-25
28 reads
Debugging techniques (focusing on T-SQL)
tl;dr; Add PRINT and/or SELECT statements. Comment/uncomment out pieces of code to isolate problems. Change INSERT/UPDATE/DELETE statements to SELECTs. Disclaimer: ... Continue reading
2019-10-07 (first published: 2019-09-23)
847 reads
When using Powershell to control Azure the Cloud Shell doesn’t require an additional login.
When studying Azure one of the things you’ll be asked to learn is the Powershell commands that can control, well, ... Continue reading
2019-09-18
82 reads
Blogs
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Tell It Once: Setting Up Claude With Skills and MCP Servers
By ReviewMyDB
Many of us use AI the same way every single day. Open a tab....
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident
By SQLPals
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident SQL...
Forums
Make It Routine
Comments posted to this topic are about the item Make It Routine
Finding Gaps in Sequential Data Using SQL Server
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
Negative and Positive Numbers
Comments posted to this topic are about the item Negative and Positive Numbers
Question of the Day
Negative and Positive Numbers
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers