SQL Tips and Tricks Archives - Page 251 of 536 - SQL Authority with Pinal Dave

SQLAuthority News – A Conversation with an Old Friend – Sri Sridharan

October 9, 2012

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

Sri Sridharan is my old friend and we often talk on GTalk. The subject varies from Life in India/USA, movies, musics, and of course SQL. We have our differences when we talk about food or movie but we always agree when we talk about SQL. Yesterday while chatting with him…

SQL SERVER – Recover the Accidentally Renamed Table

October 8, 2012

Pinal Dave

SQL, SQL Puzzle, SQL Server, SQL Tips and Tricks

I have no answer to following question. I saw a desperate email marked as urgent delivered in my mailbox. “I accidentally renamed table in my SSMS. I was scrolling very fast and I made mistakes. It was either because I double clicked or clicked on F2 (shortcut key for renaming).…

SQLAuthority News – Download Whitepaper – SQL Server Analysis Services to Hive

October 7, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL White Papers

The SQL Server Analysis Service is a very interesting subject and I always have enjoyed learning about it. You can read my earlier article over here. Big Data is my new interest and I have been exploring it recently. During this weekend this blog post caught my attention and I…

SQL SERVER – Manage Help Settings – CTRL + ALT + F1

October 6, 2012

Pinal Dave

SQL Tips and Tricks

Database, SQL Server, SQL Server Management Studio

In this blog post we will learn about how to manage help settings.

It is a miracle that curiosity survives formal education. ~ Albert Einstein

SQL SERVER – 3 Online SQL Courses at Pluralsight and Free Learning Resources

October 5, 2012

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks, SQL Video

SQL in Sixty Seconds, SQL Training

Usain Bolt is an inspiration for all. He broke his own record multiple times because he wanted to do better! Read more about him on wikipedia. He is great and indeed fastest man on the planet. Usain Bolt – World’s Fastest Man “Can you teach me SQL Server Performance Tuning?”…

SQL SERVER – Importance of User Without Login – T-SQL Demo Script

October 4, 2012

Pinal Dave

SQL Tips and Tricks

SQL Scripts, SQL Server, SQL Server Security

Earlier I wrote a blog post about SQL SERVER – Importance of User Without Login and my friend and SQL Expert Vinod Kumar has written excellent follow up blog post about Contained Databases inside SQL Server 2012. Now lots of people asked me if I can also explain the same concept again so here is the small demonstration for it. Let me show you how login without user can help. Before we continue on this subject I strongly recommend that you read my earlier blog post here.

SQL SERVER – Identify Most Resource Intensive Queries – SQL in Sixty Seconds #028 – Video

October 3, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQL Video

Database, SQL in Sixty Seconds, SQL Scripts, SQL Server Management Studio

During performance tuning conversation the very first question people often ask is what are the queries offending the server or in another word let us identify the queries which are the most resource intensive. The resources are often described as either Memory, CPU or IO. When we talk about the…