All Articles - SQL Authority with Pinal Dave

SQL SERVER – SSMS Trick – Generating CSV file using Management Studio

November 24, 2014

In my previous blog I talked about using SQLCMD to generate a comma separate files for the table data. Some blog readers reported that why we should use SQLCMD or BCP to generate the file when the same can be achieved using SQL Server Management Studio itself. Well, that was…

SQL SERVER – FIX – The term ‘Invoke-Sqlcmd’ is not recognized as the name of a cmdlet

November 23, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Powershell, SQL Error Messages

It’s always a fun to learn and share new thing which I learn about any technology. So I decided to spend my weekend at home quietly, so I could learn some scripting using PowerShell and SQL Server. My laptop has tons of software installed so I always use my Virtual…

SQL SERVER – How to use Procedure sp_user_counter1 to sp_user_counter10

November 22, 2014

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

SQL Stored Procedure

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…

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

November 21, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages

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…

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

November 20, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Notes from the Field, SQL Server Security

[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…

SQL SERVER – Is tempDB behaving like a Normal DB?

November 20, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL TempDB

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…

SQL SERVER – SQLCMD to Build Comma Separated String

November 19, 2014

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…

SQL SERVER – Restricting Access to Contained Databases using Logon Triggers

November 18, 2014

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…

SQL SERVER – How to Chang Audit Location?

November 17, 2014

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 column of the object , database , schema

November 16, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages

Being a DBA is one of the most rewarding experience because you control the server as well as the way the permissions are given to each and every individual users. In my career I have often seen people try to underestimate the use of GRANT, DENY and REVOKE. Not so…