Pages

Wednesday, July 31, 2013

SQL SERVER – FIX : ERROR : 4214 BACKUP LOG cannot be performed because there is no current database backup | Journey to SQL Authority with Pinal Dave

SQL, SQL Server, MySQL, Big Data and NoSQL (by Pinal Dave) Continue Reading...

Source: SQL SERVER – FIX : ERROR : 4214 BACKUP LOG cannot be performed because there is no current database backup | Journey to SQL Authority with Pinal Dave

SQLAuthority News – Author Visit to Nepal TechMela – 2 Technical Sessions | Journey to SQL Authority with Pinal Dave

SQL, SQL Server, MySQL, Big Data and NoSQL (by Pinal Dave) Continue Reading...

Source: SQLAuthority News – Author Visit to Nepal TechMela – 2 Technical Sessions | Journey to SQL Authority with Pinal Dave

SQL SERVER – Introduction to Extended Events – Finding Long Running Queries | Journey to SQL Authority with Pinal Dave

SQL, SQL Server, MySQL, Big Data and NoSQL (by Pinal Dave) Continue Reading...

Source: SQL SERVER – Introduction to Extended Events – Finding Long Running Queries | Journey to SQL Authority with Pinal Dave

SQL SERVER – World Shapefile Download and Upload to Database – Spatial Database | Journey to SQL Authority with Pinal Dave

SQL, SQL Server, MySQL, Big Data and NoSQL (by Pinal Dave) Continue Reading...

Source: SQL SERVER – World Shapefile Download and Upload to Database – Spatial Database | Journey to SQL Authority with Pinal Dave

SQLAuthority News – SQL Server Cheat Sheet from MidnightDBA | Journey to SQL Authority with Pinal Dave

SQL, SQL Server, MySQL, Big Data and NoSQL (by Pinal Dave) Continue Reading...

Source: SQLAuthority News – SQL Server Cheat Sheet from MidnightDBA | Journey to SQL Authority with Pinal Dave

SQLAuthority News – MS Access Database is the Way to Go – April 1st Humor | Journey to SQL Authority with Pinal Dave

SQL, SQL Server, MySQL, Big Data and NoSQL (by Pinal Dave) Continue Reading...

Source: SQLAuthority News – MS Access Database is the Way to Go – April 1st Humor | Journey to SQL Authority with Pinal Dave

SQL SERVER – Simple Installation of Master Data Services (MDS) and Sample Packages – Very Easy | Journey to SQL Authority with Pinal Dave

SQL, SQL Server, MySQL, Big Data and NoSQL (by Pinal Dave) Continue Reading...

Source: SQL SERVER – Simple Installation of Master Data Services (MDS) and Sample Packages – Very Easy | Journey to SQL Authority with Pinal Dave

SQL SERVER – Difference Between GRANT and WITH GRANT | Journey to SQL Authority with Pinal Dave

SQL, SQL Server, MySQL, Big Data and NoSQL (by Pinal Dave) Continue Reading...

Source: SQL SERVER – Difference Between GRANT and WITH GRANT | Journey to SQL Authority with Pinal Dave

SQL SERVER – Enable Identity Insert – Import Expert Wizard | Journey to SQL Authority with Pinal Dave

SQL, SQL Server, MySQL, Big Data and NoSQL (by Pinal Dave) Continue Reading...

Source: SQL SERVER – Enable Identity Insert – Import Expert Wizard | Journey to SQL Authority with Pinal Dave

SQL SERVER – 2008 – Introduction to Snapshot Database – Restore From Snapshot | Journey to SQL Authority with Pinal Dave

SQL, SQL Server, MySQL, Big Data and NoSQL (by Pinal Dave) Continue Reading...

Source: SQL SERVER – 2008 – Introduction to Snapshot Database – Restore From Snapshot | Journey to SQL Authority with Pinal Dave

SQL SERVER – Retrieve and Explore Database Backup without Restoring Database – Idera virtual database | Journey to SQL Authority with Pinal Dave

