2019-07-09 (first published: 2019-05-01)
442 reads
Thom Andrews
SQL Server Agent for SQL Express on Linux
This article will show you how to use crontab to schedule tasks that you want to run on a SQL Server on Linux instance when no Agent is configured.
2019-06-18
1,580 reads
2019-05-16
1,562 reads
2019-04-29
8,501 reads
Why QUOTENAME is important
Why good use of QUOTENAME can easily prevent injection and unexpected behaviour in Dynamic SQL.
2018-08-13
2,531 reads
SQL Server on Linux, does it have Microsoft's full attention?
SQL Server on Linux doesn't support Ubuntu 18.04 LTS. Why weren't Microsoft ready for the next LTS release?
2018-05-21
746 reads
Blogs
A simple powershell script to look up server hardware and OS information
By SQLPals
This is a simple powershell script to query and display hardware and OS information...
Collecting Server Performance Metrics: Performance Monitor
Whether you’re a DBA/administrator looking to tune a server, planning for hardware updates, or...
Introduction to SQL Server Execution Plans
By Bert Wagner
Watch this week’s episode on YouTube! I nearly always use execution plans as the...
Forums
How to send queued emails
After an upgrade, sql server stopped sending emails. Problem is not solved but during...
TLS 1.2 and Database mail
Hi, We use office 365, and just recently received an email from them saying...
Left join not pulling all from left table
T has 57,000 distinct rows Z has over a million. I did row over...
Ask SSC