This month's discount Comprehensive Database Performance Health Check · Testimonials
SQLAuthority with Pinal Dave
Home
  • Consulting
    • Health Check
  • Free Videos
  • All Articles
    • AI
    • SQL Performance
    • SQL Tips and Tricks
    • Interview Questions and Answers
    • SQL Puzzle
    • SQL Video
    • SQLAuthority News
    • Personal
  • Books
  • Consulting
SQL Server Agent Properties.

SQL SERVER – How to Get SQL Server Agent Properties?

May 1, 2018
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server, SQL Server Agent, SQL Server Management Studio

During a health check someone asked if SQL Server Agent has settings to tune. It does. Here is how to get SQL Server Agent properties with a simple script.

Read More
Job records remain in the cabinet when the Agent mechanism stops

How to List All the SQL Server Jobs When Agent is Disabled? – Interview Question of the Week #171

April 29, 2018
Pinal Dave
SQL Interview Questions and Answers
SQL Scripts, SQL Server, SQL Server Agent

When SQL Server Agent is disabled, you cannot expand it in SSMS to see its jobs. Here is how to list all the SQL Server Jobs with a simple query instead.

Read More
Get-DbaMaxMemory.

PowerShell – Get Maximum Memory of Server with dbatools

April 26, 2018
Pinal Dave
SQL Tips and Tricks
PowerShell, SQL Memory, SQL Scripts, SQL Server

Readers asked how to get started with dbatools. Here is a simple first step: finding the maximum memory of a server with one PowerShell command.

Read More
Gouache painting of full apple baskets in the grass beside one empty vermilion basket

Transaction Log Backups Based on Log Size

April 24, 2018
Pinal Dave
SQL Tips and Tricks
Shrinking Database, SQL Backup and Restore, SQL Scripts, Transaction Log

Transaction log backups on a schedule can miss a burst of activity that fills the disk. This post builds a procedure that reads the log written since the last backup and takes a log backup once it passes a limit you choose. It also explains why the old habit of shrinking the log after each backup does harm.

Read More
SQL Server Configuration Manager.

SQL SERVER – SharePoint not Working After Failover to Another Node

April 23, 2018
Pinal Dave
SQL Tips and Tricks
SharePoint, SQL Error Messages, SQL High Availability, SQL Scripts, SQL Server, SQL Server Cluster

After a SQL Server cluster failover, SharePoint users could not open any page, though all SQL resources were online. Here is what we found and how we fixed it.

Read More
One railway route can split into parallel tracks, but the switch controls the route

How to Force a Parallel Execution Plan for a Query? – Interview Question of the Week #170

April 22, 2018
Pinal Dave
SQL Interview Questions and Answers
Execution Plan, SQL Performance, SQL Scripts, SQL Server

A customer asked how to force a Parallel Execution Plan for a query. Here are two methods, including QUERYTRACEON 8649, with a simple example.

Read More
SQL SERVER - Be Careful with Logon Triggers - Don’t use Host_Name

SQL SERVER – Be Careful with Logon Triggers – Don’t use Host_Name

April 14, 2018
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Login, SQL Scripts, SQL Server, SQL Trigger, Starting SQL

A reader used HOST_NAME() in a logon trigger to limit access. Here is why that is risky, and why Logon Triggers can lock everyone out if you are not careful.

Read More
Previous 1 … 100 101 102 103 104 105 106 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

© 2006 – 2026 All rights reserved. pinal @ SQLAuthority.com