Tags » SQL Tips And Tricks

SQL SERVER - Steps to Backup to Windows Azure storage

Moving to a cloud based world is inevitable, it is something we need to learn soon. Ever since SQL Server 2014 has been released, the concept of uploading your backups to Blobs with Windows Azure has been around. 440 more words

SQL Authority

SQL SERVER - Creating a Database Administrator Group Using User-Defined Server Roles

When it comes to security related topics, I always read and learn something new from my friend Vinod. He always comes-up with something interesting and when he was at GIDS event, one of the attendees walked and asked a security question. 1,079 more words

SQL Authority

Interview Question of the Week #039 - What is Included Column Index in SQL Server 2005 and Onwards?

You may find it interesting that not many people still know what is Included Index in SQL Server. I have seen it personally around me and also have seen at… 397 more words

SQL Authority

SQL SERVER - Three Simple Guidelines for System Maintenance - Notes from the Field #098

: This is a 98th episode of Notes from the Field series. Maintenance of the database is a very critical activity and I have always seen DBA taking it very seriously. 780 more words

SQL Authority

SQL SERVER - What Does WHERE 1=1 Mean in the Code?

One of the blog followers asked this question “The code written by my colleague has WHERE 1=1. What does it mean?”

Well. You have seen people using it when they dynamically construct WHERE condition based on the input values. 271 more words

SQL Authority

SQL SERVER - What is Windows Internal Database Edition?

The more you read the more you learn. But some of the best learnings need not come from known sources. These can be accidental too. These learnings in my opinion involves tons of exploration which you would have never done before. 301 more words

SQL Authority