Changing a Drive Letter with PowerShell
Here is a short but sweet post on how to change the drive letter of a partition. Despite using my best Google skills I couldn’t find an example that...
2021-06-07 (first published: 2021-05-21)
363 reads
Blog Posts
Daily Coping 7 Jun 2021
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-06-07
9 reads
Database Fundamentals #30: Create Foreign Keys With T-SQL
You can create foreign keys using TSQL roughly the same way as you created primary keys. You can either use the ALTER TABLE statement to add the foreign key,...
2021-06-07 (first published: 2021-05-24)
430 reads
Let’s Talk About Your Development Environment
Let’s talk about your development environment. Specifically, I’d like to chat with you about the virtual space where your data architecture team, software developers, and information curators do their...
2021-06-07
10 reads
Let’s Talk About Your Development Environment
Let’s talk about your development environment. Specifically, I’d like to chat with you about the virtual space where your data architecture team, software developers, and information curators do their...
2021-06-07
27 reads
Scripting using SMO
I will be delivering a lightning talk at DataMinutes on June 7th on this topic. I thought it would help to write a synopsis of what am going to...
2021-06-06
37 reads
Azure Auditing, Monitoring & Alerting
Auditing, monitoring and alerting are security & performance tools that track activities inside a database and generates log events and alerts when a predefined event(more...)
2021-06-05
12 reads
#PowershellBasics: Writing to the screen
Writing to the screen is a really basic debugging technique. That said, since I’m really new with Powershell this is ... Continue reading
2021-06-04 (first published: 2021-05-20)
623 reads
Azure SQL database backup & restore
Database backup and restore strategy is vital in preserving data for disaster recovery, compliance or fixing human error. In a business critical application, data need(more...)
2021-06-04
10 reads
Computed Columns for Grouping–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I ran into someone trying to do some...
2021-06-04 (first published: 2021-05-19)
357 reads
Blogs
Questions and Answers from Running a Local LLM
By Steve Jones
I had a few random questions from my Running a Local LLM on Your...
Overview of Claude AI Models: Which One to Choose?
By Arun Sirpal
For those entering the AI space whether professionally or personally I wanted to give...
Houston AI-Lytics 2026–Powerpoint Slides
By Steve Jones
Thanks to everyone for attending my session on running a Local LLM. If you...
Forums
A question about how to store the address in the database
I have an app that has an address field on the customer and the...
SSIS package failing intermittently on last Excel Component
Good Afternoon, I have a Job which "fires" off an SSIS package (that is...
T-SQL in SQL Server 2025: JSON_ARRAYAGG
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Question of the Day
Multiple Sequence Values
How do I easily get the next 12 sequence values from a sequence object?
See possible answers