Tags » SQL Tips And Tricks

SQL SERVER - Proof of Concepts with Windows Azure - Notes from the Field #056

: This is a 56th episode of Notes from the Fields series. If you are DBA and Developer there is always a situation when you want to prove yourself by building a small proof of concepts of your idea. 715 more words

SQL Authority

SQL SERVER - Inside Temp Table Object Creation

When I wrote the article around tempdb like normal database, I had a number of people asked me how it is so simple to understand? Well, they were asking how are the tables created? 434 more words

SQL Authority

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

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. 389 more words

SQL Authority

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

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. 608 more words

SQL Authority

SQL SERVER - SSMS Trick - Generating CSV file using 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. 277 more words

SQL Authority

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

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. 442 more words

SQL Authority

SQL SERVER - How to use Procedure sp_user_counter1 to sp_user_counter10

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? 507 more words

SQL Authority