T-SQL Tuesday #68: Just Say No to Defaults
Using PowerShell and SMO to set MinServerMemory and MaxServerMemory Programatically
Here is a link to the official #tsql2sday invitation from Andy...
2015-07-17 (first published: 2015-07-14)
1,651 reads
cjsommer.com
SQL Server Policy Based Management by Example
What steps do you go through to validate SQL Server configurations after a server build? Even a single server can...
2015-06-16
1,527 reads
SQL Saturday Albany (#sqlsat386) – Look Who’s Speaking!
So on June 3rd I got this email from Edward Pollack.
I had submitted a few weeks earlier and had been...
2015-06-09
740 reads
Free SQL Server Performance Testing Utilities
Did that say free? Why yes, yes it did! But don’t let the price tag fool ya, these are some...
2015-06-09 (first published: 2015-06-02)
12,643 reads
SQL Agent Job Wrapper Part 3 – Handing the Errors in the Wrapper Script
This is the 3rd installment in a small series of blog posts on how to create a PowerShell wrapper for...
2015-05-26
692 reads
SQL Agent Job Wrapper Part 2 – Adding Error Generation to the Cmdlet
Last week I posted Creating a SQL Agent Job Wrapper with PowerShell and SMO. In that post I created a...
2015-05-27 (first published: 2015-05-20)
5,320 reads
Creating a SQL Agent Job Wrapper with PowerShell and SMO
Some Background
“Is there any way to start a SQL Agent job using a script or program?”
I’ve seen this question asked...
2015-05-22 (first published: 2015-05-13)
6,873 reads
T-SQL Tuesday #66 – Monitoring
Thank you Cathrine Wilhelmsen for hosting this week’s #tsql2sday.
If I knew that this T-SQL Tuesday was going to be about...
2015-05-12
535 reads
Help! My database is stuck in SINGLE_USER mode!
HELP! My database is stuck in single user mode!
I answered this twitter post a while back and figured it would...
2015-05-13 (first published: 2015-05-05)
6,173 reads
Using PowerShell to Export SQL Data to CSV. How well does it perform?
So here we are at week 4 of the #SQLNewBlogger challenge. Earlier in the week I responded to the following...
2015-05-07 (first published: 2015-04-28)
33,503 reads
Blogs
The First Steps: Understanding the Basics of FinOps
By HeyMo0sh
As a DevOps professional, I’ve seen firsthand how cloud costs can quickly spiral out...
Monday Monitor Tips: AI Query Analysis
By Steve Jones
AI is everywhere. It’s in the news, it’s being added to every product, management...
AI: Blog a Day – Day 8: RAG – Retrieval Augmented Generation
By Vinay Thakur
RAG — Retrieval Augmented Generation. we have covered so far — embeddings, vectors, vector...
Forums
would it be so terrible to install ssms on a few user desktops?
Hi, ssms is free here. I can think of other reasons to do this...
I'm thinking about submitting some articles
I've written some documentation on using different Markdown types of files on GitHub. It's...
Not Just an Upgrade
Comments posted to this topic are about the item Not Just an Upgrade
Question of the Day
Restoring On Top I
I am doing development work on a database and want to keep a backup so I can reset my database. I make some changes and want to restore over top of my changes. When I run this code, what happens?
USE Master BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO USE DNRTest GO CREATE TABLE MyTest(myid INT) GO USE master RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACESee possible answers