SQL, SQL Server, MySQL, Big Data and NoSQL (by Pinal Dave) Continue Reading...

Source: SQL SERVER – Retrieve and Explore Database Backup without Restoring Database – Idera virtual database | Journey to SQL Authority with Pinal Dave

SQLAuthority News – Milestone of 1300th Post and A Few Updates | Journey to SQL Authority with Pinal Dave

SQL, SQL Server, MySQL, Big Data and NoSQL (by Pinal Dave) Continue Reading...

Source: SQLAuthority News – Milestone of 1300th Post and A Few Updates | Journey to SQL Authority with Pinal Dave

SQLAuthority News – Author Visit Review – TechMela Nepal – March 29-30, 2010 | Journey to SQL Authority with Pinal Dave

SQL, SQL Server, MySQL, Big Data and NoSQL (by Pinal Dave) Continue Reading...

Source: SQLAuthority News – Author Visit Review – TechMela Nepal – March 29-30, 2010 | Journey to SQL Authority with Pinal Dave

SQLAuthority News – Meeting with Allen Bailochan Tuladhar – An Unlimited Experience | Journey to SQL Authority with Pinal Dave

SQL, SQL Server, MySQL, Big Data and NoSQL (by Pinal Dave) Continue Reading...

Source: SQLAuthority News – Meeting with Allen Bailochan Tuladhar – An Unlimited Experience | Journey to SQL Authority with Pinal Dave

SQLAuthority News – Speaking Sessions at TechEd India – 3 Sessions – 1 Panel Discussion | Journey to SQL Authority with Pinal Dave

SQL, SQL Server, MySQL, Big Data and NoSQL (by Pinal Dave) Continue Reading...

Source: SQLAuthority News – Speaking Sessions at TechEd India – 3 Sessions – 1 Panel Discussion | Journey to SQL Authority with Pinal Dave

Tuesday, July 30, 2013

SQLAuthority News – Spot the SQLAuthority Baby Contest – SQL Server Cheat Sheet | Journey to SQL Authority with Pinal Dave

SQL, SQL Server, MySQL, Big Data and NoSQL (by Pinal Dave) Continue Reading...

Source: SQLAuthority News – Spot the SQLAuthority Baby Contest – SQL Server Cheat Sheet | Journey to SQL Authority with Pinal Dave

SQL SERVER – What is MDS? – Master Data Services in Microsoft SQL Server 2008 R2 | Journey to SQL Authority with Pinal Dave

SQL, SQL Server, MySQL, Big Data and NoSQL (by Pinal Dave) Continue Reading...

Source: SQL SERVER – What is MDS? – Master Data Services in Microsoft SQL Server 2008 R2 | Journey to SQL Authority with Pinal Dave

SQLAuthority News – Three Posts on Reporting – T-SQL Tuesday #005 | Journey to SQL Authority with Pinal Dave

SQL, SQL Server, MySQL, Big Data and NoSQL (by Pinal Dave) Continue Reading...

Source: SQLAuthority News – Three Posts on Reporting – T-SQL Tuesday #005 | Journey to SQL Authority with Pinal Dave

SQL SERVER – Configure Management Data Collection in Quick Steps – T-SQL Tuesday #005 | Journey to SQL Authority with Pinal Dave

SQL, SQL Server, MySQL, Big Data and NoSQL (by Pinal Dave) Continue Reading...

Source: SQL SERVER – Configure Management Data Collection in Quick Steps – T-SQL Tuesday #005 | Journey to SQL Authority with Pinal Dave

SQL SERVER – What is Spatial Database? – Developing with SQL Server Spatial and Deep Dive into Spatial Indexing | Journey to SQL Authority with Pinal Dave

SQL, SQL Server, MySQL, Big Data and NoSQL (by Pinal Dave) Continue Reading...

