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,657 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,555 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
745 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,753 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
697 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,330 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,898 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
540 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,180 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,525 reads
Blogs
My Social Media Rules
By Brian Kelley
I developed these rules a while back, before COVID. I had a period of...
Why Use TRY_PARSE(): #SQLNewBlogger
By Steve Jones
Someone asked why I would use TRY_PARSE after I posted a question at SQL...
A Guatemalan's Guide to Drinking Coffee Properly
My mugI grew up surrounded by coffee farms in Guatemala and somehow spent most...
Forums
Partitioning a table with TEXTIMAGE_ON option
I have a table that ends in ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]. I'm about to...
OUTER APPLY Fundamentals: Part 2
Comments posted to this topic are about the item OUTER APPLY Fundamentals: Part 2
Building Great Software
Comments posted to this topic are about the item Building Great Software
Question of the Day
The Range of Customers
I have this data in the OrderHeader table in a SQL Server 2025 database (ordered by CustomerID ASC):
orderid orderdate customerid complete 3 2025-05-10 00:00:00.0002 1 21 2024-01-10 00:00:00.0003 1 15 2023-10-28 00:00:00.0004 1 13 2025-03-08 00:00:00.0006 1 11 2024-04-02 00:00:00.0007 1If I run this query, how many rows are returned?
SELECT * from dbo.OrderHeader where customerid between 3 and '6'See possible answers