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

SQL SERVER – How to Chang Audit Location?

November 17, 2014

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…

SQL SERVER – Filtering CPU Bound Execution Plans with Extended Events

November 14, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL CPU, SQL Extended Events

Let me take a tour to what are we talking here from a scenario point of view. Prior to SQL Server 2012, tracing the execution plan is an all or nothing approach. In profiler, if we select execution plan, we will get every occurrence of every execution plan for all…

SQL SERVER – Validation Rules: Code or Database? – Notes from the Field #054

November 13, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

BIML, Notes from the Field, SQL Server Security

[Note from Pinal]: This is a 54th episode of Notes from the Field series. Where do we blame for a mistake or error in the system? Well, developer blames DBA and DBA blame developers. Sometimes there is no solution to the catch 22 situation. I have been there and I…

SQL SERVER – FIX – Msg 4864, Level 16, State 1 – Bulk load data conversion error

November 13, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages

Working with SQL Server is such rewarding and most of the times, I get a chance to revisit and explore more into some of these errors. Long time ago, I had written a blog post to read data from CSV/text file and insert into SQL Server Table using BULK INSERT…

SQL SERVER – What is Hypothetical Indexes?

November 12, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Index

If you ever thought this is some sort of trick to bring you to the blog, well you are wrong. This infact is something worth a look and interesting thing to know. Before I start to explain you the finer details, let me tell you that this is NOT a…

SQL SERVER – FIX – Error: One or more files do not match the primary file of the database

November 11, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages

Writing about SQL Server for close to 8 years, almost every single day means I get a lot of questions from people on a daily basis. Though I try to answer as many as possible (via email, blog, twitter and Facebook), I get many interesting questions. There are a variety…