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,654 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,534 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,680 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
694 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,874 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,510 reads
Blogs
The Agent Era: When “How do I…?” Replaces “Where do I click?”
By Arun Sirpal
After a year away getting to grips with AI and its application across the...
Beware of Generic SQL Server License Keys (What to Use Instead)
By SQLPals
Beware of Generic SQL Server License Keys (What to Use Instead) ...
On Speaking Well
By Brian Kelley
Professor Patrick Winston of MIT used to give a one-hour talk about how to...
Forums
Creating a JSON Document II
Comments posted to this topic are about the item Creating a JSON Document II
Backing Up Azure Key Vault EKM Key: Stairway to TDE Level 6
By VishnuGupthanSQLPowershellDBA
Comments posted to this topic are about the item Backing Up Azure Key Vault...
Every Database Has Problems
Comments posted to this topic are about the item Every Database Has Problems
Question of the Day
Creating a JSON Document II
I want to create a JSON document that contains data from this table:
TeamID TeamNameCity YearEstablished 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960If I run this code, what document(s) is/are returned?
SELECT json_objectagg( n.city : n.TeamName) FROM dbo.NFLTeams;See possible answers