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
PowerShell - Querying SQL Server From Command Line

PowerShell – Querying SQL Server From Command Line

May 24, 2016
Pinal Dave
SQL Tips and Tricks
Command Line, PowerShell, SQL Scripts, SQL Server

A client’s deployment scripts got me curious about PowerShell. Here is how to start querying SQL Server from the command line with a PowerShell script.

Read More
SQL SERVER - What is Trace Flag - An Introduction

SQL SERVER – What is Trace Flag – An Introduction

May 23, 2016
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server, TraceFlags

What is a trace flag, how do you turn one on, and how do you keep it after a restart? A beginner’s introduction, including the startup parameter option.

Read More
SQL Server 2016 - Introducing AutoGrow and Mixed_Page_Allocations Options - TraceFlags

SQL Server 2016 – Introducing AutoGrow and Mixed_Page_Allocations Options – TraceFlags

May 21, 2016
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server, SQL Server 2016, TraceFlags

A reader asked if trace flags 1117 and 1118 work for user databases. SQL Server 2016 turns them into the AutoGrow and Mixed_Page_Allocations options.

Read More
No tool window, query, execution plan, error dialog, diagram, or chart shown.

SQL SERVER – Steps to Migrate Clustered Disk / LUN

May 16, 2016
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server

This was a clustered instance, so we need to take care of dependency also. Here are the steps which I have outlined for Migrate Clustered Disk.

Read More
Cabinet doors with their individual keys and one conspicuously empty key recess

Primary Key and Null in SQL Server – Interview Question of the Week #071

May 15, 2016
Pinal Dave
SQL Interview Questions and Answers
SQL Constraint and Keys, SQL Scripts, SQL Server

Can a primary key contain NULL values? No. Here is why primary key and NULL do not mix, and the simple interview question many candidates miss.

Read More
PowerShell - Backup SQL Server System Databases

PowerShell – Backup SQL Server System Databases

May 9, 2016
Pinal Dave
SQL Tips and Tricks
PowerShell, SQL Backup and Restore, SQL Scripts, SQL Server

A client visit showed me that basics like system database backups often get missed. Here is a PowerShell way to back up SQL Server System Databases.

Read More
A fresh sheet replaces an older sheet in a stack, marked by a small vermilion bookmark

List All the Stored Procedure Modified in Last Few Days – Interview Question of the Week #070

May 8, 2016
Pinal Dave
SQL Interview Questions and Answers
SQL Scripts, SQL Server, SQL Stored Procedure

In the interview and I end up seeing candidates failing to answer this question about the Stored Procedure Modified recently.

Read More
Previous 1 … 148 149 150 151 152 153 154 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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