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

SQL SERVER – Disable Guest Account – Serious Security Issue

February 20, 2012

“No Guests PLEASE!” “Doesn’t your Indian tradition suggest welcoming guests and treating them in the best way possible?” “Yes, but I am talking about the Guest user in SQL Server.” “Oh!” This was a real conversation that happened a couple of years ago. I welcome guests as much as any other Indian…

SQL SERVER – Migration Assistant for Oracle, MySQL, Sybase and Access v5.2

February 19, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Migration is always the challenge, it does not matter if people are migrating from one country to another country or birds are migrating from one continent to another continent or database is migrating from one platform to another platform. I remember years ago when I had to migrate our database from…

SQL SERVER – Case Sensitive Database and Database User – Fix: Error: 15151 – Cannot find the user , because it does not exist or you do not have permission.

February 18, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages, SQL Server Security

Jeff asked me another question! If you do not know Jeff, you may read the following blog posts. You will get the idea of Jeff’s personality and who Jeff really is. SQL SERVER – Installation Log Summary File Location – 2012 – 2008 R2 SQL SERVER – INNER JOIN Returning…

SQL SERVER – Be Different – Be Leader – An Interactive Journey – Questions and Answers – Book and Video

February 16, 2012

Pinal Dave

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

SQLAuthority Book Review

This is a true story. My wife and my daughter were playing in the play area in our resident complex. I was sitting a ways off and was watching them play various games. My daughter likes the slides a lot. Suddenly, one kid started to climb the slide from the…

SQL SERVER – T-SQL Errors and Reactions – SQL in Sixty Seconds #002 – Video

February 15, 2012

Pinal Dave

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

Database, SQL in Sixty Seconds, SQL Scripts

We got tremendous response to our very first video of SQL in Sixty Seconds #001. We talked about how to convert Subquery to CTE very quickly. My co-authors Vinod Kumar and Rick Morelan, we often came across very interesting and useful tips which we believe would be helpful to readers.…

SQL SERVER – Building Interactive Reports in Quick Moments – From CSV to Excel Pivot Table – A Conversation turned to Webinar

February 13, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Utility

“I have text files and I need to create interactive reports for my boss – do you have few minutes of time right now? Let us discuss.” I often get questions from people who are new to technology and struggling to get something done. However, this time it was not…

SQLAuthority News – Business Intelligence features of SQL Server 2012 RC0 – Download Virtual Machine

February 12, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Business Intelligence, SQL Download

I am in front of computer 16+ hours of the day. However, I accept that I am bit lazy when it is about doing installation etc. I always prefer that IT department help me to install my computer and I use it right away. Same feeling I get when I…