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
Two connected marquetry stations remain intact while a sliding handle marks the active station.

SQL Server – Switch Between Result Pan and Query Pan – SQL Shortcut

November 28, 2008
Pinal Dave
SQL Tips and Tricks
SQL Server, SQL Server Management Studio, SQL Shortcut

The F6 Shortcut moves focus between SSMS panes. I use it when switching between the query editor and results.

Read More
A stand mixer and a balloon whisk beside the same bowl of half-whipped cream on a kitchen counter

SSMS or VS Code for SQL Server Work

November 27, 2008
Pinal Dave
SQL Tips and Tricks
Developer, SQL Server, SQL Server Management Studio, Visual Studio

Choose SSMS or VS Code for SQL Server work by task: administration, plans, scripts, MSSQL extension features, and team workflow.

Read More
An unrolled canvas tool roll on a table at night holding a few worn tools, each in its own pocket

The Tools a DBA Installs on Day One

September 5, 2008
Pinal Dave
SQL Tips and Tricks
DBA, SQL Backup and Restore, SQL Server, SQL Server Management Studio, SQL Utility

The tools a DBA installs on day one include SSMS, command line utilities, a checked script library, and managed source control.

Read More
A garden trellis with vines tied on with twine, and one vine leaning against it without any tie

Drawing a Diagram of an Existing Database

April 24, 2008
Pinal Dave
SQL Tips and Tricks
SQL Constraint and Keys, SQL Documentation, SQL Server, SQL Server Management Studio

A diagram of an existing database starts with real foreign keys, uses SSMS to reveal relationships, and records the important paths a picture misses.

Read More
A leaf stencil taped to a plaster wall beside three identical painted sage leaves, a paint sponge on a saucer.

Templates and Snippets in SSMS

February 25, 2008
Pinal Dave
SQL Tips and Tricks
SQL Coding Standards, SQL Scripts, SQL Server Management Studio, SQL Shortcut

Templates and snippets in SSMS turn repeated SQL patterns into editable starting points while keeping environment assumptions visible.

Read More
Database Properties.

SQL SERVER – 2005 – Forced Parameterization and Simple Parameterization – T-SQL and SSMS

October 25, 2007
Pinal Dave
SQL Performance
SQL Scripts, SQL Server Management Studio

Forced parameterization can cut query compilations for busy databases. I explain FORCED vs SIMPLE parameterization and how to set each with T-SQL and SSMS.

Read More
Server is configured for RPC.

SQL SERVER – 2005 – Fix : Error : Msg 7411, Level 16, State 1 Server is not configured for RPC

October 18, 2007
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Server Management Studio, SQL Server Security

Msg 7411 says the server is not configured for RPC. A Jr. DBA I am training found the fix on his own: turn the RPC option from False to True.

Read More
Previous 1 … 46 47 48 49 50 Next
  • Books
  • Testimonials
  • Privacy Policy

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