Source: SQL SERVER – What is Spatial Database? – Developing with SQL Server Spatial and Deep Dive into Spatial Indexing | Journey to SQL Authority with Pinal Dave

SQLAuthority News – Tips for Traveling to Nepal | Journey to SQL Authority with Pinal Dave

SQL, SQL Server, MySQL, Big Data and NoSQL (by Pinal Dave) Continue Reading...

Source: SQLAuthority News – Tips for Traveling to Nepal | Journey to SQL Authority with Pinal Dave

SQLAuthority News – Best Complements – DBA Survivor: Become a Rock Star DBA | Journey to SQL Authority with Pinal Dave

SQL, SQL Server, MySQL, Big Data and NoSQL (by Pinal Dave) Continue Reading...

Source: SQLAuthority News – Best Complements – DBA Survivor: Become a Rock Star DBA | Journey to SQL Authority with Pinal Dave

SQL SERVER – SELECT TOP Shortcut in SQL Server Management Studio (SSMS) | Journey to SQL Authority with Pinal Dave

SQL, SQL Server, MySQL, Big Data and NoSQL (by Pinal Dave) Continue Reading...

Source: SQL SERVER – SELECT TOP Shortcut in SQL Server Management Studio (SSMS) | Journey to SQL Authority with Pinal Dave

SQLAuthority News – Free eBook Download – Introducing Microsoft SQL Server 2008 R2 | Journey to SQL Authority with Pinal Dave

SQL, SQL Server, MySQL, Big Data and NoSQL (by Pinal Dave) Continue Reading...

Source: SQLAuthority News – Free eBook Download – Introducing Microsoft SQL Server 2008 R2 | Journey to SQL Authority with Pinal Dave

SQL SERVER – Find Most Active Database in SQL Server – DMV dm_io_virtual_file_stats | Journey to SQL Authority with Pinal Dave

SQL, SQL Server, MySQL, Big Data and NoSQL (by Pinal Dave) Continue Reading...

Source: SQL SERVER – Find Most Active Database in SQL Server – DMV dm_io_virtual_file_stats | Journey to SQL Authority with Pinal Dave

SQL SERVER – Find Max Worker Count using DMV – 32 Bit and 64 Bit | Journey to SQL Authority with Pinal Dave

SQL, SQL Server, MySQL, Big Data and NoSQL (by Pinal Dave) Continue Reading...

Source: SQL SERVER – Find Max Worker Count using DMV – 32 Bit and 64 Bit | Journey to SQL Authority with Pinal Dave

SQL SERVER – When are Statistics Updated – What triggers Statistics to Update | Journey to SQL Authority with Pinal Dave

SQL, SQL Server, MySQL, Big Data and NoSQL (by Pinal Dave) Continue Reading...

Source: SQL SERVER – When are Statistics Updated – What triggers Statistics to Update | Journey to SQL Authority with Pinal Dave

SQL SERVER – Create Primary Key with Specific Name when Creating Table | Journey to SQL Authority with Pinal Dave

SQL, SQL Server, MySQL, Big Data and NoSQL (by Pinal Dave) Continue Reading...

Source: SQL SERVER – Create Primary Key with Specific Name when Creating Table | Journey to SQL Authority with Pinal Dave

SQL SERVER – Update Statistics are Sampled By Default | Journey to SQL Authority with Pinal Dave

SQL, SQL Server, MySQL, Big Data and NoSQL (by Pinal Dave) Continue Reading...

Source: SQL SERVER – Update Statistics are Sampled By Default | Journey to SQL Authority with Pinal Dave

SQL SERVER – T-SQL Script to Take Database Offline – Take Database Online | Journey to SQL Authority with Pinal Dave

SQL, SQL Server, MySQL, Big Data and NoSQL (by Pinal Dave) Continue Reading...

Source: SQL SERVER – T-SQL Script to Take Database Offline – Take Database Online | Journey to SQL Authority with Pinal Dave

