SQL Server Archives - Page 49 of 393 - SQL Authority with Pinal Dave

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

November 23, 2014

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…