Blog Home Page - Page 390 of 831 - SQL Authority with Pinal Dave

Nov22

There are many performance counters available in SQL Server which can be used to monitor various parameters of SQL Server engine. Have you ever been into a situation where you want to see value in performance counter for a query which you have returned? Imagine a situation where you want…

Nov21

SQL SERVER – Fix : Msg 230, Level 14, State 1 – The SELECT permission was denied on the object, database, schema – Part II

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages

No Comments

A couple of days back I wrote the blog on Msg 230 and thought it was one of the simplest implementations of access control on the system. To continue with the code in this blog, please make sure you read the same first before getting into the examples here. In…

Nov20

SQL SERVER – Common Sense Data Security – Notes from the Field #055

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Notes from the Field, SQL Server Security

No Comments

[Note from Pinal]: This is a 55th episode of Notes from the Field series. Common sense is not as much as common as we think. I am sure you agree with it from your real world experience. However, when it is about data and its security, there has to be…

Nov20

SQL SERVER – Is tempDB behaving like a Normal DB?

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL TempDB

No Comments

The more I work with SQL Server, more I am baffled with the way SQL Server works. In all these interactions, I have seen DBA’s and Developers think about TempDB as something totally different from a usage point of view and treat it differently. Yes, I do agree TempDB is…

Nov19

SQL SERVER – SQLCMD to Build Comma Separated String

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

sqlcmd

We have an active usergroup in Bangalore called SQLBangalore. Whenever I get a chance to attend the local usergroup sessions (which happens often – trust me), I get to learn something every single time. In one of the recent user group meetings I had the opportunity to attend a Tips…

Nov18

SQL SERVER – Restricting Access to Contained Databases using Logon Triggers

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Trigger

When I wrote the article on “A Simple Example of Contained Databases” lesser did I know how people might be planning to use this capability? Having said that, there are environments where people want to use the concept of contained databases yet have flexibility of restricting the users. Recently, a…

Nov17

SQL SERVER – How to Chang Audit Location?

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Audit

The auditing capability inside SQL Server is a hidden gem and not known to many in my opinion. If you have a requirement to audit your SQL Server environment and want to keep track of the activities such as DBCC commands on the server, backup, restore, failed logins, login creations,…

SQL SERVER – Fix : Msg 230, Level 14, State 1 – The SELECT permission was denied on the object, database, schema – Part II

SQL SERVER - How to Chang Audit Location? KevinHazzard

SQL SERVER – Common Sense Data Security – Notes from the Field #055

SQL SERVER – Is tempDB behaving like a Normal DB?

SQL SERVER – SQLCMD to Build Comma Separated String

SQL SERVER – Restricting Access to Contained Databases using Logon Triggers

SQL SERVER – How to Chang Audit Location?

Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 24 years of hands-on experience. He holds a Masters of Science degree and numerous database certifications.

Pinal has authored 14 SQL Server database books and 109 Pluralsight courses. To freely share his knowledge and help others build their expertise, Pinal has also written more than 5,800 database tech articles on his blog at https://blog.sqlauthority.com.

Pinal is an experienced and dedicated professional with a deep commitment to flawless customer service. If you need help with any SQL Server Performance Tuning Issues, please feel free to reach out at pinal@sqlauthority.com.

Pinal is also a CrossFit Level 1 Trainer (CF-L1) and CrossFit Level 2 Trainer (CF-L2).

Nupur Dave is a social media enthusiast and an independent consultant. She primarily focuses on the database domain, helping clients build short and long-term multi-channel campaigns to drive leads for their sales pipeline.

Shaivi Pinalkumar Dave is a book author and a women’s artistic gymnast.

Is your SQL Server running slow and you want to speed it up without sharing server credentials? In my Comprehensive Database Performance Health Check, we can work together remotely and resolve your biggest performance troublemakers in less than 4 hours.

Once you learn my business secrets, you will fix the majority of problems in the future.

Have you ever opened any PowerPoint deck when you face SQL Server Performance Tuning emergencies? SQL Server Performance Tuning Practical Workshop is my MOST popular training with no PowerPoint presentations and 100% practical demonstrations.

Essentially I share my business secrets to optimize SQL Server performance.

Jun 2026 Discount: Comprehensive Database Performance Health Check | Testimonials

SQL SERVER – How to use Procedure sp_user_counter1 to sp_user_counter10

SQL SERVER – Fix : Msg 230, Level 14, State 1 – The SELECT permission was denied on the object, database, schema – Part II

SQL SERVER – Common Sense Data Security – Notes from the Field #055

SQL SERVER – Is tempDB behaving like a Normal DB?

SQL SERVER – SQLCMD to Build Comma Separated String

SQL SERVER – Restricting Access to Contained Databases using Logon Triggers

SQL SERVER – How to Chang Audit Location?

SQL SERVER – How to use Procedure sp_user_counter1 to sp_user_counter10

SQL SERVER – Fix : Msg 230, Level 14, State 1 – The SELECT permission was denied on the object, database, schema – Part II

SQL SERVER – Common Sense Data Security – Notes from the Field #055

SQL SERVER – Is tempDB behaving like a Normal DB?

SQL SERVER – SQLCMD to Build Comma Separated String

SQL SERVER – Restricting Access to Contained Databases using Logon Triggers

SQL SERVER – How to Chang Audit Location?