Technology « SQL Server Journey with SQL Authority

Archive for the ‘Technology’ Category

SQL SERVER – Convert Subquery to CTE – SQL in Sixty Seconds #001 – Video

Posted in Database, Pinal Dave, PostADay, SQL, SQL Authority, SQL in Sixty Seconds, SQL Scripts, SQL Server, SQL Tips and Tricks, SQLServer, T SQL, Video on February 8, 2012 | 9 Comments »

SQL Server is an ocean of information. I believe if one starts learning today, after 60 years he/she may still be learning the subject (there are always a few exceptions)! Recently, I published the SQL Server Questions and Answers video tutorial, and since the course came out, I have been receiving lots of request to [...]

Read Full Post »

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

Posted in Pinal Dave, PostADay, SQL, SQL Authority, SQL Error Messages, SQL Query, SQL Server, SQL Tips and Tricks, T SQL, Technology on February 7, 2012 | 8 Comments »

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 have finished installing them. Later [...]

Read Full Post »

SQL SERVER – ERROR: FIX – Database diagram support objects cannot be installed because this database does not have a valid owner

Posted in PostADay, SQL, SQL Authority, SQL Error Messages, SQL Query, SQL Server, SQL Tips and Tricks, T SQL on February 6, 2012 | Leave a Comment »

Recently one of my friend sent me email that he is having some problem with his very small database. We talked for few minutes and we agreed that to further investigation I will need access to the whole database. As the database was very big he dropped it in common location (you can use livemesh [...]

Read Full Post »

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

Posted in PostADay, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, SQL White Papers, SQLAuthority News, T SQL, Technology on February 5, 2012 | 1 Comment »

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 decision makers, system architects, infrastructure [...]

Read Full Post »

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

Posted in PostADay, SQL, SQL Authority, SQL DMV, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, T SQL, Technology on February 4, 2012 | 1 Comment »

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. [...]

Read Full Post »

Older Posts »