SQL Archives - Page 147 of 519 - SQL Authority with Pinal Dave

SQL SERVER – Maintenance Plan – Maintenance Cleanup Task not Deleting Files

November 26, 2014

I am always notified by my blog readers whenever they see something unusual and I try to help them so that I can learn something new. Recently, one of my blog reader told that his drive is getting filled with the regular backups taken via SQL Server Maintenance Plans. My…

SQL SERVER – FIX – The database ‘model’ is marked RESTORING and is in a state that does not allow recovery to be run

November 25, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Backup and Restore, SQL Data Storage, SQL Scripts

The best way one can learn SQL Server is by trying out things on their own and I am no different. I constantly am trying to explore the various options one can use when working with SQL Server. In the same context, when I was playing around with backup restore…

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

November 24, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

CSV, SQL Server Management Studio

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…