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

SQL SERVER – Installation Log Summary File Location – 2012 – 2008 R2

February 7, 2012

Here is email received from user: “Pinal, I am new DBA in my organization and I have to manage SQL Server 2005, 2008 and 2008 R2. Today is my first day at job and my manager has asked me to install all these different edition on our test environment. I…

SQLAuthority News – Microsoft SQL Server AlwaysOn Solutions Guide for High Availability and Disaster Recovery

February 5, 2012

Pinal Dave

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

SQL White Papers

SQL Server 2012 is has very exciting new feature of SQL Server AlwaysOn. This new feature reduces planned and unplanned downtime and maximize application available. Additionally it provides data protection keeping database always available. Microsoft has released a whitepaper on this subject where it discusses common context business stakeholders, technical…

SQL SERVER – Finding Count of Logical CPU using T-SQL Script – Identify Virtual Processors

February 4, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL DMV, SQL Scripts, SQL Server

I recently received email from one of my very close friend from California. His question was very interesting. He wanted to know how many virtual processors are there available for SQL Server. He already had script for SQL Server 2008 but was mainly looking for SQL Server 2000. He made me go to my past. I found following script from my old emails (I have no reference listed along with it, so not sure the original source).

SQLAuthority News – An Incredible Successful SQL Saturday #116 Event – First SQL Saturday in India

February 3, 2012

Pinal Dave

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

SQL PASS

We have recently wrapped up our most recent event, SQL Saturday #116, and I am I am sure I am not alone in reporting that it was a huge success! We had a full crowd – every seat taken, plus standing-room-only in the back. We also had a lot of…

SQL SERVER – An Inspiring Personal Story – Movie from The Book – Video Course – SQL Server Questions and Answers – Pluralsight

February 2, 2012

Pinal Dave

Personal, SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks, SQLAuthority News

SQL Training

Nov 3, 2011 – Visit to Grandma When our SQL Server Interview Questions and Answers book got published I ran to my grandma with a copy of the book for her blessings. Well, just like every grandma, she loves me, her grandson, unconditionally. She is not into the technology domain (obviously), but she loved…

SQL SERVER – What is Slowly Changing Dimension – Quiz – Puzzle – 31 of 31

February 1, 2012

Pinal Dave

SQL, SQL Interview Questions and Answers, SQL Puzzle, SQL Server, SQL Tips and Tricks

Click here to get free chapters (PDF) in the mailbox Year 2011 was a year of learning and opportunity for me. My recent book, SQL Server Interview Questions and Answers, has received such overwhelming love and support from all of you. While writing the book, I had two simple goals: (1) Master the Basics and (2) Ignite Learning. There…

SQL SERVER – Data Collector Usage – Quiz – Puzzle – 29 of 31

January 30, 2012

Pinal Dave

SQL, SQL Interview Questions and Answers, SQL Puzzle, SQL Server, SQL Tips and Tricks

Click here to get free chapters (PDF) in the mailbox Year 2011 was a year of learning and opportunity for me. My recent book, SQL Server Interview Questions and Answers, has received such overwhelming love and support from all of you. While writing the book, I had two simple goals: (1) Master the Basics and (2) Ignite Learning. There…