SQLAuthority News – Free Download – Microsoft SQL Server 2008 R2 RTM – Express with Management Tools – SQL Server 2008 R2 Books Online | Journey to SQL Authority with Pinal Dave

SQL, SQL Server, MySQL, Big Data and NoSQL (by Pinal Dave) Continue Reading...

Source: SQLAuthority News – Free Download – Microsoft SQL Server 2008 R2 RTM – Express with Management Tools – SQL Server 2008 R2 Books Online | Journey to SQL Authority with Pinal Dave

SQL SERVER – Attach mdf file without ldf file in Database | Journey to SQL Authority with Pinal Dave

SQL, SQL Server, MySQL, Big Data and NoSQL (by Pinal Dave) Continue Reading...

Source: SQL SERVER – Attach mdf file without ldf file in Database | Journey to SQL Authority with Pinal Dave

SQLAuthority News – Public Training Classes In Hyderabad 12-14 May – Microsoft SQL Server 2005/2008 Query Optimization & Performance Tuning | Journey to SQL Authority with Pinal Dave

SQL, SQL Server, MySQL, Big Data and NoSQL (by Pinal Dave) Continue Reading...

Source: SQLAuthority News – Public Training Classes In Hyderabad 12-14 May – Microsoft SQL Server 2005/2008 Query Optimization & Performance Tuning | Journey to SQL Authority with Pinal Dave

SQLAuthority News – Public Training Classes In Hyderabad 12-14 May – SQL and 10-11 May SharePoint | Journey to SQL Authority with Pinal Dave

SQL, SQL Server, MySQL, Big Data and NoSQL (by Pinal Dave) Continue Reading...

Source: SQLAuthority News – Public Training Classes In Hyderabad 12-14 May – SQL and 10-11 May SharePoint | Journey to SQL Authority with Pinal Dave

SQL SERVER – GUID vs INT – Your Opinion | Journey to SQL Authority with Pinal Dave

SQL, SQL Server, MySQL, Big Data and NoSQL (by Pinal Dave) Continue Reading...

Source: SQL SERVER – GUID vs INT – Your Opinion | Journey to SQL Authority with Pinal Dave

SQL SERVER – Disable Clustered Index and Data Insert | Journey to SQL Authority with Pinal Dave

SQL, SQL Server, MySQL, Big Data and NoSQL (by Pinal Dave) Continue Reading...

Source: SQL SERVER – Disable Clustered Index and Data Insert | Journey to SQL Authority with Pinal Dave

SQLAuthority News – TechEd India – April 12-14, 2010 Bangalore – An Unforgettable Experience – An Opportunity of A Lifetime | Journey to SQL Authority with Pinal Dave

SQL, SQL Server, MySQL, Big Data and NoSQL (by Pinal Dave) Continue Reading...

Source: SQLAuthority News – TechEd India – April 12-14, 2010 Bangalore – An Unforgettable Experience – An Opportunity of A Lifetime | Journey to SQL Authority with Pinal Dave

SQL SERVER – What is AdventureWorks? | Journey to SQL Authority with Pinal Dave

SQL, SQL Server, MySQL, Big Data and NoSQL (by Pinal Dave) Continue Reading...

Source: SQL SERVER – What is AdventureWorks? | Journey to SQL Authority with Pinal Dave

SQL SERVER – The Difference between Dual Core vs. Core 2 Duo | Journey to SQL Authority with Pinal Dave

SQL, SQL Server, MySQL, Big Data and NoSQL (by Pinal Dave) Continue Reading...

Source: SQL SERVER – The Difference between Dual Core vs. Core 2 Duo | Journey to SQL Authority with Pinal Dave

SQL SERVER – SHRINKFILE and TRUNCATE Log File in SQL Server 2008 | Journey to SQL Authority with Pinal Dave

SQL, SQL Server, MySQL, Big Data and NoSQL (by Pinal Dave) Continue Reading...

