Tags » SQL Authority

SQL SERVER - Customization of New Query in SQL Server Management Studio

Recently I was working with one of my friends who handles production server databases as a senior DBA. He told that recently one of the Jr. 428 more words

SQL Authority

SQL SERVER - Identifying T-SQL Missing Parameter Data Types with SQL Server

I like challenges and when we are faced with a challenge – I just cannot sleep. I am in constant search for solution. More importantly I look forward for the learning experience these bring to me. 649 more words

SQL Authority

SQL SERVER - Beginning with SQL Server Security Aspects

SQL Server Security Aspects

This article is the high-level overview of the SQL Server security best practices and aspects. Ensuring SQL Server security is an important task that may be successfully solved by applying best practices and proven solutions described further in this article. 1,758 more words

SQL Authority

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