SQL Server Archives - Page 52 of 393 - SQL Authority with Pinal Dave

SQL SERVER – Using Bitwise And (&) Instead of a Junction Table – Notes from the Field #053

November 5, 2014

Notes from the Field, SQL Server Security

[Note from Pinal]: This is a 53rdth episode of Notes from the Field series. Everyday I get 100s of emails and most of the emails have a similar request. Everyone wants to get maximum performance, but they want to make the least amount of changes in their code. Well, though…

SQLAuthority News – Get My Two Books FREE at #SQLPASS

November 4, 2014

Pinal Dave

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

Every year when I visit SQLPASS, I do book signing where I give away my books for free. This year there are two opportunities when I am going to give away my books for free. Though the books are in great numbers they always run away early. I strongly suggest that…

SQL SERVER – PowerShell way of Restarting SQL Server Service

November 3, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Powershell

I learn a lot when I go for conferences all around the world. There are styles, content and cultural differences that I get a chance to learn and enjoy as part of my trips. Most of these trips I make are geared towards at least one learning experience I can…

SQL Authority News – Presenting Session at #SQLPASS on November 5, 2014

November 3, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL PASS

I will be attending SQLPASS 2014 this year in Seattle. I have attended SQLPASS 5 times before and this is my sixth times for the event. I love this event and that is why every single year I attend the event. This time I will be presenting on session Secrets…

SQL SERVER – Why my Database is in Restoring Mode After Taking Backup?

November 1, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Backup and Restore, SQL Scripts

Once upon a time there was a SharePoint consultant named Pepper. She wanted to learn about SQL Server Administration/DBA work. While she was a master SharePoint consultant at her office in Bethel she grew curious to learn SQL Server. She wanted to be independent when dealing with SQL server chores…

SQL Authority News – 8th Year Anniversary – Thank You!

November 1, 2014

Pinal Dave

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

Today is very special day in my life. Exactly 8 years ago today, I had started writing this blog. When I started writing a blog post, I really had no idea what exactly I am starting and where exactly I was going to end. Today, after 8 years, I am…

SQL SERVER – Answer to Puzzle – ISNUMERIC and Unexpected Results

October 31, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Earlier I blogged about Puzzle – ISNUMERIC and Unexpected Results – SQL in Sixty Seconds #076 and it is one of the most popular blog posts. Lots of people answered the question correctly. In the blog post I had a video puzzle. You can watch the video over here. [youtube=http://www.youtube.com/watch?v=nGH1bv-qmBI]…