Source: SQL SERVER – SHRINKFILE and TRUNCATE Log File in SQL Server 2008 | Journey to SQL Authority with Pinal Dave

SQLAuthority News – Microsoft SQL Server 2005/2008 Query Optimization and Performance Tuning Training | Journey to SQL Authority with Pinal Dave

SQL, SQL Server, MySQL, Big Data and NoSQL (by Pinal Dave) Continue Reading...

Source: SQLAuthority News – Microsoft SQL Server 2005/2008 Query Optimization and Performance Tuning Training | Journey to SQL Authority with Pinal Dave

SQL SERVER – Get Latest SQL Query for Sessions – DMV | Journey to SQL Authority with Pinal Dave

SQL, SQL Server, MySQL, Big Data and NoSQL (by Pinal Dave) Continue Reading...

Source: SQL SERVER – Get Latest SQL Query for Sessions – DMV | Journey to SQL Authority with Pinal Dave

SQLAuthority News – Wireless Router Security and Attached Devices – Complex Password | Journey to SQL Authority with Pinal Dave

SQL, SQL Server, MySQL, Big Data and NoSQL (by Pinal Dave) Continue Reading...

Source: SQLAuthority News – Wireless Router Security and Attached Devices – Complex Password | Journey to SQL Authority with Pinal Dave

SQLAuthority News – SQL Server 2008 R2 Hosted Trial | Journey to SQL Authority with Pinal Dave

SQL, SQL Server, MySQL, Big Data and NoSQL (by Pinal Dave) Continue Reading...

Source: SQLAuthority News – SQL Server 2008 R2 Hosted Trial | Journey to SQL Authority with Pinal Dave

SQLAuthority News – List of Master Data Services White Paper | Journey to SQL Authority with Pinal Dave

SQL, SQL Server, MySQL, Big Data and NoSQL (by Pinal Dave) Continue Reading...

Source: SQLAuthority News – List of Master Data Services White Paper | Journey to SQL Authority with Pinal Dave

SQLAuthority News – MSDN Flash Mentions – TechNet Flash Mention – Top Community Contributors (Annual) Winner | Journey to SQL Authority with Pinal Dave

SQL, SQL Server, MySQL, Big Data and NoSQL (by Pinal Dave) Continue Reading...

Source: SQLAuthority News – MSDN Flash Mentions – TechNet Flash Mention – Top Community Contributors (Annual) Winner | Journey to SQL Authority with Pinal Dave

SQL SERVER – Size of Index Table for Each Index – Solution 2 | Journey to SQL Authority with Pinal Dave

SQL, SQL Server, MySQL, Big Data and NoSQL (by Pinal Dave) Continue Reading...

Source: SQL SERVER – Size of Index Table for Each Index – Solution 2 | Journey to SQL Authority with Pinal Dave

SQL SERVER – Size of Index Table for Each Index – Solution 3 – Powershell | Journey to SQL Authority with Pinal Dave

SQL, SQL Server, MySQL, Big Data and NoSQL (by Pinal Dave) Continue Reading...

Source: SQL SERVER – Size of Index Table for Each Index – Solution 3 – Powershell | Journey to SQL Authority with Pinal Dave

SQL SERVER – Spatial Database Queries – What About BLOB – T-SQL Tuesday #006 | Journey to SQL Authority with Pinal Dave

SQL, SQL Server, MySQL, Big Data and NoSQL (by Pinal Dave) Continue Reading...

Source: SQL SERVER – Spatial Database Queries – What About BLOB – T-SQL Tuesday #006 | Journey to SQL Authority with Pinal Dave

SQL SERVER – Understanding ALTER INDEX ALL REBUILD with Disabled Clustered Index | Journey to SQL Authority with Pinal Dave

SQL, SQL Server, MySQL, Big Data and NoSQL (by Pinal Dave) Continue Reading...

Source: SQL SERVER – Understanding ALTER INDEX ALL REBUILD with Disabled Clustered Index | Journey to SQL Authority with Pinal Dave