Topic: SQL Authority
New with Topic: SQL Authority
pinaldave posted a blog entry
SQL SERVER – Business Intelligence – Aligning Business Metrics
Today, executive management and managers need the latest information to drive intelligent decisions for business success. More...
Today, executive management and managers need the latest information to drive intelligent decisions for business success. More...
10 hours ago
Journey to SQL Authority with Pinal Dave
| Topics: Business..., Data..., Pinal Dave, SQL
Journey to SQL Authority with Pinal Dave
| Topics: Business..., Data..., Pinal Dave, SQLpinaldave posted a blog entry
SQL SERVER – Fix : Error : Invalid object name ’sys.configurations’. (Microsoft SQL Server, Error: 208)
As you all know that SQL Azure CTP has been released; here, I have included a step-by-step guide for how to configure the CTP:...
As you all know that SQL Azure CTP has been released; here, I have included a step-by-step guide for how to configure the CTP:...
1 day ago
Journey to SQL Authority with Pinal Dave
| Topics: Pinal Dave, SQL, SQL Authority, SQL Error...
Journey to SQL Authority with Pinal Dave
| Topics: Pinal Dave, SQL, SQL Authority, SQL Error...pinaldave posted a blog entry
SQL Server – White Paper – An Introduction to Fast Track Data Warehouse Architectures by Erik Veerman
The performance and stability of any application solution—whether line of business, transactional, or business intelligence...
The performance and stability of any application solution—whether line of business, transactional, or business intelligence...
pinaldave posted a blog entry
SQL SERVER – White Papers – Consolidation Guidance for SQL Server – Consolidation Using SQL Server 2008
What are the considerations when creating a consolidation plan for my environment?What are the key differentiators among the...
What are the considerations when creating a consolidation plan for my environment?What are the key differentiators among the...
3 days ago
Journey to SQL Authority with Pinal Dave
| Topics: Database, Pinal Dave, SQL, SQL Authority
Journey to SQL Authority with Pinal Dave
| Topics: Database, Pinal Dave, SQL, SQL Authoritypinaldave posted a blog entry
SQLAuthority News – Notes from TechDays 2009 at Infosys, Bangalore
I recently had opportunity to attend TechDays 2009 Infosys. This event was the largest technology conference by Microsoft in...
I recently had opportunity to attend TechDays 2009 Infosys. This event was the largest technology conference by Microsoft in...
pinaldave posted a blog entry
SQL SERVER – 2008 Star Join Query Optimization
Business Intelligence (BI) plays a significant role in businesses nowadays. Moreover, the databases that deal with the queries...
Business Intelligence (BI) plays a significant role in businesses nowadays. Moreover, the databases that deal with the queries...
5 days ago
Journey to SQL Authority with Pinal Dave
| Topics: Best..., Business..., Data..., Pinal Dave
Journey to SQL Authority with Pinal Dave
| Topics: Best..., Business..., Data..., Pinal Davepinaldave posted a blog entry
SQLAuthority News – Airline Review – Paramount, Kingfisher, Go Air, Indigo, Jet Airways, Indian Airlines, Spicejet
First of all, this is a totally different article that I have ever written on this site. As the regular readers of my blog are...
First of all, this is a totally different article that I have ever written on this site. As the regular readers of my blog are...
6 days ago
Journey to SQL Authority with Pinal Dave
| Topics: About Me, Pinal Dave, SQL, SQL Authority
Journey to SQL Authority with Pinal Dave
| Topics: About Me, Pinal Dave, SQL, SQL Authoritypinaldave posted a blog entry
SQL SERVER – Validate an XML document in TSQL using XSD by Jacob Sebastian
Following article is sent by SQL Server MVP Jacob Sebastian on request to provide solution for validating XML document.XML...
Following article is sent by SQL Server MVP Jacob Sebastian on request to provide solution for validating XML document.XML...
7 days ago
Journey to SQL Authority with Pinal Dave
| Topics: Pinal Dave, SQL, SQL Authority, SQL Query
Journey to SQL Authority with Pinal Dave
| Topics: Pinal Dave, SQL, SQL Authority, SQL Querypinaldave posted a blog entry
SQLAuthority News – A Daily Doze of Technology – Alvin Ashcraft’s Morning Dew
A common question that I receive is regarding how I keep myself updated with latest information about technology and what is...
A common question that I receive is regarding how I keep myself updated with latest information about technology and what is...
8 days ago
Journey to SQL Authority with Pinal Dave
| Topics: SQL, SQL Authority, SQL Query, SQL Server
Journey to SQL Authority with Pinal Dave
| Topics: SQL, SQL Authority, SQL Query, SQL Serverpinaldave posted a blog entry
SQL SERVER – Size of Index Table for Each Index – Solution
Earlier I have posted small question on this blog and requested help from readers to participate here and provide solution....
Earlier I have posted small question on this blog and requested help from readers to participate here and provide solution....
9 days ago
Journey to SQL Authority with Pinal Dave
| Topics: Pinal Dave, Readers..., Readers..., SQL
Journey to SQL Authority with Pinal Dave
| Topics: Pinal Dave, Readers..., Readers..., SQLpinaldave posted a blog entry
SQLAuthority News – SQL Server R2 Resources Downloads, Documentations
Microsoft SQL Server 2008 R2 November Community Technology PreviewBuilding on SQL Server 2008, R2 provides an even more...
Microsoft SQL Server 2008 R2 November Community Technology PreviewBuilding on SQL Server 2008, R2 provides an even more...
pinaldave posted a blog entry
SQLAuthority News – Subscribe to Blog – Search a Blog
Quite often I get request if I send blog post in newsletter or through email. Here are few important links.You can for sure...
Quite often I get request if I send blog post in newsletter or through email. Here are few important links.You can for sure...
12 days ago
Journey to SQL Authority with Pinal Dave
| Topics: About Me, Pinal Dave, SQL, SQL Authority
Journey to SQL Authority with Pinal Dave
| Topics: About Me, Pinal Dave, SQL, SQL Authoritypinaldave posted a blog entry
SQLAuthority News – SQL Server 2008 Analysis Services Performance Guide
Because Microsoft SQL Server Analysis Services query and processing performance tuning is a fairly broad subject, this white...
Because Microsoft SQL Server Analysis Services query and processing performance tuning is a fairly broad subject, this white...
13 days ago
Journey to SQL Authority with Pinal Dave
| Topics: Business..., SQL, SQL Authority, SQL...
Journey to SQL Authority with Pinal Dave
| Topics: Business..., SQL, SQL Authority, SQL...pinaldave posted a blog entry
SQL SERVER – Comma Separated Values (CSV) from Table Column
I use following script very often and I realized that I have never shared this script on this blog before. Creating Comma...
I use following script very often and I realized that I have never shared this script on this blog before. Creating Comma...
14 days ago
Journey to SQL Authority with Pinal Dave
| Topics: Best..., Pinal Dave, SQL, SQL Authority
Journey to SQL Authority with Pinal Dave
| Topics: Best..., Pinal Dave, SQL, SQL Authoritypinaldave posted a blog entry
SQL SERVER – Interesting Observation – TOP 100 PERCENT and ORDER BY
Today we will go over a very simple, but interesting subject. The following error is quite common if you use ORDER BY while...
Today we will go over a very simple, but interesting subject. The following error is quite common if you use ORDER BY while...
15 days ago
Journey to SQL Authority with Pinal Dave
| Topics: Pinal Dave, SQL, SQL Authority, SQL Query
Journey to SQL Authority with Pinal Dave
| Topics: Pinal Dave, SQL, SQL Authority, SQL Querypinaldave posted a blog entry
SQL SERVER – A Common Design Problem – Should the Primary Key Always be a Clustered Index
In SQL Server, whenever we create any key, a Primary Key automatically creates clustered index on the same. I like this feature...
In SQL Server, whenever we create any key, a Primary Key automatically creates clustered index on the same. I like this feature...
16 days ago
Journey to SQL Authority with Pinal Dave
| Topics: Pinal Dave, SQL, SQL Authority, SQL Constraint and...
Journey to SQL Authority with Pinal Dave
| Topics: Pinal Dave, SQL, SQL Authority, SQL Constraint and...pinaldave posted a blog entry
SQL SERVER – Remove Bookmark Key Lookup – 4 Different Ideas
I quite often get request to summarized my ideas about Removing bookmark lookup on this blog post. Bookmark lookup or key...
I quite often get request to summarized my ideas about Removing bookmark lookup on this blog post. Bookmark lookup or key...
17 days ago
Journey to SQL Authority with Pinal Dave
| Topics: Pinal Dave, SQL, SQL Authority, SQL Index
Journey to SQL Authority with Pinal Dave
| Topics: Pinal Dave, SQL, SQL Authority, SQL Indexpinaldave posted a blog entry
SQLAuthority News – SQL Server 2008 for Oracle DBA
This 15 modules, level 300 course provides students with the knowledge and skills to capitalize on their skills and experience...
This 15 modules, level 300 course provides students with the knowledge and skills to capitalize on their skills and experience...
pinaldave posted a blog entry
SQLAuthority News – Book Review – Expert SQL Server 2008 Encryption by Michael Coles
Expert SQL Server 2008 Encryption (Paperback)Michael Coles (Author), Rodney Landrum (Author)Link to Amazon“What is your...
Expert SQL Server 2008 Encryption (Paperback)Michael Coles (Author), Rodney Landrum (Author)Link to Amazon“What is your...
19 days ago
Journey to SQL Authority with Pinal Dave
| Topics: Pinal Dave, SQL, SQL Authority, SQL Query
Journey to SQL Authority with Pinal Dave
| Topics: Pinal Dave, SQL, SQL Authority, SQL Querypinaldave posted a blog entry
SQL SERVER – Understanding Table Hints with Examples
IntroductionToday we have a very interesting subject to look at. I tried to look for help online but have not found any other...
IntroductionToday we have a very interesting subject to look at. I tried to look for help online but have not found any other...
20 days ago
Journey to SQL Authority with Pinal Dave
| Topics: Pinal Dave, SQL, SQL Authority, SQL Joins
Journey to SQL Authority with Pinal Dave
| Topics: Pinal Dave, SQL, SQL Authority, SQL Joinspinaldave posted a blog entry
SQL SERVER – Size of Index Table – A Puzzle to Find Index Size for Each Index on Table
It is very easy to find out some basic details of any table using the following Stored Procedure.USE AdventureWorksGOEXEC...
It is very easy to find out some basic details of any table using the following Stored Procedure.USE AdventureWorksGOEXEC...
21 days ago
Journey to SQL Authority with Pinal Dave
| Topics: Pinal Dave, Readers..., SQL, SQL Authority
Journey to SQL Authority with Pinal Dave
| Topics: Pinal Dave, Readers..., SQL, SQL Authoritypinaldave posted a blog entry
SQL SERVER – 2005 2008 – Backup, Integrity Check and Index Optimization By Ola Hallengren
Script of Backup, Integrity Check and Index Optimization are the most important scripts for any developer. SQL Expert and true...
Script of Backup, Integrity Check and Index Optimization are the most important scripts for any developer. SQL Expert and true...
22 days ago
Journey to SQL Authority with Pinal Dave
| Topics: Pinal Dave, SQL, SQL Authority, SQL...
Journey to SQL Authority with Pinal Dave
| Topics: Pinal Dave, SQL, SQL Authority, SQL...pinaldave posted a blog entry
SQLAuthority News – Notes of Excellent Experience at SQL PASS 2009 Summit, Seattle
Update: Do not forget to checkout last three photos and follow me on twitter (of course!)I have previously documented my...
Update: Do not forget to checkout last three photos and follow me on twitter (of course!)I have previously documented my...
pinaldave posted a blog entry
SQL SERVER – Whitepaper Consolidation Using SQL Server 2008
Many companies are considering or have already implemented consolidation of computing resources, including Microsoft SQL Server...
Many companies are considering or have already implemented consolidation of computing resources, including Microsoft SQL Server...
24 days ago
Journey to SQL Authority with Pinal Dave
| Topics: SQL, SQL Authority, SQL Query, SQL Server
Journey to SQL Authority with Pinal Dave
| Topics: SQL, SQL Authority, SQL Query, SQL Serverpinaldave posted a blog entry
SQLAuthority News – Disk Partition Alignment Best Practices for SQL Server
Disk partition alignment is a powerful tool for improving SQL Server performance. Configuring optimal disk performance is often...
Disk partition alignment is a powerful tool for improving SQL Server performance. Configuring optimal disk performance is often...
25 days ago
Journey to SQL Authority with Pinal Dave
| Topics: Best..., SQL, SQL Authority, SQL Query
Journey to SQL Authority with Pinal Dave
| Topics: Best..., SQL, SQL Authority, SQL Querypinaldave posted a blog entry
SQL SERVER – Policy Based Management – Create, Evaluate and Fix Policies
IntroductionThis article will cover the most spectacular feature of SQL 2008 – Policy-based management and how the...
IntroductionThis article will cover the most spectacular feature of SQL 2008 – Policy-based management and how the...
26 days ago
Journey to SQL Authority with Pinal Dave
| Topics: Database, Pinal Dave, SQL, SQL Authority
Journey to SQL Authority with Pinal Dave
| Topics: Database, Pinal Dave, SQL, SQL Authoritypinaldave posted a blog entry
SQL SERVER – Disable CHECK Constraint – Enable CHECK Constraint
Foreign Key and Check Constraints are two types of constraints that can be disabled or enabled when required. This type of...
Foreign Key and Check Constraints are two types of constraints that can be disabled or enabled when required. This type of...
27 days ago
Journey to SQL Authority with Pinal Dave
| Topics: Pinal Dave, SQL, SQL Authority, SQL Constraint and...
Journey to SQL Authority with Pinal Dave
| Topics: Pinal Dave, SQL, SQL Authority, SQL Constraint and...pinaldave posted a blog entry
SQL SERVER – Sharepoint Resource Available for SQL Server
Here is quick list of the tools which are available for SQL Server and Sharepoint. These are recently updated resources from...
Here is quick list of the tools which are available for SQL Server and Sharepoint. These are recently updated resources from...
28 days ago
Journey to SQL Authority with Pinal Dave
| Topics: SQL, SQL Authority, SQL..., SQL Query
Journey to SQL Authority with Pinal Dave
| Topics: SQL, SQL Authority, SQL..., SQL Querypinaldave posted a blog entry
SQL Authority News – Training MS SQL Server 2005/2008 Query Optimization And Performance Tuning
This is very short note announcing details about my course details for ‘MS SQL Server 2005/2008 Query Optimization And...
This is very short note announcing details about my course details for ‘MS SQL Server 2005/2008 Query Optimization And...
29 days ago
Journey to SQL Authority with Pinal Dave
| Topics: Pinal Dave, SQL, SQL Authority, SQL Index
Journey to SQL Authority with Pinal Dave
| Topics: Pinal Dave, SQL, SQL Authority, SQL Indexpinaldave posted a blog entry
SQL SERVER – Removing Key Lookup – Seek Predicate – Predicate – An Interesting Observation Related to Datatypes
Recently, I have been working on Query Optimization project. While working on it, I found the following interesting...
Recently, I have been working on Query Optimization project. While working on it, I found the following interesting...
30 days ago
Journey to SQL Authority with Pinal Dave
| Topics: Pinal Dave, SQL, SQL Authority, SQL Index
Journey to SQL Authority with Pinal Dave
| Topics: Pinal Dave, SQL, SQL Authority, SQL Indexpinaldave posted a blog entry
SQL SERVER – Stored Procedure are Compiled on First Run – SP taking Longer to Run First Time
During the PASS summit, one of the attendees asked me the following question.Why the Stored Procedure takes long time to run...
During the PASS summit, one of the attendees asked me the following question.Why the Stored Procedure takes long time to run...
31 days ago
Journey to SQL Authority with Pinal Dave
| Topics: Pinal Dave, SQL, SQL Authority, SQL Interview Questions and...
Journey to SQL Authority with Pinal Dave
| Topics: Pinal Dave, SQL, SQL Authority, SQL Interview Questions and...pinaldave posted a blog entry
SQLAuthority News – Data Compression Strategy Capacity Planning and Best Practices
The data compression feature in SQL Server 2008 helps compress the data inside a database, and it can help reduce the size of...
The data compression feature in SQL Server 2008 helps compress the data inside a database, and it can help reduce the size of...
32 days ago
Journey to SQL Authority with Pinal Dave
| Topics: Pinal Dave, SQL, SQL Authority, SQL Data...
Journey to SQL Authority with Pinal Dave
| Topics: Pinal Dave, SQL, SQL Authority, SQL Data...pinaldave posted a blog entry
SQLAuthority News – SQL PASS Summit, Seattle 2009 – Day 4
Fourth day was awesome. I had scheduled nearly 8 meetings with different groups of people today. It was really really fun. Let...
Fourth day was awesome. I had scheduled nearly 8 meetings with different groups of people today. It was really really fun. Let...
pinaldave posted a blog entry
SQLAuthority News – SQL PASS Summit, Seattle 2009 – Day 3
Third day at SQL PASS Summit was for me education + entertaining day. During last 10 days I was getting up everyday at 4:00...
Third day at SQL PASS Summit was for me education + entertaining day. During last 10 days I was getting up everyday at 4:00...
pinaldave posted a blog entry
SQLAuthority News – SQL PASS Summit, Seattle 2009 – Day 2
The second day of PASS started with very engaging and it started with an original game invented by Stuart Ainsworth. This game...
The second day of PASS started with very engaging and it started with an original game invented by Stuart Ainsworth. This game...
pinaldave posted a blog entry
SQLAuthority News – SQL PASS Summit, Seattle 2009 – Day 1
Day 1 at PASS was awesome. I have decided to cover this event little bit differently and with lots of images. In day 1 only I...
Day 1 at PASS was awesome. I have decided to cover this event little bit differently and with lots of images. In day 1 only I...
pinaldave posted a blog entry
SQLAuthority News – 3 Year Old Blog – PASS Summit 2009 – 10.5 Million Views
This blog has reached a remarkable milestone. It is 3 years old today. So far, there have been more than 10.5 million views on...
This blog has reached a remarkable milestone. It is 3 years old today. So far, there have been more than 10.5 million views on...
37 days ago
Journey to SQL Authority with Pinal Dave
| Topics: Pinal Dave, SQL, SQL Authority, SQL Query
Journey to SQL Authority with Pinal Dave
| Topics: Pinal Dave, SQL, SQL Authority, SQL Querypinaldave posted a blog entry
SQL Authority News – Advanced T-SQL with Itzik Ben-Gan – Solid Quality Mentors
As mentioned earlier in a blog post SQL SERVER – Advanced T-SQL with Itzik Ben-Gan – A Dream Coming True, I got the...
As mentioned earlier in a blog post SQL SERVER – Advanced T-SQL with Itzik Ben-Gan – A Dream Coming True, I got the...
pinaldave posted a blog entry
SQLAuthority News – New PASS President Rushabh Mehta
The Professional Association for SQL Server (PASS) is an independent, not-for-profit association, dedicated to supporting,...
The Professional Association for SQL Server (PASS) is an independent, not-for-profit association, dedicated to supporting,...
pinaldave posted a blog entry
SQLAuthority News – India Market and Third Party SQL Server Tools
Last week, I had wonderful time attending meeting of small ISV (Independent Software Vendors). Several topics were discussed,...
Last week, I had wonderful time attending meeting of small ISV (Independent Software Vendors). Several topics were discussed,...
40 days ago
Journey to SQL Authority with Pinal Dave
| Topics: Pinal Dave, SQL, SQL Authority, SQL Query
Journey to SQL Authority with Pinal Dave
| Topics: Pinal Dave, SQL, SQL Authority, SQL Querypinaldave posted a blog entry
SQLAuthority News – Birds-of-a-Feather (BOF) Lunch – SQL PASS Summit, Seattle, 2009
I received few emails regarding where can people meet me at SQL PASS event in Seattle. I am currently in Bellevue attending...
I received few emails regarding where can people meet me at SQL PASS event in Seattle. I am currently in Bellevue attending...
pinaldave posted a blog entry
SQL SERVER – Tuning the Performance of Change Data Capture in SQL Server 2008
Change data capture (CDC) is a new feature in SQL Server 2008 designed to capture insert, update, merge, and delete activities...
Change data capture (CDC) is a new feature in SQL Server 2008 designed to capture insert, update, merge, and delete activities...
pinaldave posted a blog entry
SQL SERVER – How to Enable Index – How to Disable Index – Incorrect syntax near ‘ENABLE’
Many times I have seen that the index is disabled when there is large update operation on the table. Bulk insert of very large...
Many times I have seen that the index is disabled when there is large update operation on the table. Bulk insert of very large...
43 days ago
Journey to SQL Authority with Pinal Dave
| Topics: Pinal Dave, SQL, SQL Authority, SQL Index
Journey to SQL Authority with Pinal Dave
| Topics: Pinal Dave, SQL, SQL Authority, SQL Indexpinaldave posted a blog entry
SQL SERVER – Advanced T-SQL with Itzik Ben-Gan – A Dream Coming True
As from my blog posts, all of you are probably aware that I am very much excited for attending SQL PASS at Seattle from Nov 1,...
As from my blog posts, all of you are probably aware that I am very much excited for attending SQL PASS at Seattle from Nov 1,...
44 days ago
Journey to SQL Authority with Pinal Dave
| Topics: About Me, Pinal Dave, SQL, SQL Authority
Journey to SQL Authority with Pinal Dave
| Topics: About Me, Pinal Dave, SQL, SQL Authoritypinaldave posted a blog entry
SQL SERVER – Link to SQL Server Book Online – BOL
Do you keep following Book Online Links handy? I do and I use them a lot.SQL Server 2008 R2SQL Server 2008 SQL Server...
Do you keep following Book Online Links handy? I do and I use them a lot.SQL Server 2008 R2SQL Server 2008 SQL Server...
46 days ago
Journey to SQL Authority with Pinal Dave
| Topics: SQL, SQL Authority, SQL BOL, SQL Query
Journey to SQL Authority with Pinal Dave
| Topics: SQL, SQL Authority, SQL BOL, SQL Querypinaldave posted a blog entry
SQLAuthority News – PASS Sessions – I will be there!
As PASS is now one week away and I am all excited for the same. I am going to attend following two sessions for sure. I...
As PASS is now one week away and I am all excited for the same. I am going to attend following two sessions for sure. I...
pinaldave posted a blog entry
SQL SERVER – Difference Between Candidate Keys and Primary Key
IntroductionNot long ago, I had an interesting and extended debate with one of my friends regarding which column should be...
IntroductionNot long ago, I had an interesting and extended debate with one of my friends regarding which column should be...
48 days ago
Journey to SQL Authority with Pinal Dave
| Topics: Pinal Dave, SQL, SQL Authority, SQL Constraint and...
Journey to SQL Authority with Pinal Dave
| Topics: Pinal Dave, SQL, SQL Authority, SQL Constraint and...pinaldave posted a blog entry
SQL SERVER – Introduction to Business Intelligence – Important Terms & Definitions
What is Business IntelligenceBusiness intelligence (BI) is a broad category of application programs and technologies for...
What is Business IntelligenceBusiness intelligence (BI) is a broad category of application programs and technologies for...
49 days ago
Journey to SQL Authority with Pinal Dave
| Topics: Business..., Data..., Pinal Dave, SQL
Journey to SQL Authority with Pinal Dave
| Topics: Business..., Data..., Pinal Dave, SQLpinaldave posted a blog entry
SQLAuthority News – PASS 2009 Sessions on Query Optimization and Performance Tuning
PASS Summit 2009 is now only 10 days away and I am very excited for the same. I can not wait to attend the summit as this is...
PASS Summit 2009 is now only 10 days away and I am very excited for the same. I can not wait to attend the summit as this is...
pinaldave posted a blog entry
SQL SERVER – Change Collation of Database Column – T-SQL Script – Consolidating Collations – Extention Script
This document is created by Brian Cidern, he has written this excellent extension to SQL Expert who SQL SERVER – Change...
This document is created by Brian Cidern, he has written this excellent extension to SQL Expert who SQL SERVER – Change...
51 days ago
Journey to SQL Authority with Pinal Dave
| Topics: Readers..., Readers..., SQL, SQL Authority
Journey to SQL Authority with Pinal Dave
| Topics: Readers..., Readers..., SQL, SQL Authority