Feb 2026 Discount: Comprehensive Database Performance Health Check | Testimonials

Home
  • Consulting
  • Training
  • Free Videos
  • All Articles
    • Interview Questions and Answers
    • SQL Tips and Tricks
    • SQL Performance
    • SQL Puzzle
    • Big Data
    • Blog Stats
    • SQL Books
    • Search SQLAuthority
  • Downloads
  • Hire Me
  • Health Check

SQL SERVER – Connecting Specific Database on Starting SSMS

October 5, 2017
Pinal Dave
SQL
In today’s blog post we are going to learn how to connect specific database directly when we start SQL Server Management Studio. Honestly, this is a very simple process, but I have seen quite a few DBA still unaware of this feature. I have seen DBAs directly connecting to master…
Read More

SQL SERVER – How to Delete a Single Table From SQL Server Backup File (.bak)

October 4, 2017
Pinal Dave
SQL Tips and Tricks
SQL Backup, SQL Server

Question: How to Delete a Single Table From SQL Server Backup File (.bak)?

Read More

SQL SERVER – Puzzle – Shortest Code to Produce the Number 1000000000 (One Billion)

October 3, 2017
Pinal Dave
SQL Puzzle
SQL Function, SQL Scripts, SQL Server

In the last puzzle, user had to write the shortest code to produce 0. I have received around 700 valid answers and while reading through the answers, I had a blast. I personally learned quite a lot from just administrating the quiz. Since that puzzle, I have received quite a few emails requesting to come up with next puzzle.

Read More
Error

SQL SERVER – The SaveToSQLServer Method has Encountered OLE DB Error Code 0x80040E4D

October 2, 2017
Pinal Dave
SQL
SQL Connection, SQL Error Messages, SQL Server

My relationship with existing clients, I provide quick help to them on simple issues. Let us learn the error related to SaveToSQLServer.

Read More

How to Enforce Password Policy of Windows to SQL Server? – Interview Question of the Week #142

October 1, 2017
Pinal Dave
SQL Interview Questions and Answers
SQL Login, SQL Scripts, SQL Server, SQL Server Security

Question: How to Enforce Password Policy of Windows to SQL Server?

Read More

SQL SERVER – How to Enable Backup Compression On by Default

September 30, 2017
Pinal Dave
SQL Tips and Tricks
SQL Backup, SQL Scripts, SQL Server

In this blog post we will discuss how to Enable Backup Compression on by default.

Read More

SQL SERVER – Document Your Databases with Data Dictionary and Diagrams

September 29, 2017
Pinal Dave
SQL
SQL Documentation, SQL Server

A couple of months ago I told you about the new interesting tool I found for documenting existing database schemas – Dataedo. For those who don’t remember, this is a desktop tool that enables you to describe database schema elements and create ER diagrams for existing databases, and export to nicely formatted HTML and PDF documents.

Read More
Previous 1 … 233 234 235 236 237 238 239 … 829 Next
  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

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

Go to mobile version