All Articles

 

2999 Aug 30, 2014 SQL SERVER – CTRL + R Shortcut Does Not Work in SSMS
2998 Aug 29, 2014 SQL SERVER – Query to Find Seed Values, Increment Values and Current Identity Column Value of the Table with Max Value of Datatype – Part 2
2997 Aug 28, 2014 SQL SERVER – Detecting Corruption with Suspect Pages Table – Notes from the Field #043
2996 Aug 27, 2014 SQL SERVER – Query to Find Seed Values, Increment Values and Current Identity Column Value of the Table with Max Value of Datatype
2995 Aug 26, 2014 SQL SERVER – Fix Error 7202 Could not find server in sys.servers. Verify that the correct server name was specified
2994 Aug 25, 2014 SQL Authority News – Secret Tool Box of Successful Bloggers: 52 Tips to Build a High Traffic Top Ranking Blog
2993 Aug 24, 2014 SQL SERVER – How to See Active SQL Server Connections For Database
2992 Aug 23, 2014 Developer’s Life – Summary of Superhero Articles
2991 Aug 22, 2014 SQL SERVER – How to Force New Cardinality Estimation or Old Cardinality Estimation
2990 Aug 21, 2014 SQL SERVER – Backing Up and Recovering the Tail End of a Transaction Log – Notes from the Field #042
2989 Aug 20, 2014 SQL SERVER – Cardinality Estimation and Performance – SQL in Sixty Seconds #072
2988 Aug 19, 2014 SQL SERVER – Simple Demo of New Cardinality Estimation Features of SQL Server 2014
2987 Aug 18, 2014 SQL SERVER – Learn SQL Server 2014 Online in a Day – My Latest Pluralsight Course
2986 Aug 17, 2014 SQL SERVER – Convert Seconds to Hour : Minute : Seconds Format
2985 Aug 16, 2014 SQL SERVER – Convert Old Syntax of RAISEERROR to THROW
2984 Aug 15, 2014 SQL SERVER – Validating If Date is Last Day of the Year, Month or Day
2983 Aug 14, 2014 SQL SERVER – Script to Find First Day of Current Month
2982 Aug 13, 2014 SQLAuthority News – Live Virtual Classroom New Trend in Technology
2981 Aug 13, 2014 SQL SERVER – ?Finding Out What Changed in a Deleted Database – Notes from the Field #041
2980 Aug 12, 2014 SQL Authority News – FalafelCON 2014: 2 days with the Best Developers in the World
2979 Aug 12, 2014 SQL SERVER – Integrate Your Data with Skyvia – Cloud ETL Solution
2978 Aug 11, 2014 Database – Beginning with Cloud Database As A Service
2977 Aug 11, 2014 SQL SERVER – How to Roll Back SQL Server Database Changes
2976 Aug 10, 2014 SQL Authority News – Download and Install Adventure Works 2014 Sample Databases
2975 Aug 09, 2014 SQL SERVER – Microsoft SQL Server Migration Assistant V6.0 Released
2974 Aug 08, 2014 SQL SERVER – Introduction to SQL Server 2014 In-Memory OLTP
2973 Aug 07, 2014 SQL SERVER – SSIS Parameters in Parent-Child ETL Architectures – Notes from the Field #040
2972 Aug 06, 2014 SQL SERVER – SSMS: Memory Usage By Memory Optimized Objects Report
2971 Aug 05, 2014 SQL SERVER – SSMS: Database Consistency History Report
2970 Aug 04, 2014 SQL SERVER – SSMS: Backup and Restore Events Report
2969 Aug 03, 2014 Developer’s Life – Every Developer is a Captain America
2968 Aug 02, 2014 MySQL – Export the Resultset to CSV file
2967 Aug 01, 2014 SQL SERVER – SSMS: Disk Usage Report
2966 Jul 31, 2014 Developer’s Life – Disaster Lessons – Notes from the Field #039
2965 Jul 30, 2014 SQL Authority News – Play by Play with Pinal Dave – A Birthday Gift
2964 Jul 30, 2014 SQL SERVER – SSMS: Top Object and Batch Execution Statistics Reports
2963 Jul 29, 2014 Developer – Cross-Platform: Fact or Fiction?
2962 Jul 29, 2014 SQL SERVER – SSMS: Top Queries by CPU and IO
2961 Jul 28, 2014 SQL SERVER – SSMS: Top Transaction Reports
2960 Jul 27, 2014 Developer’s Life – Every Developer is the Incredible Hulk
2959 Jul 26, 2014 MySQL – UDF – Validate Integer Function
2958 Jul 25, 2014 SQL SERVER – SSMS: Transaction Log Shipping Status Report
2957 Jul 24, 2014 SQL SERVER – How to Format and Refactor Your SQL Code Directly in SSMS and Visual Studio
2956 Jul 24, 2014 SQL SERVER – Andy Defines Basic RDBMS: Isolation in Processes – Notes from the Field #038
2955 Jul 23, 2014 SQL Authority News – Webinar: SQL Server 2014 In-Memory OLTP and SafePeak In-Memory Caching
2954 Jul 23, 2014 SQL SERVER – Finding Object Dependencies in SSMS – SQL in Sixty Seconds #071
2953 Jul 22, 2014 SQL SERVER – Free Entry to SQLPASS 2014 is Possible
2952 Jul 22, 2014 SQL SERVER – SSMS: Activity – All Blocking Transactions
2951 Jul 21, 2014 SQL SERVER – Activity Reports – Dormant Sessions
2950 Jul 20, 2014 Developer’s Life – Every Developer is a Wonder Woman
2949 Jul 19, 2014 MySQL – How to Format Date in MySQL with DATE_FORMAT()
2948 Jul 18, 2014 SQL SERVER – Free intellisense add-in for SSMS
2947 Jul 17, 2014 SQL SERVER – Beginning Contained Databases – Notes from the Field #037
2946 Jul 16, 2014 SQL SERVER – Difference Between Login and User – SQL in Sixty Seconds #070
2945 Jul 15, 2014 SQL SERVER – SSMS: Memory Consumption Report
2944 Jul 14, 2014 SQL SERVER – SSMS: Scheduler Health Report
2943 Jul 13, 2014 Developer’s Life – Every Developer is a Harry Potter
2942 Jul 12, 2014 MySQL – How INSERT() Function Works for MySQL
2941 Jul 11, 2014 SQL SERVER – What is Biml and How Can it Help Me with SQL Server BI? – Notes from the Field #036
2940 Jul 10, 2014 SQLAuthority News – Two Whitepapers on Performance Tuning and Enhancements
2939 Jul 10, 2014 SQL SERVER – Round Up From Notes from the Field of Blog Posts of Tim Radney
2938 Jul 09, 2014 SQL SERVER – Documentation Tool
2937 Jul 08, 2014 SQL SERVER – Three Top Efficiency Features of Management Tool for SQL Server
2936 Jul 07, 2014 SQL SERVER – SSMS: Schema Change History Report
2935 Jul 06, 2014 Developer’s Life – Every Developer is Like Transformers
2934 Jul 05, 2014 SQL SERVER – Download SQL SERVER 2014 Database Engine Permission Posters
2933 Jul 04, 2014 SQL SERVER – SSMS: Configuration Changes History
2932 Jul 03, 2014 SQL SERVER – Automate Database Operations for Success – Notes from the Field #035
2931 Jul 02, 2014 SQL SERVER – SSMS: Server Dashboard Report
2930 Jul 01, 2014 SQL SERVER – Introduction to SQL Server Management Studio Reports
2929 Jun 30, 2014 SQL SERVER – Find Blocking Using Blocked Process Threshold  
2928 Jun 29, 2014 Developer’s Life – Every Developer is a Iron Man
2927 Jun 28, 2014 MySQL – Add a Column at Particular Ordinal Position in Table
2926 Jun 27, 2014 SQL SERVER – Activity Monitor to Identify Blocking – Find Expensive Queries
2925 Jun 26, 2014 SQL SERVER – SSIS Component Error Outputs – Notes from the Field #034
2924 Jun 25, 2014 SQL SERVER – In-Memory Databases and Caching Wars
2923 Jun 24, 2014 SQL SERVER – Backup to Azure Blob using SQL Server 2014 Management Studio
2922 Jun 23, 2014 SQL SERVER – SQL Server Data Compare Tool
2921 Jun 22, 2014 Developer’s Life – Every Developer is a Sherlock Holmes
2920 Jun 21, 2014 SQL SERVER – Fix Error – Package ‘Microsoft SQL Management Studio Package’ failed to load in SQL Server Management Studio
2919 Jun 20, 2014 MySQL – Dynamic SQL with EXECUTE and PREPARE Statements
2918 Jun 19, 2014 SQL SERVER – Keeping MSDB System Database Lean and Fit – Notes from the Field #033
2917 Jun 18, 2014 SQL SERVER – Change Fill Factor – SQL in Sixty Seconds #069
2916 Jun 17, 2014 Database – Taking Backup of MySQL and MongoDB on Cloud
2915 Jun 16, 2014 SQL SERVER – SQL Server Schema Compare Tool
2914 Jun 15, 2014 Developer’s Life – Every Developer is a Chhota Bheem
2913 Jun 14, 2014 SQLAuthority News – SQL Server 2012 Service Pack 2 is Available
2912 Jun 13, 2014 SQL SERVER – How to Get SQL Server Restart Notification?
2911 Jun 12, 2014 SQL SERVER – SQL Server High Availability Options – Notes from the Field #032
2910 Jun 11, 2014 SQL SERVER – Attach or Detach Database – SQL in Sixty Seconds #068
2909 Jun 10, 2014 MySQL – Video Course – MySQL Backup and Recovery Fundamentals
2908 Jun 09, 2014 SQL SERVER – How to Recover SQL Database Data Deleted by Accident
2907 Jun 08, 2014 Developer’s Life – Every Developer is a Batman
2906 Jun 07, 2014 MySQL – Introduction to CONCAT and CONCAT_WS functions
2905 Jun 06, 2014 SQL SERVER – What are Actions in SSAS and How to Make a Reporting Action
2904 Jun 05, 2014 SQL SERVER – Planned and Unplanned Availablity Group Failovers – Notes from the Field #031
2903 Jun 04, 2014 SQL SERVER – Contest Winner – What Next on SQL in Sixty Seconds – Poll Result
2902 Jun 03, 2014 SQL SERVER – Repair a SQL Server Database Using a Transaction Log Explorer
2901 Jun 02, 2014 SQL SERVER – Iridium I/O – SQL Server Deduplication that Shrinks Databases and Improves Performance
2900 Jun 02, 2014 SQL SERVER – Faster SQL Server Databases and Applications – Power and Control with SafePeak Caching Options
2899 Jun 01, 2014 Developer’s Life – Every Developer is a Superman
2898 May 31, 2014 MySQL – Introduction to User Defined Variables
2897 May 30, 2014 SQL SERVER – Merge Two Columns into a Single Column
2896 May 29, 2014 SQL SERVER – Parsing SSIS Catalog Messages – Notes from the Field #030
2895 May 28, 2014 SQL SERVER – Take the Quiz for a chance to win a Quadcopter Drone – Brain Teasers
2894 May 28, 2014 SQL SERVER – Copy Database – SQL in Sixty Seconds #067
2893 May 27, 2014 SQL SERVER – Fix – Agent Starting Error 15281 – SQL Server blocked access to procedure ‘dbo.sp_get_sqlagent_properties’ of component ‘Agent XPs’ because this component is turned off as part of the security configuration for this server
2892 May 26, 2014 SQL SERVER – Poll – What would you love to see in SQL in Sixty Seconds?
2891 May 25, 2014 SQLAuthority News – Download Whitepaper – A Case Study on “Hekaton” against RPM – SQL Server 2014 CTP1
2890 May 24, 2014 SQLAuthority News – Presented Soft Skill Session on Presentation Skills at SQL Bangalore on May 3, 2014
2889 May 23, 2014 SQL SERVER – Fix: Error: Compatibility Level Drop Down is Empty
2888 May 22, 2014 SQL SERVER – Windows File/Folder and Share Permissions – Notes from the Field #029
2887 May 21, 2014 MySQL – Scalability on Amazon RDS: Scale out to multiple RDS instances
2886 May 21, 2014 SQL SERVER – Reset SA Password – SQL in Sixty Seconds #066
2885 May 20, 2014 SQL SERVER – 3 Challenges for DBA and Smart Solutions
2884 May 19, 2014 SQL SERVER – CTE can be Updated
2883 May 18, 2014 SQL SERVER – Migration Assistant Upgraded to Support SQL Server 2014
2882 May 17, 2014 Developer’s Life – Every Developer is a Spiderman
2881 May 16, 2014 MySQL – Beginning Temporary Tables in MySQL
2880 May 15, 2014 SQL SERVER – SSIS Look Up Component – Cache Mode – Notes from the Field #028
2879 May 14, 2014 SQL SERVER – DMV to Identify Incremental Statistics – Performance improvements in SQL Server 2014 – Part 3
2878 May 13, 2014 SQL SERVER – Simple Example of Incremental Statistics – Performance improvements in SQL Server 2014 – Part 2
2877 May 12, 2014 SQL SERVER – What is Incremental Statistics? – Performance improvements in SQL Server 2014 – Part 1
2876 May 11, 2014 SQL SERVER – SELECT INTO with FileGroup or Partitionis Not Possible
2875 May 10, 2014 MySQL – Grouping by Multiple Columns to Single Column as A String
2874 May 09, 2014 SQLAuthority News – Great Time Spent at Great Indian Developers Summit 2014
2873 May 08, 2014 Developer’s Life – Attitude and Communication – They Can Cause Problems – Notes from the Field #027
2872 May 07, 2014 SQL SERVER – What is SSAS Tabular Data model and Why to use it – Part 2
2871 May 06, 2014 SQL SERVER – How to Change Compatibility of Database to SQL Server 2014
2870 May 05, 2014 SQL SERVER – How to Install SQL Server 2014 – A 99 Seconds Video
2869 May 04, 2014 SQL Authority News – Download Microsoft SQL Server 2014 Feature Pack and Microsoft SQL Server Developer’s Edition
2868 May 03, 2014 SQL Authority News – Presenting at SQL Bangalore on May 3, 2014 – Performing an Effective Presentation
2867 May 02, 2014 MySQL – How to Create Stored Procedure in MySQL
2866 May 01, 2014 SQL SERVER – Good Value for Page Life Expectancy – Notes from the Field #026
2865 May 01, 2014 SQL SERVER – Synchronize Data Exclusively with T-SQL
2864 Apr 30, 2014 SQL SERVER – Faster Application Performance with In-Memory OLTP: Microsoft SQL Server 2014 and SafePeak Dynamic Caching
2863 Apr 29, 2014 SQL SERVER – Optimizing Three Important Resources – CPU, Memory and Disk
2862 Apr 28, 2014 SQLAuthority News – An Amazing Event – Presented at North India’s Largest Conference C Sharp Corner
2861 Apr 27, 2014 SQLAuthority News – Two Microsoft Whitepaper on In-Memory OLTP
2860 Apr 26, 2014 SQLAuthority News – Microsoft Whitepaper – Optimizing Your Query Plans with the SQL Server 2014 Cardinality Estimator
2859 Apr 25, 2014 SQL SERVER – GIDS – Two Technical Sessions Today – Resources and Whereabouts – Part 2
2858 Apr 24, 2014 SQL SERVER – Database File Names and Extentions – Notes from the Field #025
2857 Apr 23, 2014 Data Science: A Step Forward from Business Intelligence
2856 Apr 22, 2014 SQL SERVER – GIDS – Two Technical Sessions Today – Resources and Whereabouts
2855 Apr 21, 2014 SQL SERVER – Presenting 4 Technology Sessions at Great Indian Developer 2014 – Contest
2854 Apr 20, 2014 SQL SERVER – Download SQL Server 2014 Developer Edition at USD 59.59
2853 Apr 19, 2014 SQL Authority News – Microsoft Whitepaper – SQL Server 2014 and Windows Azure Blob Storage Service: Better Together
2852 Apr 19, 2014 Developers – Drive by Daniel Pink – Book Review
2851 Apr 18, 2014 SQL SERVER – Idera SQL XEvent Profiler – a Free Tool for XEvent Monitoring
2850 Apr 17, 2014 SQL SERVER – Tools for Proactive DBAs – Central Management Server – Notes from the Field #024
2849 Apr 17, 2014 SQL SERVER – Life of a SQL Query – Query States
2848 Apr 16, 2014 SQL SERVER – Calculating XIRR in SQL Server – Internal Rate of Return Available
2847 Apr 15, 2014 SQL SERVER – Three Questions – Do You Know Your Servers? – Book Gift
2846 Apr 14, 2014 SQL SERVER – Finding Last Backup Time for All Database – Last Full, Differential and Log Backup – Optimized
2845 Apr 13, 2014 SQLAuthority News – Microsoft Whitepaper – Migrating Content Between Report Servers
2844 Apr 12, 2014 SQLAuthority News – Microsoft Whitepaper – Idle Connection Resiliency
2843 Apr 11, 2014 SQL SERVER – Drop All the Foreign Key Constraint in Database – Create All the Foreign Key Constraint in Database
2842 Apr 10, 2014 SQL SERVER – Finding Jobs Shrinking Database Files – Notes from the Field #023
2841 Apr 09, 2014 MySQL – Finding First day and Last day of a Month
2840 Apr 08, 2014 SQL SERVER – What is SSAS Tabular Data Model and Why to Use it
2839 Apr 07, 2014 SQLAuthority News – Speaking at C-Sharp Corner Annual Conference 2014 – April 11-13 – Delhi
2838 Apr 06, 2014 SQL SERVER – Fix – Error 1759 Computed column in table is not allowed to be used in another computed-column definition
2837 Apr 05, 2014 SQL SERVER – Unable to ALTER Computed Column in SQL Server – How to ALTER Computed Column
2836 Apr 04, 2014 SQL SERVER – Finding Last Backup Time for All Database – Last Full, Differential and Log Backup
2835 Apr 03, 2014 SQL SERVER – Say No to DB Data Roles – SQL Security – Notes from the Field #022
2834 Apr 02, 2014 Developer – How To Market Yourself as a Software Developer
2833 Apr 01, 2014 MySQL – List User Defined Tables – Two Methods
2832 Mar 31, 2014 SQL SERVER – How to Detect Schema Change Across Two Servers
2831 Mar 30, 2014 SQL SERVER – Q and A from Facebook Page
2830 Mar 29, 2014 SQL SERVER – SQL Server 2014 Developer Training Kit and Sample Databases
2829 Mar 28, 2014 MySQL – Generate Script for a Table Using SQL
2828 Mar 27, 2014 SQLAuthority News – Sign up for SQL Authority Low Frequency Newsletter
2827 Mar 26, 2014 SQL SERVER – SSIS Execution Control Using Precedence Constraints – Notes from the Field #021
2826 Mar 25, 2014 MySQL – How to Connect to MySQL Server on Command Prompt
2825 Mar 24, 2014 SQL SERVER – Does Use of CTE Change the Order of Join in Inner Join
2824 Mar 23, 2014 SQL SERVER – Turning On Graphical Execution Plan After Enabling ShowPlan Text
2823 Mar 22, 2014 Professional Development – Dr W. Edwards Deming’s 14 Principles on Total Quality Management
2822 Mar 21, 2014 MySQL – Search For Values Within A Comma Separated Values – FIND_IN_SET
2821 Mar 20, 2014 SQL SERVER – Index Fragmentation Next Steps – Notes from the Field #020
2820 Mar 19, 2014 SQL SERVER – Retrieve Last Inserted Rows from Table – Question with No Answer
2819 Mar 18, 2014 SQL SERVER – Performance: Do-it-Yourself Caching with Memcached vs. Automated Caching with SafePeak
2818 Mar 17, 2014 MySQL – Pattern Matching Comparison Using Regular Expressions with REGEXP
2817 Mar 16, 2014 SQL SERVER – What is the Difference Between Latches and Locks
2816 Mar 15, 2014 SQL SERVER – Find Port SQL Server is Listening – Port SQL Server is Running
2815 Mar 14, 2014 SQL SERVER – Error – Resolution – Could not allocate space for object in database because the filegroup is full
2814 Mar 13, 2014 SQL SERVER – SSIS Data Flow Troubleshooting – Part1 – Notes from the Field #019
2813 Mar 12, 2014 MySQL – How to do Straight Join in MySQL?
2812 Mar 11, 2014 SQL Contest – Win Amazon Gift Cards – Learn How to Get Started with ClustrixDB
2811 Mar 10, 2014 MySQL – How to do Natural Join in MySQL? – A Key Difference Between Inner Join and Natural Join
2810 Mar 09, 2014 MySQL – Reset Row Number for Each Group – Partition By Row Number
2809 Mar 08, 2014 MySQL – Generating Row Number for Each Row using Variable
2808 Mar 07, 2014 SQL SERVER – Retrieve Maximum Length of Object Name with sp_server_info
2807 Mar 06, 2014 SQL SERVER – Performance Statistic Collection – Notes from the Field #018
2806 Mar 05, 2014 SQL SERVER – SQL Report Builder in dbForge Studio for SQL Server
2805 Mar 04, 2014 SQL SERVER – How to Synchronize Data Across Databases and Servers
2804 Mar 03, 2014 SQL SERVER – Images and media file management in SQL Server and MySQL – Coding Media Management Tools is Never Easy
2803 Mar 02, 2014 SQL SERVER – Listing Primary Key of Table with Stored Procedure sp_pkeys
2802 Mar 01, 2014 SQL SERVER – Listing Foreign Key Relationships of Table with Stored Procedure sp_fkeys
2801 Feb 28, 2014 SQL SERVER – 28 Links for Learning SQL Wait Stats from Beginning
2800 Feb 27, 2014 SQL SERVER – Dude, Where is the SQL Agent Job History? – Notes from the Field #017
2799 Feb 26, 2014 SQL SERVER – Find Anything in Object Explorer in SSMS
2798 Feb 25, 2014 MySQL – Profiler : A Simple and Convenient Tool for Profiling SQL Queries
2797 Feb 24, 2014 SQL SERVER – Contest Post – Notes from the Field – Learning Performance Tuning and Database Health
2796 Feb 23, 2014 SQLAuthority News – Two Whitepapers from AzureCAT Team on SQL Database
2795 Feb 22, 2014 SQLAuthority News – 4 Whitepapers on Windows Azure
2794 Feb 21, 2014 SQL SERVER – Statistical Analysis in SQL Server – A Quick Introduction
2793 Feb 20, 2014 SQL SERVER – Finding the Last Backup for All Databases – Notes from the Field #016
2792 Feb 19, 2014 MongoDB and MySQL – Comparing Scalability, Data Distribution & Query Model – Part 3
2791 Feb 18, 2014 MongoDB and MySQL – Comparing Scalability, Data Distribution & Query Model – Part 2
2790 Feb 17, 2014 MongoDB and MySQL – Comparing Scalability, Data Distribution & Query Model – Part 1
2789 Feb 16, 2014 MySQL – How to Detect Current Time Zone Name in MySQL
2788 Feb 15, 2014 SQL SERVER – Get Current TimeZone Name in SQL Server
2787 Feb 14, 2014 MySQL – When to Use TIMESTAMP or DATETIME – Difference Between TIMESTAMP or DATETIME
2786 Feb 13, 2014 SQL SERVER – Expanding Your Skills – Notes from the Field #015
2785 Feb 12, 2014 SQL SERVER – SafePeak SQL Server Acceleration Software Gets an Upgrade
2784 Feb 11, 2014 SQL SERVER – SysTools SQL Recovery Software – An Experiment to Recover Database Corruption
2783 Feb 10, 2014 SQL SERVER – Migration of SQL Server 2012 Database Mirroring to AlwaysOn Availability Group
2782 Feb 09, 2014 Developers – A Fun List of Things Related to Developer
2781 Feb 08, 2014 SQL Puzzle – A Quick Fun with Bit Wise Operator – Part 2
2780 Feb 07, 2014 SQL Puzzle – A Quick Fun with Bit Wise Operator
2779 Feb 06, 2014 SQL SERVER – Learning SSIS – Where Do I Start? – Notes from the Field #014
2778 Feb 05, 2014 SQL SERVER – Retrieve All the Data from VARCHAR(MAX) Column
2777 Feb 04, 2014 MySQL – Learning Online MySQL Workbench Guided Tour – Pluralsight Course
2776 Feb 03, 2014 SQL SERVER – 9 Things You Should be Doing with Your Backups
2775 Feb 02, 2014 MySQL – Download MySQL Workbench Shortcut in PDF
2774 Feb 01, 2014 MYSQL – Could not Drop Object [Content] (‘Cannot delete or update a parent row: a foreign key constraint fails’, 1217) DROP DATABASE DatabaseName
2773 Jan 31, 2014 SQL SERVER – Synchronize Schema across Multiple Environment – How to Overcome Database Migration Challenge
2772 Jan 30, 2014 SQL SERVER – Virtualized SQL Server Performance and Storage System – Notes from the Field #013
2771 Jan 29, 2014 SQL SERVER – How to Survive on Free Tools for Month – SQL Data Compare Software – The ApexSQL Diff Tool
2770 Jan 28, 2014 SQL SERVER – Back& Reborn as Premier Back End SaaS Provider
2769 Jan 27, 2014 SQL SERVER – Monitoring Your Server at a Glance – A Open Conversation with DBAs
2768 Jan 26, 2014 SQL SERVER – Rename a Table Name Containing [ or ] Identifier in the Name – Part 2
2767 Jan 25, 2014 SQL SERVER – Rename a Table Name Containing [ or ] in the Name – Identifier in the Table Name
2766 Jan 24, 2014 SQL SERVER – Writing SQL Queries Made Easy with dbForget SQL Complete
2765 Jan 24, 2014 SQL SERVER – Query Plan Analysis of Pivot and Unpivot with Profiler of dbForge Studio for SQL Server
2764 Jan 23, 2014 SQL SERVER – Tools for Proactive DBAs – Policy Based Management – Notes from the Field #012
2763 Jan 22, 2014 SQL SERVER – How to Survive on Free Tools for Month – Database Comparison Done Easily with ApexSQL Diff – The ApexSQL Diff Tool
2762 Jan 21, 2014 SQL SERVER – SQLWays – Database and Application Migration Tool
2761 Jan 20, 2014 SQL SERVER – How to Validate Syntax and Not Execute Statement – An Unexplored Debugging Tip
2760 Jan 19, 2014 SQL SERVER – Identify Oldest Active Transaction with DBCC OPENTRAN
2759 Jan 18, 2014 Personal Technology – Inserting Image in PDF File with Adobe Acrobat X Pro
2758 Jan 17, 2014 SQL SERVER – Fix – Login failed for user ‘username’. The user is not associated with a trusted SQL Server connection. (Microsoft SQL Server, Error: 18452)
2757 Jan 16, 2014 SQL SERVER – Check for Database Integrity – Notes from the Field #011
2756 Jan 15, 2014 SQL SERVER – How to Survive on Free Tools for Month – “View dependencies” returning all results – The ApexSQL Search tool
2755 Jan 14, 2014 Big Data – Real-Time Analytics Performance with ClustrixDB
2754 Jan 13, 2014 SQL SERVER – 7 Essential Tools to Support Core Database Administration – SQL DBA Bundle
2753 Jan 12, 2014 MySQL – Change the Limit of Row Retrieved in MySQL Workbench
2752 Jan 11, 2014 SQL SERVER – Create Unique Constraint on Table Column on Existing Table
2751 Jan 10, 2014 MySQL – Learn MySQL Online – 4 MySQL Courses at Pluralsight
2750 Jan 09, 2014 SQL SERVER – Auditors, Passwords and Exceptions – Notes from the Field #010
2749 Jan 08, 2014 SQL SERVER – How to Survive on Free Tools for Month – Enjoy Refactoring – ApexSQL Refactor
2748 Jan 07, 2014 MySQL – Locate the Configuration File – my.ini or my.cnf on Windows Platform
2747 Jan 06, 2014 SQL SERVER – Start Services or Stop Services with PowerShell – Answer to Question
2746 Jan 05, 2014 SQL SERVER – Start Services or Stop Services with PowerShell – Question to Readers?
2745 Jan 04, 2014 Developers – Seven Foods Developers Love
2744 Jan 03, 2014 MySQL – MySQL Query Optimization and Performance Tuning – Online Video Courses
2743 Jan 02, 2014 SQL SERVER – Tools for Proactive DBAs – Central Management Server – Notes from the Field #009
2742 Jan 01, 2014 SQLAuthority News – Happy New Year 2014 – Resolution of the New Years
2741 Dec 31, 2013 Developers – Top Ten Influential Movies for Developers – Add Your Favourite
2740 Dec 30, 2013 SQL SERVER – MySQL – LIMIT and OFFSET – Skip and Return Only Next Few Rows – Paging Solution
2739 Dec 29, 2013 SQL SERVER – MySQL – How to Concat Strings?
2738 Dec 28, 2013 Developer – 10 Phrases Developer Use Too Often
2737 Dec 27, 2013 MySQL – How to Change Delimiter in MySQL – Supporting GO Keyword of SQL Server in MySQL
2736 Dec 26, 2013 SQL SERVER – Roundup Post – Notes from the Field – Year 2013 – Performance Tuning and Database Health
2735 Dec 25, 2013 SQL SERVER – Overall SQL Server Performance – Not Just Query Performance – Notes from the Field #008
2734 Dec 24, 2013 SQL – A Career in Database Forensics
2733 Dec 23, 2013 SQL SERVER – Learning More About SQL Wait Stats
2732 Dec 22, 2013 SQL SERVER – What Permissions I have on Database I am Connected to?
2731 Dec 21, 2013 Developer – Nine Things Developers Hate to Hear
2730 Dec 20, 2013 SQL SERVER – Redundant Indexes Good or Bad – Final Wrap – Part 7
2729 Dec 19, 2013 SQL SERVER – SQL Server Alerts and How to Use Them – Notes from the Field #007
2728 Dec 18, 2013 SQL SERVER – How to Survive on Free Tools for Month – ApexSQL Complete – A Free SQL Advanced Intellisense
2727 Dec 17, 2013 SQL Contest – USD 100 Gift Card and Attractive Discount from Devart
2726 Dec 16, 2013 SQL SERVER – Monitor Database via a Heatmap, Alarms List and Realtime Diagnostics for FREE
2725 Dec 15, 2013 SQL SERVER – How to Identify Datatypes and Properties of Variable
2724 Dec 14, 2013 Personal Technology – How to Dress for an Interview – Guidelines and Suggestions
2723 Dec 13, 2013 MySQL – How to Create Stored Procedure
2722 Dec 12, 2013 SQL SERVER – Optimal Memory Settings for SQL Server – Notes from the Field #006
2721 Dec 11, 2013 SQL Reporting – How to Add Excel and Word Reporting to Your Own Application – An Innovative Approach
2720 Dec 10, 2013 SQL SERVER – Working with Business Days in SQL Server – A Different Approach
2719 Dec 09, 2013 SQL SERVER – How to Allow Only Alphabets in Column – Create Check Constraint to Insert Only Alphabets
2718 Dec 08, 2013 SQLAuthority News – Notes from SQLLive 360 – Orlando, Nov 2013 – A Great Experience
2717 Dec 07, 2013 Personal Technology – How to do Exercise and Stay Relaxed while in Office – Tips for Developers
2716 Dec 06, 2013 SQL SERVER – Wrap on Series of Temporary Statistics
2715 Dec 05, 2013 SQL SERVER – Finding Frequently Running Query and Elapsed Time – Notes from the Field #005
2714 Dec 04, 2013 SQL SERVER – Scripting Statistics for Read-Only Database and Making it Permanent
2713 Dec 03, 2013 Weekend Project – Connect your Database and Automatically Generate a Fully Customized Back-office Interface
2712 Dec 02, 2013 SQL SERVER – Location of Statistics Before and After Database is Marked as a Read-Only
2711 Dec 01, 2013 SQL SERVER – Download SQL Server 2014 CTP2 and Related Downloads
2710 Nov 30, 2013 SQL SERVER – How to Script Statistics from SSMS? – Scripting Statistics is Disabled in SSMS
2709 Nov 29, 2013 SQL SERVER – Statistics for Read-Only Database are in TempDB
2708 Nov 28, 2013 SQL SERVER – Building Three-Part Name from OBJECT_ID – Database Name, Schema Name, TableName
2707 Nov 27, 2013 SQL SERVER – MySQL – Order Column by Nearest Value for Any Integer
2706 Nov 26, 2013 SQL SERVER – SQL Server Configuration Checking – A Must Do for Every DBA – Notes from the Field #004
2705 Nov 25, 2013 SQL SERVER – Export Data AS CSV from Database Using SQLCMD
2704 Nov 24, 2013 Personal Technology – A Quick Note on Good Elevator Etiquette
2703 Nov 23, 2013 SQL SERVER – FIX : Error 3154: The backup set holds a backup of a database other than the existing database – SSMS
2702 Nov 22, 2013 SQL – Everything about Data Magazine – FREE to Subscribe
2701 Nov 21, 2013 SQL SERVER – vCPUs – How Many Are Too Many CPU for SQL Server Virtualization ? – Notes from the Field #003
2700 Nov 20, 2013 SQL SERVER – How to export data from SQL Server to Excel or any other Format?
2699 Nov 19, 2013 SQL SERVER – 3 Quick Videos on Careers, Certifications and Information
2698 Nov 18, 2013 SQLAuthority News – Presenting 3 Session at SQL Server Live, Orlando, Florida
2697 Nov 17, 2013 Personal Technology – From Floppy to CD, DVD to USB Drive – Quick Note on Evolution of Personal Storage Device
2696 Nov 16, 2013 SQL SERVER – SQLPASS 2013, Charlotte Memories – Book and Book Signing – Part 2
2695 Nov 15, 2013 SQL SERVER – SQLPASS 2013, Charlotte Memories – Friends and Technology – Part 1
2694 Nov 14, 2013 SQL SERVER – Root Cause to Performance Problems – Notes from the Field #002
2693 Nov 13, 2013 SQL SERVER – Backup SQL databases to Box or SkyDrive
2692 Nov 12, 2013 MySQL – How to Write Loop in MySQL
2691 Nov 11, 2013 SQL – Biggest Concerns in a Data-Driven World
2690 Nov 10, 2013 Personal Technology – Laptop Screen Blank – No Post – No BIOS – No Boot
2689 Nov 09, 2013 MYSQL – Identifying Current Version of MySQL Server Installation – Part 2
2688 Nov 08, 2013 MySQL – How to Find mysqld.exe with Command Prompt – Fix: ‘mysql’ is not recognized as an internal or external command, operable program or batch file
2687 Nov 07, 2013 SQL SERVER – Transaction Log Full – Transaction Log Larger than Data File – Notes from the Field #001
2686 Nov 06, 2013 Big Data – ClustrixDB – Extreme Scale SQL Database with Real-time Analytics, Releases Software Download – NewSQL
2685 Nov 05, 2013 SQL SERVER – Number-Crunching with SQL Server – Exceed the Functionality of Excel
2684 Nov 04, 2013 SQL SERVER – Implementing IF … THEN in SQL SERVER with CASE Statements
2683 Nov 03, 2013 MYSQL – Detecting Current Version of MySQL Server Installation
2682 Nov 02, 2013 SQL SERVER – Weekly Series – Memory Lane – #053 – Final Post in Series
2681 Nov 01, 2013 SQLAuthority News – 7th Anniversary of Blog – A Personal Note
2680 Oct 31, 2013 Big Data – Is Big Data Relevant to me? – Big Data Questionnaires – Guest Post by Vinod Kumar
2679 Oct 30, 2013 Big Data – Learning Basics of Big Data in 21 Days – Bookmark
2678 Oct 29, 2013 Big Data – Final Wrap and What Next – Day 21 of 21
2677 Oct 28, 2013 Big Data – Various Learning Resources – How to Start with Big Data? – Day 20 of 21
2676 Oct 27, 2013 SQL SERVER – Download FREE PDFs from SQLAuthority.com
2675 Oct 26, 2013 SQL SERVER – Weekly Series – Memory Lane – #052
2674 Oct 25, 2013 Big Data – How to become a Data Scientist and Learn Data Science? – Day 19 of 21
2673 Oct 24, 2013 Big Data – Basics of Big Data Analytics – Day 18 of 21
2672 Oct 23, 2013 Big Data – Interacting with Hadoop – What is Sqoop? – What is Zookeeper? – Day 17 of 21
2671 Oct 22, 2013 SQL Contest – Win 10 Amazon Gift Cards worth (USD 200) and 10 NuoDB T-Shirts
2670 Oct 22, 2013 Big Data – Interacting with Hadoop – What is PIG? – What is PIG Latin? – Day 16 of 21
2669 Oct 21, 2013 Big Data – Data Mining with Hive – What is Hive? – What is HiveQL (HQL)? – Day 15 of 21
2668 Oct 20, 2013 Professional Development – Difference Between Bio, CV and Resume
2667 Oct 19, 2013 SQL SERVER – Weekly Series – Memory Lane – #051
2666 Oct 18, 2013 Big Data – Operational Databases Supporting Big Data – Columnar, Graph and Spatial Database – Day 14 of 21
2665 Oct 17, 2013 Big Data – Operational Databases Supporting Big Data – Key-Value Pair Databases and Document Databases – Day 13 of 21
2664 Oct 16, 2013 SQLAuthority News – Why VoIP Service Providers Should Think About NuoDB’s Geo Distribution
2663 Oct 16, 2013 Big Data – Operational Databases Supporting Big Data – RDBMS and NoSQL – Day 12 of 21
2662 Oct 15, 2013 SQL SERVER – How to easily work with Database Diagrams
2661 Oct 15, 2013 Big Data – Role of Cloud Computing in Big Data – Day 11 of 21
2660 Oct 14, 2013 Big Data – Buzz Words: What is NewSQL – Day 10 of 21
2659 Oct 13, 2013 SQLAuthority News – Presented Technical Session at DevReach 2013, Sofia, Bulgaria – Oct 1, 2013
2658 Oct 12, 2013 SQL SERVER – Weekly Series – Memory Lane – #050
2657 Oct 11, 2013 Big Data – Buzz Words: Importance of Relational Database in Big Data World – Day 9 of 21
2656 Oct 10, 2013 Big Data – Buzz Words: What is HDFS – Day 8 of 21
2655 Oct 09, 2013 Big Data – Buzz Words: What is MapReduce – Day 7 of 21
2654 Oct 08, 2013 SQLAuthority News – Mark the Date: October 16, 2013 – Introducing NuoDB Blackbirds: THE Distributed Database
2653 Oct 08, 2013 Big Data – Buzz Words: What is Hadoop – Day 6 of 21
2652 Oct 07, 2013 Big Data – Buzz Words: What is NoSQL – Day 5 of 21
2651 Oct 06, 2013 SQL – Business Intelligence: Derive Data or Information?
2650 Oct 05, 2013 SQL SERVER – Weekly Series – Memory Lane – #049
2649 Oct 04, 2013 Big Data – Basics of Big Data Architecture – Day 4 of 21
2648 Oct 03, 2013 Big Data – Evolution of Big Data – Day 3 of 21
2647 Oct 02, 2013 Big Data – What is Big Data – 3 Vs of Big Data – Volume, Velocity and Variety – Day 2 of 21
2646 Oct 01, 2013 Big Data – Beginning Big Data – Day 1 of 21
2645 Sep 30, 2013 Big Data – Beginning Big Data Series Next Month in 21 Parts
2644 Sep 29, 2013 SQL – Download FREE Book – Data Access for HighlyScalable Solutions: Using SQL, NoSQL, and Polyglot Persistence
2643 Sep 28, 2013 SQL SERVER – Weekly Series – Memory Lane – #048
2642 Sep 27, 2013 SQL Contests – Solution – Identify the Database Celebrity
2641 Sep 26, 2013 SQL SERVER – Select Columns from Stored Procedure Resultset
2640 Sep 25, 2013 SQL SERVER – How to Access the Previous Row and Next Row value in SELECT statement? – Part 4
2639 Sep 24, 2013 SQL SERVER – How to Access the Previous Row and Next Row value in SELECT statement? – Part 3
2638 Sep 23, 2013 SQL Contest – Hint for Identify the Database Celebrity
2637 Sep 23, 2013 SQL SERVER – How to Access the Previous Row and Next Row value in SELECT statement? – Part 2
2636 Sep 22, 2013 SQL SERVER – How to Access the Previous Row and Next Row value in SELECT statement?
2635 Sep 21, 2013 SQL SERVER – Weekly Series – Memory Lane – #047
2634 Sep 20, 2013 Developer – Best Practices for Daily Stand-Up or Daily Scrum – Rules and Regulations
2633 Sep 19, 2013 SQL Contest – Identify the Database Celebrity – Win USD 100 Amazon Gift Card
2632 Sep 18, 2013 SQL SERVER – Five Puzzles around UNION – Participate in All Five
2631 Sep 17, 2013 SQL SERVER – Detecting Potential Bottlenecks with the help of Profiler
2630 Sep 16, 2013 SQL SERVER – Execute Operating System Commands in sqlcmd
2629 Sep 15, 2013 Personal Technology – Who is Accessing your Google Account?
2628 Sep 14, 2013 SQL SERVER – Weekly Series – Memory Lane – #046
2627 Sep 13, 2013 SQL – Weekend Project – Watching Technically Seth Series – What is your plan for this weekend?
2626 Sep 12, 2013 SQL SERVER – Automatically Store Results of Query to File with sqlcmd
2625 Sep 11, 2013 SQL SERVER – Simple Puzzle with UNION – Part 5
2624 Sep 10, 2013 SQL SERVER – Simple Puzzle with UNION – Part 4
2623 Sep 09, 2013 SQL SERVER – Simple Puzzle with UNION – Part 3
2622 Sep 08, 2013 SQL SERVER – Download SQL Server Developer Edition 2012 for USD 60
2621 Sep 07, 2013 SQL SERVER – Weekly Series – Memory Lane – #045
2620 Sep 06, 2013 SQL SERVER – Simple Puzzle with UNION – Part 2
2619 Sep 05, 2013 SQL SERVER – Simple Puzzle with UNION
2618 Sep 04, 2013 SQLAuthority News – 10 SQL in Sixty Days Video in 10 Days – Contest to Win 10 Cool Gifts
2617 Sep 03, 2013 SQLAuthority News – Learn MySQL Indexing in 99 Minutes – MySQL Indexing for Performance – Video Course
2616 Sep 02, 2013 SQLAuthority News – IT Security for Small Businesses
2615 Sep 01, 2013 SQL SERVER – SQL Basics Video: SQL 2012 Certification Path – SQL in Sixty Seconds #065
2614 Aug 31, 2013 SQL SERVER – Weekly Series – Memory Lane – #044
2613 Aug 30, 2013 SQL SERVER – SQL Basics Video: What Are Filegroups – SQL in Sixty Seconds #064
2612 Aug 29, 2013 SQL SERVER – SQL Basics Video: Database Datafiles and Logfiles – SQL in Sixty Seconds #063
2611 Aug 28, 2013 SQL SERVER – Tips for SQL Query Optimization by Analyzing Query Plan
2610 Aug 28, 2013 SQL SERVER – SQL Basics Video: Database Careers – SQL in Sixty Seconds #062
2609 Aug 27, 2013 SQL Contest – Download NuoDB 1.2 to Win 20 Amazon Gift Cards
2608 Aug 27, 2013 SQL SERVER – SQL Basics Video: SQL Code Generators – SQL in Sixty Seconds #061
2607 Aug 26, 2013 SQL SERVER – SQL Basics Video: Using Management Studio – SQL in Sixty Seconds #060
2606 Aug 25, 2013 SQL SERVER – SQL Basics Video: Code Comments – SQL in Sixty Seconds #059
2605 Aug 24, 2013 SQL SERVER – Weekly Series – Memory Lane – #043
2604 Aug 23, 2013 SQL SERVER – SQL Basics Video: Joining Tables – SQL in Sixty Seconds #058
2603 Aug 22, 2013 SQL SERVER – SQL Basics Video: Running SQL Code – SQL in Sixty Seconds #057
2602 Aug 21, 2013 SQL SERVER – SQL Basics Video: Data and Information in Businesses – SQL in Sixty Seconds #056
2601 Aug 20, 2013 SQL SERVER – Simple Trick to Backup Azure Database with SkyDrive
2600 Aug 19, 2013 SQL – Solution – Crossword Puzzle Based on Course Building Successful High Traffic Profitable Blog
2599 Aug 18, 2013 Personal Technology – Chrome Missing Close Button – Chrome in Desktop Mode in Windows 8
2598 Aug 17, 2013 SQL SERVER – Weekly Series – Memory Lane – #042
2597 Aug 16, 2013 SQL SERVER – SQL Basics: SQL 2012 Certification Path – Day 10 of 10
2596 Aug 15, 2013 SQL SERVER – SQL Basics: What Are Filegroups – Day 9 of 10
2595 Aug 14, 2013 SQL SERVER – SQL Basics: Database Datafiles and Logfiles – Day 8 of 10
2594 Aug 13, 2013 SQL SERVER – SQL Basics: Database Careers – Day 7 of 10
2593 Aug 12, 2013 SQL SERVER – SQL Basics: SQL Code Generators – Day 6 of 10
2592 Aug 11, 2013 SQL SERVER – SQL Basics: Using Management Studio – Day 5 of 10
2591 Aug 10, 2013 SQL SERVER – Weekly Series – Memory Lane – #041
2590 Aug 09, 2013 SQL SERVER – SQL Basics: Code Comments – Day 4 of 10
2589 Aug 08, 2013 SQL – NuoDB Releases 1.2 has Several SQL Enhancements
2588 Aug 08, 2013 SQL SERVER – SQL Basics: Joining Tables – Day 3 of 10
2587 Aug 07, 2013 SQL SERVER – SQL Basics: Running SQL Code – Day 2 of 10
2586 Aug 06, 2013 SQL SERVER – SQL Basics: Data and Information in Businesses – Day 1 of 10
2585 Aug 05, 2013 SQLAuthority News – Releasing Author’s 10th Book – SQL Basics Joes 2 Pros: A Getting Started Guide to Administering and Developing SQL Server Databases for Beginners
2584 Aug 04, 2013 SQL SERVER – Understanding Restrict Access to Restricted_User Database Property
2583 Aug 03, 2013 SQL SERVER – Weekly Series – Memory Lane – #040
2582 Aug 02, 2013 SQL SERVER – Disk Space Monitoring – Detecting Low Disk Space on Server
2581 Aug 01, 2013 SQL – Crossword Puzzle Based on Course Building Successful High Traffic Profitable Blog
2580 Jul 31, 2013 SQL SERVER – How to Compare the Schema of Two Databases with Schema Compare
2579 Jul 30, 2013 SQL – Download NuoDB and Qualify for FREE Amazon Gift Cards
2578 Jul 30, 2013 SQL – Building a High Traffic, Profitable Blog – A Unique Gift on Author’s Birthday
2577 Jul 29, 2013 SQL SERVER – Example of Performance Tuning for Advanced Users with DB Optimizer
2576 Jul 28, 2013 SQLAuthority News – 5 days of SQL Server Reporting Service (SSRS) Summary
2575 Jul 27, 2013 SQL SERVER – Weekly Series – Memory Lane – #039
2574 Jul 27, 2013 SQL SERVER – How to an Add Identity Column to Table in SQL Server
2573 Jul 26, 2013 SQL SERVER – Data Sources and Data Sets in Reporting Services SSRS
2572 Jul 26, 2013 SQL – What is the latest Version of NuoDB? – A Quick Contest to Get Amazon Gift Cards
2571 Jul 25, 2013 SQL SERVER – Create a Very First Report with the Report Wizard
2570 Jul 24, 2013 SQL SERVER – Installing SQL Server Data Tools and SSRS
2569 Jul 23, 2013 SQL SERVER – Determine if SSRS 2012 is Installed on your SQL Server
2568 Jul 22, 2013 SQL SERVER – What is SSRS and Why SSRS is asked for in many Job Opening?
2567 Jul 21, 2013 SQL SERVER – What is the Maximum Relational Database Size Supported by Single Instance?
2566 Jul 20, 2013 SQL SERVER – Weekly Series – Memory Lane – #038
2565 Jul 19, 2013 SQL SERVER – Database in RESTORING State for Long Time
2564 Jul 18, 2013 SQL SERVER – Auditing and Profiling Database Made Easy with SQL Audit and Comply
2563 Jul 17, 2013 SQL SERVER – Delay Command in SQL Server – SQL in Sixty Seconds #055
2562 Jul 16, 2013 SQL – Difference Between INNER JOIN and JOIN
2561 Jul 15, 2013 SQL – What ACID stands in the Database? – Contest to Win 24 Amazon Gift Cards and Joes 2 Pros 2012 Kit
2560 Jul 14, 2013 SQL SERVER – Drivers for PHP, JDBC, ODBC and OLE DB
2559 Jul 13, 2013 SQL SERVER – Weekly Series – Memory Lane – #037
2558 Jul 12, 2013 MySQL – Learning MySQL Online in 6 Hours – MySQL Fundamentals in 320 Minutes
2557 Jul 11, 2013 SQL – Agile Software Development Methodology vs Waterfall Software Development Methodology
2556 Jul 10, 2013 SQL SERVER – Need Your Feedback – Next Action Items in SQL in Sixty Seconds
2555 Jul 09, 2013 SQL – Download Database Cheat Sheet for MongoDB, NuoDB, MySQL for FREE
2554 Jul 08, 2013 SQL – Difference between != and <> Operator used for NOT EQUAL TO Operation
2553 Jul 07, 2013 SQL SERVER – Check Database Level (IsNullConcat) and Session Level Settings (CONCAT_NULL_YIELDS_NULL) using T-SQL
2552 Jul 06, 2013 SQL SERVER – Weekly Series – Memory Lane – #036
2551 Jul 05, 2013 SQL SERVER – A Quick Note on CONCAT_NULL_YIELDS_NULL
2550 Jul 04, 2013 SQL SERVER – How to Refresh SSMS Intellisense Cache to Update Schema Changes
2549 Jul 03, 2013 Developer Training – 6 Online Courses to Learn SQL Server, MySQL and Technology
2548 Jul 02, 2013 Personal Technology – Excel Tip: Comparing Excel Files
2547 Jul 01, 2013 SQL SERVER – Check If Column Exists in SQL Server Table
2546 Jun 30, 2013 SQL SERVER – 2014 CTP1 Available for Download – SQL SERVER 2014 Community Technology Preview 1
2545 Jun 29, 2013 SQL SERVER – Weekly Series – Memory Lane – #035
2544 Jun 28, 2013 SQL SERVER – How to Set Variable and Use Variable in SQLCMD Mode
2543 Jun 27, 2013 SQL SERVER – Another lesser known feature of SQL Server Management Studio 2012 – Guest Post by Balmukund Lakhani
2542 Jun 26, 2013 SQL SERVER – Maximize Database Performance with DB Optimizer – SQL in Sixty Seconds #054
2541 Jun 25, 2013 SQL SERVER – Relationship with Parallelism with Locks and Query Wait – Question for You
2540 Jun 24, 2013 SQL SERVER – An Efficiency Tool to Compare and Synchronize SQL Server Databases
2539 Jun 23, 2013 SQL SERVER – List of All the Samples Database Available to Download for FREE
2538 Jun 22, 2013 SQL SERVER – Weekly Series – Memory Lane – #034
2537 Jun 21, 2013 SQL SERVER – Storing 64-bit Unsigned Integer Value in Database
2536 Jun 20, 2013 SQL – Contest to Get The Date – Win USD 50 Amazon Gift Cards and Cool Gift
2535 Jun 19, 2013 SQL SERVER – NuoDB in Sixty Seconds – SQL in Sixty Seconds #053
2534 Jun 18, 2013 SQL – NuoDB and Third Party Explorer – SQuirreL SQL Client, SQL Workbench/J and DbVisualizer
2533 Jun 17, 2013 SQL – Migrate Database from SQL Server to NuoDB – A Quick Tutorial
2532 Jun 16, 2013 SQL SERVER – Microsoft SQL Server 2014 CTP1 Product Guide
2531 Jun 15, 2013 SQL SERVER – Weekly Series – Memory Lane – #033
2530 Jun 14, 2013 SQL – Quick Start with Explorer Sections of NuoDB – Query NuoDB Database
2529 Jun 13, 2013 SQL – Quick Start with Admin Sections of NuoDB – Manage NuoDB Database
2528 Jun 12, 2013 SQL – Step by Step Guide to Download and Install NuoDB – Getting Started with NuoDB
2527 Jun 11, 2013 SQL SERVER – Puzzle #1 – Querying Pattern Ranges and Wild Cards
2526 Jun 10, 2013 SQL SERVER – New SQL Server 2012 Functions – Webinar by Rick Morelan
2525 Jun 10, 2013 SQL SERVER – The Story of a Lesser Known Startup Parameter in SQL Server – Guest Post by Balmukund Lakhani
2524 Jun 09, 2013 SQL SERVER – 2014 Announced and SQL Server 2014 Datasheet
2523 Jun 08, 2013 SQL SERVER – Weekly Series – Memory Lane – #032
2522 Jun 07, 2013 SQL SERVER – QUOTED_IDENTIFIER ON/OFF Explanation and Example – Question on Real World Usage
2521 Jun 06, 2013 SQLAuthority News – Top 5 Latest Microsoft Certifications of 2013 – Guest Post
2520 Jun 05, 2013 SQL SERVER – SQL in Sixty Seconds – Last Three Episodes – Need Your Opinion
2519 Jun 04, 2013 SQL SERVER – Script to Update a Specific Column in Entire Database
2518 Jun 03, 2013 SQLAuthority News – Don’t Be Afraid To Fool The World – Video by John Sonmez
2517 Jun 02, 2013 SQLAuthority News – Advantages of Distance Learning
2516 Jun 01, 2013 SQL SERVER – Weekly Series – Memory Lane – #031
2515 May 31, 2013 SQLAuthority News – New Theme of SQLAuthority and Video Courses
2514 May 30, 2013 SQL SERVER – Add Identity Column to Table Based on Order of Another Column
2513 May 29, 2013 SQL SERVER – Puzzle SET ANSI_NULLS and Resultset – SQL in Sixty Seconds #052
2512 May 28, 2013 SQL SERVER- Solution – SQL Puzzle of SET ANSI_NULL
2511 May 27, 2013 SQL SERVER – How to INSERT data from Stored Procedure to Table – 2 Different Methods
2510 May 26, 2013 Blogging Best Practices – Checklist for Building Successful Blog – Part 6
2509 May 25, 2013 SQL SERVER – Weekly Series – Memory Lane – #030
2508 May 24, 2013 Blogging Best Practices – Frequently Asked Questions – Part 5
2507 May 23, 2013 Blogging Best Practices – Blogging Rules, Ethics and Etiquette – Part 4
2506 May 22, 2013 Blogging Best Practices – Writing an Interesting Blog – Part 3
2505 May 21, 2013 Blogging Best Practices – Getting Started with Blogging – Part 2
2504 May 20, 2013 Blogging Best Practices – Concepts, Ideas and Motives – Part 1
2503 May 19, 2013 Blogging Best Practices – Pluralsight Online Course Based on My Experience
2502 May 18, 2013 SQL SERVER – Weekly Series – Memory Lane – #029
2501 May 17, 2013 SQL SERVER – Solution to Puzzle – REPLICATE over 8000 Characters
2500 May 16, 2013 SQLAuthority News – 2500 Blog Posts, 2 Million Views per month, 62 Million Total Views
2499 May 15, 2013 SQL SERVER – SQL Puzzle of SET ANSI_NULL – Win USD 50 worth Amazon Gift Cards and Bubble Copter R/C
2498 May 14, 2013 SQL SERVER – How to use xp_sscanf in Real World Scenario?
2497 May 13, 2013 SQL SERVER – Puzzle and Answer – REPLICATE over 8000 Characters
2496 May 12, 2013 SQL SERVER – Interesting Observation of CONCAT_NULL_YIELDS_NULL and CONCAT in SQL Server 2012 onwards
2495 May 11, 2013 SQL SERVER – Weekly Series – Memory Lane – #028
2494 May 10, 2013 SQL SERVER – Adding Column Defaulting to Current Datetime in Table
2493 May 09, 2013 SQL SERVER – A New Approach to Scale .NET Applications
2492 May 08, 2013 SQL SERVER – RESEED Identity Column in Database Table – Rest Table Identity Value – SQL in Sixty Seconds #051
2491 May 07, 2013 SQLAuthority News – Sharding or No Sharding of Database – Working on my Weekend Project
2490 May 06, 2013 SQL SERVER – Azure SQL Databases Backup Made Easy with SQLBackupAndFTP
2489 May 05, 2013 SQL SERVER – sys.dm_xe_map_values – Reasons for Statement Recompilation
2488 May 04, 2013 SQL SERVER – Weekly Series – Memory Lane – #027
2487 May 03, 2013 SQL SERVER – DELETE From SELECT Statement – Using JOIN in DELETE Statement – Multiple Tables in DELETE Statement
2486 May 02, 2013 SQLAuthority News – Presenting 3 Technical Sessions at Great Indian Developer Summit – May 7, 2013 – Bangalore
2485 May 01, 2013 SQLAuthority News – Learn Fundamentals of MySQL Online – Pluralsight Course
2484 Apr 30, 2013 SQL SERVER – UPDATE From SELECT Statement – Using JOIN in UPDATE Statement – Multiple Tables in Update Statement
2483 Apr 29, 2013 SQL SERVER – Disable All the Foreign Key Constraint in Database – Enable All the Foreign Key Constraint in Database
2482 Apr 28, 2013 SQLAuthority News – Download PowerPivot or PowerView enabled Workbook Optimizer – Download SQL Server Connector for Apache Hadoop
2481 Apr 27, 2013 SQL SERVER – Weekly Series – Memory Lane – #026
2480 Apr 26, 2013 SQL SERVER – UNION ALL and UNION are Different Operation
2479 Apr 25, 2013 SQL SERVER – Return Specific Row to at the Bottom of the Resultset – T-SQL Script – Part 2
2478 Apr 24, 2013 SQL SERVER – Interview Questions and Answers Sample Chapter Free Download – SQL in Sixty Seconds #050
2477 Apr 23, 2013 SQL SERVER – Return Specific Row to at the Bottom of the Resultset – T-SQL Script
2476 Apr 22, 2013 SQL SERVER – Discussion – Scale-up vs Scale-out Architectures
2475 Apr 22, 2013 SQLAuthority News – Webinar SQL Server Locking and Concurrency by Rick Morelan
2474 Apr 21, 2013 SQLAuthority News – Women in SQL – Youngest SQL Speaker – Bangalore SQL User Group Event on April 20, 2013
2473 Apr 20, 2013 SQL SERVER – Weekly Series – Memory Lane – #025
2472 Apr 19, 2013 SQL SERVER – How to Begin with VMware – Introduction to Virtualization
2471 Apr 18, 2013 SQL SERVER – Using SSIS to Import CSV File into Salesforce Online Database with dotConnect for Salesforce from Devart
2470 Apr 17, 2013 SQL SERVER – Remove Cached Login from SSMS Connect Dialog – SQL in Sixty Seconds #049
2469 Apr 16, 2013 SQL SERVER – Get High Availability with SQL Server 2012
2468 Apr 15, 2013 SQLAuthority News – Excellent Experience at TechEd India 2013 Bangalore and Pune – Photo Journey
2467 Apr 14, 2013 SQL SERVER – Tricks for Row Offset and Paging in Various Versions of SQL Server
2466 Apr 13, 2013 SQL SERVER – Weekly Series – Memory Lane – #024
2465 Apr 12, 2013 SQLAuthority News – HP Project Moonshot Interchangeable and Interlockable Servers with Elastically Scale NuoDB
2464 Apr 11, 2013 SQLAuthority News – Koenig Solutions Invests into World’s Largest IT Training Center
2463 Apr 10, 2013 SQL SERVER – Enable SQLCMD Mode in SSMS – SQL in Sixty Seconds #048
2462 Apr 09, 2013 SQL SERVER – Fix : Error: 217 Implicit conversion from data type datetime to int is not allowed. Use the CONVERT function to run this query.
2461 Apr 08, 2013 SQL SERVER – The procedure attempted to return a status of NULL, which is not allowed. A status of 0 will be returned instead.
2460 Apr 07, 2013 SQL SERVER – Pass One Stored Procedure’s Result as Another Stored Procedure’s Parameter
2459 Apr 06, 2013 SQL SERVER – Weekly Series – Memory Lane – #023
2458 Apr 05, 2013 SQL SERVER – Group by Rows and Columns using XML PATH – Efficient Concating Trick
2457 Apr 04, 2013 SQLAuthority Contests – Get 50 Amazon Gift Cards – Experience NuoDB Starlings 1.0.2
2456 Apr 03, 2013 SQL SERVER – Resolve Cannot Resolve Collation Conflict Error – SQL in Sixty Seconds #047
2455 Apr 02, 2013 SQL SERVER – An Interesting Case of Redundant Indexes – Index on Col1, Col2 and Index on Col1, Col2, Col3 – Part 6
2454 Apr 01, 2013 SQL SERVER – Three Efficiency Tools for SQL Server from Devart
2453 Mar 31, 2013 SQL SERVER – Three Important Documentation to download – Standards Support, Protocol, Data Portability
2452 Mar 30, 2013 SQL SERVER – Weekly Series – Memory Lane – #022
2451 Mar 29, 2013 SQL SERVER – XML Data Type- SQL Queries 2012 Joes 2 Pros Volume 5 – XML Querying Techniques for SQL Server 2012
2450 Mar 28, 2013 SQL SERVER – Executing Dynamic SQL – SQL Queries 2012 Joes 2 Pros Volume 4 – Query Programming Objects for SQL Server 2012
2449 Mar 27, 2013 SQL SERVER – Introduction to GUIDs – SQL Queries 2012 Joes 2 Pros Volume 3 – Advanced Query Tools and Techniques for SQL Server 2012
2448 Mar 26, 2013 SQL SERVER – Identity Fields Review – SQL Queries 2012 Joes 2 Pros Volume 2 – The SQL Query Techniques Tutorial for SQL Server 2012
2447 Mar 25, 2013 SQL SERVER – Query Writing Strategy – SQL Queries 2012 Joes 2 Pros Volume 1 – The SQL Queries 2012 Hands-On Tutorial for Beginners
2446 Mar 24, 2013 SQLAuthority News – Whitepaper – Plan Caching and Recompilation in SQL Server 2012
2445 Mar 23, 2013 SQL SERVER – Weekly Series – Memory Lane – #021
2444 Mar 22, 2013 SQL SERVER – Fix – Error: 1060 The number of rows provided for a TOP or FETCH clauses row count parameter must be an integer
2443 Mar 21, 2013 SQL SERVER – Identify Last User Access of Table using T-SQL Script
2442 Mar 20, 2013 SQLAuthority News – How to Avoid Procrastination – Professional Development #001 – Video
2441 Mar 19, 2013 SQL SERVER – TechEd India 2013 Sessions and Relevent Pluralsight Courses
2440 Mar 18, 2013 SQLAuthority News – Presenting Two Technology Sessions at TechEd India 2013 – Today and Tomorrow
2439 Mar 17, 2013 SQLAuthority News – Excellent Learning Experience at SQLskills Immersion Events
2438 Mar 16, 2013 SQL SERVER – Weekly Series – Memory Lane – #020
2437 Mar 15, 2013 SQLAuthority News – Presenting Two Session at TechEd India 2013 on March 18-19, 2013 at Bangalore
2436 Mar 14, 2013 SQLAuthority News – Truly Amazing Experience at Pluralsight Author Summit February 2013
2435 Mar 13, 2013 SQL SERVER – Shortcut to SELECT Single Row from Table – SQL in Sixty Seconds #046 – Video
2434 Mar 12, 2013 SQL SERVER – Avoid Using Function in WHERE Clause – Scan to Seek
2433 Mar 11, 2013 SQL SERVER – How to Add Column at Specific Location in Table
2432 Mar 10, 2013 SQLAuthority News – SQL Server Data Tools – Business Intelligence for Visual Studio 2012 – SQL Server 2012 Data-Tier Application Framework
2431 Mar 09, 2013 SQL SERVER – Weekly Series – Memory Lane – #019
2430 Mar 08, 2013 SQL SERVER – Tricky Question – What is the Default Size of the Database
2429 Mar 07, 2013 SQL SERVER – Check If String is a Palindrome in Using T-SQL Script – Reverse Function
2428 Mar 06, 2013 SQL SERVER – Watch Four Efficiency Tricks in SQL Server In Sixty Seconds – Subscribe for SQL Learning Videos
2427 Mar 05, 2013 SQL SERVER – Exporting Query Results to CSV using SQLCMD
2426 Mar 04, 2013 SQL SERVER – SSMS does NOT Print NULL Values
2425 Mar 03, 2013 SQL SERVER – Download Microsoft PowerPivot for Excel 2010 and PowerPivot in Excel 2013 Samples
2424 Mar 02, 2013 SQL SERVER – Weekly Series – Memory Lane – #018
2423 Mar 01, 2013 SQL SERVER – Beginning SQL 2012 – Basics of CONVERT and FORMAT Function – Abstract from Joes 2 Pros Volume 5
2422 Feb 28, 2013 SQL SERVER – Beginning SQL 2012 – Basics of CONVERT and FORMAT Function – Abstract from Joes 2 Pros Volume 4
2421 Feb 27, 2013 SQL SERVER – Cycle Clipboard Ring in SSMS – SQL in Sixty Seconds #045 – Video
2420 Feb 27, 2013 SQL SERVER – Beginning SQL 2012 – Spatial Unions and Collections – Abstract from Joes 2 Pros Volume 3
2419 Feb 26, 2013 SQL SERVER – Beginning SQL 2012 – Aggregation Functions – Abstract from Joes 2 Pros Volume 2
2418 Feb 25, 2013 SQL SERVER – Beginning SQL 2012 – Why we use Code Comments – Abstract from Joes 2 Pros Volume 1
2417 Feb 24, 2013 SQL SERVER – Cumulative Update Released in February 2013 for SQL Server Editions
2416 Feb 23, 2013 SQL SERVER – Weekly Series – Memory Lane – #017
2415 Feb 22, 2013 SQL SERVER – T-SQL Script to Keep CPU Busy
2414 Feb 21, 2013 SQL SERVER – Shortcut to SELECT only 1 Row from Table
2413 Feb 20, 2013 SQL SERVER – Restore SQL Database using SSMS – SQL in Sixty Seconds #044 – Video
2412 Feb 19, 2013 SQLAuthority News – Introduction to ColdFusion – Video Tutorial on Pluralsight
2411 Feb 18, 2013 SQLAuthority News – NuoDB Announces Webinar Series To Demystify Cloud Data Management
2410 Feb 17, 2013 SQL SERVER – Fix : Error – sqljdbc_auth.dll Issue – com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host localhost, port 1433 has failed
2409 Feb 16, 2013 SQL SERVER – Weekly Series – Memory Lane – #016
2408 Feb 15, 2013 SQLAuthority News – Presenting at Sarasota IT Pro Camp, Florida on February 16, 2013
2407 Feb 14, 2013 SQL SERVER – Development Productivity Tool – dbForge Studio for SQL Server
2406 Feb 13, 2013 SQL SERVER – Get SQL Server Version and Edition Information – SQL in Sixty Seconds #043 – Video
2405 Feb 12, 2013 SQL SERVER – An Interesting Case of Redundant Indexes – Index on Col1 and Included Columns Col2 and Col3 – Part 5
2404 Feb 11, 2013 SQL SERVER – What is Semantics Model – A Simple Explanation
2403 Feb 10, 2013 SQL SERVER – Primary Key and NonClustered Index in Simple Words
2402 Feb 09, 2013 SQL SERVER – Weekly Series – Memory Lane – #015
2401 Feb 08, 2013 SQL SERVER – Backup and Restore Database Using Command Prompt – SQLCMD
2400 Feb 07, 2013 SQLAuthority News – Delhi Flash Mob and Women Safety – 2400th Blog Post – A Milestone
2399 Feb 06, 2013 SQL SERVER – Generate Random Values – SQL in Sixty Seconds #042 – Video
2398 Feb 05, 2013 SQL SERVER – Fix: Error: 1505 The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name and the index name
2397 Feb 04, 2013 SQL SERVER – Fix Error: 8111 – Cannot define PRIMARY KEY constraint on nullable column in table – Error: 1750 – Could not create constraint. See previous errors
2396 Feb 03, 2013 SQLAuthority News – Reset Messaging (SMS/Text) Icon Count in Android Jelly Bean
2395 Feb 02, 2013 SQL SERVER – Weekly Series – Memory Lane – #014
2394 Feb 01, 2013 SQL SERVER – Difference Between NOLOCK and NOWAIT Hints
2393 Jan 31, 2013 SQL SERVER – Significance of Table Input Parameter to Stored Procedure – Guest Post by Vikas Munjal – Koenig Solutions
2392 Jan 30, 2013 SQL SERVER – Autocomplete and Code Formatting Tool – SQL in Sixty Seconds #041 – Video
2391 Jan 29, 2013 SQL SERVER – Contest to Win Amazon Card – Experience Cloud Data Management System (CDMS) and NuoDB
2390 Jan 28, 2013 SQL SERVER – Basic Explanation of SET LOCK_TIMEOUT – How to Not Wait on Locked Query
2389 Jan 27, 2013 SQLAuthority News – Developing Multi-tenant Applications for the Cloud, 3rd Edition – Book Download
2388 Jan 26, 2013 SQL SERVER – Weekly Series – Memory Lane – #013
2387 Jan 25, 2013 SQL SERVER – Basic Explanation of Query Hint NOWAIT – How to Not Wait on Locked Query
2386 Jan 24, 2013 SQL SERVER – How to Use Instead of Trigger – Guest Post by Vikas Munjal – Koenig Solutions
2385 Jan 23, 2013 SQL SERVER – TRIM Function to Remove Leading and Trailing Spaces of String – SQL in Sixty Seconds #040 – Video
2384 Jan 22, 2013 SQLAuthority News – Great Experience at SharePoint Conference Singapore 2013
2383 Jan 21, 2013 SQL SERVER – Best Practices to Store the SQL Server Backups
2382 Jan 20, 2013 SQLAuthority News – Download Whitepaper – Introducing the BI Semantic Model in Microsoft SQL Server 2012
2381 Jan 19, 2013 SQL SERVER – Weekly Series – Memory Lane – #012
2380 Jan 18, 2013 SQL SERVER – A List of Various SQL Server RTM and Service Pack Number
2379 Jan 17, 2013 SQL SERVER – An Interesting Case of Redundant Indexes – Index on Col1, Col2 and Index on Col1, Col2, Col3 – Part 4
2378 Jan 16, 2013 SQL SERVER – Send Email From SQL Server – Configure Database Mail – SQL in Sixty Seconds #039 – Video
2377 Jan 15, 2013 SQL SERVER – Introduction of Showplan Warning
2376 Jan 14, 2013 SQLAuthority News – Attending SQLskills Training in February 2013
2375 Jan 13, 2013 SQLAuthority News – Download Whitepaper – SSIS Operational and Tuning Guide – SSIS for Azure and Hybrid Data Movement – Leveraging a Hadoop cluster from SSIS
2374 Jan 12, 2013 SQL SERVER – Weekly Series – Memory Lane – #011
2373 Jan 11, 2013 SQL SERVER – An Interesting Case of Redundant Indexes – Index on Col1, Col2 and Index on Col1, Col2, Col3 – Part 3
2372 Jan 10, 2013 SQLAuthority News – Speaking at Southeast Asia SharePoint Conference 2013 – Singapore
2371 Jan 09, 2013 SQL SERVER – How to Hide Yourself from SQL Server? – Guest Post by Balmukund Lakhani
2370 Jan 08, 2013 SQL Server – Using SSMS Commandline Parameters – Guest Post by Vinod Kumar M
2369 Jan 08, 2013 SQLAuthority News – Register for NuoDB the Elastically Scalable, SQL/ACID Database
2368 Jan 07, 2013 SQL SERVER – An Interesting Case of Redundant Indexes – Index on Col1, Col2 and Index on Col1, Col2, Col3 – Part 2
2367 Jan 06, 2013 SQLAuthority News – Download Whitepaper – Cleanse and Match Master Data by Using EIM
2366 Jan 05, 2013 SQL SERVER – Weekly Series – Memory Lane – #010
2365 Jan 04, 2013 SQL SERVER – An Interesting Case of Redundant Indexes – Index on Col1, Col2 and Index on Col1, Col2, Col3 – Part 1
2364 Jan 03, 2013 SQLAuthority News – Year 2012 in Review – Perspective of Blog
2363 Jan 02, 2013 SQL SERVER – Wrap SQL Code in SSMS – SQL in Sixty Seconds #038 – Video
2362 Jan 01, 2013 SQLAuthority News – Resolutions of Year 2013 – Commitment to Myself
2361 Dec 31, 2012 SQLAuthority News – Last Post of Year 2012
2360 Dec 30, 2012 SQL SERVER – Fix: Error: The conversion returned status value 2 and status text “The value could not be converted because of a potential loss of data.”. (SQL Server Import and Export Wizard)
2359 Dec 29, 2012 SQL SERVER – Weekly Series – Memory Lane – #009
2358 Dec 28, 2012 SQLAuthority News – NuoDB RC2 Available to Download – General Availability in Near Future
2357 Dec 27, 2012 SQL SERVER – Creating Database with Different Collation on Server
2356 Dec 26, 2012 SQL SERVER – Take Database Backup using SSMS – SQL in Sixty Seconds #037 – Video
2355 Dec 25, 2012 SQL SERVER – Restoring 2012 Database to 2008 or 2005 Version and 2 other Most Asked Questions
2354 Dec 24, 2012 SQL SERVER – Fix – Error: 4214: BACKUP LOG cannot be performed because there is no current database backup.
2353 Dec 23, 2012 SQL SERVER – What is Hekaton? – Simple Words Explanation
2352 Dec 22, 2012 SQL SERVER – Weekly Series – Memory Lane – #008
2351 Dec 21, 2012 SQLAuthority News – Chrome Browser – Personal Technology
2350 Dec 20, 2012 SQL SERVER – Difference Between CURRENT_TIMESTAMP and GETDATE() – CURRENT_TIMESTAMP Equivalent in SQL Server
2349 Dec 19, 2012 SQL SERVER – Select and Delete Duplicate Records – SQL in Sixty Seconds #036 – Video
2348 Dec 18, 2012 SQL SERVER – Select the Most Optimal Backup Methods for Server
2347 Dec 17, 2012 SQL SERVER – Auto Complete and Format T-SQL Code – Devart SQL Complete
2346 Dec 16, 2012 SQLAuthority News – First SQL Bangalore Event Report – Nov 24, 2012 – SQL Server User Group Bangalore
2345 Dec 15, 2012 SQL SERVER – Weekly Series – Memory Lane – #007
2344 Dec 14, 2012 SQL Contest – Result of Cartoon Contest
2343 Dec 13, 2012 SQLAuthority News – Speaking at Southeast Asia SharePoint Conference 2013 – Singapore
2342 Dec 12, 2012 SQL SERVER – Inviting Ideas for SQL in Sixty Seconds – 12/12/12
2341 Dec 11, 2012 SQL SERVER – Asynchronous Update and Timestamp – Check if Row Values are Changed Since Last Retrieve
2340 Dec 10, 2012 SQL SERVER – Get 2 of My Books FREE at Koenig Tech Day – Where Technologies Converge!
2339 Dec 09, 2012 SQL Authority News – Download SQL Server Data Type Conversion Chart
2338 Dec 08, 2012 SQL SERVER – Weekly Series – Memory Lane – #006
2337 Dec 07, 2012 SQLAuthority News – Technology and Online Learning – Personal Technology Tip
2336 Dec 06, 2012 SQL SERVER – Caption the Cartoon Contest – Last 2 Days
2335 Dec 05, 2012 SQL SERVER – Concat Strings in SQL Server using T-SQL – SQL in Sixty Seconds #035 – Video
2334 Dec 04, 2012 SQL SERVER – Fix: Error : 402 The data types ntext and varchar are incompatible in the equal to operator
2333 Dec 03, 2012 SQL SERVER – Fix Error: Microsoft OLE DB Provider for SQL Server error ‘80040e07′ or Microsoft SQL Native Client error ‘80040e07′
2332 Dec 02, 2012 SQL SERVER – Find Referenced or Referencing Object in SQL Server using sys.sql_expression_dependencies
2331 Dec 01, 2012 SQL SERVER – Weekly Series – Memory Lane – #005
2330 Nov 30, 2012 SQL SERVER – Fix Visual Studio Error : Connections to SQL Server files (.mdf) require SQL Server Express 2005 to function properly. Please verify the installation of the component or download from the URL
2329 Nov 29, 2012 SQL Contest – Win USD 300 Worth Gift – Cartoon Contest is Back
2328 Nov 28, 2012 SQL SERVER – Auto Recovery File Settings in SSMS – SQL in Sixty Seconds #034 – Video
2327 Nov 27, 2012 SQL SERVER – Shard No More – An Innovative Look at Distributed Peer-to-peer SQL Database
2326 Nov 26, 2012 SQL SERVER – Sends backups to a Network Folder, FTP Server, Dropbox, Google Drive or Amazon S3
2325 Nov 25, 2012 SQL SERVER – Find Weekend and Weekdays from Datetime in SQL Server 2012
2324 Nov 24, 2012 SQL SERVER – Weekly Series – Memory Lane – #004
2323 Nov 23, 2012 SQLAuthority News – Android Efficiency Tips and Tricks – Personal Technology Tip
2322 Nov 22, 2012 SQL SERVER – Removing Leading Zeros From Column in Table – Part 2
2321 Nov 21, 2012 SQL SERVER – Display Datetime in Specific Format – SQL in Sixty Seconds #033 – Video
2320 Nov 20, 2012 SQL SERVER – Using RAND() in User Defined Functions (UDF)
2319 Nov 19, 2012 SQL SERVER – Removing Leading Zeros From Column in Table
2318 Nov 18, 2012 SQLAuthority News – Microsoft SQL Server 2012 Service Pack 1 Released (SP1)
2317 Nov 17, 2012 SQL SERVER – Weekly Series – Memory Lane – #003
2316 Nov 16, 2012 SQL SERVER – Retrieving Random Rows from Table Using NEWID()
2315 Nov 15, 2012 SQL SERVER – Concurrency Basics – Guest Post by Vinod Kumar
2314 Nov 14, 2012 SQL SERVER – Rename Columnname or Tablename – SQL in Sixty Seconds #032 – Video
2313 Nov 13, 2012 SQLAuthority News – Happy Deepavali and Happy New Year
2312 Nov 12, 2012 SQL SERVER – Get Free Books on While Learning SQL Server 2012 Error Handling
2311 Nov 11, 2012 SQL SERVER – Changing Default Installation Path for SQL Server
2310 Nov 10, 2012 SQL SERVER – Beginning New Weekly Series – Memory Lane – #002
2309 Nov 09, 2012 SQLAuthority News – #SQLPASS 2012 Book Signing Photos
2308 Nov 08, 2012 SQLAuthority News – Learning, Community and Book Signing at #SQLPASS 2012
2307 Nov 07, 2012 SQLAuthority News – 2 New Books – FREE Books and Book Signing at #SQLPASS 2012
2306 Nov 06, 2012 SQLAuthority News – #SQLPASS 2012 Schedule – Where can You Find Me
2305 Nov 05, 2012 SQLAuthority News – #SQLPASS 2012 Seattle Update – Memorylane 2009, 2010, 2011
2304 Nov 04, 2012 SQLAuthority News – Why I am Going to Attend #SQLPASS Summit 2012 – Seattle
2303 Nov 03, 2012 SQL SERVER – Beginning New Weekly Series – Memory Lane – #001
2302 Nov 02, 2012 SQL SERVER – Function to Round Up Time to Nearest Minutes Interval
2301 Nov 01, 2012 SQLAuthority News – 6th Anniversary and 50 Million Views and Over 2300 Blog Posts – Thank You Thank You
2300 Oct 31, 2012 SQL SERVER – Copy Data from One Table to Another Table – SQL in Sixty Seconds #031 – Video
2299 Oct 30, 2012 SQL SERVER – UNION ALL and ORDER BY – How to Order Table Separately While Using UNION ALL
2298 Oct 29, 2012 SQLAuthority News – Windows Efficiency Tricks and Tips – Personal Technology Tip
2297 Oct 28, 2012 SQL SERVER – Move Database Files MDF and LDF to Another Location
2296 Oct 27, 2012 SQL SERVER – Storing Variable Values in Temporary Array or Temporary List
2295 Oct 26, 2012 SQL SERVER – Introduction to Big Data – Guest Post
2294 Oct 25, 2012 SQL SERVER – Last Two Days to Get FREE Book – Joes 2 Pros Certification 70-433
2293 Oct 24, 2012 SQL SERVER – Resolving SQL Server Connection Errors – SQL in Sixty Seconds #030 – Video
2292 Oct 23, 2012 SQL SERVER – Order By Numeric Values Formatted as String
2291 Oct 22, 2012 SQL SERVER – Vacation, Travel and Study – A New Concept
2290 Oct 21, 2012 SQLAuthority News – Windows Azure Training Kit Updated October 2012
2289 Oct 20, 2012 SQLAuthority News – Who I Am And How I Got Here – True Story as Blog Post
2288 Oct 19, 2012 SQLAuthority News – Storing Data and Files in Cloud – Dropbox – Personal Technology Tip
2287 Oct 18, 2012 SQL SERVER – Finding Different ColumnName From Almost Identitical Tables
2286 Oct 17, 2012 SQLAuthority News – Pluralsight Course Review – Practices for Software Startups – Part 2 of 2
2285 Oct 16, 2012 SQLAuthority News – Pluralsight Course Review – Practices for Software Startups – Part 1 of 2
2284 Oct 15, 2012 SQL SERVER – Free Print Book on SQL Server Joes 2 Pros Kit
2283 Oct 14, 2012 SQL SERVER – Find First Non-Numeric Character from String
2282 Oct 13, 2012 SQL SERVER – 2012 – List All The Column With Specific Data Types in Database
2281 Oct 12, 2012 SQL SERVER – Advanced Data Quality Services with Melissa Data – Azure Data Market
2280 Oct 11, 2012 SQLAuthority News – Amazon Gift Card Raffle for Beta Tester Feedback for NuoDB
2279 Oct 10, 2012 SQL SERVER – Identify Most Resource Intensive Queries – SQL in Sixty Seconds #029 – Video
2278 Oct 09, 2012 SQL SERVER – Identify Numbers of Non Clustered Index on Tables for Entire Database
2277 Oct 09, 2012 SQLAuthority News – A Conversation with an Old Friend – Sri Sridharan
2276 Oct 08, 2012 SQL SERVER – Recover the Accidentally Renamed Table
2275 Oct 07, 2012 SQLAuthority News – Download Whitepaper – SQL Server Analysis Services to Hive
2274 Oct 06, 2012 SQL SERVER – Manage Help Settings – CTRL + ALT + F1
2273 Oct 05, 2012 SQL SERVER – 3 Online SQL Courses at Pluralsight and Free Learning Resources
2272 Oct 04, 2012 SQL SERVER – Importance of User Without Login – T-SQL Demo Script
2271 Oct 03, 2012 SQL SERVER – Identify Most Resource Intensive Queries – SQL in Sixty Seconds #028 – Video
2270 Oct 02, 2012 SQL SERVER – Solution – 2 T-SQL Puzzles – Display Star and Shortest Code to Display 1
2269 Oct 01, 2012 SQLAuthority News – Follow up on – Replace a Column Name in Multiple Stored Procedure all together
2268 Sep 30, 2012 SQL SERVER – Preserve Leading Zero While Coping to Excel from SSMS
2267 Sep 29, 2012 SQL SERVER – Importance of User Without Login
2266 Sep 28, 2012 SQL SERVER – A Picture is Worth a Thousand Words – A Collection of Inspiring and Funny Posts by Vinod Kumar
2265 Sep 27, 2012 SQL SERVER – Not Possible – Delete From Multiple Table – Update Multiple Table in Single Statement
2264 Sep 26, 2012 SQL SERVER – Copy Column Headers from Resultset – SQL in Sixty Seconds #027 – Video
2263 Sep 25, 2012 SQL SERVER – Basic Calculation and PEMDAS Order of Operation
2262 Sep 24, 2012 SQL SERVER – Excel Losing Decimal Values When Value Pasted from SSMS ResultSet
2261 Sep 23, 2012 SQLAuthority News – Download SQL Server 2012 SP1 CTP4
2260 Sep 22, 2012 SQL SERVER – Validating Unique Columnname Across Whole Database
2259 Sep 21, 2012 SQL SERVER – Replace a Column Name in Multiple Stored Procedure all together
2258 Sep 20, 2012 SQL SERVER – 2 T-SQL Puzzles and Win USD 50 worth Amazon Gift Card and 25 Other Prizes
2257 Sep 19, 2012 SQL SERVER – Effect of Collation on Resultset – SQL in Sixty Seconds #026 – Video
2256 Sep 18, 2012 SQL SERVER – SSMS Automatically Generates TOP (100) PERCENT in Query Designer
2255 Sep 17, 2012 SQL SERVER – Guest Post by Sandip Pani – SQL Server Statistics Name and Index Creation
2254 Sep 16, 2012 SQLAuthority News – Download Whitepaper – Power View Infrastructure Configuration and Installation: Step-by-Step and Scripts
2253 Sep 15, 2012 SQL SERVER – Download Microsoft SQL Server Compact 4.0 SP1
2252 Sep 14, 2012 SQL SERVER – Grouping by Multiple Columns to Single Column as A String
2251 Sep 13, 2012 SQL SERVER – Core Concepts – Elasticity, Scalability and ACID Properties – Exploring NuoDB an Elastically Scalable Database System
2250 Sep 12, 2012 SQL SERVER – Get Date and Time From Current DateTime – SQL in Sixty Seconds #025 – Video
2249 Sep 11, 2012 SQL SERVER – Why Do We Need Master Data Management – Importance and Significance of Master Data Management (MDM)
2248 Sep 10, 2012 SQL SERVER – Why Do We Need Data Quality Services – Importance and Significance of Data Quality Services (DQS)
2247 Sep 09, 2012 SQL SERVER – Configuring Interactive Cleansing Suggestion Min Score for Suggestions in Data Quality Services (DQS) – Sensitivity of Suggestion
2246 Sep 08, 2012 SQL SERVER – Unable to DELETE Project in Data Quality Projects (DQS)
2245 Sep 07, 2012 SQL SERVER – Fun Post – Connecting Same SQL Server using Different Methods
2244 Sep 06, 2012 SQL SERVER – FIX ERROR – Cannot connect to . Login failed. The login is from an untrusted domain and cannot be used with Windows authentication. (Microsoft SQL Server, Error: 18452)
2243 Sep 05, 2012 SQLAuthority News – A Quick Note on @Pluralsight Video – Call Me Maybe Developer Way
2242 Sep 04, 2012 SQL SERVER – Step by Step Guide to Beginning Data Quality Services in SQL Server 2012 – Introduction to DQS
2241 Sep 03, 2012 SQL SERVER – DQS Error – Cannot connect to server – A .NET Framework error occurred during execution of user-defined routine or aggregate “SetDataQualitySessions” – SetDataQualitySessionPhaseTwo
2240 Sep 02, 2012 SQLAuthority News – Weekend Experiment with NuoDB – Points to Pondor and Whitepaper
2239 Sep 01, 2012 SQLAuthority News – Memories at Anniversary of SQL Wait Stats Book
2238 Aug 31, 2012 SQL SERVER – Error: Fix – Msg 208 – Invalid object name ‘dbo.backupset’ – Invalid object name ‘dbo.backupfile’
2237 Aug 30, 2012 SQL SERVER – Beginning of SQL Server Architecture – Terminology – Guest Post
2236 Aug 29, 2012 SQL SERVER – Three Methods to Insert Multiple Rows into Single Table – SQL in Sixty Seconds #024 – Video
2235 Aug 28, 2012 SQL SERVER – A Brief Note on SET TEXTSIZE
2234 Aug 27, 2012 SQL SERVER – Answer – Value of Identity Column after TRUNCATE command
2233 Aug 26, 2012 SQL SERVER – Download PSSDIAG Data Collection Utility
2232 Aug 25, 2012 SQLAuthority News – Featuring in Call Me Maybe The Developer Way – Pluralsight Video
2231 Aug 24, 2012 SQL SERVER – DELETE, TRUNCATE and RESEED Identity
2230 Aug 23, 2012 SQL SERVER – Reseting Identity Values for All Tables
2229 Aug 22, 2012 SQL SERVER – Color Coding SQL Server Management Studio Status Bar – SQL in Sixty Seconds #023 – Video
2228 Aug 21, 2012 SQL SERVER – Installing Data Quality Services (DQS) on SQL Server 2012
2227 Aug 20, 2012 SQL SERVER – Winners – Contest Win Joes 2 Pros Combo (USD 198)
2226 Aug 19, 2012 SQLAuthority News – 2 Security Updates for SQL Server 2000 SP 4 Users
2225 Aug 18, 2012 SQLAuthority News – Presented at Bangalore DevCon August 4, 2012
2224 Aug 17, 2012 SQL SERVER – Curious Case of Disappearing Rows – ON UPDATE CASCADE and ON DELETE CASCADE – T-SQL Example – Part 2 of 2
2223 Aug 16, 2012 SQL SERVER – Curious Case of Disappearing Rows – ON UPDATE CASCADE and ON DELETE CASCADE – Part 1 of 2
2222 Aug 15, 2012 SQLAuthority News – Technical Review of Learning at Koenig Solutions
2221 Aug 14, 2012 SQLAuthority News – Learning Trip – Traveling to Learn SQL Server
2220 Aug 13, 2012 SQLAuthority News – Getting Ready to Learn SQL Server
2219 Aug 12, 2012 SQL SERVER – ERROR: FIX using Compatibility Level – Database diagram support objects cannot be installed because this database does not have a valid owner – Part 2
2218 Aug 11, 2012 SQL SERVER – Contest – Summary of 5 Day and Additional Information
2217 Aug 10, 2012 SQL SERVER – Understanding XML – Contest Win Joes 2 Pros Combo (USD 198) – Day 5 of 5
2216 Aug 09, 2012 SQL SERVER – Expanding Views – Contest Win Joes 2 Pros Combo (USD 198) – Day 4 of 5
2215 Aug 08, 2012 SQL SERVER – Clustered Index and Primary Key – Contest Win Joes 2 Pros Combo (USD 198) – Day 3 of 5
2214 Aug 07, 2012 SQL SERVER – Identity Fields – Contest Win Joes 2 Pros Combo (USD 198) – Day 2 of 5
2213 Aug 06, 2012 SQL SERVER – Query Hint – Contest Win Joes 2 Pros Combo (USD 198) – Day 1 of 5
2212 Aug 05, 2012 SQLAuthority News – Microsoft Whitepaper – AlwaysOn Solution Guide: Offloading Read-Only Workloads to Secondary Replicas
2211 Aug 04, 2012 SQL SERVER – Fix: Error: 8117: Operand data type bit is invalid for sum operator
2210 Aug 03, 2012 SQLAuthority News – Learning Never Ends – Becoming Student Again
2209 Aug 02, 2012 SQL SERVER – Beginning of SQL Server Security – Guest Post
2208 Aug 01, 2012 SQL SERVER – 5 Videos from Joes 2 Pros Series Exam Prep Series 70-433 – SQL in Sixty Seconds
2207 Aug 01, 2012 SQL SERVER – Follow up on Beginning NuoDB – Who will Benefit and How to Start – Part 2
2206 Jul 31, 2012 SQL SERVER – Beginning NuoDB – Who will Benefit and How to Start
2205 Jul 30, 2012 SQLAuthority News – A Year Older and 3 SQL Server Books and 3 Video Courses – 33
2204 Jul 29, 2012 SQL SERVER – Services Pack 2 for SQL Server 2008 R2 – Microsoft SQL Server 2008 R2 Service Pack 2
2203 Jul 28, 2012 SQL SERVER – Difference Between ORIGINAL_LOGIN() and SUSER_SNAME()
2202 Jul 27, 2012 SQL SERVER – Query to Get Unique Distinct Data Based on Condition – Eliminate Duplicate Data from Resultset
2201 Jul 26, 2012 SQL SERVER – Answer – How to Convert Hex to Decimal or INT
2200 Jul 25, 2012 SQL SERVER – How do I Record Video and Webcast – Milestone – 2200th Blog Post – SQL in Sixty Seconds #022 – Video
2199 Jul 24, 2012 SQLAuthority Guest Post – Lessons from Life and Work – Power in the Workplace – Srini Chandra (Author of 3 Lives, in search of bliss)
2198 Jul 23, 2012 SQL SERVER – Observation of Top with Index and Order of Resultset
2197 Jul 22, 2012 SQLAuthority News – 2 SQL Server Documentations Updates
2196 Jul 21, 2012 SQL SERVER – Download SQL Server 2012 Developer Training Kit – Update July 2012
2195 Jul 20, 2012 SQL SERVER – INFORMATION_SCHEMA.COLUMNS and Value Character Maximum Length -1
2194 Jul 19, 2012 SQL SERVER – Find Column Used in Stored Procedure – Search Stored Procedure for Column Name – Part 2
2193 Jul 18, 2012 SQL SERVER – Generate Script for Schema and Data – SQL in Sixty Seconds #021 – Video
2192 Jul 17, 2012 SQLAuthority Guest Post – Lessons from Life – Practice Let Go – Srini Chandra (Author of 3 Lives, in search of bliss)
2191 Jul 16, 2012 SQL SERVER – 2012 Functions – FORMAT() and CONCAT() – An Interesting Usage
2190 Jul 15, 2012 SQL SERVER – Find Column Used in Stored Procedure – Search Stored Procedure for Column Name
2189 Jul 14, 2012 SQL SERVER – Example of Width Sensitive and Width Insensitive Collation
2188 Jul 13, 2012 SQL SERVER – Switch Between Two Parenthesis using Shortcut CTRL+]
2187 Jul 12, 2012 SQL SERVER – Effect of Case Sensitive Collation on Resultset
2186 Jul 11, 2012 SQL SERVER – Remove Debug Button in SSMS – SQL in Sixty Seconds #020 – Video
2185 Jul 10, 2012 SQLAuthority Guest Post – Lessons from Life and Work by Srini Chandra (Author of 3 Lives, in search of bliss)
2184 Jul 09, 2012 SQL SERVER – Monday Morning Puzzle – Query Returns Results Sometimes but Not Always
2183 Jul 08, 2012 SQLAuthority News – 2 Whitepapers Announced – AlwaysOn Architecture Guide: Building a High Availability and Disaster Recovery Solution
2182 Jul 07, 2012 SQL SERVER – CTRL+SHIFT+] Shortcut to Select Code Between Two Parenthesis
2181 Jul 06, 2012 SQL SERVER – NTFS File System Performance for SQL Server
2180 Jul 05, 2012 SQL SERVER – Retrieve SQL Server Installation Date Time
2179 Jul 04, 2012 SQL SERVER – Tricks to Comment T-SQL in SSMS – SQL in Sixty Seconds #019 – Video
2178 Jul 03, 2012 SQL SERVER – Monitoring SQL Server Database Transaction Log Space Growth – DBCC SQLPERF(logspace) – Puzzle for You
2177 Jul 02, 2012 SQL SERVER – Weekend Project – Visiting Friend’s Company – Koenig Solutions
2176 Jul 01, 2012 SQL SERVER – Discard Results After Query Execution – SSMS
2175 Jun 30, 2012 SQL SERVER – Validating Spatial Object as NULL using IsNULL
2174 Jun 29, 2012 SQL SERVER – Validating Spatial Object with IsValidDetailed Function
2173 Jun 28, 2012 SQL SERVER – Fix : Error 3623 – An invalid floating point operation occurred
2172 Jun 27, 2012 SQL SERVER – Powershell – Importing CSV File Into Database – Video
2171 Jun 26, 2012 SQL SERVER – Weekend Project – Experimenting with ACID Transactions, SQL Compliant, Elastically Scalable Database
2170 Jun 25, 2012 SQL SERVER – Template Browser – A Very Important and Useful Feature of SSMS
2169 Jun 24, 2012 SQL SERVER – Download SQL Server Product Documentation
2168 Jun 23, 2012 SQL SERVER – Introduction to Function SIGN
2167 Jun 22, 2012 SQL SERVER – Follow up – Usage of $rowguid and $IDENTITY
2166 Jun 21, 2012 SQL SERVER – ColumnStore Index – Batch Mode vs Row Mode
2165 Jun 20, 2012 SQL SERVER – Importing CSV File Into Database – SQL in Sixty Seconds #018 – Video
2164 Jun 19, 2012 SQL SERVER – Solution – User Not Able to See Any User Created Object in Tables – Security and Permissions Issue
2163 Jun 18, 2012 SQL SERVER – Identifying Column Data Type of uniqueidentifier without Querying System Tables
2162 Jun 17, 2012 SQL SERVER – Read Only Files and SQL Server Management Studio (SSMS)
2161 Jun 16, 2012 SQL SERVER – Simple Explanation and Puzzle with SOUNDEX Function and DIFFERENCE Function
2160 Jun 15, 2012 SQL SERVER – Free eBook Download – EPUB, MOBI, PDF Format
2159 Jun 14, 2012 SQL SERVER – Solution of Puzzle – Swap Value of Column Without Case Statement
2158 Jun 13, 2012 SQL SERVER – Video – Beginning Performance Tuning with SQL Server Execution Plan
2157 Jun 12, 2012 SQL SERVER – A Quick Look at Logging and Ideas around Logging
2156 Jun 11, 2012 SQL SERVER – Developer Training Resources and Summary Roundup
2155 Jun 10, 2012 SQL SERVER – Finding Size of a Columnstore Index Using DMVs
2154 Jun 09, 2012 SQL SERVER – Service Broker and CAP_CPU_PERCENT – Limiting SQL Server Instances to CPU Usage
2153 Jun 08, 2012 SQL SERVER – A Puzzle – Swap Value of Column Without Case Statement
2152 Jun 07, 2012 SQL SERVER – Load Generator – Free Tool From CodePlex
2151 Jun 06, 2012 SQL SERVER – Tricks to Replace SELECT * with Column Names – SQL in Sixty Seconds #017 – Video
2150 Jun 05, 2012 SQL SERVER – Fix: Error: 10920 Cannot drop user-defined function. It is being used as a resource governor classifier
2149 Jun 04, 2012 SQL SERVER – Simple Example to Configure Resource Governor – Introduction to Resource Governor
2148 Jun 03, 2012 SQL SERVER – Fix: Error: 147 An aggregate may not appear in the WHERE clause unless it is in a subquery contained in a HAVING clause or a select list, and the column being aggregated is an outer reference
2147 Jun 02, 2012 SQL SERVER – A Puzzle Part 4 – Fun with SEQUENCE in SQL Server 2012 – Guess the Next Value
2146 Jun 01, 2012 Developer Training – A Conclusive Summary- Part 5
2145 May 31, 2012 Developer Training – Various Options for Maximum Benefit – Part 4
2144 May 30, 2012 Developer Training – Difficult Questions and Alternative Perspective – Part 3
2143 May 29, 2012 Developer Training – Employee Morals and Ethics – Part 2
2142 May 28, 2012 Developer Training – Importance and Significance – Part 1
2141 May 27, 2012 SQL SERVER – A Puzzle Part 3 – Fun with SEQUENCE in SQL Server 2012 – Guess the Next Value
2140 May 26, 2012 SQL SERVER – A Puzzle Part 2 – Fun with SEQUENCE in SQL Server 2012 – Guess the Next Value
2139 May 25, 2012 SQL SERVER – A Puzzle – Fun with SEQUENCE in SQL Server 2012 – Guess the Next Value
2138 May 24, 2012 SQL SERVER – A Puzzle – Fun with NULL – Fix Error 8117
2137 May 23, 2012 SQL SERVER – Standard Reports from SQL Server Management Studio – SQL in Sixty Seconds #016 – Video
2136 May 22, 2012 SQL SERVER – SmallDateTime and Precision – A Continuous Confusion
2135 May 21, 2012 SQL SERVER – Renaming Index – Index Naming Conventions
2134 May 20, 2012 SQL SERVER – New Look for CodePlexProject – Hosting for Open Source Software
2133 May 19, 2012 SQL SERVER – Saturday Fun Puzzle with SQL Server DATETIME2 and CAST
2132 May 18, 2012 SQL SERVER – Thinking about Deprecated, Discontinued Features and Breaking Changes while Upgrading to SQL Server 2012 – Guest Post by Nakul Vachhrajani
2131 May 17, 2012 SQLAuthority News – SQL Server 2012 Upgrade Technical Guide – A Comprehensive Whitepaper – (454 pages – 9 MB)
2130 May 16, 2012 SQL SERVER – SQL in Sixty Seconds – 5 Videos from Joes 2 Pros Series – SQL Exam Prep Series 70-433
2129 May 15, 2012 SQL SERVER – Get Schema Name from Object ID using OBJECT_SCHEMA_NAME
2128 May 14, 2012 SQL SERVER – Columnstore Index and sys.dm_db_index_usage_stats
2127 May 13, 2012 SQLAuthority News – Download Whitepaper – Choosing a Tabular or Multidimensional Modeling Experience in SQL Server 2012 Analysis Services
2126 May 12, 2012 SQL SERVER – Developer Training Kit for SQL Server 2012
2125 May 11, 2012 SQL SERVER – Quiz and Video – Introduction to Discovering XML Data Type Methods
2124 May 10, 2012 SQL SERVER – Quiz and Video – Introduction to SQL Error Actions
2123 May 09, 2012 SQL SERVER – Quiz and Video – Introduction to Basics of a Query Hint
2122 May 08, 2012 SQL SERVER – Quiz and Video – Introduction to Hierarchical Query using a Recursive CTE
2121 May 07, 2012 SQL SERVER – Quiz and Video – Introduction to SQL Server Security
2120 May 06, 2012 SQL SERVER – Four Tutorial for SQL Server 2012 New Features
2119 May 05, 2012 SQL SERVER – Migrate a SQL Server Reports from one server to another server
2118 May 04, 2012 SQL SERVER – Identify Columnstore Index Usage from Execution Plan
2117 May 03, 2012 SQL SERVER – A Tricky Question and Even Trickier Answer – Index Intersection – Partition Function
2116 May 02, 2012 SQL SERVER – Video – Step by Step Installation of SQL Server 2012
2115 May 01, 2012 SQL SERVER – Maximum Allowable Length of Characters for Temp Objects is 116 – Guest Post by Balmukund Lakhani
2114 Apr 30, 2012 SQL SERVER – A Brief Introduction to expressor Studio 3.6
2113 Apr 29, 2012 SQL SERVER – Microsoft Certification – SQL Server 2012
2112 Apr 28, 2012 SQLAuthority News – Migration Guide: Migrating to SQL Server 2012 Failover Clustering and Availability Groups from Prior Clustering and Mirroring Deployments – Part 1
2111 Apr 27, 2012 SQL SERVER – Introduction to Discovering XML Data Type Methods – A Primer
2110 Apr 26, 2012 SQL SERVER – Introduction to SQL Error Actions – A Primer
2109 Apr 25, 2012 SQL SERVER – Introduction to Basics of a Query Hint – A Primer
2108 Apr 24, 2012 SQL SERVER – Introduction to Hierarchical Query using a Recursive CTE – A Primer
2107 Apr 23, 2012 SQL SERVER – Introduction to SQL Server Security – A Primer
2106 Apr 22, 2012 SQLAuthority News – Fast Track Data Warehouse Reference Guide for SQL Server 2012
2105 Apr 21, 2012 SQL SERVER – Working with FileTables in SQL Server 2012 – Part 3 – Retrieving Various FileTable Properties
2104 Apr 20, 2012 SQL SERVER – Performance Tuning – Part 2 of 2 – Analysis, Detection, Tuning and Optimizing
2103 Apr 19, 2012 SQL SERVER – Performance Tuning – Part 1 of 2 – Getting Started and Configuration
2102 Apr 18, 2012 SQLAuthority News – Select the Best SQL in Sixty Seconds Episode – Help us Improve
2101 Apr 17, 2012 SQL SERVER – Cheatsheet – Released for SQL Server 2012 Edition
2100 Apr 16, 2012 SQLAuthority News – Presenting at Great Indian Developer Summit 2012 – SQL Server Misconception and Resolutions
2099 Apr 15, 2012 SQL SERVER – Working with FileTables in SQL Server 2012 – Part 2 – Methods to Insert Data Into Table
2098 Apr 14, 2012 SQL SERVER – Working with FileTables in SQL Server 2012 – Part 1 – Setting Up Environment
2097 Apr 13, 2012 SQLAuthority News – Social Media Series – LinkedIn and Professional Profile
2096 Apr 12, 2012 SQLAuthority News – Social Media Series – YouTube and Movies
2095 Apr 11, 2012 SQL SERVER – Installing AdventureWorks Sample Database – SQL in Sixty Seconds #010 – Video
2094 Apr 10, 2012 SQLAuthority News – Social Media Series – Facebook and Google+
2093 Apr 09, 2012 SQLAuthority News – Social Media Series – Twitter and Myself
2092 Apr 08, 2012 SQLAuthority News – Download SQL Azure Labs Codename “Data Explorer” Client
2091 Apr 07, 2012 SQL SERVER – DMV sys.dm_exec_describe_first_result_set_for_object – Describes the First Result Metadata for the Module
2090 Apr 06, 2012 SQLAuthority News – Reliving TechEd with Vinod Kumar at Bangalore User Groups
2089 Apr 05, 2012 SQLAuthority News – #TechEdIn – TechEd India 2012 Memories and Photos
2088 Apr 04, 2012 SQL SERVER – Cleaning Up SQL Server Indexes – Defragmentation, Fillfactor – Video
2087 Apr 03, 2012 SQL SERVER – FIX: ERROR Msg 5169, Level 16: FILEGROWTH cannot be greater than MAXSIZE for file
2086 Apr 02, 2012 SQL SERVER – Use ROLL UP Clause instead of COMPUTE BY
2085 Apr 01, 2012 SQL SERVER – A Puzzle – Illusion – Confusion – April Fools’ Day
2084 Mar 31, 2012 SQL SERVER – sp_describe_first_result_set New System Stored Procedure in SQL Server 2012
2083 Mar 30, 2012 SQL SERVER – Online Index Rebuilding Index Improvement in SQL Server 2012
2082 Mar 29, 2012 SQL SERVER – Difference between DATABASEPROPERTY and DATABASEPROPERTYEX
2081 Mar 28, 2012 SQL SERVER – T-SQL Constructs – *= and += – SQL in Sixty Seconds #009 – Video
2080 Mar 27, 2012 SQL SERVER – Right Aligning Numerics in SQL Server Management Studio (SSMS)
2079 Mar 26, 2012 SQL SERVER – Partition Parallelism Support in expressor 3.6
2078 Mar 25, 2012 SQL SERVER – Download Free eBook – Introducing Microsoft SQL Server 2012
2077 Mar 24, 2012 SQL SERVER – Transcript of Learning SQL Server Performance: Indexing Basics – Interview of Vinod Kumar by Pinal Dave
2076 Mar 23, 2012 SQL SERVER – Using MAXDOP 1 for Single Processor Query – SQL in Sixty Seconds #008 – Video
2075 Mar 22, 2012 SQL SERVER – #TechEdIn – Presenting Tomorrow on Speed Up! – Parallel Processes and Unparalleled Performance at TechEd India 2012
2074 Mar 21, 2012 SQL SERVER – Table Variables and Transactions – SQL in Sixty Seconds #007 – Video
2073 Mar 20, 2012 SQL SERVER – #TechEdIn – Presenting Tomorrow on SQL Server Misconception and Resolution with Vinod Kumar at TechEd India 2012
2072 Mar 19, 2012 SQLAuthority News – #TechEDIn – TechEd India 2012 – Things to Do and Explore for SQL Enthusiast
2071 Mar 18, 2012 SQL SERVER – Finding Shortest Distance between Two Shapes using Spatial Data Classes – Ramsetu or Adam’s Bridge
2070 Mar 17, 2012 SQL SERVER – TechEd India 2012 – Content, Speakers and a Lots of Fun
2069 Mar 16, 2012 SQL SERVER – SQL Server Misconceptions and Resolution – A Practical Perspective – TechEd 2012 India
2068 Mar 15, 2012 SQL SERVER – Install Samples Database Adventure Works for SQL Server 2012
2067 Mar 14, 2012 SQL SERVER – SQL Server Performance: Indexing Basics – SQL in Sixty Seconds #006 – Video
2066 Mar 13, 2012 SQL SERVER – Speed Up! – Parallel Processes and Unparalleled Performance – TechEd 2012 India
2065 Mar 12, 2012 SQL Server – Learning SQL Server Performance: Indexing Basics – Interview of Vinod Kumar by Pinal Dave
2064 Mar 11, 2012 SQL SERVER – 2012 – All Download Links in Single Page – SQL Server 2012
2063 Mar 10, 2012 SQLAuthority News – SQL Server 2012 – Microsoft Learning Training and Certification
2062 Mar 09, 2012 SQLAuthority News – Download Microsoft SQL Server 2012 RTM Now
2061 Mar 08, 2012 SQL Server – Learning SQL Server Performance: Indexing Basics – Video
2060 Mar 07, 2012 SQL SERVER – T-SQL Errors and Reactions – Demo – SQL in Sixty Seconds #005 – Video
2059 Mar 06, 2012 SQLAuthority News – TechED India 2012 – Bangalore – March 21-23, 2012
2058 Mar 05, 2012 SQL SERVER – Top 10 “Ease of Use” Features of expressor Studio
2057 Mar 04, 2012 SQL SERVER – Technical Reference Guides for Designing Mission-Critical Solutions – A Must Read
2056 Mar 03, 2012 SQL SERVER – Various Leap Year Logics
2055 Mar 02, 2012 SQL Server – SafePeak “Logon Trigger” Feature for Managing Data Access
2054 Mar 01, 2012 SQLAuthority News – The Best Quotes of “Who Wrote This?” Contest
2053 Feb 29, 2012 SQL SERVER – Function: Is Function – SQL in Sixty Seconds #004 – Video
2052 Feb 28, 2012 SQL SERVER – Detecting Leap Year in T-SQL using SQL Server 2012 – IIF, EOMONTH and CONCAT Function
2051 Feb 27, 2012 SQL SERVER – Identifying guest User using Policy Based Management
2050 Feb 26, 2012 SQL SERVER – Standards Support, Protocol, Data Portability – 3 Important SQL Server Documentations for Downloads
2049 Feb 25, 2012 SQL SERVER – A Cool Trick – Restoring the Default SQL Server Management Studio – SSMS
2048 Feb 24, 2012 SQL SERVER – guest User and MSDB Database – Enable guest User on MSDB Database
2047 Feb 23, 2012 SQL SERVER – Detecting guest User Permissions – guest User Access Status
2046 Feb 22, 2012 SQL SERVER – T-SQL Constructs – Declaration and Initialization – SQL in Sixty Seconds #003 – Video
2045 Feb 21, 2012 SQL SERVER – Force Removing User from Database – Fix: Error: Could not drop login ‘test’ as the user is currently logged in.
2044 Feb 20, 2012 SQL SERVER – Disable Guest Account – Serious Security Issue
2043 Feb 19, 2012 SQL SERVER – Migration Assistant for Oracle, MySQL, Sybase and Access v5.2
2042 Feb 18, 2012 SQL SERVER – Case Sensitive Database and Database User – Fix: Error: 15151 – Cannot find the user , because it does not exist or you do not have permission.
2041 Feb 17, 2012 SQL SERVER – Solution Part 2 – A Quick Puzzle on JOIN and NULL – SQL Brain Teaser
2040 Feb 16, 2012 SQL SERVER – Be Different – Be Leader – An Interactive Journey – Questions and Answers – Book and Video
2039 Feb 15, 2012 SQL SERVER – T-SQL Errors and Reactions – SQL in Sixty Seconds #002 – Video
2038 Feb 14, 2012 SQL SERVER – What is Big Data – An Explanation in Simple Words
2037 Feb 13, 2012 SQL SERVER – Building Interactive Reports in Quick Moments – From CSV to Excel Pivot Table – A Conversation turned to Webinar
2036 Feb 12, 2012 SQLAuthority News – Business Intelligence features of SQL Server 2012 RC0 – Download Virtual Machine
2035 Feb 11, 2012 SQL SERVER – Solution – A Quick Puzzle on JOIN and NULL – SQL Brain Teaser
2034 Feb 10, 2012 SQL SERVER – A Quick Puzzle on JOIN and NULL – SQL Brain Teaser
2033 Feb 09, 2012 SQL SERVER – INNER JOIN Returning More Records than Exists in Table
2032 Feb 08, 2012 SQL SERVER – Convert Subquery to CTE – SQL in Sixty Seconds #001 – Video
2031 Feb 07, 2012 SQL SERVER – Installation Log Summary File Location – 2012 – 2008 R2
2030 Feb 06, 2012 SQL SERVER – ERROR: FIX – Database diagram support objects cannot be installed because this database does not have a valid owner
2029 Feb 05, 2012 SQLAuthority News – Microsoft SQL Server AlwaysOn Solutions Guide for High Availability and Disaster Recovery
2028 Feb 04, 2012 SQL SERVER – Finding Count of Logical CPU using T-SQL Script – Identify Virtual Processors
2027 Feb 03, 2012 SQLAuthority News – An Incredible Successful SQL Saturday #116 Event – First SQL Saturday in India
2026 Feb 02, 2012 SQL SERVER – An Inspiring Personal Story – Movie from The Book – Video Course – SQL Server Questions and Answers – Pluralsight
2025 Feb 01, 2012 SQL SERVER – What is Slowly Changing Dimension – Quiz – Puzzle – 31 of 31
2024 Jan 31, 2012 SQL SERVER – Advantages of Partitioning – Quiz – Puzzle – 30 of 31
2023 Jan 30, 2012 SQL SERVER – Data Collector Usage – Quiz – Puzzle – 29 of 31
2022 Jan 29, 2012 SQL SERVER – Reclaiming Space Back from Database – Quiz – Puzzle – 28 of 31
2021 Jan 28, 2012 SQL SERVER – Lots of Date Functions – Find Right One to Use – Quiz – Puzzle – 27 of 31
2020 Jan 27, 2012 SQL SERVER – Common Gotcha’s Associated with Common Table Expressions (CTE) – Quiz – Puzzle – 26 of 31
2019 Jan 26, 2012 SQLAuthority News – Interview with Book Authors after 2 Months of Book Released
2018 Jan 26, 2012 SQL SERVER – Different Aspect of Policy Based Management – Quiz – Puzzle – 25 of 31
2017 Jan 25, 2012 SQL SERVER – Correct Value for Fillfactor – Quiz – Puzzle – 24 of 31
2016 Jan 24, 2012 SQL SERVER – Database Mirroring and Fine-Prints – Quiz – Puzzle – 23 of 31
2015 Jan 23, 2012 SQL SERVER – What is Piecemeal Restore – Quiz – Puzzle – 22 of 31
2014 Jan 22, 2012 SQL SERVER – Difference between Create Index – Drop Index – Rebuild Index – Quiz – Puzzle – 21 of 31
2013 Jan 21, 2012 SQL SERVER – Methods for Accessing SQL Server XML Datatype – Quiz – Puzzle – 20 of 31
2012 Jan 20, 2012 SQL SERVER – MERGE or INSERT, UPDATE, DELETE – Quiz – Puzzle – 19 of 31
2011 Jan 19, 2012 SQL SERVER – Importance of Resource Database – Quiz – Puzzle – 18 of 31
2010 Jan 18, 2012 SQL SERVER – Various Ways to Create Constraints – Quiz – Puzzle – 17 of 31
2009 Jan 17, 2012 SQL SERVER – CHECKPOINT Behavior and Database Recovery Models – Quiz – Puzzle – 16 of 31
2008 Jan 16, 2012 SQL SERVER – Difference between CHAR, VARCHAR, NVARCHAR and VARCHAR(MAX) – Quiz – Puzzle – 15 of 31
2007 Jan 16, 2012 SQL SERVER – Using SafePeak to Accelerate Performance of 3rd Party Applications
2006 Jan 15, 2012 SQL SERVER – Cases When Stored Procedure RECOMPILE – Quiz – Puzzle – 14 of 31
2005 Jan 14, 2012 SQL SERVER – Debate – Table Variables vs Temporary Tables – Quiz – Puzzle – 13 of 31
2004 Jan 13, 2012 SQL SERVER – DACPAC and SQL Azure – Quiz – Puzzle – 12 of 31
2003 Jan 12, 2012 SQL SERVER – Non-Clustered Index and Automatic Rebuild – Quiz – Puzzle – 11 of 31
2002 Jan 11, 2012 SQL SERVER – A Quick Look at expressor Data Quality Solutions
2001 Jan 11, 2012 SQL SERVER – Reasons for Using Output Clause – Quiz – Puzzle – 10 of 31
2000 Jan 10, 2012 SQL SERVER – Locking, Blocking and Deadlock – Quiz – Puzzle – 9 of 31
1999 Jan 09, 2012 SQL SERVER – Using RANKING Functions Instead of SQL Looping Logic of Cursor – Quiz – Puzzle – 8 of 31
1998 Jan 08, 2012 SQL SERVER – Indexed Views and Restrictions – Quiz – Puzzle – 7 of 31
1997 Jan 07, 2012 SQL SERVER – Collation and Collation Sensitivity – Quiz – Puzzle – 6 of 31
1996 Jan 06, 2012 SQL SERVER – Locking and Blocking – Important Aspect of Database and Effect on Performance – Quiz – Puzzle – 5 of 31
1995 Jan 05, 2012 SQL SERVER – An Important Part of Most SELECT statement – WHERE clause – Quiz – Puzzle – 4 of 31
1994 Jan 05, 2012 SQLAuthority News – I am Speaking at SQL Saturday 116 – Bangalore, India on January 7, 2012 – First SQL Saturday in India
1993 Jan 04, 2012 SQL SERVER – Understanding Identity Beyond its Every Increasing Nature – Quiz – Puzzle – 3 of 31
1992 Jan 04, 2012 SQLAuthority News – To Err is Human; to Forgive, Divine – Errata of SQL Server Interview Book
1991 Jan 03, 2012 SQL SERVER – Significance of Various Kinds of Triggers- Quiz – Puzzle – 2 of 31
1990 Jan 02, 2012 SQL SERVER – Importance of ANSI ISOLATION Levels in SQL Server Database – Quiz – Puzzle – 1 of 31
1989 Jan 01, 2012 SQL SERVER – Interview Questions and Answers – Perspectives of an Author
1988 Dec 31, 2011 SQLAuthority News – An Year Worth Remembering and Looking Forward to Better Next Year
1987 Dec 30, 2011 SQLAuthority News – A Quick History of Writing Three Books in Year 2011
1986 Dec 29, 2011 SQL SERVER – Year End Brain Teaser – Disabled Login and Associated User Without Disabled User Red Arrow
1985 Dec 28, 2011 SQL SERVER – Effect of Compressed Backup Setting at Server Level on Database Backup
1984 Dec 27, 2011 SQL SERVER – Target Recovery Time of a Database – Advance Option in SQL Server 2012
1983 Dec 26, 2011 SQL SERVER – Fix: Error: 15138 – The database principal owns a schema in the database, and cannot be dropped
1982 Dec 25, 2011 SQL SERVER – Merry Christmas and Happy Holidays – Database Properties – Number of Users
1981 Dec 24, 2011 SQL SERVER – A Simple Puzzle and Simple Solution of Datatype and Computed Column
1980 Dec 23, 2011 SQL SERVER – A Quick Script for Point in Time Recovery – Back Up and Restore
1979 Dec 22, 2011 SQL SERVER – Mastering the Basics – Igniting Learning – A Unique Learning Experience
1978 Dec 21, 2011 SQL SERVER – A Quick Trick about SQL Server 2012 CONCAT Function – PRINT
1977 Dec 20, 2011 SQL SERVER – A Quick Trick about SQL Server 2012 CONCAT function
1976 Dec 19, 2011 SQLAuthority News – Introduction to expressor Connectivity to Salesforce – expressor Data Integration Applications
1975 Dec 18, 2011 SQL SERVER – Adventure Works for SQL Server 2012 RC0 – Samples Database for SQL Server 2012 RC0
1974 Dec 17, 2011 SQL SERVER – FIX – ERROR : Msg 3201, Level 16 Cannot open backup device.Operating system error 3 (The system cannot find the path specified.)
1973 Dec 16, 2011 SQL SERVER – 2012 Auditing Enhancement – On Audit Log Failure Options – Maximum Rollover Files
1972 Dec 15, 2011 SQLAuthority News – Online Session Practical Tricks and Tips to Speed up Database Queries Today
1971 Dec 14, 2011 SQL SERVER – Explain Error:166 : does not allow specifying the database name as a prefix to the object name – Puzzle to Win SQL Server Interview Questions and Answers Book
1970 Dec 13, 2011 SQL SERVER – A Quick Look at Performance – A Quick Look at Configuration
1969 Dec 12, 2011 SQLAuthority News – Virtual Presentation on Practical Tricks and Tips to Speed up Database Queries – December 15, 2011
1968 Dec 11, 2011 SQL SERVER – Fix: Error: Msg 1904, Level 16 The statistics on table has 33 column names in statistics key list. The maximum limit for index or statistics key column list is 32
1967 Dec 10, 2011 SQLAuthority News – SQL Saturday 116 – SQL Saturday in Bangalore, India on January 7, 2012 – 4 Saturdays to Go
1966 Dec 10, 2011 SQL SERVER – 2012 RC0: Fix Setup Error: File format is not valid
1965 Dec 09, 2011 SQL SERVER – Bad Practice of Using Keywords as an Object Name – Avoid Using Keywords as an Object
1964 Dec 08, 2011 SQL SERVER – Error: Deleting Offline Database and Creating the Same Name
1963 Dec 07, 2011 SQL SERVER – Plenty of SQL Community Updates
1962 Dec 06, 2011 SQLAuthority News – SQL Server Interview Questions and Answers Available on Kindle Format as eBook to Download
1961 Dec 05, 2011 SQLAuthority News – SQL Saturday 116 – SQL Saturday in Bangalore, India on January 7, 2012
1960 Dec 04, 2011 SQLAuthority News – Microsoft SQL Server ODBC Driver for Linux Available Now
1959 Dec 03, 2011 SQLAuthority News – Download Whitepaper 5 Tips for a Smooth SSIS Upgrade to SQL Server 2012
1958 Dec 02, 2011 SQL SERVER – Effect of SET NOCOUNT on @@ROWCOUNT
1957 Dec 01, 2011 SQL SERVER – Where Can YOU Get My Books – SQL Server Interview Question and Answers
1956 Nov 30, 2011 SQL SERVER – Fix: Error: File cannot be loaded because the execution of scripts is disabled on this system. Please see “get-help about_signing” for more details
1955 Nov 29, 2011 SQL SERVER – Using expressor Composite Types to Enforce Business Rules
1954 Nov 28, 2011 SQLAuthority News – SafePeak’s SQL Server Performance Contest – Winners
1953 Nov 27, 2011 SQL SERVER – Powershell – Get a List of Fixed Hard Drive and Free Space on Server
1952 Nov 26, 2011 SQL SERVER – Get Directory Structure using Extended Stored Procedure xp_dirtree
1951 Nov 25, 2011 SQL SERVER – DVM sys.dm_os_sys_info Column Name Changed in SQL Server 2012
1950 Nov 24, 2011 SQL SERVER – Solution to Puzzle – Simulate LEAD() and LAG() without Using SQL Server 2012 Analytic Function
1949 Nov 23, 2011 SQL SERVER – 2012 – Summary of All the Analytic Functions – MSDN and SQLAuthority
1948 Nov 22, 2011 SQL SERVER – Introduction to PERCENTILE_DISC() – Analytic Functions Introduced in SQL Server 2012
1947 Nov 21, 2011 SQL SERVER – Puzzle to Win Print Book – Explain Value of PERCENTILE_CONT() Using Simple Example
1946 Nov 20, 2011 SQL SERVER – Introduction to PERCENTILE_CONT() – Analytic Functions Introduced in SQL Server 2012
1945 Nov 19, 2011 SQL SERVER – 2012 RC0 Various Resources and Downloads
1944 Nov 18, 2011 SQL SERVER – Introduction to PERCENT_RANK() – Analytic Functions Introduced in SQL Server 2012
1943 Nov 17, 2011 SQL SERVER – Puzzle to Win Print Book and Free 30 Days Online Training Material
1942 Nov 16, 2011 SQL SERVER – Puzzle to Win Print Book – Write T-SQL Self Join Without Using LEAD and LAG
1941 Nov 15, 2011 SQL SERVER – Introduction to LEAD and LAG – Analytic Functions Introduced in SQL Server 2012
1940 Nov 14, 2011 SQLAuthority News – A Real Story of Book Getting ‘Out of Stock’ to A 25% Discount Story Available
1939 Nov 13, 2011 SQL SERVER – CSVExpress and Quick Data Load
1938 Nov 12, 2011 SQLAuthority News – Various Microsoft SQL Server Documentations Available for Download
1937 Nov 11, 2011 SQL SERVER – Puzzle to Win Print Book – Functions FIRST_VALUE and LAST_VALUE with OVER clause and ORDER BY
1936 Nov 10, 2011 SQL SERVER – OVER clause with FIRST _VALUE and LAST_VALUE – Analytic Functions Introduced in SQL Server 2012 – ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING
1935 Nov 09, 2011 SQL SERVER – Introduction to FIRST _VALUE and LAST_VALUE – Analytic Functions Introduced in SQL Server 2012
1934 Nov 08, 2011 SQLAuthority News – Updates on Contests, Books and SQL Server
1933 Nov 08, 2011 SQL SERVER – Introduction to CUME_DIST – Analytic Functions Introduced in SQL Server 2012
1932 Nov 07, 2011 SQL SERVER – Video – Performance Improvement in Columnstore Index
1931 Nov 06, 2011 SQL SERVER – Updating Data in A Columnstore Index
1930 Nov 05, 2011 SQL SERVER – SSMS 2012 Reset Keyboard Shortcuts to Default
1929 Nov 04, 2011 SQL SERVER 2012 Editions – Highlights of The Cloud-Ready Information Platform
1928 Nov 04, 2011 SQLAuthority News – SQL Server Interview Questions And Answers Book Summary
1927 Nov 03, 2011 SQLAuthority News – New Book Released – SQL Server Interview Questions And Answers
1926 Nov 02, 2011 SQL SERVER – Import CSV into Database – Transferring File Content into a Database Table using CSVexpress
1925 Nov 01, 2011 SQLAuthority News – 5th Anniversary Giveaways
1924 Nov 01, 2011 SQLAuthority News – History of the Database – 5 Years of Blogging at SQLAuthority
1923 Oct 31, 2011 SQL SERVER – Database Dynamic Caching by Automatic SQL Server Performance Acceleration
1922 Oct 30, 2011 SQL SERVER – How to Ignore Columnstore Index Usage in Query
1921 Oct 29, 2011 SQL SERVER – Fundamentals of Columnstore Index
1920 Oct 28, 2011 SQLAuthority News – Online Webcast How to Identify Resource Bottlenecks – Wait Types and Queues
1919 Oct 27, 2011 SQLAuthority News – SQL Server Wait Stats – eBook to Download on Kindle – Answer to FREE PDF Download Request
1918 Oct 26, 2011 SQLAuthority News – Book Signing Event – SQLPASS 2011 Event Log
1917 Oct 25, 2011 SQLAuthority News – Meeting SQL Friends – SQLPASS 2011 Event Log
1916 Oct 24, 2011 SQLAuthority News – Story of Seattle – SQLPASS 2011 Event Log
1915 Oct 23, 2011 SQL SERVER – Dedicated Access Control for SQL Server Express Edition – An error occurred while obtaining the dedicated administrator connection (DAC) port.
1914 Oct 22, 2011 SQLAuthority News – Random Thoughts and Random Ideas
1913 Oct 21, 2011 SQL SERVER – DATEDIFF – Accuracy of Various Dateparts
1912 Oct 20, 2011 SQL SERVER – TRACEWRITE – Wait Type – Wait Related to Buffer and Resolution
1911 Oct 19, 2011 SQL SERVER – A Simple Quiz – T-SQL Brain Trick
1910 Oct 18, 2011 SQL SERVER – Next Version of SQL Server ‘Denali’ is Officially Named as SQL Server 2012
1909 Oct 18, 2011 SQLAuthority News – Your Performance Story – My Contribution to Your Learning
1908 Oct 17, 2011 SQLAuthority News – SafePeak Releases a Major Update: SafePeak version 2.1 for SQL Server Performance Acceleration
1907 Oct 16, 2011 SQL SERVER – Denali – Three DMVs – sys.dm_server_memory_dumps – sys.dm_server_services – sys.dm_server_registry
1906 Oct 15, 2011 SQLAuthority News – SQL Server 2008 SP3 Available to Download
1905 Oct 14, 2011 SQL SERVER – SQLPASS Memory Lane of 2009 and 2010
1904 Oct 13, 2011 SQLAuthority News – SQLPASS – Today FREE 100 SQL Wait Stats Book Print Copy – Book Signing
1903 Oct 12, 2011 SQLAuthority News – SQLPASS – 100 SQL Wait Stats Book Print Copy Giveaway – A Book Every Minute for an Hour Tomorrow
1902 Oct 11, 2011 SQL SERVER – expressor Studio 3.4 Rules Editor – ETL Graphical Coding Tool
1901 Oct 11, 2011 SQLAuthority News – Why I am Going to Attend PASS Summit Unite 2011 – Seattle
1900 Oct 10, 2011 SQLAuthority News – Milestone – 1900th Post and 31 Million Views – Thank You!
1899 Oct 09, 2011 SQLAuthority News – System Center Monitoring Pack for Microsoft SQL Server 2008 R2 Parallel Data Warehouse Appliance
1898 Oct 08, 2011 SQLAuthority News – SQL Server Quiz 2011 – All was well few moments before all went wrong – Reasons and Resolutions
1897 Oct 07, 2011 SQL SERVER – Server Side Paging in SQL Server CE (Compact Edition)
1896 Oct 06, 2011 SQL SERVER – Detecting Database Case Sensitive Property using fn_helpcollations()
1895 Oct 05, 2011 SQLAuthority News – SQL Wait Stats Book – Available as Kindle eBook – October Special
1894 Oct 04, 2011 SQL SERVER – Quick Note about JOIN – Common Questions and Simple Answers
1893 Oct 04, 2011 SQL SERVER – CE – 3 Links to Performance Tuning Compact Edition
1892 Oct 03, 2011 SQL SERVER – SQL Backup and FTP – A Quick and Handy Tool
1891 Oct 02, 2011 SQL SERVER – CE – List of Information_Schema System Tables
1890 Oct 01, 2011 SQL SERVER – CE – Samples Database for SQL CE 4.0
1889 Sep 30, 2011 SQL SERVER – Denali – DMV – sys.dm_os_windows_info – Information about Operating System
1888 Sep 30, 2011 SQL SERVER – Denali – DMV – sys.dm_os_volume_stats – Information about operating system volume
1887 Sep 29, 2011 SQLAuthority News – Various Ways to Stay in Touch with SQLAuthority.com – Best Practices
1886 Sep 28, 2011 SQL SERVER – Denali – DMV Enhancement – sys.dm_exec_query_stats – New Columns
1885 Sep 28, 2011 SQLAuthority News – Tomorrow Online Session – Ancient Trade of Performance Tuning – Index, Beyond Index and No Index
1884 Sep 27, 2011 SQLAuthority News – 31 Millions Views – Free 5 Print Copy of SQL Wait Types and Queues
1883 Sep 26, 2011 SQLAuthority News – Online Session – Ancient Trade of Performance Tuning – Index, Beyond Index and No Index
1882 Sep 26, 2011 SQL SERVER – Denali – Startup Parameters Easy to Configure
1881 Sep 25, 2011 SQLAuthority News – Learn SQL Azure at Microsoft Virtual Academy
1880 Sep 24, 2011 SQL SERVER – Denali – Download CTP3 Demo VHD Including Fully Configured Services and Integration with SharePoint 2010 and Office 2010
1879 Sep 23, 2011 SQL SERVER – Puzzle – Usage of New Index Hints for Denali – ForceSeek and ForceScan
1878 Sep 22, 2011 SQL SERVER – Learning SSAS (SQL Server Analysis Services) Online in 6 Hours – Top Down Designing and Bottom Up Designing
1877 Sep 22, 2011 SQLAuthority News – Latest expressor Data Integration Platform Posts
1876 Sep 21, 2011 SQL SERVER – Denali – 14 New Functions – A Quick Guide
1875 Sep 20, 2011 SQL SERVER – Denali – Date and Time Functions – EOMONTH() – A Quick Introduction
1874 Sep 19, 2011 SQL SERVER – Denali – Date and Time Functions – DATEFROMPARTS() – DATETIMEFROMPARTS() – DATETIME2FROMPARTS() – TIMEFROMPARTS() – SMALLDATETIMEFROMPARTS() – DATETIMEOFFSETFROMPARTS() – A Quick Introduction
1873 Sep 18, 2011 SQLAuthority News – Implementing a Microsoft SQL Server Parallel Data Warehouse Using the Kimball Approach
1872 Sep 18, 2011 SQLAuthority News – Automation of Data Mining Using Integration Services
1871 Sep 17, 2011 SQL SERVER – Denali – String Function – FORMAT() – A Quick Introduction
1870 Sep 16, 2011 SQL SERVER – Denali – String Function – CONCAT() – A Quick Introduction
1869 Sep 15, 2011 SQLAuthority News – Uncut and Unedited – Interview of Pinal Dave on Book Authoring
1868 Sep 14, 2011 SQL SERVER – Introduction to expressor 3.4 Lookup Tables
1867 Sep 13, 2011 SQL SERVER – Denali – New Functions and Shorthand for CASE Statement
1866 Sep 12, 2011 SQL SERVER – Denali CTP3 – Step by Step Installation Video – 200 Seconds
1865 Sep 12, 2011 SQL SERVER – DBA Quiz 2011 – All was well few moments before all went wrong – Reasons and Resolutions
1864 Sep 11, 2011 SQL SERVER – Denali – Logical Function – CHOOSE() – A Quick Introduction
1863 Sep 10, 2011 SQL SERVER – Denali – Logical Function – IIF() – A Quick Introduction
1862 Sep 09, 2011 SQL SERVER – Denali – Conversion Function – Difference between PARSE(), TRY_PARSE(), TRY_CONVERT()
1861 Sep 08, 2011 SQL SERVER – Denali – Conversion Function – TRY_CONVERT() – A Quick Introduction
1860 Sep 07, 2011 SQL SERVER – Denali – Conversion Function – TRY_PARSE() – A Quick Introduction
1859 Sep 07, 2011 SQL SERVER – A Guide to Integrating SQL Server with XML, C#, and PowerShell – Book Available for SQL Server Certification
1858 Sep 06, 2011 SQL SERVER – Denali – Conversion Function – PARSE() – A Quick Introduction
1857 Sep 06, 2011 SQL SERVER – Download Denali CTP3 and Denali CTP 3 Product Guide
1856 Sep 05, 2011 SQLAuthority News – Whitepaper – Running SQL Server with Hyper-V Dynamic Memory Best Practices and Considerations – Consolidating Databases Using Virtualization Planning Guide
1855 Sep 05, 2011 SQL SERVER – Programming and Development – Book Available for SQL Server Certification
1854 Sep 04, 2011 SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – OpenXML Options – Day 35 of 35
1853 Sep 03, 2011 SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Preparing XML in Memory – Day 34 of 35
1852 Sep 02, 2011 SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Shredding XML – Day 33 of 35
1851 Sep 02, 2011 SQLAuthority News – Programming & Development For Microsoft SQL Server 2008
1850 Sep 01, 2011 SQLAuthority News – Shaivi’s Birthday – SQL Wait Stats Joes 2 Pros Book Released Today – 30 Million Views Completed
1849 Sep 01, 2011 SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Using Root With Auto XML Mode – Day 32 of 35
1848 Aug 31, 2011 SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Using Root With Auto XML Mode – Day 31 of 35
1847 Aug 30, 2011 SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – What is XML? – Day 30 of 35
1846 Aug 29, 2011 SQL SERVER – SSQL Architecture Basics – Core Architecture Concepts – Book Available for SQL Server Certification
1845 Aug 29, 2011 SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – What is XML? – Day 29 of 35
1844 Aug 28, 2011 SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Structured Error Handling – Day 28 of 35
1843 Aug 27, 2011 SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – SQL Server Error Messages – Day 27 of 35
1842 Aug 26, 2011 SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Table-Valued Functions – Day 26 of 35
1841 Aug 25, 2011 SQL SERVER – Author’s Book is Available in India and USA
1840 Aug 25, 2011 SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Table-Valued Store Procedure Parameters – Day 25 of 35
1839 Aug 24, 2011 SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Easy Introduction to CHECK Options – Day 24 of 35
1838 Aug 23, 2011 SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Introduction to Views – Day 23 of 35
1837 Aug 22, 2011 SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – All about SQL Constraints – Day 22 of 35
1836 Aug 22, 2011 SQL SERVER – SQL Query Techniques For Microsoft SQL Server 2008 – Book Available for SQL Server Certification
1835 Aug 21, 2011 SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – All about SQL Statistics – Day 21 of 35
1834 Aug 20, 2011 SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Introduction to Page Split – Day 20 of 35
1833 Aug 19, 2011 SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – The Clustered Index – Simple Understanding – Day 19 of 35
1832 Aug 18, 2011 SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Geography Data Type – Calculating Distance Between Two Points on the Earth – Day 18 of 35
1831 Aug 17, 2011 SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Sparse Data and Space Used by Sparse Data – Day 17 of 35
1830 Aug 16, 2011 SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – System and Time Data Types – Day 16 of 35
1829 Aug 16, 2011 SQLAuthority News – Pluralsight Giving Away Free Subscription to Quiz Participants
1828 Aug 15, 2011 SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Data Row Space Usage and NULL Storage – Day 15 of 35
1827 Aug 14, 2011 SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Output Clause in Simple Examples – Day 14 of 35
1826 Aug 13, 2011 SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Ranking Functions – Advanced NTILE in Detail – Day 13 of 35
1825 Aug 12, 2011 SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Ranking Functions – RANK( ), DENSE_RANK( ), and ROW_NUMBER( ) – Day 12 of 35
1824 Aug 11, 2011 SQL SERVER – SafePeak – The Plug and Play Immediate Acceleration Solution
1823 Aug 11, 2011 SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Advanced Aggregates with the Over Clause – Day 11 of 35
1822 Aug 10, 2011 SQL SERVER – Who needs ETL Version Control?
1821 Aug 10, 2011 SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Aggregates with the Over Clause – Day 10 of 35
1820 Aug 10, 2011 SQL SERVER – Use INSERT INTO … SELECT instead of Cursor
1819 Aug 09, 2011 SQL SERVER – The SQL Hands-On Guide for Beginners – Book Available for SQL Server Certification
1818 Aug 09, 2011 SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Overriding Identity Fields – Tricks and Tips of Identity Fields – Day 9 of 35
1817 Aug 08, 2011 SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Many to Many Relationships – Day 8 of 35
1816 Aug 07, 2011 SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Dirty Records and Table Hints – Day 7 of 35
1815 Aug 06, 2011 SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Row Constructors – Day 6 of 35
1814 Aug 05, 2011 SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Finding un-matching Records – Day 5 of 35
1813 Aug 04, 2011 SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Efficient Query Writing Strategy – Day 4 of 35
1812 Aug 03, 2011 SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Finding Apostrophes in String and Text – Day 3 of 35
1811 Aug 02, 2011 SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Wildcard – Querying Special Characters – Day 2 of 35
1810 Aug 01, 2011 SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Wildcard Basics Recap – Day 1 of 35
1809 Aug 01, 2011 SQL SERVER – Win a Book a Day – Contest Rules – Day 0 of 35
1808 Jul 31, 2011 SQL SERVER – The Difficult Interview Question – Moment of the Life – Day 31 of 31
1807 Jul 30, 2011 SQL SERVER – Interview Questions and Answers – Guest Post by Jacob Sebastian – Day 30 of 31
1806 Jul 29, 2011 SQL SERVER – Interview Questions and Answers – Guest Post by Feodor Georgiev – Day 29 of 31
1805 Jul 28, 2011 SQL SERVER – Interview Questions and Answers – Guest Post by Nakul Vachhrajani – Day 28 of 31
1804 Jul 28, 2011 SQL SERVER – Latest expressor Data Integration Platform Posts
1803 Jul 27, 2011 SQL SERVER – Interview Questions and Answers – Guest Post by Rick Morelan – Day 27 of 31
1802 Jul 26, 2011 SQL SERVER – Interview Questions and Answers – Guest Post by Malathi Mahadevan – Day 26 of 31
1801 Jul 25, 2011 SQL SERVER – Azure Interview Questions and Answers – Guest Post by Paras Doshi – Day 25 of 31
1800 Jul 24, 2011 SQL SERVER – Interview Questions and Answers – Frequently Asked Questions – Data Warehouseing Concepts – Day 24 of 31
1799 Jul 23, 2011 SQL SERVER – Interview Questions and Answers – Frequently Asked Questions – Data Warehouseing Concepts – Day 23 of 31
1798 Jul 22, 2011 SQL SERVER – Interview Questions and Answers – Frequently Asked Questions – Data Warehouseing Concepts – Day 22 of 31
1797 Jul 21, 2011 SQL SERVER – Interview Questions and Answers – Frequently Asked Questions – Data Warehouseing Concepts – Day 21 of 31
1796 Jul 20, 2011 SQL SERVER – Interview Questions and Answers – Frequently Asked Questions – Day 20 of 31
1795 Jul 19, 2011 SQL SERVER – Interview Questions and Answers – Frequently Asked Questions – Day 19 of 31
1794 Jul 18, 2011 SQL SERVER – Interview Questions and Answers – Frequently Asked Questions – Day 18 of 31
1793 Jul 17, 2011 SQL SERVER – Interview Questions and Answers – Frequently Asked Questions – Day 17 of 31
1792 Jul 16, 2011 SQL SERVER – Interview Questions and Answers – Frequently Asked Questions – Day 16 of 31
1791 Jul 15, 2011 SQL SERVER – Interview Questions and Answers – Frequently Asked Questions – Day 15 of 31
1790 Jul 14, 2011 SQL SERVER – Interview Questions and Answers – Frequently Asked Questions – Day 14 of 31
1789 Jul 13, 2011 SQL SERVER – Query to Find Duplicate Indexes – Script to Find Redundant Indexes
1788 Jul 13, 2011 SQL SERVER – Interview Questions and Answers – Frequently Asked Questions – Day 13 of 31
1787 Jul 12, 2011 SQL SERVER – Database Worst Practices – New Town and New Job and New Disasters
1786 Jul 12, 2011 SQL SERVER – Interview Questions and Answers – Frequently Asked Questions – Day 12 of 31
1785 Jul 11, 2011 SQL SERVER – Interview Questions and Answers – Frequently Asked Questions – Day 11 of 31
1784 Jul 10, 2011 SQL SERVER – Interview Questions and Answers – Frequently Asked Questions – Day 10 of 31
1783 Jul 09, 2011 SQL SERVER – Interview Questions and Answers – Frequently Asked Questions – Day 9 of 31
1782 Jul 08, 2011 SQL SERVER – Interview Questions and Answers – Frequently Asked Questions – Day 8 of 31
1781 Jul 08, 2011 SQL SERVER – Introduction to expressor Datascript Modules
1780 Jul 07, 2011 SQL SERVER – Interview Questions and Answers – Frequently Asked Questions – Day 7 of 31
1779 Jul 06, 2011 SQL SERVER – Interview Questions and Answers – Frequently Asked Questions – Day 6 of 31
1778 Jul 05, 2011 SQL SERVER – Interview Questions and Answers – Frequently Asked Questions – Day 5 of 31
1777 Jul 04, 2011 SQL SERVER – Interview Questions and Answers – Frequently Asked Questions – Day 4 of 31
1776 Jul 03, 2011 SQL SERVER – Interview Questions and Answers – Frequently Asked Questions – Day 3 of 31
1775 Jul 02, 2011 SQL SERVER – Interview Questions and Answers – Frequently Asked Questions – Day 2 of 31
1774 Jul 01, 2011 SQL SERVER – Interview Questions and Answers – Frequently Asked Questions – Introduction – Day 1 of 31
1773 Jul 01, 2011 SQL SERVER – Interview Questions and Answers – Frequently Asked Questions – Complete Downloadable List – Day 0 of 31
1772 Jun 30, 2011 SQL SERVER – Two Puzzles – Answer and Win USD 25 Gift Card
1771 Jun 29, 2011 SQL SERVER – Find Details for Statistics of Whole Database – DMV – T-SQL Script
1770 Jun 28, 2011 SQLAuthority News – Monthly list of Puzzles and Solutions on SQLAuthority.com
1769 Jun 27, 2011 SQL SERVER – Puzzle Involving NULL – Resolve – Error – Operand data type void type is invalid for sum operator
1768 Jun 26, 2011 SQL SERVER – T-SQL Scripts to Find Maximum between Two Numbers
1767 Jun 25, 2011 SQLAuthority News – Download Whitepaper – SQL Server 2008 R2 Analysis Services Operations Guide
1766 Jun 24, 2011 SQL SERVER – BI Quiz Hint – Performance Tuning Cubes – Hints
1765 Jun 23, 2011 SQLAuthority News – Ahmedabad Tech Ed On Road June 11, 2011 – An Event to Remember – A Grand Success of Community Tech Days
1764 Jun 22, 2011 SQL SERVER – SSAS – Multidimensional Space Terms and Explanation
1763 Jun 22, 2011 SQL SERVER – List of Article on Expressor Data Integration Platform
1762 Jun 21, 2011 SQL SERVER – Solution – Generating Zero Without using Any Numbers in T-SQL
1761 Jun 20, 2011 SQLAuthority News – Job Interviewing the Right Way (and for the Right Reasons) – Guest Post by Feodor Georgiev
1760 Jun 19, 2011 SQLAuthority News – Download Whitepaper Using SharePoint List Data in PowerPivot
1759 Jun 18, 2011 SQL SERVER – Selecting Domain from Email Address
1758 Jun 17, 2011 SQL SERVER – Solution – Puzzle – Statistics are not Updated but are Created Once
1757 Jun 16, 2011 SQL SERVER – Free Online Training on .net and SQL
1756 Jun 15, 2011 SQL SERVER – Solution – Puzzle – SELECT * vs SELECT COUNT(*)
1755 Jun 14, 2011 SQLAuthority News – BI Quiz Question – How to Optimize Cube? – Hints
1754 Jun 14, 2011 SQL SERVER – Watch Online and Download – Inside of Next Generation SQL Server – Best Practices Analyzer using Microsoft Baseline Configuration Analyzer
1753 Jun 14, 2011 SQL SERVER – First Month as DBA Trainee – Disasters and Recovery
1752 Jun 13, 2011 SQL SERVER – Extending SQL Azure with Azure worker role – Guest Post by Paras Doshi
1751 Jun 12, 2011 SQL SERVER – PHP on Windows and SQL Server Training Kit
1750 Jun 11, 2011 SQL SERVER – Integration Services Balanced Data Distributor – SSIS Balanced Data Distributor
1749 Jun 10, 2011 SQLAuthority News – Presenting at Tech-Ed On Road – Ahmedabad – June 11, 2011 – Wait Types and Queues
1748 Jun 09, 2011 SQL SERVER – Online Session on What is New in Denali – Today Online
1747 Jun 08, 2011 SQL SERVER – 5 Tips for Improving Your Data with expressor Studio
1746 Jun 07, 2011 SQL SERVER – Three Puzzling Questions – Need Your Answer
1745 Jun 06, 2011 SQL SERVER – BI Quiz – Troubleshooting Cube Performance
1744 Jun 05, 2011 SQLAuthority News – SQL Server 2008 R2 Update for Developers Training Kit – Download – May Update
1743 Jun 05, 2011 SQLAuthority News – Download Pre-configured VHD – SQL Server 2008 R2 Standard on Windows Server 2008 R2 SP1 Standard
1742 Jun 04, 2011 SQL SERVER – Question to You – When to use Function and When to use Stored Procedure
1741 Jun 03, 2011 SQLAuthority News – Community Tech Days – TechEd on The Road – Ahmedabad – June 11, 2011
1740 Jun 02, 2011 SQL SERVER – Puzzle – Statistics are not Updated but are Created Once
1739 Jun 01, 2011 SQL SERVER – Creating All New Database with Full Recovery Model
1738 May 31, 2011 SQLAuthority News – Best SQLAuthority Posts of May
1737 May 30, 2011 SQL SERVER – Puzzle – SELECT * vs SELECT COUNT(*)
1736 May 29, 2011 SQL Azure – SQL Azure Throttling and Decoding Reason Codes
1735 May 28, 2011 SQL SERVER – A Quick Notes on SQL Azure
1734 May 27, 2011 SQL SERVER – Copy Database from Instance to Another Instance – Copy Paste in SQL Server
1733 May 26, 2011 SQL SERVER – Getting Columns Headers without Result Data – SET FMTONLY ON
1732 May 25, 2011 SQLAuthority News – Most Valuable Photographer – Vijay Raj
1731 May 24, 2011 SQL SERVER – Beginning SQL Azure – Article Links by Dhananjay Kumar
1730 May 23, 2011 SQL SERVER – Running SSIS Package in Scheduled Job
1729 May 22, 2011 SQL SERVER – Download PowerPivot Security Architecture Diagram
1728 May 21, 2011 SQL SERVER – Running SSIS Package From Command Line
1727 May 20, 2011 SQL SERVER – Management Studio and Browser in Same Application
1726 May 19, 2011 SQL SERVER – Connecting to Server Using Windows Authentication by SQLCMD
1725 May 18, 2011 SQL SERVER – FIX – ERROR – Service Logon Failure (ObjectExplorer)
1724 May 17, 2011 SQLAuthority News – Facebook Page and Twitter – Connect Using Social Media
1723 May 16, 2011 SQL SERVER – SQL Server Compression Estimator – Codeplex
1722 May 15, 2011 SQL SERVER – Attending MVP Open Day – May 2011
1721 May 14, 2011 SQLAuthority News – Restart Remote Computer – Shutdown Remote Computer
1720 May 13, 2011 SQL SERVER – Vote for My Session in SQL PASS
1719 May 12, 2011 SQL SERVER – Import CSV File into Database Table Using SSIS
1718 May 11, 2011 SQL SERVER – expressor 3.2 Release Review
1717 May 10, 2011 SQL SERVER – Resource Database ID – 32767
1716 May 10, 2011 SQL SERVER – Common Table Expression (CTE) and Few Observation
1715 May 09, 2011 SQL SERVER – SQL Server Management Pack Guide for System Center Operations Manager 2007
1714 May 08, 2011 SQL SERVER – What Kind of Lock WITH (NOLOCK) Hint Takes on Object?
1713 May 07, 2011 SQL SERVER – 2008 – 2008 R2 – Create Script to Copy Database Schema and All The Objects – Data, Schema, Stored Procedure, Functions, Triggers, Tables, Views, Constraints and All Other Database Objects
1712 May 06, 2011 SQL SERVER – Video – Best Practices Analyzer using Microsoft Baseline Configuration Analyzer
1711 May 05, 2011 SQL SERVER – Presenting on Best Practices Analyzer using Microsoft Baseline Configuration Analyzer
1710 May 04, 2011 SQL SERVER – Cartoon Challenge – 140 Character Winner is Here
1709 May 04, 2011 SQL SERVER – Interview on Wait Types and Wait Queues
1708 May 03, 2011 SQL SERVER – Error: Failed to retrieve data for this request. Microsoft.SqlServer.Management.Sdk.Sfc – ‘DATABASEPROPERTY’ is not a recognized built-in function name. (Microsoft SQL Server, Error: 195)
1707 May 02, 2011 SQL SERVER – Performance Improvement with of Executing Stored Procedure with Result Sets in SQL Server 2012
1706 May 01, 2011 SQL SERVER – Migration Assistant for Access, MySQL, Oracle, Sybase
1705 Apr 30, 2011 SQL SERVER – CTAS – Create Table As SELECT – What is CTAS?
1704 Apr 29, 2011 SQL SERVER – 2012 – Executing Stored Procedure with Result Sets
1703 Apr 28, 2011 SQL SERVER – 2012 – Executing Stored Procedure with Result Sets
1702 Apr 27, 2011 SQL SERVER – Introduction to SQL Azure – Creating Database and Connecting Database
1701 Apr 26, 2011 SQLAuthority News – Pluralsight On-Demand FREE for SQL Server Course
1700 Apr 25, 2011 SQLAuthority News – 1700th Blog Posts – Over 25 Millions of Views – A SQL Milestone
1699 Apr 24, 2011 SQL SERVER – How to ALTER CONSTRAINT
1698 Apr 23, 2011 SQL SERVER – Using Decode in SQL Server
1697 Apr 22, 2011 SQL SERVER – Potential Bottlenecks for Performance
1696 Apr 21, 2011 SQL SERVER – Prevent Constraint to Allow NULL
1695 Apr 20, 2011 SQLAuthority News – Last 5 Days to WIN Windows Phone 7 – 140 Words to Win
1694 Apr 19, 2011 SQLAuthority News – Sudden Death of SSD on my Laptop – A Warning for SSD Users
1693 Apr 18, 2011 SQL SERVER – Speaking on T-SQL Worst Practices at Great Indian Developer Summit 2011 – Bangalore
1692 Apr 17, 2011 SQL SERVER – Applying NOLOCK Hint at Query Level – NOLOCK for whole Transaction
1691 Apr 16, 2011 SQL SERVER – Making Database to Read Only – Changing Database to Read/Write
1690 Apr 15, 2011 SQL SERVER – Finding Location of Log File when Primary Datafile is Crashed
1689 Apr 14, 2011 SQL SERVER – Transaction Log Impact Detection Using DMV – dm_tran_database_transactions
1688 Apr 13, 2011 SQL SERVER – FIX – ERROR : Msg 3201, Level 16 Cannot open backup device . Operating system error 5(Access is denied.)
1687 Apr 12, 2011 SQL SERVER – Query to Recent Query on Server with Execution Plan Function to Get SQL
1686 Apr 11, 2011 SQL SERVER – expressor Studio Includes Powerful Scripting Capabilities
1685 Apr 10, 2011 SQL SERVER – TempDB in RAM for Performance
1684 Apr 09, 2011 SQL SERVER – Add New Column With Default Value
1683 Apr 08, 2011 SQLAuthority News – TechED 2011 – Bangalore – An Unforgettable Experience – Day Next
1682 Apr 07, 2011 SQLAuthority News – TechED 2011 – Bangalore – An Unforgettable Experience – Day 3
1681 Apr 06, 2011 SQLAuthority News – TechED 2011 – Bangalore – An Unforgettable Experience – Day 2
1680 Apr 05, 2011 SQLAuthority News – Win Windows Phone from Idera in 140 Characters – A Cartoon Challenge of SQL
1679 Apr 04, 2011 SQL SERVER – MondayMeme – 11 Words or Less
1678 Apr 04, 2011 SQLAuthority News – A Million Hits a Month – A Milestone
1677 Apr 03, 2011 SQLAuthority News – TechED 2011 – Bangalore – An Unforgettable Experience – Day 1
1676 Apr 02, 2011 SQLAuthority News – TechED 2011 – Bangalore – An Unforgettable Experience – Day 0
1675 Apr 01, 2011 SQLAuthority News – Today is First April – April Fool’s Day
1674 Mar 31, 2011 SQL SERVER – ‘Denali’ – A Simple Example of Contained Databases
1673 Mar 30, 2011 SQL SERVER – TechEd 2011 – Random Question and Answers
1672 Mar 29, 2011 SQL SERVER – Fix : Error : The request failed or the service did not respond in timely fashion. Consult the event log or other applicable error logs for details
1671 Mar 28, 2011 SQL SERVER – Denali – Improvement in Startup Options
1670 Mar 27, 2011 SQL SERVER – 32 Bit – 64 Bit – HTML5 – Database Backup Restore
1669 Mar 26, 2011 SQL SERVER – Related Scripts for TechEd 2011 Presentations
1668 Mar 25, 2011 SQLAuthority News – Win Surprise Gift at TechED 2011 Sessions – Wait Types and Extended Events
1667 Mar 24, 2011 SQL SERVER – Tomorrow 2 Sessions on Performance Tuning at TechEd India 2011 – March 25, 2011
1666 Mar 23, 2011 SQL SERVER – Denali – ObjectID in Negative – Local TempTable has Negative ObjectID
1665 Mar 22, 2011 SQLAuthority News – Solid Quality Journal – Importance of Statistics
1664 Mar 21, 2011 SQL SERVER – SQL Server Migration Assistant (SSMA) – Tools – Video – Download
1663 Mar 20, 2011 SQL SERVER – Denali Feature – Zoom Query Editor
1662 Mar 19, 2011 SQL SERVER – Log File Growing for Model Database – model Database Log File Grew Too Big
1661 Mar 18, 2011 SQL SERVER 2008 – 2012 – Declare and Assign Variable in Single Statement
1660 Mar 17, 2011 SQL SERVER – Tell me What You Want to Listen – My 2 TechED 2011 Sessions
1659 Mar 16, 2011 SQLAuthority News – I am Presenting 2 Sessions at TechEd India
1658 Mar 15, 2011 SQL SERVER – SQLServer Quiz 2011 – Do you know your execution plan – Two questions – One Answer
1657 Mar 14, 2011 SQL SERVER – Guest Post – Architecting Data Warehouse – Niraj Bhatt
1656 Mar 13, 2011 SQL SERVER – Pending IO request in SQL Server – DMV
1655 Mar 12, 2011 SQLAuthority News – Download – Microsoft SQL Server Compact 4.0
1654 Mar 11, 2011 SQL SERVER – Finding Latch Statistics
1653 Mar 10, 2011 SQL SERVER – Sharing your ETL Resources Across Applications with Ease
1652 Mar 09, 2011 SQLAuthority News – Stay Connected and Social Media
1651 Mar 08, 2011 SQL SERVER – Difference between COUNT(DISTINCT) vs COUNT(ALL)
1650 Mar 07, 2011 SQL SERVER – Enable PowerPivot Plugin in Excel
1649 Mar 06, 2011 SQL SERVER – Running Multiple Batch Files Together in Parallel
1648 Mar 05, 2011 SQLAuthority News – Fast Track Data Warehouse 3.0 Reference Guide
1647 Mar 04, 2011 SQL SERVER – Concurrency Problems and their Relationship with Isolation Level
1646 Mar 03, 2011 SQL SERVER – Demo Script – Keeping CPU Busy
1645 Mar 02, 2011 SQLAuthority News – Uncut and Unedited Video Interview of Pinal Dave
1644 Mar 01, 2011 SQLAuthority News – Pinal Dave: Blogger, MVP and now Interviewee by Michael J Swart
1643 Feb 28, 2011 SQL SERVER – Summary of Month – Wait Type – Day 28 of 28
1642 Feb 27, 2011 SQL SERVER – Best Reference – Wait Type – Day 27 of 28
1641 Feb 26, 2011 SQL SERVER – Guest Post – Glenn Berry – Wait Type – Day 26 of 28
1640 Feb 25, 2011 SQL SERVER – 2011 – Wait Type – Day 25 of 28
1639 Feb 24, 2011 SQL SERVER – 2000 – DBCC SQLPERF(waitstats) – Wait Type – Day 24 of 28
1638 Feb 23, 2011 SQL SERVER – OLEDB – Link Server – Wait Type – Day 23 of 28
1637 Feb 22, 2011 SQL SERVER – Guest Post – Jacob Sebastian – Filestream – Wait Types – Wait Queues – Day 22 of 28
1636 Feb 21, 2011 SQL SERVER – Guest Posts – Feodor Georgiev – The Context of Our Database Environment – Going Beyond the Internal SQL Server Waits – Wait Type – Day 21 of 28
1635 Feb 20, 2011 SQL SERVER – MSQL_XP – Wait Type – Day 20 of 28
1634 Feb 19, 2011 SQL SERVER – PREEMPTIVE and Non-PREEMPTIVE – Wait Type – Day 19 of 28
1633 Feb 18, 2011 SQL SERVER – LOGBUFFER – Wait Type – Day 18 of 28
1632 Feb 17, 2011 SQL SERVER – Introduction to Adaptive ETL Tool – How adaptive is your ETL?
1631 Feb 17, 2011 SQL SERVER – WRITELOG – Wait Type – Day 17 of 28
1630 Feb 16, 2011 SQL SERVER – Guest Post – Jonathan Kehayias – Wait Type – Day 16 of 28
1629 Feb 15, 2011 SQL SERVER – LCK_M_XXX – Wait Type – Day 15 of 28
1628 Feb 14, 2011 SQL SERVER – BACKUPIO, BACKUPBUFFER – Wait Type – Day 14 of 28
1627 Feb 13, 2011 SQL SERVER – FT_IFTS_SCHEDULER_IDLE_WAIT – Full Text – Wait Type – Day 13 of 28
1626 Feb 12, 2011 SQL SERVER – PAGELATCH_DT, PAGELATCH_EX, PAGELATCH_KP, PAGELATCH_SH, PAGELATCH_UP – Wait Type – Day 12 of 28
1625 Feb 11, 2011 SQL SERVER – ASYNC_IO_COMPLETION – Wait Type – Day 11 of 28
1624 Feb 10, 2011 SQL SERVER – IO_COMPLETION – Wait Type – Day 10 of 28
1623 Feb 10, 2011 SQLAuthority News – DotNET Challenge of Sorting Generic List
1622 Feb 09, 2011 SQL SERVER – PAGEIOLATCH_DT, PAGEIOLATCH_EX, PAGEIOLATCH_KP, PAGEIOLATCH_SH, PAGEIOLATCH_UP – Wait Type – Day 9 of 28
1621 Feb 08, 2011 SQL SERVER – SOS_SCHEDULER_YIELD – Wait Type – Day 8 of 28
1620 Feb 08, 2011 SQL SERVER – Automation Process Good or Ugly
1619 Feb 07, 2011 SQL SERVER – CXPACKET – Parallelism – Advanced Solution – Wait Type – Day 7 of 28
1618 Feb 07, 2011 SQLAuthority News – Presenting at Virtual Tech Days TechEd Pre-Con – February 9, 2011
1617 Feb 06, 2011 SQL SERVER – CXPACKET – Parallelism – Usual Solution – Wait Type – Day 6 of 28
1616 Feb 05, 2011 SQL SERVER – Capturing Wait Types and Wait Stats Information at Interval – Wait Type – Day 5 of 28
1615 Feb 04, 2011 SQL SERVER – DMV – sys.dm_os_waiting_tasks and sys.dm_exec_requests – Wait Type – Day 4 of 28
1614 Feb 03, 2011 SQL SERVER – DMV – sys.dm_os_wait_stats Explanation – Wait Type – Day 3 of 28
1613 Feb 02, 2011 SQL SERVER – Signal Wait Time Introduction with Simple Example – Wait Type – Day 2 of 28
1612 Feb 01, 2011 SQL SERVER – Wait Stats – Wait Types – Wait Queues – Day 0 of 28
1611 Feb 01, 2011 SQL SERVER – Introduction to Wait Stats and Wait Types – Wait Type – Day 1 of 28
1610 Jan 31, 2011 SQL SERVER – What is Fill Factor and What is the Best Value for Fill Factor
1609 Jan 30, 2011 SQL SERVER – Denali – SEQUENCE is not IDENTITY
1608 Jan 29, 2011 SQL SERVER – Denali – Introduction to SEQUENCE – Simple Example of SEQUENCE
1607 Jan 28, 2011 SQLAuthority News – Deployment guide for Microsoft SharePoint Foundation 2010
1606 Jan 27, 2011 SQL SERVER – What is a Technology Evangelist?
1605 Jan 26, 2011 SQL SERVER – Reducing Page Contention on TempDB
1604 Jan 25, 2011 SQL SERVER – Denali – Clipboard Ring – CTRL+SHIFT+V
1603 Jan 24, 2011 SQL SERVER – Denali – Multi-Monitor SSMS Windows
1602 Jan 23, 2011 SQLAuthority News – Download Whitepaper – Enabling and Securing Data Entry with Analysis Services Writeback
1601 Jan 22, 2011 SQL SERVER- Differences Between Left Join and Left Outer Join
1600 Jan 21, 2011 SQLAuthority News – 1600 Blog Post Articles – A Milestone
1599 Jan 20, 2011 SQLAuthority News – Scaling Up Your Data Warehouse with SQL Server 2008 R2
1598 Jan 19, 2011 SQL SERVER – Shrinking Database is Bad – Increases Fragmentation – Reduces Performance
1597 Jan 18, 2011 SQL SERVER – 4 Tips for ETL Software IDE Developers
1596 Jan 17, 2011 SQL SERVER – A Funny Cartoon on Index
1595 Jan 16, 2011 SQLAuthority News – Whitepaper Download – Using Star Join and Few-Outer-Row Optimizations to Improve Data Warehousing Queries
1594 Jan 15, 2011 SQLAuthority News – Best Practices for Data Warehousing with SQL Server 2008 R2
1593 Jan 14, 2011 SQL SERVER – Quick Look at SQL Server Configuration for Performance Indications
1592 Jan 13, 2011 SQL SERVER – A Quick Note on DB_ID() and DB_NAME() – Get Current Database ID – Get Current Database Name
1591 Jan 12, 2011 SQLAuthority News – Download SQL Server 2008 R2 Upgrade Technical Reference Guide
1590 Jan 11, 2011 SQL SERVER – Performance Tuning Resolution
1589 Jan 10, 2011 SQLAuthority News – Free Trip on SQL Cruise
1588 Jan 09, 2011 SQL SERVER – master Database Log File Grew Too Big
1587 Jan 08, 2011 SQL SERVER – Get File Statistics Using fn_virtualfilestats
1586 Jan 07, 2011 SQL SERVER – DMV – sys.dm_exec_query_optimizer_info – Statistics of Optimizer
1585 Jan 06, 2011 SQL SERVER – Beginning SQL Server: One Step at a Time – SQL Server Magazine
1584 Jan 05, 2011 SQL SERVER – Copy Statistics from One Server to Another Server
1583 Jan 04, 2011 SQL SERVER – 2008 – Unused Index Script – Download
1582 Jan 03, 2011 SQL SERVER – 2008 – Missing Index Script – Download
1581 Jan 02, 2011 SQL SERVER – Reduce the Virtual Log Files (VLFs) from LDF file
1580 Jan 01, 2011 SQLAuthority News – Resolution for New Year 2011
1579 Dec 31, 2010 SQLAuthority News – Community Service and Public Speaking Engagements
1578 Dec 30, 2010 SQL SERVER – Detect Virtual Log Files (VLF) in LDF
1577 Dec 29, 2010 SQLAuthority News – My Evaluation of Singapore SharePoint Conference
1576 Dec 28, 2010 SQL SERVER – Plan Cache and Data Cache in Memory
1575 Dec 27, 2010 SQL SERVER – ORDER BY ColumnName vs ORDER BY ColumnNumber
1574 Dec 26, 2010 SQL SERVER – Server Side Paging in SQL Server Denali – Part2
1573 Dec 25, 2010 SQLAuthority News – 18 Seconds of Fame – My PASS Experience
1572 Dec 24, 2010 SQLAuthority News – Feature Pack for Microsoft SQL Server 2005 SP4
1571 Dec 23, 2010 SQL SERVER – Index Created on View not Used Often – Observation of the View – Part 2
1570 Dec 22, 2010 SQL SERVER – Public Training and Private Training – Differences and Similarities – Public Training vs Private Training
1569 Dec 21, 2010 SQL SERVER – Index Created on View not Used Often – Observation of the View
1568 Dec 20, 2010 SQL SERVER – Securing TRUNCATE Permissions in SQL Server
1567 Dec 19, 2010 SQLAuthority News – Microsoft SQL Server 2005 Service Pack 4 RTM
1566 Dec 19, 2010 SQL SERVER – SQL Server 2008 with Service Pack 2
1565 Dec 18, 2010 SQL SERVER – Index Created on View not Used Often – Limitation of the View 12
1564 Dec 17, 2010 SQLAuthority News – A Successful Community TechDays at Ahmedabad – December 11, 2010
1563 Dec 16, 2010 SQL SERVER – Server Side Paging in SQL Server Denali Performance Comparison
1562 Dec 15, 2010 SQL SERVER – Server Side Paging in SQL Server Denali – A Better Alternative
1561 Dec 14, 2010 SQL SERVER – What the Business Says Is Not What the Business Wants
1560 Dec 13, 2010 SQL SERVER – What is Page Life Expectancy (PLE) Counter
1559 Dec 12, 2010 SQL SERVER – Activity Monitor and Performance Issue
1558 Dec 11, 2010 SQLAuthority News – SQL Server 2008 R2 System Views Map
1557 Dec 10, 2010 SQL SEVER – Finding Memory Pressure – External and Internal
1556 Dec 09, 2010 SQLAuthority News – Community Tech Days – December 11, 2010
1555 Dec 08, 2010 SQL SERVER – Installing AdventureWorks for SQL Server Denali
1554 Dec 07, 2010 SQLAuthority News – A Successful Performance Tuning Seminar at Pune – Dec 4-5, 2010
1553 Dec 06, 2010 SQL SERVER – Solution – Challenge – Puzzle – Usage of FAST Hint
1552 Dec 05, 2010 SQL SERVER – Solution – Puzzle – Challenge – Error While Converting Money to Decimal
1551 Dec 04, 2010 SQLAuthority News – Statistics Used by the Query Optimizer in Microsoft SQL Server 2008 – Microsoft Whitepaper
1550 Dec 03, 2010 SQL SERVER – A Successful Performance Tuning Seminar – Hyderabad – Nov 27-28, 2010 – Next Pune
1549 Dec 02, 2010 SQLAuthority News – Community Tech Days – A SQL Legends in Ahmedabad – December 11, 2010
1548 Dec 01, 2010 SQL SERVER – 3 Simple Puzzles – Need Your Suggestions
1547 Nov 30, 2010 SQL SERVER – Automated Type Conversion using Expressor Studio
1546 Nov 29, 2010 SQL SERVER – DBA or DBD? – Database Administrator or Database Developer
1545 Nov 28, 2010 SQL SERVER – Challenge – Puzzle – Why does RIGHT JOIN Exists
1544 Nov 27, 2010 SQL SERVER – Puzzle – Challenge – Error While Converting Money to Decimal
1543 Nov 26, 2010 SQL SERVER – Challenge – Puzzle – Usage of FAST Hint
1542 Nov 25, 2010 SQL SERVER – Concat Function in SQL Server – SQL Concatenation
1541 Nov 24, 2010 SQLAuthority News – What’s New in SQL Server “Denali”
1540 Nov 23, 2010 SQLAuthority News – SQLPASS Nov 8-11, 2010-Seattle – An Alternative Look at Experience
1539 Nov 22, 2010 SQLAuthority News – Statistics and Best Practices – Virtual Tech Days – Nov 22, 2010
1538 Nov 21, 2010 SQL SERVER – Change Database Access to Single User Mode Using SSMS
1537 Nov 20, 2010 SQLAuthority News – Book Review – Beginning T-SQL 2008 by Kathi Kellenberger
1536 Nov 19, 2010 SQLAuthority News – Blog Stats Revealed
1535 Nov 18, 2010 SQLAuthority News – SQL Server Performance Series Hyderabad / Pune – Nov/Dec 2010
1534 Nov 17, 2010 SQL SERVER – History of SQL Server Database Encryption
1533 Nov 16, 2010 SQLAuthority News – Download Whitepaper – Understanding and Controlling Parallel Query Processing in SQL Server
1532 Nov 15, 2010 SQL SERVER – Information Related to DATETIME and DATETIME2
1531 Nov 14, 2010 SQL SERVER – ERROR – FIX – Msg 3702, Level 16, State 3, Line 1 Cannot drop database “MyDBName” because it is currently in use
1530 Nov 13, 2010 SQL SERVER – Reducing CXPACKET Wait Stats for High Transactional Database
1529 Nov 12, 2010 SQL SERVER – Get All the Information of Database using sys.databases
1528 Nov 11, 2010 SQLAuthority News – SQL Server Denali CTP1 – Release Date November 9, 2010
1527 Nov 10, 2010 SQL SERVER – Get Database Backup History for a Single Database
1526 Nov 09, 2010 SQL SERVER – Recycle Error Log – Create New Log file without Server Restart
1525 Nov 08, 2010 SQLAuthority News – Why I am Going to Attend PASS Summit Unite 2010 – Seattle
1524 Nov 07, 2010 SQLAuthority News – Presenting at South East Asia SharePoint Conference – Oct 26, 27, 2010 – Singapore
1523 Nov 06, 2010 SQLAuthority News – Last Day to Participate in my Questions at SQL Quiz
1522 Nov 05, 2010 SQLAuthority News – Happy Deepavali and Happy News Year
1521 Nov 04, 2010 SQL SERVER – Finding Last Backup Time for All Database
1520 Nov 03, 2010 SQL SERVER – Fix: Error: MS Jet OLEDB 4.0 cannot be used for distributed queries because the provider is used to run in apartment mode.
1519 Nov 02, 2010 SQL SERVER – Are you a Database Administrator or a Database Developer?
1518 Nov 01, 2010 SQLAuthority News – 4th Birthday of Blog – 20 Million Views – Blog Anniversary – A Milestone
1517 Oct 31, 2010 SQLAuthority News – New Banner of Blog
1516 Oct 30, 2010 SQL SERVER – Minimum Maximum Memory – Server Memory Options
1515 Oct 29, 2010 SQL SERVER – List of all the Views from Database
1514 Oct 28, 2010 SQLAuthority News – Blog of Nupur Dave on Windows Live
1513 Oct 27, 2010 SQL SERVER – SQL Challenge – SQL Puzzle – Query Creating Most TempDB IO Usage
1512 Oct 26, 2010 SQLAuthority News – Database Performance for SharePoint Sites – Session Tomorrow in Singapore
1511 Oct 25, 2010 SQL SERVER – A Brief Introduction to DW 2.0
1510 Oct 24, 2010 SQL SERVER – Corrupted Backup File and Unsuccessful Restore
1509 Oct 23, 2010 SQL SERVER – Taking Multiple Backup of Database in Single Command – Mirrored Database Backup
1508 Oct 22, 2010 SQLAuthority News – SQLAuthority News – Presenting at South East Asia SharePoint Conference – Demo Details
1507 Oct 21, 2010 SQLAuthority News – Book Review – Beginning SQL Joes 2 Pros: The SQL Hands-On Guide for Beginners
1506 Oct 20, 2010 SQL SERVER – Could not connect to TCP error code 10061: No connection could be made because the target machine actively refused it
1505 Oct 19, 2010 SQLAuthority News – SQL Server Performance Optimizations Seminar – Grand Success – Colombo, Sri Lanka – Oct 4 – 5, 2010
1504 Oct 18, 2010 SQL SERVER – Change Column DataTypes
1503 Oct 17, 2010 SQL SERVER – System Stored Procedure sys.sp_tables
1502 Oct 16, 2010 SQL SERVER – StreamInsight and SQL Server 2008 R2
1501 Oct 15, 2010 SQLAuthority News – Microsoft WhitePaper on PowerPivot Data Refresh
1500 Oct 14, 2010 SQL SERVER – 1500 Posts – A MileStone – Origin of Blog Name Revealed
1499 Oct 13, 2010 SQL SERVER – Visiting Alma Mater – Delivering Session on Database Performance and Career – Nirma Institute of Technology
1498 Oct 12, 2010 SQL SERVER – Indexed View always Use Index on Table
1497 Oct 11, 2010 SQLAuthority News – Presenting at South East Asia SharePoint Conference – Maintaining SQL Server at Optimal Performance for Blazing Fast SharePoint Site
1496 Oct 10, 2010 SQL SERVER – Encrypted Stored Procedure and Activity Monitor
1495 Oct 09, 2010 SQLAuthority News – SQL Server 2008 Add-ins and Feature Pack Downloads
1494 Oct 08, 2010 SQL SERVER – Simple Explanation of Data Type Precedence
1493 Oct 07, 2010 SQL SERVER – SQL Quiz – The View, The Table and The Clustered Index Confusion
1492 Oct 06, 2010 SQL SERVER – Quickest Way to Identify Blocking Query and Resolution – Dirty Solution
1491 Oct 05, 2010 SQL SERVER – Error : Fix : Msg 5133, Level 16, State 1, Line 2 Directory lookup for the file failed with the operating system error 2(The system cannot find the file specified.)
1490 Oct 04, 2010 SQL SERVER – Find Total Number of Transaction on Interval
1489 Oct 03, 2010 SQL SERVER – The Limitations of the Views – Eleven and more…
1488 Oct 02, 2010 SQLAuthority News – SQL Server Seminar at Colombo Full – Hyderabad Few Seats Available
1487 Oct 01, 2010 SQL SERVER – Get Query Running in Session
1486 Sep 30, 2010 SQL SERVER – Microsoft SQL Server 2008 Service Pack 2 Download
1485 Sep 30, 2010 SQLAuthority News – Monthly Roundup of SQLAuthority Blog Posts
1484 Sep 29, 2010 SQL SERVER – View Over the View Not Possible with Index View – Limitations of the View 11
1483 Sep 28, 2010 SQLAuthority News – SQL Health Check and SQL Seminars
1482 Sep 27, 2010 SQL SERVER – Keywords View Definition Must Not Contain for Indexed View – Limitation of the View 10
1481 Sep 26, 2010 SQL SERVER – SELF JOIN Not Allowed in Indexed View – Limitation of the View 9
1480 Sep 25, 2010 SQL SERVER – Get Numeric Value From Alpha Numeric String – Get Numbers Only
1479 Sep 24, 2010 SQL SERVER – Outer Join Not Allowed in Indexed Views – Limitation of the View 8
1478 Sep 23, 2010 SQL SERVER – Cross Database Queries Not Allowed in Indexed View – Limitation of the View 7
1477 Sep 22, 2010 SQL SERVER – UNION Not Allowed but OR Allowed in Index View – Limitation of the View 6
1476 Sep 21, 2010 SQL SERVER – COUNT(*) Not Allowed but COUNT_BIG(*) Allowed – Limitation of the View 5
1475 Sep 20, 2010 SQL SERVER – How to Stop Growing Log File Too Big
1474 Sep 19, 2010 SQL SERVER – SSRS 2008 R2 – MapGallery and Codeplex – World Map
1473 Sep 18, 2010 SQL SERVER – 2008 R2 – PowerPivot for Microsoft Excel 2010 – RTM
1472 Sep 17, 2010 SQLAuthority News – How to Subscribe to this Blog?
1471 Sep 16, 2010 SQLAuthority News – What is an MVP? – How to become an MVP?
1470 Sep 15, 2010 SQL SERVER – SELECT * and Adding Column Issue in View – Limitation of the View 4
1469 Sep 14, 2010 SQL SERVER – Disabled Index and Index Levels and B-Tree
1468 Sep 13, 2010 SQL SERVER – What are Wait Types, Wait Stats and its Importance
1467 Sep 12, 2010 SQL SERVER – Soft Delete Conversation – Your Opinion Needed
1466 Sep 11, 2010 SQLAuthority News – Download – Microsoft SQL Server 2008 R2 Best Practices Analyzer Whitepaper
1465 Sep 10, 2010 SQL SERVER – Find Automatically Created Statistics – T-SQL
1464 Sep 09, 2010 SQLAuthority News – Spicejet Complaint – Update – No Outcome
1463 Sep 08, 2010 SQL SERVER – Find Row Count in Table – Find Largest Table in Database – Part 2
1462 Sep 07, 2010 SQL SERVER – Index Levels and Delete Operations – Page Level Observation
1461 Sep 06, 2010 SQL SERVER – Index Created on View not Used Often – Limitation of the View 3
1460 Sep 05, 2010 SQL SERVER – Few Notes on Fast Track Data Warehouse
1459 Sep 04, 2010 SQLAuthority News – Social Media Confusion – Twitter, FaceBook, LinkedIn and Me
1458 Sep 03, 2010 SQL SERVER – Soft Delete – IsDelete Column – Your Opinion
1457 Sep 02, 2010 SQLAuthority News – SQL Server Health Check Service – Speed UP SQL Server
1456 Sep 01, 2010 SQLAuthority News – Fathers and Daughters
1455 Aug 31, 2010 SQLAuthority News – A Monthly Round Up of SQLAuthority Blog Posts – August 2010
1454 Aug 30, 2010 SQLAuthority News – SQL Server Performance Optimization – Seminar Series
1453 Aug 29, 2010 SQLAuthority News – Download – SQL Server Monitoring Management Pack
1452 Aug 28, 2010 SQL SERVER – Plan Cache – Retrieve and Remove – A Simple Script
1451 Aug 27, 2010 SQLAuthority News – Spicejet Complain – Do Not Fly with Spicejet
1450 Aug 26, 2010 SQL SERVER – Adding Column is Expensive by Joining Table Outside View – Limitation of the Views Part 2
1449 Aug 25, 2010 SQL SERVER – Does Order of Column in WHERE clause Matter?
1448 Aug 24, 2010 SQLAuthority News – Download Microsoft SQL Server Migration Assistant
1447 Aug 24, 2010 SQLAuthority News – Feedback Received for Virtual Tech Days Sessions on Spatial Database
1446 Aug 23, 2010 SQL SERVER – ORDER BY Does Not Work – Limitation of the Views Part 1
1445 Aug 22, 2010 SQL SERVER – Computed Columns – Index and Performance
1444 Aug 21, 2010 SQL SERVER – Computed Column – PERSISTED and Storage – Part 2
1443 Aug 20, 2010 SQL SERVER – Function to Retrieve First Word of Sentence – String Operation
1442 Aug 19, 2010 SQL SERVER – Negative Identity Seed Value and Negative Increment Interval
1441 Aug 18, 2010 SQL SERVER – Download SQL Server 2008 Interview Questions and Answers Complete List
1440 Aug 17, 2010 SQLAuthority News – Speaking Online at Virtual Techdays – Aug 18, 2010 – Spatial Datatypes
1439 Aug 16, 2010 SQL SERVER – Finding the Occurrence of Character in String
1438 Aug 15, 2010 SQLAuthority News – Bookmark Link for Sync Framework for SQL Azure
1437 Aug 14, 2010 SQLAuthority News – Why SQL Server is better than any other RDBMS Applications?
1436 Aug 13, 2010 SQL SERVER – Computed Column and Performance – Part 3
1435 Aug 12, 2010 SQL SERVER – SHRINKDATABASE For Every Database in the SQL Server
1434 Aug 11, 2010 SQLAuthority News – MSDN Subscription Giveaway Announced
1433 Aug 10, 2010 SQL SERVER – Best Practices for DBA Before Taking Vacation
1432 Aug 09, 2010 SQLAuthority News – Risk and Health Assessment Program for Microsoft SQL Server – Scoping Tool v1.2
1431 Aug 09, 2010 SQLAuthority News – SQL Server Monitoring Management Pack Download
1430 Aug 08, 2010 SQLAuthority News – Microsoft SQL Server 2008 R2 Report Builder 3.0
1429 Aug 07, 2010 SQLAuthority News – Community Tech Days, Ahmedabad – July 24, 2010
1428 Aug 06, 2010 SQL SERVER – Parallelism Query in Database
1427 Aug 05, 2010 SQLAuthority News – SQL Data Camp, Chennai, July 17, 2010 – A Huge Success
1426 Aug 04, 2010 SQL SERVER – Computed Column – PERSISTED and Performance – Part 2
1425 Aug 03, 2010 SQL SERVER – Computed Column – PERSISTED and Performance
1424 Aug 02, 2010 SQLAuthority News – T-SQL Challenges and Hints and Suggestions
1423 Aug 01, 2010 SQL SERVER – Introduction to BINARY_CHECKSUM and Working Example
1422 Jul 31, 2010 SQLAuthority News – A Monthly Round Up of SQLAuthority Blog Posts
1421 Jul 30, 2010 SQLAuthority News – Author’s Birthday – 5 SQL Server Best Practices
1420 Jul 29, 2010 SQL SERVER – Check Advanced Server Configuration
1419 Jul 28, 2010 SQLAuthority News – 2 Sessions at TechInsight 2010 – June 29 – July 1, 2010
1418 Jul 27, 2010 SQL SERVER – Computed Column – PERSISTED and Storage
1417 Jul 26, 2010 SQL SERVER – FIX: ERROR: 8170 Insufficient result space to convert uniqueidentifier value to char
1416 Jul 25, 2010 SQLAuthority News – Last 2 Day to Win MSDN Subscription – Total 2 to Win
1415 Jul 24, 2010 SQLAuthority News – The story of the world – Spatial Data types – July 24, 2010
1414 Jul 24, 2010 SQL SERVER – Find Queries using Parallelism from Cached Plan
1413 Jul 23, 2010 SQLAuthority News – Guest Post – Walkthrough on Creating WCF Data Service (ODATA) and Consuming in Windows 7 Mobile application
1412 Jul 22, 2010 SQLAuthority News – SolidQ Journal Released – A Must Read for All
1411 Jul 21, 2010 SQL SERVER – Win USD 11,899 worth MSDN Subscription 5 Days to go
1410 Jul 20, 2010 SQL SERVER – SELECT * FROM dual – Dual Equivalent
1409 Jul 19, 2010 SQL SERVER – Identifying Statistics Used by Query
1408 Jul 18, 2010 SQLAuthority News – SQL Server Quickstart Downloads from Microsoft
1407 Jul 17, 2010 SQLAuthority News – Community TechDays, Ahmedabad – July 24, 2010
1406 Jul 16, 2010 SQL SERVER – Datetime Function TODATETIMEOFFSET Example
1405 Jul 15, 2010 SQL SERVER – Datetime Function SWITCHOFFSET Example
1404 Jul 14, 2010 SQLAuthority News – Two SQL Sessions at SQL Data Camp at Chennai – July 17, 2010
1403 Jul 13, 2010 SQL SERVER – How do I Learn and How do I Teach
1402 Jul 12, 2010 SQLAuthority News – FREE Microsoft Visual Studio 2010 Ultimate with MSDN
1401 Jul 11, 2010 SQL SERVER – Parallelism – Row per Processor – Row per Thread – Thread 0
1400 Jul 10, 2010 SQLAuthority News – Milestone – 1400th Post and Why do I blog
1399 Jul 09, 2010 SQLAuthority News – I am a MVP and I Love SQL Server
1398 Jul 08, 2010 SQL SERVER – The Self Join – Inner Join and Outer Join
1397 Jul 07, 2010 SQL SERVER – Upper Case Shortcut SQL Server Management Studio
1396 Jul 06, 2010 SQLAuthority News – I am Microsoft Certified Trainer (MCT)
1395 Jul 05, 2010 SQL SERVER – PowerShell Version Info
1394 Jul 04, 2010 SQL SERVER – Index Levels, Page Count, Record Count and DMV – sys.dm_db_index_physical_stats
1393 Jul 03, 2010 SQL SERVER – View XML Query Plans in SSMS as Graphical Execution Plan
1392 Jul 02, 2010 SQL SERVER – Parallelism – Row per Processor – Row per Thread
1391 Jul 01, 2010 SQL SERVER – Introduction to Best Practices Analyzer – Quick Tutorial
1390 Jun 30, 2010 SQLAuthority News – A Monthly Round Up of SQLAuthority Blog Posts
1389 Jun 29, 2010 SQL SERVER – Outer Join Not Allowed in Indexed Views
1388 Jun 29, 2010 SQLAuthority News – Exam 70-433 – MCTS – Microsoft SQL Server 2008, Database Development
1387 Jun 28, 2010 SQL SERVER – Default Statistics on Column – Automatic Statistics on Column
1386 Jun 27, 2010 SQLAuthority News – Announcing Winners of the Office 2010 Giveaway
1385 Jun 26, 2010 SQL SERVER – Fast Track Data Warehouse for SQL Server 2008
1384 Jun 25, 2010 SQLAuthority News – Download – Microsoft SQL Server 2008 R2 Best Practices Analyzer
1383 Jun 24, 2010 SQLAuthority News – Meeting Bryan Oliver and Learning Wisdom of Life
1382 Jun 23, 2010 SQLAuthority News – Guest Post – SELECT * FROM XML – Jacob Sebastian
1381 Jun 22, 2010 SQLAuthority News – Price List – Oracle vs SQL Server
1380 Jun 21, 2010 SQL SERVER – TRANSACTION, DML and Schema Locks
1379 Jun 20, 2010 SQL SERVER – Free Download – SQL Server 2008 R2 Update for Developers Training Kit
1378 Jun 19, 2010 SQLAuthority News – Delivering Two SQL Sessions at SQL Data Camp at Chennai – July 17, 2010
1377 Jun 18, 2010 SQLAuthority News – Interview with SQL Server MVP Madhivanan – A Real Problem Solver
1376 Jun 17, 2010 SQL SERVER – Data Pages in Buffer Pool – Data Stored in Memory Cache
1375 Jun 16, 2010 SQL SERVER – Find Largest Supported DML Operation – Question to You
1374 Jun 15, 2010 SQL SERVER – Shrinking NDF and MDF Files – Readers’ Opinion
1373 Jun 14, 2010 SQLAuthority News – Author Visit – SQL Server 2008 R2 Launch
1372 Jun 13, 2010 SQL SERVER – What is Denali?
1371 Jun 12, 2010 SQL SERVER – Difference Between DATETIME and DATETIME2 – WITH GETDATE
1370 Jun 11, 2010 SQL SERVER – Difference Between DATETIME and DATETIME2
1369 Jun 10, 2010 SQL SERVER – Difference Between GETDATE and SYSDATETIME
1368 Jun 09, 2010 SQL SERVER – Fastest Way to Restore the Database
1367 Jun 08, 2010 SQL SERVER – Merge Operations – Insert, Update, Delete in Single Execution
1366 Jun 07, 2010 SQL SERVER – Subquery or Join – Various Options – SQL Server Engine Knows the Best – Part 2
1365 Jun 06, 2010 SQL SERVER – Subquery or Join – Various Options – SQL Server Engine knows the Best
1364 Jun 05, 2010 SQL SERVER – Convert IN to EXISTS – Performance Talk
1363 Jun 04, 2010 SQL SERVER – Generate Database Script for SQL Azure
1362 Jun 03, 2010 SQLAuthority News – Training and Consultancy and Travel – Story of Last 30 Days
1361 Jun 02, 2010 SQL SERVER – Stored Procedure and Transactions
1360 Jun 01, 2010 SQL SERVER – Precision of SMALLDATETIME – A 1 Minute Precision
1359 May 31, 2010 SQLAuthority News – Monthly Roundup of Best SQL Posts
1358 May 30, 2010 SQLAuthority News – Guest Post – Performance Counters Gathering using Powershell
1357 May 29, 2010 SQLAuthority News – Guest Post – FAULT Contract in WCF with Learning Video
1356 May 28, 2010 SQL SERVER – Disabled Index and Update Statistics
1355 May 27, 2010 SQL SERVER – DATE and TIME in SQL Server 2008
1354 May 26, 2010 SQLAuthority News – SQL Server Technology Evangelists and Evangelism
1353 May 26, 2010 SQLAuthority News – Win MS Office License – Last 2 days
1352 May 25, 2010 SQLAuthority News – Whitepaper – SQL Azure vs. SQL Server
1351 May 24, 2010 SQLAuthority News – Microsoft SQL Server 2008 R2 – PowerPivot for Microsoft Excel 2010
1350 May 24, 2010 SQL SERVER – Check the Isolation Level with DBCC useroptions
1349 May 23, 2010 SQLAuthority News – Virtual Launch Event for Office 2010 – Contest – Win MS Office License
1348 May 22, 2010 SQLAuthority News – Downloads Available for Microsoft SQL Server Compact 3.5
1347 May 21, 2010 SQL SERVER – Simple Example of Snapshot Isolation – Reduce the Blocking Transactions
1346 May 20, 2010 SQLAuthority News – Professional Development and Community
1345 May 19, 2010 SQLAuthority News – Updated Favorite Scripts and Best Articles Page
1344 May 18, 2010 SQLAuthority Book Review – DBA Survivor: Become a Rock Star DBA
1343 May 17, 2010 SQLAuthority News – Bookmark – Deprecated Database Engine Features in SQL Server 2008
1342 May 16, 2010 SQLAuthority News – Storage and SQL Server Capacity Planning and configuration – SharePoint Server 2010
1341 May 15, 2010 SQL SERVER – List All the DMV and DMF on Server
1340 May 14, 2010 SQL SERVER – Find Most Expensive Queries Using DMV
1339 May 13, 2010 SQL SERVER – Four Posts on Removing the Bookmark Lookup – Key Lookup
1338 May 12, 2010 SQL SERVER – Understanding ALTER INDEX ALL REBUILD with Disabled Clustered Index
1337 May 11, 2010 SQL SERVER – Spatial Database Queries – What About BLOB – T-SQL Tuesday #006
1336 May 10, 2010 SQL SERVER – Size of Index Table for Each Index – Solution 3 – Powershell
1335 May 09, 2010 SQL SERVER – Size of Index Table for Each Index – Solution 2
1334 May 08, 2010 SQLAuthority News – MSDN Flash Mentions – TechNet Flash Mention – Top Community Contributors (Annual) Winner
1333 May 07, 2010 SQLAuthority News – List of Master Data Services White Paper
1332 May 06, 2010 SQLAuthority News – SQL Server 2008 R2 Hosted Trial
1331 May 06, 2010 SQLAuthority News – Wireless Router Security and Attached Devices – Complex Password
1330 May 05, 2010 SQL SERVER – Get Latest SQL Query for Sessions – DMV
1329 May 04, 2010 SQLAuthority News – Microsoft SQL Server 2005/2008 Query Optimization and Performance Tuning Training
1328 May 03, 2010 SQL SERVER – SHRINKFILE and TRUNCATE Log File in SQL Server 2008
1327 May 02, 2010 SQL SERVER – The Difference between Dual Core vs. Core 2 Duo
1326 May 01, 2010 SQL SERVER – What is AdventureWorks?
1325 Apr 30, 2010 SQLAuthority News – TechEd India – April 12-14, 2010 Bangalore – An Unforgettable Experience – An Opportunity of A Lifetime
1324 Apr 29, 2010 SQL SERVER – Disable Clustered Index and Data Insert
1323 Apr 28, 2010 SQL SERVER – GUID vs INT – Your Opinion
1322 Apr 27, 2010 SQLAuthority News – Public Training Classes In Hyderabad 12-14 May – SQL and 10-11 May SharePoint
1321 Apr 26, 2010 SQLAuthority News – Public Training Classes In Hyderabad 12-14 May – Microsoft SQL Server 2005/2008 Query Optimization & Performance Tuning
1320 Apr 26, 2010 SQL SERVER – Attach mdf file without ldf file in Database
1319 Apr 25, 2010 SQLAuthority News – Free Download – Microsoft SQL Server 2008 R2 RTM – Express with Management Tools – SQL Server 2008 R2 Books Online
1318 Apr 24, 2010 SQL SERVER – T-SQL Script to Take Database Offline – Take Database Online
1317 Apr 23, 2010 SQL SERVER – Update Statistics are Sampled By Default
1316 Apr 22, 2010 SQL SERVER – Create Primary Key with Specific Name when Creating Table
1315 Apr 21, 2010 SQL SERVER – When are Statistics Updated – What triggers Statistics to Update
1314 Apr 20, 2010 SQL SERVER – Find Max Worker Count using DMV – 32 Bit and 64 Bit
1313 Apr 19, 2010 SQL SERVER – Find Most Active Database in SQL Server – DMV dm_io_virtual_file_stats
1312 Apr 18, 2010 SQLAuthority News – Free eBook Download – Introducing Microsoft SQL Server 2008 R2
1311 Apr 17, 2010 SQL SERVER – SELECT TOP Shortcut in SQL Server Management Studio (SSMS)
1310 Apr 16, 2010 SQLAuthority News – Best Complements – DBA Survivor: Become a Rock Star DBA
1309 Apr 15, 2010 SQLAuthority News – Tips for Traveling to Nepal
1308 Apr 14, 2010 SQL SERVER – What is Spatial Database? – Developing with SQL Server Spatial and Deep Dive into Spatial Indexing
1307 Apr 13, 2010 SQL SERVER – Configure Management Data Collection in Quick Steps – T-SQL Tuesday #005
1306 Apr 13, 2010 SQLAuthority News – Three Posts on Reporting – T-SQL Tuesday #005
1305 Apr 12, 2010 SQL SERVER – What is MDS? – Master Data Services in Microsoft SQL Server 2008 R2
1304 Apr 11, 2010 SQLAuthority News – Spot the SQLAuthority Baby Contest – SQL Server Cheat Sheet
1303 Apr 10, 2010 SQLAuthority News – Speaking Sessions at TechEd India – 3 Sessions – 1 Panel Discussion
1302 Apr 09, 2010 SQLAuthority News – Meeting with Allen Bailochan Tuladhar – An Unlimited Experience
1301 Apr 08, 2010 SQLAuthority News – Author Visit Review – TechMela Nepal – March 29-30, 2010
1300 Apr 07, 2010 SQLAuthority News – Milestone of 1300th Post and A Few Updates
1299 Apr 06, 2010 SQL SERVER – Retrieve and Explore Database Backup without Restoring Database – Idera virtual database
1298 Apr 05, 2010 SQL SERVER – 2008 – Introduction to Snapshot Database – Restore From Snapshot
1297 Apr 04, 2010 SQL SERVER – Enable Identity Insert – Import Expert Wizard
1296 Apr 03, 2010 SQL SERVER – Difference Between GRANT and WITH GRANT
1295 Apr 02, 2010 SQL SERVER – Simple Installation of Master Data Services (MDS) and Sample Packages – Very Easy
1294 Apr 01, 2010 SQLAuthority News – MS Access Database is the Way to Go – April 1st Humor
1293 Mar 31, 2010 SQLAuthority News – SQL Server Cheat Sheet from MidnightDBA
1292 Mar 30, 2010 SQL SERVER – World Shapefile Download and Upload to Database – Spatial Database
1291 Mar 29, 2010 SQL SERVER – Introduction to Extended Events – Finding Long Running Queries
1290 Mar 28, 2010 SQLAuthority News – Author Visit to Nepal TechMela – 2 Technical Sessions
1289 Mar 27, 2010 SQL SERVER – FIX : ERROR : 4214 BACKUP LOG cannot be performed because there is no current database backup
1288 Mar 26, 2010 SQL SERVER – Generate Report for Index Physical Statistics – SSMS
1287 Mar 25, 2010 SQL SERVER – Out of the Box – Activity and Performance Reports from SSSMS
1286 Mar 24, 2010 SQL SERVER – Fix : Error : 8501 MSDTC on server is unavailable. Changed database context to publisherdatabase
1285 Mar 23, 2010 SQLAuthority News – We’re sorry… … but your computer or network may be sending automated queries. To protect our users, we can’t process your request right now.
1284 Mar 22, 2010 SQL SERVER – Enumerations in Relational Database – Best Practice
1283 Mar 21, 2010 SQL SERVER – Fix : Error : 3117 : The log or differential backup cannot be restored because no files are ready to rollforward
1282 Mar 20, 2010 SQLAuthority News – Microsoft SQL Server Protocol Documentation Download
1281 Mar 19, 2010 SQL SERVER – Interview Questions & Answers Needs Your Help
1280 Mar 18, 2010 SQL SERVER – Mirroring Configured Without Domain – The server network address TCP://SQLServerName:5023 can not be reached or does not exist
1279 Mar 17, 2010 SQL SERVER – Difference Between ROLLBACK IMMEDIATE and WITH NO_WAIT during ALTER DATABASE
1278 Mar 16, 2010 SQL SERVER – Quick Note of Database Mirroring
1277 Mar 15, 2010 SQL SERVER – MAXDOP Settings to Limit Query to Run on Specific CPU
1276 Mar 14, 2010 SQLAuthority News – Interesting Whitepaper – We Loaded 1TB in 30 Minutes with SSIS, and So Can You
1275 Mar 13, 2010 SQLAuthority News – SQL Server 2008 R2 Update for Developers Training Kit (March 2010 Update)
1274 Mar 13, 2010 SQLAuthority News – Download Microsoft SQL Server JDBC Driver 3.0 CTP 1
1273 Mar 12, 2010 SQL SERVER – Checklist for Analyzing Slow-Running Queries
1272 Mar 11, 2010 SQL SERVER – Force Index Scan on Table – Use No Index to Retrieve the Data – Query Hint
1271 Mar 10, 2010 SQLAuthority Book Review – Professional SQL Server 2008 Internals and Troubleshooting
1270 Mar 09, 2010 SQL SERVER – Improve Performance by Reducing IO – Creating Covered Index
1269 Mar 08, 2010 SQLAuthority News – SQL SERVER 2008 R2 Pricing
1268 Mar 07, 2010 SQLAuthority News – Office 2010 Readiness Check – Are you ready for Office 2010?
1267 Mar 06, 2010 SQLAuthority News – SQL Server Modeling CTP – Nov 2009 Release 2 (formerly Oslo)
1266 Mar 05, 2010 SQL SERVER – Order of Columns in Update Statement Does not Matter
1265 Mar 04, 2010 SQL SERVER – Rollback TRUNCATE Command in Transaction
1264 Mar 03, 2010 SQL SERVER – Performance Comparison – INSERT TOP (N) INTO Table – Using Top with INSERT
1263 Mar 02, 2010 SQLAuthority News – Excellent Event – TechEd Sri Lanka – Feb 8, 2010
1262 Mar 01, 2010 SQL SERVER – Data and Page Compressions – Data Storage and IO Improvement
1261 Feb 28, 2010 SQLAuthority News – Hyderabad Techies February Fever Feb 11, 2010 – Indexing for Performance
1260 Feb 27, 2010 SQL SERVER – INSERT TOP (N) INTO Table – Using Top with INSERT
1259 Feb 26, 2010 SQLAuthority News – Keeping Your Ducks in a Row
1258 Feb 25, 2010 SQLAuthority News – MUGH – Microsoft User Group Hyderabad – Feb 2, 2010 Session Review
1257 Feb 24, 2010 SQL SERVER – Introduction to Rollup Clause
1256 Feb 23, 2010 SQLAuthority News – Links to Book On Line – Data Mining Algorithms (Analysis Services – Data Mining)
1255 Feb 22, 2010 SQLAuthority News – Blog Subscription and Comments RSS
1254 Feb 21, 2010 SQL SERVER- IF EXISTS(Select null from table) vs IF EXISTS(Select 1 from table)
1253 Feb 20, 2010 SQL SERVER – Recompile Stored Procedure at Run Time
1252 Feb 19, 2010 SQLAuthority News – Microsoft SQL Server Migration Assistant 2008 for MySQL v1.0 CTP1
1251 Feb 18, 2010 SQL SERVER – Plan Recompilation and Reduce Recompilation – Performance Tuning
1250 Feb 17, 2010 SQLAuthority News – SQL Server Technical Article – The Data Loading Performance Guide
1249 Feb 16, 2010 SQL SERVER – Stored Procedure Optimization Tips – Best Practices
1248 Feb 15, 2010 SQL SERVER – Difference Between Update Lock and Exclusive Lock
1247 Feb 14, 2010 SQLAuthority News – SuperFlow for Creating SRS Report Models in Configuration Manager 2007
1246 Feb 13, 2010 SQLAuthority News – Download SQL Server 2008 Express Datasheet
1245 Feb 12, 2010 SQLAuthority News – Ahmedabad Community Tech Days – Jan 30, 2010 – Huge Success
1244 Feb 11, 2010 SQL SERVER – ALTER DATABASE dbname SET SINGLE_USER WITH ROLLBACK IMMEDIATE
1243 Feb 10, 2010 SQLAuthority News – Converting a Delimited String of Values into Columns
1242 Feb 09, 2010 SQL SERVER – Brief Note about StreamInsight – What is StreamInsight
1241 Feb 08, 2010 SQL SERVER – Find the Size of Database File – Find the Size of Log File
1240 Feb 07, 2010 SQL SERVER – SQL Server 2008 R2 Update for Developers Training Kit
1239 Feb 06, 2010 SQLAuthority News – Presenting Two Sessions at TechED Sri Lanka
1238 Feb 05, 2010 SQL SERVER – Stream Aggregate Showplan Operator – Reason of Compute Scalar before Stream Aggregate
1237 Feb 04, 2010 SQL SERVER – Get the List of Object Dependencies – sp_depends and information_schema.routines and sys.dm_sql_referencing_entities
1236 Feb 03, 2010 SQLAuthority News – MVP Open Day South Asia – Jan 20, 2010 – Jan 23, 2010 – Review Part Fun
1235 Feb 02, 2010 SQLAuthority News – MVP Open Day South Asia – Jan 20, 2010 – Jan 23, 2010 – Review Part Business
1234 Feb 01, 2010 SQL SERVER – Question – How to Convert Hex to Decimal
1233 Jan 31, 2010 SQL SERVER – Location of Resource Database in SQL Server Editions
1232 Jan 30, 2010 SQL SERVER – Several Readers Questions and Readers Answers
1231 Jan 29, 2010 SQLAuthority News – Microsoft in India – Leadership Profiles
1230 Jan 28, 2010 SQLAuthority News – Community Tech Days – Jan 30, 2010 – Must Attend
1229 Jan 27, 2010 SQLAuthority News – SQL Server 2008 R2 – Release Date in May 2010
1228 Jan 26, 2010 SQLAuthority News – Download White Paper – Troubleshooting Performance Problems in SQL Server 2008
1227 Jan 25, 2010 SQL SERVER – Find Statistics Update Date – Update Statistics
1226 Jan 24, 2010 SQLAuthority News – Download Sample Databases for Microsoft SQL Server 2008 (December 2009) Samples Refresh 4
1225 Jan 23, 2010 SQLAuthority News – Remote BLOB Store Provider Library Implementation Specification
1224 Jan 22, 2010 SQL SERVER – Execution Plan – Estimated I/O Cost – Estimated CPU Cost – No Unit
1223 Jan 21, 2010 SQLAuthority News – Community Tech Days – Jan 30, 2010 – Event Announcement
1222 Jan 20, 2010 SQLAuthority News – MVP Open Day South Asia – Jan 20, 2010 – Jan 23, 2010
1221 Jan 19, 2010 SQL SERVER – SSMS Query Command(s) completed successfully without ANY Results
1220 Jan 18, 2010 SQL SERVER – DMV Error: FIX: Error: Msg 297, Level 16 The user does not have permission to perform this action
1219 Jan 17, 2010 SQL SERVER – Get Server Version and Additional Info
1218 Jan 16, 2010 SQLAuthority News – Download Windows Azure Platform Training Kit – December Update
1217 Jan 15, 2010 SQL SERVER – Initializing a Merge Subscription Without a Snapshot
1216 Jan 15, 2010 SQLAuthority News – Vote for SQL Server 2005 Service Pack 4 – Vote for SQL Server 2008 Service Pack 2
1215 Jan 14, 2010 SQL SERVER – Find Busiest Database
1214 Jan 13, 2010 SQLAuthority News – SQL Server Migration QuickStart
1213 Jan 12, 2010 SQL SERVER – Fragmentation – Detect Fragmentation and Eliminate Fragmentation
1212 Jan 11, 2010 SQL SERVER – The server network address “TCP://SQLServer:5023″ can not be reached or does not exist. Check the network address name and that the ports for the local and remote endpoints are operational. (Microsoft SQL Server, Error: 1418)
1211 Jan 10, 2010 SQLAuthority News – Download – Microsoft Sync Framework Power Pack for SQL Azure November CTP (32-bit)
1210 Jan 09, 2010 SQLAuthority News – Microsoft SQL Server Migration Assistant 2008 for MySQL v1.0 CTP1
1209 Jan 08, 2010 SQLAuthority News – Ahmedabad – Gandhinagar SQL Server User Group Meet – Dec 19, 2009
1208 Jan 07, 2010 SQLAuthority News – Webcasts – Resources for IT Managers and their Teams
1207 Jan 06, 2010 SQL SERVER – Unique Nonclustered Index Creation with IGNORE_DUP_KEY = ON – A Transactional Behavior
1206 Jan 05, 2010 SQL SERVER – SQL Server RDL Specification
1205 Jan 05, 2010 SQL SERVER – Fix: Error: 262 : SHOWPLAN permission denied in database
1204 Jan 04, 2010 SQL SERVER – Unique Nonclustered Index Creation with IGNORE_DUP_KEY = ON
1203 Jan 03, 2010 SQLAuthority News – TechDays Session at Infosys Mysore 2009 – Change Data Capture and PowerPivot
1202 Jan 02, 2010 SQL SERVER – Find Location of Data File Using T-SQL
1201 Jan 01, 2010 SQL SERVER – FIX: Error: 1807 Could not obtain exclusive lock on database ‘model’. Retry the operation later.
1200 Dec 31, 2009 SQLAuthority News – 1200th Post – An Important Milestone
1199 Dec 30, 2009 SQL SERVER – FIX : Error : Msg 1949, Level 16: Cannot create index on view. The function yields nondeterministic results. Use a deterministic system function, or modify the user-defined function to return deterministic results.
1198 Dec 29, 2009 SQL SERVER – Get Date of All Weekdays or Weekends of the Year
1197 Dec 28, 2009 SQL SERVER – Difference Temp Table and Table Variable – Effect of Transaction
1196 Dec 27, 2009 SQL SERVER – Download FREE SQL SERVER Express Edition and Service Pack 1
1195 Dec 26, 2009 SQL SERVER – Whitepaper SQL Server 2008 Full-Text Search: Internals and Enhancements
1194 Dec 25, 2009 SQL SERVER – CDC and TRUNCATE – Cannot truncate table because it is published for replication or enabled for Change Data Capture
1193 Dec 24, 2009 SQL Authority News – Training MS SQL Server 2005/2008 Query Optimization And Performance Tuning
1192 Dec 23, 2009 SQL SERVER – ORDER BY Clause and TOP WITH TIES
1191 Dec 22, 2009 SQLAuthority News – Meeting SQL Expert Imran at Hyderabad
1190 Dec 21, 2009 SQL SERVER – Comma Separated Values (CSV) from Table Column – Part 2
1189 Dec 20, 2009 SQLAuthority News – Migrating DTS Packages to Integration Services
1188 Dec 19, 2009 SQLAuthority News – Migrating to SQL Server from Other Database Products
1187 Dec 18, 2009 SQL SERVER – Differences in Vulnerability between Oracle and SQL Server
1186 Dec 17, 2009 SQLAuthority News – Hub-And-Spoke: Building an EDW with SQL Server and Strategies of Implementation
1185 Dec 16, 2009 SQL SERVER – Fillfactor, Index and In-depth Look at Effect on Performance
1184 Dec 15, 2009 SQL SERVER – Difference TempTable and Table Variable – TempTable in Memory a Myth
1183 Dec 14, 2009 SQLAuthority News – An Year of Personal Events – A Life Outside SQL
1182 Dec 13, 2009 SQL SERVER – White Paper – Partitioned Table and Index Strategies Using SQL Server 2008
1181 Dec 12, 2009 SQLAuthority News – Featured on Channel 9
1180 Dec 11, 2009 SQL SERVER – ERROR: FIX: Cannot drop server because it is used as a Distributor in replication
1179 Dec 10, 2009 SQL SERVER – Future of Business Intelligence
1178 Dec 09, 2009 SQL SERVER – Business Intelligence – Aligning Business Metrics
1177 Dec 08, 2009 SQL SERVER – Fix : Error : Invalid object name ‘sys.configurations’. (Microsoft SQL Server, Error: 208)
1176 Dec 07, 2009 SQL Server – White Paper – An Introduction to Fast Track Data Warehouse Architectures by Erik Veerman
1175 Dec 06, 2009 SQL SERVER – White Papers – Consolidation Guidance for SQL Server – Consolidation Using SQL Server 2008
1174 Dec 05, 2009 SQLAuthority News – Notes from TechDays 2009 at Infosys, Bangalore
1173 Dec 04, 2009 SQL SERVER – 2008 Star Join Query Optimization
1172 Dec 03, 2009 SQLAuthority News – Airline Review – Paramount, Kingfisher, Go Air, Indigo, Jet Airways, Indian Airlines, Spicejet
1171 Dec 02, 2009 SQL SERVER – Validate an XML document in TSQL using XSD by Jacob Sebastian
1170 Dec 01, 2009 SQLAuthority News – A Daily Doze of Technology – Alvin Ashcraft’s Morning Dew
1169 Nov 30, 2009 SQL SERVER – Size of Index Table for Each Index – Solution
1168 Nov 29, 2009 SQL SERVER – Azure Start Guide – Step by Step Installation Guide
1167 Nov 28, 2009 SQLAuthority News – SQL Server R2 Resources Downloads, Documentations
1166 Nov 27, 2009 SQLAuthority News – Subscribe to Blog – Search a Blog
1165 Nov 26, 2009 SQLAuthority News – SQL Server 2008 Analysis Services Performance Guide
1164 Nov 25, 2009 SQL SERVER – Comma Separated Values (CSV) from Table Column
1163 Nov 24, 2009 SQL SERVER – Interesting Observation – TOP 100 PERCENT and ORDER BY
1162 Nov 23, 2009 SQL SERVER – A Common Design Problem – Should the Primary Key Always be a Clustered Index
1161 Nov 22, 2009 SQL SERVER – Remove Bookmark Key Lookup – 4 Different Ideas
1160 Nov 21, 2009 SQLAuthority News – SQL Server 2008 for Oracle DBA
1159 Nov 20, 2009 SQLAuthority News – Book Review – Expert SQL Server 2008 Encryption by Michael Coles
1158 Nov 19, 2009 SQL SERVER – Understanding Table Hints with Examples
1157 Nov 18, 2009 SQL SERVER – Size of Index Table – A Puzzle to Find Index Size for Each Index on Table
1156 Nov 17, 2009 SQL SERVER – 2005 2008 – Backup, Integrity Check and Index Optimization By Ola Hallengren
1155 Nov 16, 2009 SQLAuthority News – Notes of Excellent Experience at SQL PASS 2009 Summit, Seattle
1154 Nov 15, 2009 SQL SERVER – Whitepaper Consolidation Using SQL Server 2008
1153 Nov 14, 2009 SQLAuthority News – Disk Partition Alignment Best Practices for SQL Server
1152 Nov 13, 2009 SQL SERVER – Policy Based Management – Create, Evaluate and Fix Policies
1151 Nov 12, 2009 SQL SERVER – Disable CHECK Constraint – Enable CHECK Constraint
1150 Nov 11, 2009 SQL SERVER – Sharepoint Resource Available for SQL Server
1149 Nov 10, 2009 SQL Authority News – Training MS SQL Server 2005/2008 Query Optimization And Performance Tuning
1148 Nov 09, 2009 SQL SERVER – Removing Key Lookup – Seek Predicate – Predicate – An Interesting Observation Related to Datatypes
1147 Nov 08, 2009 SQL SERVER – Stored Procedure are Compiled on First Run – SP taking Longer to Run First Time
1146 Nov 07, 2009 SQLAuthority News – Data Compression Strategy Capacity Planning and Best Practices
1145 Nov 06, 2009 SQLAuthority News – SQL PASS Summit, Seattle 2009 – Day 4
1144 Nov 05, 2009 SQLAuthority News – SQL PASS Summit, Seattle 2009 – Day 3
1143 Nov 04, 2009 SQLAuthority News – SQL PASS Summit, Seattle 2009 – Day 2
1142 Nov 03, 2009 SQLAuthority News – SQL PASS Summit, Seattle 2009 – Day 1
1141 Nov 02, 2009 SQLAuthority News – 3 Year Old Blog – PASS Summit 2009 – 10.5 Million Views
1140 Nov 01, 2009 SQL Authority News – Advanced T-SQL with Itzik Ben-Gan – Solid Quality Mentors
1139 Oct 31, 2009 SQLAuthority News – New PASS President Rushabh Mehta
1138 Oct 30, 2009 SQLAuthority News – India Market and Third Party SQL Server Tools
1137 Oct 29, 2009 SQLAuthority News – Birds-of-a-Feather (BOF) Lunch – SQL PASS Summit, Seattle, 2009
1136 Oct 28, 2009 SQL SERVER – Tuning the Performance of Change Data Capture in SQL Server 2008
1135 Oct 27, 2009 SQL SERVER – How to Enable Index – How to Disable Index – Incorrect syntax near ‘ENABLE’
1134 Oct 26, 2009 SQL SERVER – Advanced T-SQL with Itzik Ben-Gan – A Dream Coming True
1133 Oct 25, 2009 SQLAuthority News – Best Practices for Integration Services Configurations
1132 Oct 24, 2009 SQL SERVER – Link to SQL Server Book Online – BOL
1131 Oct 23, 2009 SQLAuthority News – PASS Sessions – I will be there!
1130 Oct 22, 2009 SQL SERVER – Difference Between Candidate Keys and Primary Key
1129 Oct 21, 2009 SQL SERVER – Introduction to Business Intelligence – Important Terms & Definitions
1128 Oct 20, 2009 SQLAuthority News – PASS 2009 Sessions on Query Optimization and Performance Tuning
1127 Oct 19, 2009 SQL SERVER – Change Collation of Database Column – T-SQL Script – Consolidating Collations – Extention Script
1126 Oct 18, 2009 SQLAuthority News – Whitepaper – Auditing in SQL Server 2008
1125 Oct 17, 2009 SQLAuthority News – Happy Diwali and New Year
1124 Oct 16, 2009 SQL SERVER – Recently Executed T-SQL Query
1123 Oct 15, 2009 SQL SERVER – Enable Automatic Statistic Update on Database
1122 Oct 14, 2009 SQLAuthority News – First Editorial – T-SQL Challenges Beginners
1121 Oct 13, 2009 SQL SERVER – Comic Slow Query – SQL Joke
1120 Oct 12, 2009 SQL SERVER – Query Optimization – Remove Bookmark Lookup – Remove RID Lookup – Remove Key Lookup – Part 3
1119 Oct 11, 2009 SQLAuthority News – Accessing SQL Server Databases with PHP
1118 Oct 10, 2009 SQL SERVER – Download Logical Query Processing Poster
1117 Oct 09, 2009 SQL SERVER – Queries Waiting for Memory Allocation to Execute
1116 Oct 08, 2009 SQL SERVER – Query Optimization – Remove Bookmark Lookup – Remove RID Lookup – Remove Key Lookup – Part 2
1115 Oct 07, 2009 SQL SERVER – Query Optimization – Remove Bookmark Lookup – Remove RID Lookup – Remove Key Lookup
1114 Oct 06, 2009 SQL SERVER – Interesting Observation – Query Hint – FORCE ORDER
1113 Oct 05, 2009 SQLAuthority News – Community TechDays in Ahmedabad – A Successful Event – Oct 3, 2009
1112 Oct 04, 2009 SQL SERVER – Choose Right Edition of SQL Server Express for Your Application
1111 Oct 03, 2009 SQLAuthority News – Database Encryption in SQL Server 2008 Enterprise Edition
1110 Oct 02, 2009 SQLAuthority News – SQL Server 2008 – The Other Side of Index – Live Presentation in Ahmedabad
1109 Oct 01, 2009 SQL SERVER – SQL Server Management Studio and Client Statistics
1108 Sep 30, 2009 SQLAuthority News – Community Tech Days – Oct 3, 2009 – SQL Server 2008 – The Other Side of Index
1107 Sep 29, 2009 SQL SERVER – Interesting Observation – Execution Plan and Results of Aggregate Concatenation Queries
1106 Sep 28, 2009 SQLAuthority News – Download IIS Database Manager
1105 Sep 27, 2009 SQLAuthority News – FILESTREAM Storage in SQL Server 2008
1104 Sep 26, 2009 SQLAuthority News – FIX : An error occurred while executing this command. If this error persists, please contact your Live Meeting administrator.
1103 Sep 25, 2009 SQL SERVER – Outer Join in Indexed View – Question to Readers
1102 Sep 24, 2009 SQL SERVER – Interesting Observation – Index on Index View Used in Similar Query
1101 Sep 23, 2009 SQL SERVER – Insert Values of Stored Procedure in Table – Use Table Valued Function
1100 Sep 22, 2009 SQLAuthority News – Article 1100 and Community Service
1099 Sep 21, 2009 SQL SERVER – Introduction to Service Broker and Sample Script
1098 Sep 20, 2009 SQL SERVER – Execution Plan and Results of Aggregate Concatenation Queries Depend Upon Expression Location
1097 Sep 19, 2009 SQLAuthority News – SQL Server Accelerator for Business Intelligence (BI)
1096 Sep 18, 2009 SQLAuthority News – Community Tech Days Oct 3, 2009 – Ahmedabad
1095 Sep 17, 2009 SQL SERVER – Converting Stored Procedure into Table Valued Function
1094 Sep 16, 2009 SQLAuthority News – Download Microsoft SQL Server StreamInsight CTP2
1093 Sep 15, 2009 SQL SERVER – Cryptography in SQL Server 2008
1092 Sep 14, 2009 SQL SERVER – Plan Caching and Schema Change – An Interesting Observation
1091 Sep 13, 2009 SQL SERVER – Introduction to Spatial Coordinate Systems: Flat Maps for a Round Planet
1090 Sep 12, 2009 SQLAuthority News – Risk and Health Assessment Program for Microsoft SQL Server – Scoping Tool v1.2
1089 Sep 11, 2009 SQLAuthority News – Why I am Going to Attend PASS Summit Unite 2009- Seattle
1088 Sep 10, 2009 SQL SERVER – SQL Server Desktop Screen Background
1087 Sep 09, 2009 SQL SERVER – Difference between SQL Server Express and MySQL
1086 Sep 08, 2009 SQLAuthority News – Shaivi Dave – Baby SQLAuthority
1085 Sep 07, 2009 SQL SERVER – Importance of Database Schemas in SQL Server
1084 Sep 06, 2009 SQL SERVER – Find Gaps in The Sequence
1083 Sep 05, 2009 SQL SERVER – FIX – ERROR : Cannot drop the database because it is being used for replication. (Microsoft SQL Server, Error: 3724)
1082 Sep 04, 2009 SQL SERVER – Designing SQL Server 2005 Analysis Services Cubes for Excel 2007 PivotTables
1081 Sep 03, 2009 SQL SERVER – What is Data Mining – A Simple Introductory Note
1080 Sep 02, 2009 SQL SERVER – Mirrored Backup and Restore and Split File Backup
1079 Sep 01, 2009 SQL SERVER – Download Script of Change Data Capture (CDC)
1078 Sep 01, 2009 SQLAuthority News – Baby SQLAuthority is here!
1077 Aug 31, 2009 SQLAuthority News – Effect of Oracle acquiring MySQL – A Delayed Analysis
1076 Aug 30, 2009 SQLAuthority News – Application and Multi-Server Management
1075 Aug 29, 2009 SQL SERVER – Plan Caching in SQL Server 2008 by Greg Low
1074 Aug 28, 2009 SQL SERVER – Best Practices – Implementation of Database Object Schemas
1073 Aug 27, 2009 SQL SERVER – Introduction to SQL Azure
1072 Aug 26, 2009 SQL SERVER – SQL Server Express – A Complete Reference Guide
1071 Aug 25, 2009 SQLAuthority News – Business Intelligence Training Roadshow August September 2009
1070 Aug 24, 2009 SQL SERVER – Index Seek vs. Index Scan – Diffefence and Usage – A Simple Note
1069 Aug 23, 2009 SQLAuthority News – SQL Server 2008 Migration White Papers
1068 Aug 22, 2009 SQLAuthority News – Microsoft SQL Server 2008 Books Online
1067 Aug 21, 2009 SQL SERVER – Get Query Plan Along with Query Text and Execution Count
1066 Aug 20, 2009 SQL SERVER – FIX : ERROR : Cannot open database requested by the login. The login failed. Login failed for user ‘NT AUTHORITY\NETWORK SERVICE’.
1065 Aug 19, 2009 SQLAuthority News – Two Virtual Tech Days Sessions – Watch it Online
1064 Aug 18, 2009 SQLAuthority News – Beyond Relational Interview on SQL Server 2008 Beyond Relational
1063 Aug 17, 2009 SQL SERVER – Measure CPU Pressure – CPU Business
1062 Aug 16, 2009 SQLAuthority News – Evaluate the Microsoft SQL Server 2008 R2 August Community Technology Preview (CTP)
1061 Aug 15, 2009 SQL SERVER – Introduction to Change Data Capture (CDC) in SQL Server 2008
1060 Aug 14, 2009 SQLAuthority News – USB Drive Fails to Copy Large File
1059 Aug 13, 2009 SQL SERVER – Reason for SQL Server Agent Starting Before SQL Server Engine Service
1058 Aug 12, 2009 SQL SERVER – Backup master Database Interval – master Database Best Practices
1057 Aug 11, 2009 SQL SERVER – Discussion – Effect of Missing Identity on System – Real World Scenario
1056 Aug 10, 2009 SQLAuthority News – A Quick Guide to Twitter
1055 Aug 09, 2009 SQLAuthority News – Interview with SQL Server MVP Glenn Berry
1054 Aug 08, 2009 SQL Server – Multiple CTE in One SELECT Statement Query
1053 Aug 07, 2009 SQLAuthority News – Humorous SQL Cake – Funny SQL Cake
1052 Aug 06, 2009 SQL SERVER – Get Time in Hour:Minute Format from a Datetime – Get Date Part Only from Datetime
1051 Aug 05, 2009 SQL SERVER – Get a List of Fixed Hard Drive and Free Space on Server
1050 Aug 04, 2009 SQL SERVER – Forgot the Password of Username SA
1049 Aug 04, 2009 SQLAuthority News – Author Visit – Virtual Tech Days August 2009
1048 Aug 03, 2009 SQL SERVER – Introduction to SQL Server 2008 Profiler
1047 Aug 02, 2009 SQLAuthority News – Proposed eGov Standards Policy – Benefit for All or Only A Chosen Few
1046 Aug 01, 2009 SQLAuthority News – Download Microsoft SQL Server Management Pack for Operations Manager 2007
1045 Jul 31, 2009 SQL SERVER – Introduction to Cloud Computing
1044 Jul 30, 2009 SQLAuthority News – Author’s Birthday – Top 7 Commenters – Volunteers
1043 Jul 29, 2009 SQL SERVER – 2008 – Copy Database With Data – Generate T-SQL For Inserting Data From One Table to Another Table
1042 Jul 28, 2009 SQL SERVER – 2008 – Design Process Decision Flow
1041 Jul 27, 2009 SQL SERVER – List All Missing Identity Values of Table in Database
1040 Jul 26, 2009 SQLAuthority News – Search SQL Server Solutions
1039 Jul 25, 2009 SQLAuthority News – Download – Cumulative Update Package for SQL Server 2008
1038 Jul 24, 2009 SQL SERVER – Maximizing View of SQL Server Management Studio – Full Screen – New Screen
1037 Jul 23, 2009 SQL SERVER – Puzzle – Write Script to Generate Primary Key and Foreign Key
1036 Jul 22, 2009 SQLAuthority News – SQL Server Value Calculator
1035 Jul 21, 2009 SQLAuthority News – SQL Azure – Microsoft SQL Data Services – Introduction and Pricing
1034 Jul 20, 2009 SQLAuthority News – Authors Visit – DelhiBuzz TechEd on July 11, 2009
1033 Jul 19, 2009 SQL SERVER – Get Last Running Query Based on SPID
1032 Jul 18, 2009 SQLAuthority News – Whitepaper – Using the Resource Governor
1031 Jul 17, 2009 SQL SERVER – Two Methods to Retrieve List of Primary Keys and Foreign Keys of Database
1030 Jul 16, 2009 SQL SERVER – Four Different Ways to Find Recovery Model for Database
1029 Jul 15, 2009 SQL SERVER – Restore Sequence and Understanding NORECOVERY and RECOVERY
1028 Jul 14, 2009 SQL SERVER – Backup Timeline and Understanding of Database Restore Process in Full Recovery Model
1027 Jul 13, 2009 SQL SERVER – BLOB – Pointer to Image, Image in Database, FILESTREAM Storage
1026 Jul 12, 2009 SQLAuthority News – Big Thinkers – Robert Cain
1025 Jul 11, 2009 SQL SERVER – Standby Servers and Types of Standby Servers
1024 Jul 10, 2009 SQLAuthority News – Request SQLAuthority.com Stickers and SQL Server Cheat Sheet
1023 Jul 09, 2009 SQLAuthority News – Authors Visit – K-MUG TechEd Trivandrum on June 27, 2009
1022 Jul 08, 2009 SQLAuthority News – Book Review – Murach’s SQL Server 2008 for Developers
1021 Jul 07, 2009 SQLAuthority News – Authors Visit – DotNet Buzz Delhi TechEd Delhi on July 11, 2009
1020 Jul 06, 2009 SQL SERVER – Languages for BI – MDX, DMX, XMLA
1019 Jul 05, 2009 SQLAuthority News – FIX : Error : HP OfficeJet Scanning and Printing Gray or Pink Shades
1018 Jul 04, 2009 SQL SERVER – Disk Partition Alignment Best Practices
1017 Jul 03, 2009 SQLAuthority News – Book Review – The Rational Guide to Building Technical User Communities (Rational Guides)
1016 Jul 02, 2009 SQLAuthority News – MVP Award Renewed
1015 Jul 01, 2009 SQL SERVER – Difference between Line Feed (\n) and Carriage Return (\r) – T-SQL New Line Char
1014 Jun 30, 2009 SQL SERVER – 2008 – Policy-Based Management – Create, Evaluate and Fix Policies
1013 Jun 29, 2009 SQL SERVER – Maximum Number of Index per Table
1012 Jun 28, 2009 SQL SERVER – 2008 – Management Studio New Features
1011 Jun 27, 2009 SQL SERVER – Fix : Error : 17892 Logon failed for login due to trigger execution. Changed database context to ‘master’.
1010 Jun 26, 2009 SQL SERVER – Interesting Observation of Logon Trigger On All Servers – Solution
1009 Jun 25, 2009 SQLAuthority News – Authors Visit – K-MUG TechEd Trivandrum on June 27, 2009
1008 Jun 24, 2009 SQLAuthority News – Update on pinaldave.com and SQLAuthority.com
1007 Jun 23, 2009 SQL SERVER – 2005 – 2008 – Delete Duplicate Rows
1006 Jun 22, 2009 SQLAuthority News – TechEd on Road Ahmedabad June 20, 2009 – An Astounding Success
1005 Jun 21, 2009 SQLAuthority News – Risk and Health Assessment Program for Microsoft SQL Server – Scoping Tool v1.1
1004 Jun 20, 2009 SQL Server – Understanding Table Hints with Examples
1003 Jun 19, 2009 SQL SERVER – Why You Should Attend PASS Summit Unite 2009- Seattle
1002 Jun 18, 2009 SQL SERVER – Clustered Index on Separate Drive From Table Location
1001 Jun 17, 2009 SQL SERVER – List Schema Name and Table Name for Database
1000 Jun 16, 2009 SQLAuthority News – 1000th Article Milestone – 8 Millions Views – Solid Quality Mentors
999 Jun 15, 2009 SQL SERVER – Query Optimizer Hint ROBUST PLAN – Question to You
998 Jun 14, 2009 SQL SERVER – 2008 – SSMS Feature – Multi-server Queries
997 Jun 13, 2009 SQL SERVER – Effect of Normalization on Index and Performance
996 Jun 12, 2009 SQL SERVER – 2008 – Customize Toolbar – Remove Debug Button from Toolbar
995 Jun 11, 2009 SQLAuthority News – Registration and Competition – TechEd on Road – Ahmedabad – June 20, 2009 Saturday
994 Jun 10, 2009 SQL SERVER – Performance Counters from System Views – By Kevin Mckenna
993 Jun 09, 2009 SQLAuthority News – TechEd On Road Ahmedabad, India is Announced – June 20, 2009 Saturday
992 Jun 08, 2009 SQL SERVER – Fix : Error: 15372 Failed to generate a ser instance od SQL Server due to a failure in starting the process for the user instance. The connection will be closed
991 Jun 07, 2009 SQLAuthority News – Using SQL Server 2008 Extended Events – White paper By Jonathan Kehayias
990 Jun 06, 2009 SQL SERVER – Order of Hotfix and Service Pack
989 Jun 05, 2009 SQLAuthority News – Rambling of Author and Technology Musing – Bing, Google, Windows 7, Books, Blogs, Twitter and Life
988 Jun 04, 2009 SQL SERVER – What is Interim Table – Simple Definition of Interim Table
987 Jun 03, 2009 SQL SERVER – Connect Item – Vote for Feature Request Function TRIM
986 Jun 02, 2009 SQLAuthority News – Summary of TechEd India 2009 – A Grand Event
985 Jun 01, 2009 SQL SERVER – List All Objects Created on All Filegroups in Database
984 May 31, 2009 SQL SERVER – Create Multiple Filegroup For Single Database
983 May 30, 2009 SQL SERVER – Difference Between Candidate Keys and Primary Key
982 May 29, 2009 SQLAuthority News – Blog Makeover – New Banner – New Color
981 May 28, 2009 SQL SERVER – Fix : Error : SQLDUMPER library failed initialization. Your installation is either corrupt or has been tampered with. Please uninstall then re-run setup to correct to correct this problem. in a modal dialog with the title SQL Writer
980 May 27, 2009 SQL SERVER – Interesting Observation of Logon Trigger On All Servers
979 May 26, 2009 SQL SERVER – Find Hostname and Current Logged In User Name
978 May 25, 2009 SQLAuthority News – Download Microsoft SQL Server 2008 Books Online (May 2009)
977 May 24, 2009 SQL SERVER – Introduction to Business Intelligence – Important Terms and Definitions
976 May 23, 2009 SQLAuthority News – SQL Server Energy Event with Rushabh Mehta – May 20, 2009
975 May 22, 2009 SQLAuthority News – Download – SQL Server 2008 Developer Training Kit
974 May 21, 2009 SQL SERVER – FIX : ERROR : (provider: Named Pipes Provider, error: 40 – Could not open a connection to SQL Server) (Microsoft SQL Server, Error: )
973 May 20, 2009 SQL Server – Download PDF SQL Server Cheat Sheet
972 May 19, 2009 SQLAuthority News – SQL Server Energy Event – Mark Your Calendar – May 20, 2009
971 May 18, 2009 SQL SERVER – Fix : Management Studio Error : Saving Changes in not permitted. The changes you have made require the following tables to be dropped and re-created. You have either made changes to a table that can’t be re-created or enabled the option Prevent saving changes that require the table to be re-created
970 May 17, 2009 SQL SERVER – How to Drop Temp Table – Check Existence of Temp Table
969 May 17, 2009 SQLAuthority News – Gandhinagar SQL Server User Group Meeting – International Speaker Visiting
968 May 16, 2009 SQLAuthority News – TechEd India 2009 – Day 3 – Product Group Meeting – Final Presentations – Meeting Friends
967 May 15, 2009 SQLAuthority News – TechEd India 2009 – Day 2 – In-Person Meeting with Industry Leaders – Community Party
966 May 14, 2009 SQLAuthority News – TechEd India 2009 – Day 1 – Authors Tech Session – SQL Server Cheat Sheet – Meeting Great People
965 May 13, 2009 SQLAuthority News – TechEd India 2009 – Day 0 – Day 1 – Authors Tech Session – SQL Server Cheat Sheet – Catch Me Live
964 May 12, 2009 SQLAuthority News – Release of SQL Server 2008 R2 Announced
963 May 12, 2009 SQL SERVER – How to Drop Primary Key Contraint
962 May 11, 2009 SQL SERVER – Questions and Answers with Database Administrators
961 May 10, 2009 SQL SERVER – 10 Reasons for Database Outsourcing
960 May 09, 2009 SQL SERVER – Find Last Date Time Updated for Any Table
959 May 08, 2009 SQLAuthority News – Future of Business Intelligence and Databases – Article by Nupur Dave
958 May 07, 2009 SQL SERVER – FIX : Error : Windows Update; Error Code 8000FFFF
957 May 06, 2009 SQLAuthority News – Book Review – SQL Server 2008 Management and Administration by Ross Mistry
956 May 05, 2009 SQLAuthority News – Author Visit – TechEd India 2009 – Hyderabad
955 May 04, 2009 SQL SERVER – Roadmap of Microsoft Certifications – SQL Server Certifications
954 May 03, 2009 SQL SERVER – Add or Remove Identity Property on Column
953 May 02, 2009 SQL SERVER – Example of DDL, DML, DCL and TCL Commands
952 May 01, 2009 SQLAuthority News – Gandhinagar SQL Server User Group Meeting April 24, 2009
951 Apr 30, 2009 SQL SERVER – FIX : ERROR : is not a valid Win32 application. (Exception from HRESULT: 0x800700C1)
950 Apr 29, 2009 SQL SERVER – Solution to Puzzle – Shortest Code to Perform SSN Validation
949 Apr 28, 2009 SQL SERVER – Introduction to SQL Server Encryption and Symmetric Key Encryption Tutorial with Script
948 Apr 27, 2009 SQLAuthority News – Starting the SQL Journey – How Did I Get Started With SQL?
947 Apr 26, 2009 SQL SERVER – List All the Tables for All Databases Using System Tables
946 Apr 25, 2009 SQLAuthority News – Interview of Author on 60 Seconds with Pinal Dave
945 Apr 24, 2009 SQL SERVER – Leading Zero to Number
944 Apr 24, 2009 SQL SERVER – Introduction to SQL Server 2008 Profiler
943 Apr 23, 2009 SQLAuthority News – Gandhinagar SQL Server User Group Meeting April 24, 2009
942 Apr 23, 2009 SQL SERVER – FIX : Error: 18486 Login failed for user ‘sa’ because the account is currently locked out. The system administrator can unlock it. – Unlock SA Login
941 Apr 22, 2009 SQL SERVER – Difference Between SQL Server Compact Edition (CE) and SQL Server Express Edition
940 Apr 21, 2009 SQL SERVER – What is Cloud Computing – Introduction to Cloud Computing
939 Apr 20, 2009 SQLAuthority Book Review – Pro T-SQL 2008 Programmer’s Guide by Michael Coles
938 Apr 19, 2009 SQL SERVER – Fix : SQL Server 2008 Developer Edition Install fail due to .NET Framework 3.5 missing
937 Apr 18, 2009 SQLAuthority News – Troubleshooting Performance Problems in SQL Server 2008
936 Apr 17, 2009 SQLAuthority News – Authors Website Redesigned – http://www.pinaldave.com – Feedback Requested
935 Apr 16, 2009 SQLAuthority News – Microsoft Certification Exam – Discount Code – Free Second Chance – MCTS, MCITP, MCPD
934 Apr 15, 2009 SQL SERVER – Poll Result – What is Your Favorite Database?
933 Apr 14, 2009 SQL SERVER – Check if Current Login is Part of Server Role Member
932 Apr 13, 2009 SQL SERVER – Introduction to JOINs – Basic of JOINs
931 Apr 12, 2009 SQL SERVER – FIX : ERROR : The SQL Server System Configuration Checker cannot be executed due to WMI configuration on the machine Error:2147749896 (0×80041008)
930 Apr 11, 2009 SQL SERVER – Interesting Observation of DMV of Active Transactions and DMV of Current Transactions
929 Apr 10, 2009 SQL SERVER – Restore or Attach Database Without .NDF or .MDF is Not Possible
928 Apr 10, 2009 SQLAuthority News – Download Microsoft SQL Server Management Pack for Operations Manager 2007
927 Apr 10, 2009 SQLAuthority News – Download SQL Server 2005 Report Packs – SQL Server Sample Reports – Report Templates
926 Apr 09, 2009 SQL SERVER – Fix : Error : Msg 9803, Level 16. Invalid data for type “numeric” – Data Type Mapping for Oracle Publishers
925 Apr 08, 2009 SQL SERVER – Maximum Columns per Primary Key – Fix : Error : Msg 1904, Level 16, The index on table has column names in index key list. The maximum limit for index or statistics key column list is 16
924 Apr 08, 2009 SQLAuthority News – SQL Server 2008 Service Pack 1 Released – Available for Download
923 Apr 07, 2009 SQL SERVER – Server Type and File Extention
922 Apr 06, 2009 SQL SERVER – Logical Query Processing Phases – Order of Statement Execution
921 Apr 05, 2009 SQL SERVER – 2008 – Management Studio New Features
920 Apr 05, 2009 SQL SERVER – Mirrored Backup and Restore and Split File Backup
919 Apr 04, 2009 SQL SERVER – Automated Index Defragmentation Script
918 Apr 03, 2009 SQLAuthority News – Launch of Gandhinagar SQL Server User Group
917 Apr 02, 2009 SQL SERVER – Very Powerful and Feature-Rich Backup, Zip and FTP Utility SQLBackupAndFTP
916 Apr 01, 2009 SQL SERVER – Reseed Identity of Table – Table Missing Identity Values – Gap in Identity Column
915 Mar 31, 2009 SQL SERVER – 2008 – IntelliSense Does Not Work – Enable IntelliSense
914 Mar 30, 2009 SQLAuthority News – Top 10 Strategic Technologies for 2009
913 Mar 29, 2009 SQL SERVER – Fix : Error : Msg 2714, Level 16, State 6 – There is already an object named ‘#temp’ in the database
912 Mar 28, 2009 SQLAuthority News – SQL SERVER 2008 – Updated Brochure Available for Download
911 Mar 27, 2009 SQLAuthority News – Database Poll and Gandhinagar SQL Server User Group Launch Today
910 Mar 27, 2009 SQLAuthority News – Author Video Interview Published Online – Microsoft MVP Summit 2009
909 Mar 26, 2009 SQL SERVER – FIX : Error: Msg 15123, Level 16 – The configuration option ‘advance option’ does not exist, or it may be an advanced option.
908 Mar 26, 2009 SQL SERVER – Fix : Error : Msg 4621, Level 16, State 10 : Permissions at the server scope can only be granted when the current database is master
907 Mar 25, 2009 SQLAuthority News – Announcement – Gandhinagar SQL Server User Group – March 27, 2009
906 Mar 25, 2009 SQLAuthority News – Ahmedabad SQL Server User Group Meeting Review – March 21, 2009
905 Mar 24, 2009 SQL SERVER – 2008 – SCOPE_IDENTITY Bug with Multi Processor Parallel Plan and Solution
904 Mar 23, 2009 SQL SERVER – 2008 – Location of Activity Monitor – Where is SQL Serve Activity Monitor Located
903 Mar 22, 2009 SQL SERVER – 2008 – Activity Monitor is Empty – Fix Activity Monitor for All Users
902 Mar 21, 2009 SQL SERVER – 2008 – Optimize for Ad hoc Workloads – Advance Performance Optimization
901 Mar 20, 2009 SQL SERVER – AWE (Address Windowing Extensions) Explained in Simple Words
900 Mar 19, 2009 SQLAuthority News – 900th Article – 9 Best Practices – Important Milestones
899 Mar 18, 2009 SQL SERVER – Find All Servers From Local Network – Using sqlcmd – Detect Installed SQL Server on Network
898 Mar 17, 2009 SQL SERVER – Practical SQL Server XML: Part One – Query Plan Cache and Cost of Operations in the Cache
897 Mar 16, 2009 SQL SERVER – UDF – Pad Ride Side of Number with 0 – Fixed Width Number Display
896 Mar 15, 2009 SQL SERVER – Interesting Observation of ON Clause on LEFT JOIN – How ON Clause affects Resultset in LEFT JOIN
895 Mar 14, 2009 SQLAuthority News – Lots of SQL Server News – Tip of the Article
894 Mar 13, 2009 SQL SERVER – Profiler – Adding Filters – Observation on CPU Load
893 Mar 12, 2009 SQL SERVER – What is Your Favorite Database? – Poll Continuous
892 Mar 11, 2009 SQL SERVER – Difference Between Union vs. Union All – Optimal Performance Comparison
891 Mar 10, 2009 SQL SERVER – Pad Ride Side of Number with 0 – Fixed Width Number Display
890 Mar 09, 2009 SQLAuthority News – Author Visit – Complete Wrapup of Microsoft MVP Summit 2009 Trip
889 Mar 08, 2009 SQLAuthority News – Author Visit – South Asian MVPs at Global MVP Summit 2009
888 Mar 07, 2009 SQLAuthority News – Author Visit – Tech User Group Meeting, Markham, Canada and Toronto CA Solutions
887 Mar 06, 2009 SQLAuthority News – Author Visit – Toronto, Canada – Insert Image in Database
886 Mar 05, 2009 SQLAuthority News – MVP Summit 2009 – Day 4 – Keynote of Steve Ballmer
885 Mar 04, 2009 SQLAuthority News – MVP Summit 2009 – Day 3 – Party Day and SQL Celebrity Photos
884 Mar 03, 2009 SQLAuthority News – MVP Summit 2009 – Day 2 – Most Contributing MVP of Year
883 Mar 02, 2009 SQLAuthority News – MVP Summit 2009 – Day 1 – Summit Welcome and Keynotes
882 Mar 01, 2009 SQLAuthority News – MVP Summit 2009 – Day 0 – About Pinal Dave
881 Feb 28, 2009 SQLAuthority News – MVP Summit 2009 – Database Industry Discussion – Live From London Airport and Sheraton Seattle
880 Feb 27, 2009 SQLAuthority News – MVP Summit 2009 – Journey Begins
879 Feb 26, 2009 SQL SERVER – 2008 – Find Relationship of Foreign Key and Primary Key using T-SQL – Find Tables With Foreign Key Constraint in Database
878 Feb 25, 2009 The Poll – What is Your Favorite Database?
877 Feb 24, 2009 SQLAuthority News – Author Visit – MVP Global Summit 2009 – Seattle and Redmond
876 Feb 24, 2009 SQL SERVER – Disable Windows Authentication – Remove Windows Authentication Login Account
875 Feb 23, 2009 SQLAuthority News – Ahmedabad User Group Meeting February 21 2009
874 Feb 22, 2009 SQL SERVER – Download – Microsoft SQL Server 2008 Management Studio Express
873 Feb 21, 2009 SQL SERVER – Observation – Effect of Clustered Index over Nonclustered Index
872 Feb 20, 2009 SQLAuthority News – Ahmedabad User Group Meeting February 21 2009
871 Feb 19, 2009 SQL SERVER – Enable and Disable Index Non Clustered Indexes Using T-SQL
870 Feb 18, 2009 SQLAuthority Author Visit – A True Outsourcing Giant and Technology Leader DigiCorp in Ahmedabad India
869 Feb 17, 2009 SQL SERVER – Find Current Location of Data and Log File of All the Database
868 Feb 16, 2009 SQL SERVER – List All Server Wide Configurations Values
867 Feb 15, 2009 SQL SERVER – Reasons to Backup Master Database – Why Should Master Database Backedup
866 Feb 14, 2009 SQL SERVER – Restore Master Database – An Easy Solution
865 Feb 13, 2009 SQL SERVER – Simple Example of Reading XML File Using T-SQL
864 Feb 12, 2009 SQL SERVER – Simple Example of Creating XML File Using T-SQL
863 Feb 11, 2009 SQL SERVER – Technical Articles – Performance Optimizations for the XML Data Type in SQL Server 2005
862 Feb 10, 2009 SQL SERVER – Start SQL Server Instance in Single User Mode
861 Feb 09, 2009 SQL SERVER – 2008 – Download Microsoft SQL Server 2008 Express with Tools Free
860 Feb 08, 2009 SQL SERVER – Introduction to Force Index Query Hints – Index Hint – Part2
859 Feb 07, 2009 SQL SERVER – Introduction to Force Index Query Hints – Index Hint
858 Feb 06, 2009 SQL SERVER – Quickest Way to – Kill All Threads – Kill All User Session – Kill All Processes
857 Feb 05, 2009 SQLAuthority News – Two Promotion to Help Community
856 Feb 04, 2009 SQL SERVER – Observation – Effect of Clustered Index over Nonclustered Index
855 Feb 03, 2009 SQLAuthority News – Download SQL Server 2008 System Views Poster – PDF – A Wall Poster
854 Feb 02, 2009 SQL SERVER – T-SQL Script for FizzBuzz Logic
853 Feb 01, 2009 SQLAuthority News – Download Microsoft SQL Server 2008 Books Online (January 2009)
852 Jan 31, 2009 SQL SERVER – FIX : ERROR : Msg 5834, Level 16, State 1, Line 1 The affinity mask specified conflicts with the IO affinity mask specified. Use the override option to force this configuration
851 Jan 30, 2009 SQL SERVER – 2008 – 2005 – Rebuild Every Index of All Tables of Database – Rebuild Index with FillFactor
850 Jan 29, 2009 SQLAuthority News – Microsoft Certification Exam – Discount Code – Free Second Chance – MCTS, MCITP, MCPD
849 Jan 28, 2009 SQL SERVER – Generate A Single Random Number for Range of Rows of Any Table – Very interesting Question from Reader
848 Jan 27, 2009 SQLAuthority News – Download Cumulative update package 3 for SQL Server 2008
847 Jan 27, 2009 SQLAuthority News – Download Microsoft SQL Server JDBC Driver 2.0 Community Technology Preview
846 Jan 26, 2009 SQLAuthority News – Happy 60th Republic Day to India – Database Tip
845 Jan 25, 2009 SQL SERVER – Shrinking NDF and MDF Files – A Safe Operation
844 Jan 24, 2009 SQLAuthority News – Download Microsoft SQL Server 2005 Data Mining Add-ins for Microsoft Office 2007
843 Jan 23, 2009 SQL SERVER – 2008 – 2005 – Find Longest Running Query – TSQL – Part 2
842 Jan 22, 2009 SQLAuthority News – Milestone of 6 Million Visits – 60 Lak Visits – Search and Job
841 Jan 21, 2009 SQLAuthority News – SQLAuthority News – Ahmedabad User Group Meeting January 17 2009 – Review
840 Jan 20, 2009 SQL SERVER – Rules for Optimizining Any Query – Best Practices for Query Optimization
839 Jan 19, 2009 SQLAuthority News – CWE/SANS TOP 25 Most Dangerous Programming Errors
838 Jan 18, 2009 SQL SERVER – Difference Between Index Scan and Index Seek
837 Jan 17, 2009 SQLAuthority News – Download Microsoft SQL Server Protocol Documentation
836 Jan 16, 2009 SQLAuthority News – Ahmedabad User Group Meeting January 17 2009
835 Jan 15, 2009 SQL SERVER – Remove Duplicate Entry from Comma Delimited String – UDF
834 Jan 14, 2009 SQL SERVER – Find Number of Rows and Disk Space Reserved – Using sp_spaceused Interesting Observation
833 Jan 13, 2009 SQL SERVER – Find Row Count in Table – Find Largest Table in Database – T-SQL
832 Jan 12, 2009 SQLAuthority News – Humor – Favorite Website – Funny Image
831 Jan 11, 2009 SQL SERVER – Top Five Articles of Year 2008
830 Jan 10, 2009 SQLAuthority News – Security White Papers
829 Jan 09, 2009 SQL SERVER – sqlcmd – Using a Dedicated Administrator Connection to Kill Currently Running Query
828 Jan 08, 2009 SQLAuthority News – Author Visit – Mumbai, India – From January 8, 2008 to January 11, 2008
827 Jan 07, 2009 SQL SERVER – Find Currently Running Query – T-SQL
826 Jan 06, 2009 SQL SERVER – Interesting Observation – Using sqlcmd From SSMS Query Editor
825 Jan 05, 2009 SQL SERVER – sqlcmd vs osql – Basic Comparison
824 Jan 04, 2009 SQL SERVER – 2008 – Change Color of Status Bar of SSMS Query Editor
823 Jan 03, 2009 SQL SERVER – Time Delay While Running T-SQL Query – WAITFOR Introduction
822 Jan 02, 2009 SQL SERVER – 2008 – 2005 – Find Longest Running Query – TSQL
821 Jan 01, 2009 SQLAuthority News – Happy New Year – 5 SQL New Year Resolutions
820 Dec 31, 2008 SQLAuthority News – Recap Year 2008 – Two Most Important Event of My Life
819 Dec 30, 2008 SQLAuthority Author Visit Report – Tech Meetings – Recession – Job Market – Consolidation of Servers – OS Choice – Server Reboots – Performance Optimization – Backup and Restore
818 Dec 29, 2008 SQL SERVER – 2008 – Certification Path Complete Download PDF
817 Dec 28, 2008 SQL SERVER – Fix : Msg 15151, Level 16, State 1, Line 3 Cannot drop the login ‘test’, because it does not exist or you do not have permission
816 Dec 27, 2008 SQL SERVER – Add Any User to SysAdmin Role – Add Users to System Roles
815 Dec 26, 2008 SQL SERVER – Fix : Error : Msg 15151, Level 16, State 1, Line 2 Cannot alter the login ‘sa’, because it does not exist or you do not have permission
814 Dec 25, 2008 SQLAuthority Author Visit – Valsad, Daman, Silvassa, Vapi – Tech Meetings
813 Dec 25, 2008 SQLAuthority News – Merry Christmas – Search SQLAuthority
812 Dec 24, 2008 SQL SERVER – DISABLE and ENABLE user SA
811 Dec 23, 2008 SQL SERVER – 2008 – Download Copy of Developer Edition for Free Is Myth
810 Dec 22, 2008 SQL SERVER – Find Next Running Time of Scheduled Job Using T-SQL
809 Dec 21, 2008 SQLAuthority News – SQL Server Related Downloads from Microsoft
808 Dec 20, 2008 SQL SERVER – Change Collation of Database Column – T-SQL Script
807 Dec 19, 2008 SQLAuthority News – Download – SQL Server 2005 Books Online (December 2008)
806 Dec 18, 2008 SQLAuthority News – Download Microsoft SQL Server 2005 Service Pack 3
805 Dec 17, 2008 SQL SERVER – Interesting Interview Questions – Revisited
804 Dec 16, 2008 SQL SERVER – Find Collation of Database and Table Column Using T-SQL
803 Dec 15, 2008 SQLAuthority News – Wedding Day of Author – Photographs – Mr. and Mrs. SQLAuthority
802 Dec 14, 2008 SQL SERVER – Connect using Enterprise Manager to SQL Server 2005/2008
801 Dec 13, 2008 SQL SERVER – Email from Blog Reader – Not a Potential Bug in SQL – Puzzle
800 Dec 12, 2008 SQLAuthority News – Wedding Day of Author – 800th Article of Blog
799 Dec 11, 2008 SQL SERVER – Interesting Interview Questions – Part 2 – Puzzle – Solution
798 Dec 11, 2008 SQLAuthority News – SQL SERVER 2008 Upgrade Technical Reference Guide Download
797 Dec 10, 2008 SQL SERVER 2008 – Top 10 SQL Server 2008 Features for Independent Software Vendor Applications
796 Dec 10, 2008 SQL SERVER – Interesting Interview Questions – Part 2 – Puzzle
795 Dec 09, 2008 SQL SERVER – Find Table Rowcount Without Using T-SQL and Without Opening Table
794 Dec 08, 2008 SQLAuthority News – Download Microsoft SQL Server Management Pack for Operations Manager 2007
793 Dec 08, 2008 SQLAuthority News – Author Photographs Updated
792 Dec 07, 2008 SQL SERVER – Interesting Interview Questions
791 Dec 06, 2008 SQLAuthority News – 10 Days After Attack on India
790 Dec 05, 2008 SQLAuthority Author Visit – Ahmedabad SQL Server User Group Meeting – November 2008
789 Dec 04, 2008 SQL SERVER – Microsoft SQL Server 2008 Enterprise Evaluation: Trial Experience for IT Professionals / Developers
788 Dec 03, 2008 SQL SERVER – Default Collation of SQL Server 2008
787 Dec 02, 2008 SQL SERVER – 2008 – Install SQL Server 2008 – How to Upgrade to SQL Server 2008 – Installation Tutorial
786 Dec 01, 2008 SQL SERVER – Roadmap of Microsoft Certifications – SQL Server Certifications
785 Nov 30, 2008 SQL SERVER – Interesting Observation – Use of Index and Execution Plan
784 Nov 29, 2008 SQLAuthority News – Author Visit – Ahmedabad SQL Server User Group Meeting – November 2008
783 Nov 28, 2008 SQL Server – Switch Between Result Pan and Query Pan – SQL Shortcut
782 Nov 27, 2008 SQLAuthority News – Download Tools and Documentation for SQL SERVER
781 Nov 26, 2008 SQLAuthority News – Help to Find Recession Proof Job
780 Nov 25, 2008 SQLAuthority Author Visit – Ahmedabad SQL Server User Group Meeting – November 2008
779 Nov 24, 2008 SQL SERVER – Interesting Observation about Order of Resultset without ORDER BY
778 Nov 23, 2008 SQL SERVER – 2008 – Download and Install Samples Database AdventureWorks 2008
777 Nov 22, 2008 SQL SERVER – Simple Use of Cursor to Print All Stored Procedures of Database Including Schema
776 Nov 21, 2008 SQLAuthority News – SQL Server White Paper: SQL Server 2008 Compliance Guide
775 Nov 20, 2008 SQL SERVER – Simple Use of Cursor to Print All Stored Procedures of Database
774 Nov 19, 2008 SQLAuthority News – Author Visit – South Asia MVP Open Day 2008 – Goa – Group Photo
773 Nov 18, 2008 SQLAuthority News – Author Visit – South Asia MVP Open Day 2008 – Goa – Day 3
772 Nov 17, 2008 SQLAuthority News – Author Visit – South Asia MVP Open Day 2008 – Goa – Day 2
771 Nov 16, 2008 SQLAuthority News – Author Visit – South Asia MVP Open Day 2008 – Goa – Day 1
770 Nov 15, 2008 SQLAuthority News – Author Visit – South Asia MVP Open Day 2008 – Goa – Link List
769 Nov 14, 2008 SQLAuthority News – Author Visit – South Asia MVP Open Day 2008 – Goa
768 Nov 13, 2008 SQLAuthority News – RML Utilities – Usage and Additional Help
767 Nov 12, 2008 SQLAuthority News – Download RML Utilities for SQL Server
766 Nov 11, 2008 SQL SERVER – Delete Backup History – Cleanup Backup History
765 Nov 10, 2008 SQL SERVER – Check Database Integrity for All Databases of Server
764 Nov 09, 2008 SQLAuthority News – SQL Server 2008 Book Online Updated in October 2008
763 Nov 08, 2008 SQL SERVER 2008 – Connect Visual Studio 2005 Patch Download
762 Nov 07, 2008 SQL SERVER – Refresh Database Using T-SQL
761 Nov 06, 2008 SQLAuthority News – 5 Millions Visitors – 2 Anniversary – Authors Note on Economy Slow Down and Job Opportunity – SQL Server
760 Nov 05, 2008 SQL SERVER – Clear Drop Down List of Recent Connection From SQL Server Management Studio
759 Nov 04, 2008 SQL SERVER – Fix : Error: 4064 – Cannot open user default database. Login failed. Login failed for user
758 Nov 03, 2008 SQLAuthority News – SQL Server Security Whitepapers
757 Nov 02, 2008 SQL SERVER – Fix : Error : Login failed for user ‘UserName’. The user is not associated with a trusted SQL Server connection
756 Nov 01, 2008 SQL SERVER – Stored Procedure WITH ENCRYPTION and Execution Plan
755 Oct 31, 2008 SQL SERVER – DECLARE Multiple Variables in One Statement
754 Oct 30, 2008 SQLAuthority News – Download Microsoft SQL Server Management Pack for Operations Manager 2007
753 Oct 29, 2008 SQLAuthority News – Download SQL Server 2005 Service Pack 3 – CTP
752 Oct 28, 2008 SQLAuthority News – Happy Diwali to All of You
751 Oct 27, 2008 SQLAuthority News – Download Microsoft SQL Server 2008 Feature Pack, October 2008
750 Oct 26, 2008 SQLAuthority News – Definition – Outsourcing, Offshoring, Nearshoring, Offshore Outsourcing
749 Oct 25, 2008 SQL SERVER – Simulate INNER JOIN using LEFT JOIN statement – Performance Analysis
748 Oct 24, 2008 SQLAuthority News – TOP Downloads – Bookmark
747 Oct 23, 2008 Author Visit – MVP Open Day 2008 – Goa – November 15-17
746 Oct 22, 2008 SQLAuthority News – Running SQL Server 2008 in a Hyper-V Environment Best Practices and Performance Considerations
745 Oct 21, 2008 SQL SERVER – Fix : Error : Incorrect syntax near . You may need to set the compatibility level of the current database to a higher value to enable this feature. See help for the stored procedure sp_dbcmptlevel
744 Oct 20, 2008 SQL SERVER – Transaction and Local Variables – Swap Variables – Update All At Once Concept
743 Oct 19, 2008 SQL SERVER – Introduction to CLR – Simple Example of CLR Stored Procedure
742 Oct 18, 2008 SQL SERVER – Retrieve – Select Only Date Part From DateTime – Best Practice – Part 2
741 Oct 17, 2008 SQL SERVER – Get Common Records From Two Tables Without Using Join
740 Oct 17, 2008 SQLAuthority News – Ahmedabad SQL Server User Group Meeting – October 2008
739 Oct 16, 2008 SQL SERVER – Downgrade Database to Previous Version
738 Oct 15, 2008 SQL SERVER – Introduction and Example of UNION and UNION ALL
737 Oct 14, 2008 SQL SERVER – Get Numeric Value From Alpha Numeric String – UDF for Get Numeric Numbers Only
736 Oct 13, 2008 SQLAuthority News – Book Review – Pro SQL Server 2005 Replication (Definitive Guide)
735 Oct 12, 2008 SQLAuthority News – SQL Injection – SQL Joke, SQL Humor, SQL Laugh
734 Oct 11, 2008 SQLAuthority News – Download – Microsoft SQL Server 2008 Feature Pack, August 2008
733 Oct 10, 2008 SQL SERVER – 2008 – Enhenced TRIM() Function – Remove Trailing Spaces, Leading Spaces, White Space, Tabs, Carriage Returns, Line Feeds
732 Oct 09, 2008 SQL SERVER – 2008 – TRIM() Function – User Defined Function
731 Oct 08, 2008 SQLAuthority News – SQL Server 2008 – Microsoft Certifications for 70-432 70-433 70-450 70-452
730 Oct 07, 2008 SQL SERVER – 2008 – High Resolution Wallpaper and Screen Saver
729 Oct 07, 2008 SQLAuthority News – Author Visit – SQL Hour at Patni Computer Systems
728 Oct 06, 2008 SQLAuthority News – Upgrade SQL Server With SA Renamed – Rebuild System Databases – SQL Server 2008
727 Oct 05, 2008 SQL SERVER – 2008 – Fix Connection Error with Visual Studio 2008 – Server Version is not supported – VS SP1 ISO Download
726 Oct 04, 2008 SQLAuthority News – Cumulative update package 1 for SQL Server 2008
725 Oct 03, 2008 SQL SERVER – 2008 – Find If Index is Being Used in Database
724 Oct 03, 2008 SQLAuthority News – Download – Visual Studio Team System 2008 Database Edition GDR September CTP
723 Oct 02, 2008 SQLAuthority News – Download – Microsoft SQL Server 2008 Books Online (August 2008)
722 Oct 02, 2008 SQL Server – 2008 – Cheat Sheet – One Page PDF Download
721 Oct 01, 2008 SQL SERVER – Example of PIVOT UNPIVOT Cross Tab Query in Different SQL Server Versions
720 Sep 30, 2008 SQLAuthority News – Security Update for SQL Server 2005 Service Pack 2
719 Sep 29, 2008 SQL SERVER – Puzzle – Solution – Computed Columns Datatype Explanation
718 Sep 28, 2008 SQL SERVER – Renaming SP is Not Good Idea – Renaming Stored Procedure Does Not Update sys.procedures
717 Sep 27, 2008 SQL SERVER – Puzzle – Computed Columns Datatype Explanation
716 Sep 26, 2008 SQL SERVER – Get Answer in Float When Dividing of Two Integer
715 Sep 25, 2008 SQL SERVER – Guidelines and Coding Standards Complete List Download
714 Sep 24, 2008 SQL SERVER – Guidelines and Coding Standards Part – 2
713 Sep 23, 2008 SQL SERVER – Guidelines and Coding Standards Part – 1
712 Sep 22, 2008 SQLAuthority Author Visit – Ahmedabad SQL Server User Group Meeting – September 2008
711 Sep 21, 2008 SQL SERVER – 2008 – Fix Connection Error with Visual Studio 2008 – Server Version is not supported
710 Sep 20, 2008 SQLAuthority Author Visit – Ahmedabad User Group Meeting September 2008
709 Sep 20, 2008 SQL SERVER – 2008 – Interview Questions and Answers Complete List Download
708 Sep 19, 2008 SQL SERVER – 2008 – Interview Questions and Answers – Part 8
707 Sep 18, 2008 SQL SERVER – 2008 – Interview Questions and Answers – Part 7
706 Sep 17, 2008 SQL SERVER – 2008 – Interview Questions and Answers – Part 6
705 Sep 16, 2008 SQL SERVER – 2008 – Interview Questions and Answers – Part 5
704 Sep 15, 2008 SQL SERVER – 2008 – Interview Questions and Answers – Part 4
703 Sep 14, 2008 SQL SERVER – 2008 – Interview Questions and Answers – Part 3
702 Sep 13, 2008 SQL SERVER – 2008 – Interview Questions and Answers – Part 2
701 Sep 12, 2008 SQL SERVER – 2008 – Interview Questions and Answers – Part 1
700 Sep 11, 2008 SQLAuthority News – 700 Articles and Author Updates
699 Sep 10, 2008 SQLAuthority News – SharePoint – Steps To Create A Custom WebPart – Deploy It SharePoint Site
698 Sep 09, 2008 SQL Server – Error : Fix : SharePoint Stop Working After Changing Server (Computer) Name
697 Sep 08, 2008 SQL SERVER – 2008 – Creating Primary Key, Foreign Key and Default Constraint
696 Sep 07, 2008 SQL SERVER – Explanation about Usage of Unique Index and Unique Constraint
695 Sep 06, 2008 SQL SERVER – Find Primary Key Using SQL Server Management Studio
694 Sep 05, 2008 SQL SERVER – 2008 – Creating Full Text Catalog and Full Text Search
693 Sep 05, 2008 SQLAuthority News – Download SQL Server Related Products
692 Sep 04, 2008 SQLAuthirty Author Visit – SQL SERVER – User Group Meeting – Ahmedabad – August 30, 2008
691 Sep 03, 2008 SQLAuthority Author Visit – Microsoft Student Partner Conference
690 Sep 02, 2008 SQL SERVER – 2008 – Hardware and Software Requirements for Installing SQL Server 2008
689 Sep 01, 2008 SQL SERVER – 2008 – Introduction to Filtered Index – Improve performance with Filtered Index
688 Aug 31, 2008 SQL SERVER – 2008 – Introduction to Table-Valued Parameters with Example
687 Aug 30, 2008 SQL SERVER – FIX : ERROR : Could Not Connect to SQL Server – TDSSNIClient initialization failed with error 0x7e, status code 0x60
686 Aug 29, 2008 SQL SERVER – Few Useful DateTime Functions to Find Specific Dates
685 Aug 28, 2008 SQL SERVER – 2008 – Introduction to Merge Statement – One Statement for INSERT, UPDATE, DELETE
684 Aug 27, 2008 SQLAuthority News – Download SQL Server 2008 Report Builder 2.0 RC1
683 Aug 27, 2008 SQLAuthority News – SQL Server Express 2008 Downloads
682 Aug 26, 2008 SQL SERVER – How to Rename a Column Name or Table Name
681 Aug 25, 2008 SQLAuthority News – Ahmedabad SQL Server User Group Meeting – August 2008
680 Aug 25, 2008 SQLAuthority News – 4 Million Visits – over 675 SQL Server Articles
679 Aug 24, 2008 SQL SERVER – Fix : Error : 40 – could not open a connection to SQL server – Fix Connection Problems of SQL Server
678 Aug 23, 2008 SQL SERVER – 2008 – Configure Database Mail – Send Email From SQL Database
677 Aug 22, 2008 SQL SERVER – UDF – Function to Convert Text String to Title Case – Proper Case – Part 2
676 Aug 21, 2008 SQL SERVER – Behind the Scene of SQL Server Activity of – Transaction Log – Shrinking Log
675 Aug 21, 2008 SQLAuthority News – Microsoft SQL Server Management Pack for Microsoft Operations Manager 2005
674 Aug 20, 2008 SQLAuthority News – Find Your IP Address – What Is My IP Address
673 Aug 19, 2008 SQL SERVER – Disable All the Trigger of Current Database
672 Aug 18, 2008 SQL SERVER – Detailed Explanation of Transaction Lock, Lock Type, Avoid Locks
671 Aug 17, 2008 SQL SERVER – 2005 – Best Practices Analyzer (August 2008)
670 Aug 17, 2008 SQL SERVER – XML – Split a Delimited String – Generate a Delimited String
669 Aug 16, 2008 SQLAuthority News – Tip of the Minute
668 Aug 15, 2008 SQLAuthority News – Happy Indepedance Day to India
667 Aug 15, 2008 SQL SERVER – 2008 – Introduction to Online Indexing Operation
666 Aug 14, 2008 SQL SERVER – Get Date Time in Any Format – UDF – User Defined Functions
665 Aug 13, 2008 SQLAuthority News – Authors Personal Website Renovate – SQL Centric Website
664 Aug 12, 2008 SQLAuthority News – SQL Server 2008 Pricing and Licensing
663 Aug 12, 2008 SQLAuthority News – Microsoft SQL Server 2008 Books Online – BOL – English
662 Aug 11, 2008 SQLAuthority News – SQL Server 2008 Downloads Availables
661 Aug 10, 2008 SQL SERVER – 2008 – Download and Install Samples Database AdventureWorks 2005 – Detail Tutorial
660 Aug 09, 2008 SQL SERVER – Fix : Error : 1326 Cannot connect to Database Server Error: 40 – Could not open a connection to SQL Server
659 Aug 08, 2008 SQLAuthority News – Security Update for SQL Server 2000 Service Pack 4 and MSDE 2000
658 Aug 08, 2008 SQL SERVER – 2008 – Released To Manufacturing Available
657 Aug 07, 2008 SQL SERVER – EXCEPT Clause in SQL Server is Similar to MINUS Clause in Oracle
656 Aug 06, 2008 SQL SERVER – Query to Find Column From All Tables of Database
655 Aug 05, 2008 SQL SERVER – 2005 – Get Field Name and Type of Database Table
654 Aug 04, 2008 SQLAuthority News – SQLAuthority Site With New Banner
653 Aug 03, 2008 SQL SERVER – 2005 – Difference Between INTERSECT and INNER JOIN – INTERSECT vs. INNER JOIN
652 Aug 02, 2008 SQL SERVER – Effect of Order of Join In Query
651 Aug 01, 2008 SQL SERVER – 2008 – Get Current System Date Time
650 Jul 31, 2008 SQL SERVER – 2008 – Find Current System Date Time and Time Offset
649 Jul 30, 2008 SQLAuthority News – Author BirthDay – SQL Server Birthday
648 Jul 29, 2008 SQL SERVER – SQL SERVER – Simple Example of Recursive CTE – Part 2 – MAXRECURSION – Prevent CTE Infinite Loop
647 Jul 28, 2008 SQL SERVER – Simple Example of Recursive CTE
646 Jul 27, 2008 SQL SERVER – mssqlsystemresource – Resource Database
645 Jul 26, 2008 SQLAuthority News – Readers Selection – Readers Most Favorite Articles
644 Jul 25, 2008 SQLAuthority News – SQLAuthority T-Shirts, Mug, Hat and Other Product
643 Jul 25, 2008 SQL SERVER – DBCC SHRINKFILE Takes Long Time to Run
642 Jul 24, 2008 SQL SERVER – 2005 -Track Down Active Transactions Using T-SQL
641 Jul 23, 2008 SQL SERVER – Introduction to Log Viewer
640 Jul 22, 2008 SQL SERVER – Clear SQL Server Memory Caches
639 Jul 21, 2008 SQL SERVER – FIX – ERROR : 9004 An error occurred while processing the log for database. If possible, restore from backup. If a backup is not available, it might be necessary to rebuild the log.
638 Jul 21, 2008 SQLAuthority Author Visit – Ahmedabad SQL Server User Group Meeting – July 19 2008
637 Jul 20, 2008 SQL SERVER – Change the Port of Service Broker Configuration
636 Jul 19, 2008 SQL Server – Fix – Error : 9692 The _MSG protocol transport cannot listen on port because it is in use by another process.
635 Jul 18, 2008 SQL SERVER – Introduction to Service Broker
634 Jul 18, 2008 SQLAuthority News – Updated My Personal Book Mark Pages
633 Jul 17, 2008 SQLAuthority News – Ahmedabad SQL Server Usergroup Meeting
632 Jul 16, 2008 SQL SERVER – Readers Contribution to Site – Simple Example of Cursor
631 Jul 15, 2008 SQL SERVER – Deferred Name Resolution
630 Jul 14, 2008 SQL SERVER – 2008 – Introduction to SPARSE Columns – Part 2
629 Jul 13, 2008 SQL SERVER – SP_CONFIGURE – Displays or Changes Global Configuration Settings
628 Jul 12, 2008 SQL SERVER – 2008 – User Account – sa or sysadmin
627 Jul 11, 2008 SQL SERVER – 2005 – Two Important Security Update
626 Jul 10, 2008 SQL SERVER – 2008 – Introduction to SPARSE Columns
625 Jul 09, 2008 SQL SERVER – 2008 – Two Convenient Features Inline Assignment – Inline Operations
624 Jul 08, 2008 SQL SERVER – Find Space Used For Any Particular Table
623 Jul 07, 2008 SQLAuthority News – Thank You to Awarding Author SQL MVP
622 Jul 06, 2008 SQL SERVER – 2008 – Introduction to Row Compression
621 Jul 05, 2008 SQL SERVER – Difference Between Database Mail and SQLMail
620 Jul 04, 2008 SQL SERVER – Deprecated DataType vardecimal
619 Jul 03, 2008 SQL SERVER – 2008 – Introduction to New Feature of Backup Compression
618 Jul 02, 2008 SQL SERVER – 2008 – Insert Multiple Records Using One Insert Statement – Use of Row Constructor
617 Jul 01, 2008 SQLAuthority News – Microsoft Most Valuable Professional Award for SQL Server – MVP
616 Jun 30, 2008 SQL SERVER – 2008 – High Availability – Hot Add Memory
615 Jun 29, 2008 SQLAuthority News – Rise in SQL Injection Attacks Exploiting Unverified User Data Input
614 Jun 28, 2008 SQL SERVER – 2008 – High Availability – Hot Add CPU
613 Jun 27, 2008 SQL SERVER – Difference Between DBMS and RDBMS
612 Jun 26, 2008 SQLAuthority News – Famous Quotes From Bill Gates – Part 2
611 Jun 25, 2008 SQLAuthority Download – SQL Server Cheatsheet
610 Jun 24, 2008 SQLAuthority News – Microsoft Source Code Analyzer for SQL Injection
609 Jun 23, 2008 SQLAuthority News – Release Notes for SQL Server 2008 Release Candidate 0
608 Jun 22, 2008 SQL SERVER – Create Check Constraint on Column
607 Jun 21, 2008 SQLAuthority News – White Paper: Security Overview for Database Administrators
606 Jun 20, 2008 SQL SERVER – Find Current Identity of Table
605 Jun 19, 2008 SQLAuthority News – White Paper: SQL Server 2008 Compared to Oracle Database 11g
604 Jun 18, 2008 SQLAuthority News – Famous Quotes From Bill Gates
603 Jun 17, 2008 SQL SERVER – 2008 – SQL Server Start Time
602 Jun 16, 2008 SQL SERVER – Introduction to SERVERPROPERTY and example
601 Jun 15, 2008 SQL SERVER – 2008 – Inline Variable Assignment
600 Jun 14, 2008 SQLAuthority News – 600 Article and Over 3 Million Readers
599 Jun 13, 2008 SQL SERVER – 2008 – Introduction to Policy Management – Enforcing Rules on SQL Server
598 Jun 12, 2008 SQL SERVER – 2008 – Step By Step Installation Guide With Images
597 Jun 11, 2008 SQL SERVER – 2008 – Four Key Pillars
596 Jun 10, 2008 SQL SERVER – Microsoft SQL Server 2008 Reporting Services Add-in for Microsoft SharePoint Technologies
595 Jun 09, 2008 SQLAuthority News – SQL Server 2008 Release Candidate 0
594 Jun 08, 2008 SQL SERVER – Order of Conditions in WHERE Clauses
593 Jun 07, 2008 SQL SERVER – PIVOT and UNPIVOT Table Examples
592 Jun 06, 2008 SQLAuthority News – Search SQLAuthority – Get Email On Every Article
591 Jun 05, 2008 SQL SERVER – 2008 – Compound Assignment Operators
590 Jun 04, 2008 SQL SERVER – Create a Comma Delimited List Using SELECT Clause From Table Column
589 Jun 03, 2008 SQL SERVER – Example of DISTINCT in Aggregate Functions
588 Jun 02, 2008 SQL SERVER – Order Of Column In Index
587 Jun 01, 2008 SQL SERVER – SQL SERVER – UDF – Get the Day of the Week Function – Part 4
586 May 31, 2008 SQL SERVER – Create Default Constraint Over Table Column
585 May 30, 2008 SQLAuthority News – 3 Million Readers and Continuing Journey
584 May 29, 2008 SQL SERVER – UNPIVOT Table Example
583 May 28, 2008 SQLAuthority News – Download – Windows Server 2008 w/ SQL Server 2005
582 May 27, 2008 SQL SERVER – SQL SERVER – UDF – Get the Day of the Week Function – Part 3
581 May 26, 2008 SQLAuthority News – SQL SERVER 2008 – New Logo
580 May 25, 2008 SQL SERVER – T-SQL Script to Devide One Column into Two Column
579 May 24, 2008 SQL Authority News – SQL Server Interview Questions – SQL Related Jobs – DBA Job Description
578 May 23, 2008 SQL SERVER – SQL SERVER – UDF – Get the Day of the Week Function – Part 2
577 May 22, 2008 SQL SERVER – PIVOT Table Example
576 May 21, 2008 SQL SERVER – 2005 – Twelve Tips For Optimizing Sql Server 2005 Query Performance
575 May 20, 2008 SQL SERVER – 2008 – Choosing the Right Edition for Your Needs
574 May 19, 2008 SQLAuthority Download – Providing Security for Web Applications and Infrastructure: Best Practices for Managing Security Risks
573 May 18, 2008 SQLAuthority News – SQL SERVER Database Administrator Job Description
572 May 17, 2008 SQL SERVER – Ideal TempDB FileGrowth Value
571 May 16, 2008 SQL SERVER – Find Table in Every Database of SQL Server – Part 3
570 May 15, 2008 SQL SERVER – SQL Joke, SQL Humor, SQL Laugh – Silly Mistake
569 May 14, 2008 SQL SERVER – Orphaned MS DTC Transaction Information
568 May 13, 2008 SQL SERVER – Four Basic SQL Statements – SQL Operations
567 May 12, 2008 SQL SERVER – SQL SERVER – Comparison : Similarity and Difference #TempTable vs @TempVariable – Part 2
566 May 11, 2008 SQL SERVER 2005 – Microsoft Will Release SP3 Soon
565 May 10, 2008 SQL SERVER – Function Property – Deterministic or Non-Deterministic
564 May 09, 2008 SQL SERVER – FIX : Error 7311 – You may receive an error message when you try to run distributed queries from a 64-bit SQL Server 2005 client to a linked 32-bit SQL Server 2000 server or to a linked SQL Server 7.0 server
563 May 08, 2008 SQL SERVER – 2005 – Find Tables With Foreign Key Constraint in Database – Part 2
562 May 07, 2008 SQL SERVER – Create Database Error in Windows Vista
561 May 06, 2008 SQL SERVER 2005 – FIX Error: 18456 : VISTA Windows Authentication
560 May 05, 2008 SQL SERVER – Find Table in Every Database of SQL Server – Part 2
559 May 04, 2008 SQL SERVER – 2000 – SQL SERVER – Delete Duplicate Records – Rows – Readers Contribution
558 May 03, 2008 SQL SERVER 2005 – Vista Ultimate and SQL Server 2005 DEV Edition
557 May 02, 2008 SQL SERVER – How to Rename Database Objects to Comply With Naming Conventions
556 May 01, 2008 SQLAuthority News – Write for SQLAuthority
555 Apr 30, 2008 SQL SERVER – Find Table in Every Database of SQL Server – Part 2
554 Apr 29, 2008 SQL SERVER – Find Table in Every Database of SQL Server
553 Apr 28, 2008 SQL SERVER – Download FAQ Sheet – SQL Server in One Page
552 Apr 27, 2008 SQL SERVER – Query Analyzer Shortcuts – Part 2
551 Apr 26, 2008 SQL SERVER – Optimization Rules of Thumb – Best Practices – Reader’s Article
550 Apr 25, 2008 SQL SERVER – Optimization Rules of Thumb – Best Practices
549 Apr 25, 2008 SQLAuthority News – Authors Personal Bookmarks
548 Apr 24, 2008 SQLAuthority News – Download Microsoft Office Visio 2007 Professional SQL Server Add-In
547 Apr 23, 2008 SQL SERVER – Converting Subqueries to Joins
546 Apr 22, 2008 SQL SERVER – Better Performance – LEFT JOIN or NOT IN?
545 Apr 21, 2008 SQL SERVER – 2008 – Update Resolving Conflict Between SQL Server 2005 and SQL Server 2008
544 Apr 20, 2008 SQL SERVER – Identifiers As Valid Object Names
543 Apr 19, 2008 SQL SERVER – Is Cursor Database Object or Datatype
542 Apr 18, 2008 SQL SERVER – Generate Foreign Key Scripts For Database
541 Apr 17, 2008 SQLAuthority News – My Favorite Link of This Blog
540 Apr 16, 2008 SQL SERVER – 2008 – Row Constructors – Load Temp Tables From Stored Procedures
539 Apr 15, 2008 SQL SERVER – Surface Area Configuration Tools Reduce Exposure To Security Risks
538 Apr 14, 2008 SQL SERVER – SQL Slammer (Computer Worm)
537 Apr 13, 2008 SQL SERVER – 2008 – Important Resources
536 Apr 12, 2008 SQL SERVER – 2008 – Download Presentation and Whitepapers
535 Apr 11, 2008 SQL SERVER – 2005 – Find Database Collation Using T-SQL and SSMS – Part 2
534 Apr 10, 2008 SQL SERVER – 2005 – Restore Database Using Corrupt Datafiles (.mdf and .ldf) – Part 2
533 Apr 09, 2008 SQL SERVER – 2005 – Connection Strings For .NET
532 Apr 08, 2008 SQL SERVER – Change Order of Column In Database Tables
531 Apr 07, 2008 SQL SERVER – 2005 – Restore Database Using Corrupt Datafiles (.mdf and .ldf)
530 Apr 06, 2008 SQL SERVER – 15 Best Practices for Better Database Performance
529 Apr 05, 2008 SQL SERVER – 2005 – Transferring Ownership of a Schema to a User
528 Apr 04, 2008 SQLAuthority News – Translation in International Languages – Arabic, Chinese, Dutch, French, German, Greek, Italian, Japanese, Korean, Portuguese, Russian, Spanish
527 Apr 03, 2008 SQLAuthority News – Learn New Things – Self Criticism
526 Apr 02, 2008 SQL SERVER – Find Nth Highest Salary of Employee – Query to Retrieve the Nth Maximum value
525 Apr 01, 2008 SQL SERVER – Microsoft SQL Server 2000/2005 Management Pack Download
524 Mar 31, 2008 SQL SERVER – Popular Articles of SQLAuthority Blog
523 Mar 30, 2008 SQL SERVER – Introduction to Heap Structure – What is Heap?
522 Mar 29, 2008 SQL SERVER – 2005 – List All Column With Indentity Key In Specific Database
521 Mar 28, 2008 SQL SERVER – 2005 – Introduction to sys.dm_exec_query_optimizer_info
520 Mar 27, 2008 SQL SERVER – 2005 – Find Index Fragmentation Details – Slow Index Performance
519 Mar 26, 2008 SQLAuthority News – Few Links About SQLAuthority
518 Mar 25, 2008 SQL SERVER – Simple Puzzle Using Union and Union All – Answer
517 Mar 24, 2008 SQL SERVER – Simple Puzzle Using Union and Union All
516 Mar 23, 2008 SQL SERVER – 2005 – Mechanisms to Ensure Integrity and Consistency of Databases – Locking and Row Versioning
515 Mar 22, 2008 SQL SERVER – 2005 – Find Highest / Most Used Stored Procedure
514 Mar 21, 2008 SQL SERVER – Introduction to Live Lock – What is Live Lock?
513 Mar 20, 2008 SQLAuthority News – Book Review – Joe Celkos SQL Puzzles and Answers, Second Edition, Second Edition
512 Mar 19, 2008 SQL SERVER – Add Column With Default Column Constraint to Table
511 Mar 18, 2008 SQL SERVER – 2005 – Analysis Services Query Performance Top 10 Best Practices
510 Mar 17, 2008 SQLAuthority News – Download White Papers – Migration from MySQL, Oracle, Sybase, or Microsoft Access to Microsoft SQL Server
509 Mar 16, 2008 SQL SERVER – 2005 – Retrieve Any User Defined Object Details Using sys.objects Database
508 Mar 15, 2008 SQL SERVER – 2005 – Retrieve Processes Using Specified Database
507 Mar 14, 2008 SQL SERVER – 2005 – Introduction to CLR and Integration to CLR with SQL – Simple Sample Example of CLR
506 Mar 13, 2008 SQL SERVER – FIX : Error : 3702 Cannot drop database because it is currently in use – Part 2
505 Mar 12, 2008 SQL SERVER – 2005 – Find Nth Highest Record from Database Table – Using Ranking Function ROW_NUMBER
504 Mar 11, 2008 SQL SERVER – How to Retrieve TOP and BOTTOM Rows Together using T-SQL – Part 3
503 Mar 10, 2008 SQL SERVER – How to Retrieve TOP and BOTTOM Rows Together using T-SQL – Part 2
502 Mar 09, 2008 SQLAuthority News – Authors Most Visited Article on Blog
501 Mar 08, 2008 SQL SERVER – 2005 – Find Nth Highest Record from Database Table
500 Mar 07, 2008 SQLAuthority News – 500th Post – An Interesting Journey with SQL Server
499 Mar 06, 2008 SQLAuthority News – SQL Server 2005 is The Data Platform Leader
498 Mar 05, 2008 SQL SERVER – Simple Example of Cursor – Sample Cursor Part 2
497 Mar 04, 2008 SQL SERVER – 2005 – A Simple Way To Defragment All Indexes In A Database That Is Fragmented Above A Declared Threshold
496 Mar 03, 2008 SQL SERVER – Sharpen Your Basic SQL Server Skills – Learn the distinctions between unique constraint and primary key constraint and the easiest way to get random rows from a table
495 Mar 02, 2008 SQL SERVER – How to Retrieve TOP and BOTTOM Rows Together using T-SQL
494 Mar 01, 2008 SQL SERVER – Transfer The Logins and The Passwords Between Instances of SQL Server 2005
493 Feb 29, 2008 SQL SERVER – Introduction to SQL Server Encryption and Symmetric Key Encryption Tutorial
492 Feb 28, 2008 SQL SERVER – Dynamic Case Statement – FIX : ERROR 156 : Incorrect syntax near the keyword
491 Feb 27, 2008 SQLAuthority New – Microsoft SQL Server 2008 and System Center – Managing, Deploying, and Protecting SQL Server 2008
490 Feb 26, 2008 SQL SERVER – SELECT 1 vs SELECT * – An Interesting Observation
489 Feb 25, 2008 SQLAuthority News – Download Upgrade Service Datasheet
488 Feb 24, 2008 SQL SERVER – 2005 – Licensing Model Compared to Other Database Products
487 Feb 23, 2008 SQL SERVER – 2005 – Understanding Licensing Model
486 Feb 22, 2008 SQL SERVER – Find All The User Defined Functions (UDF) – Part 2
485 Feb 21, 2008 SQLAuthority News – Download SQL Server 2008 February CTP Sample Codes
484 Feb 21, 2008 SQLAuthority New – SQL Server 2008 Books Online CTP (February 2008)
483 Feb 20, 2008 SQL SERVER – UDF to Return a Calendar for Any Date for Any Year
482 Feb 19, 2008 SQL SERVER – 2005 – FIX: Error message when you run a query against a table that does not have a clustered index in SQL Server 2005: “A severe error occurred on the current command”
481 Feb 18, 2008 SQLAuthority News – Download SQL Server 2008 February CTP (CTP 6)
480 Feb 17, 2008 SQL SERVER – How to Escape Single Quotes – Fix: Error: 105 Unclosed quotation mark after the character string ‘
479 Feb 16, 2008 SQL SERVER – Msg: 2593 : There are ROWCOUNT rows in PAGECOUNT pages for object ‘OBJECT’.
478 Feb 15, 2008 SQL SERVER – Index Reorganize or Index Rebuild
477 Feb 14, 2008 SQL SERVER – Introduction to Performance Monitor – How to Use Perfmon
476 Feb 13, 2008 SQL SERVER – Introduction to Three Important Performance Counters
475 Feb 12, 2008 SQL SERVER – Get Current Database Name
474 Feb 11, 2008 SQL SERVER – 2005 – Find Unused Indexes of Current Database
473 Feb 10, 2008 SQLAuthority News – RIP: Ken Henderson, 1967 – 2008
472 Feb 09, 2008 SQLAuthority News – 2008 – Download – SQL Server 2008 Brochure
471 Feb 08, 2008 SQL SERVER – Microsoft SQL Server Compact 3.5 SP1 Beta for ADO.Net Entity Framework Beta 3
470 Feb 07, 2008 SQL SERVER – Sharpen Your Basic SQL Server Skills – Database backup demystified
469 Feb 06, 2008 SQL SERVER – Import CSV File Into SQL Server Using Bulk Insert – Load Comma Delimited File Into SQL Server
468 Feb 05, 2008 SQLAuthority News – SQL Joke, SQL Humor, SQL Laugh – Funny Microsoft Quotes
467 Feb 04, 2008 SQL SERVER – Simple Example of WHILE Loop with BREAK and CONTINUE
466 Feb 03, 2008 SQL SERVER – FIX : ERROR : Cannot find template file for new query (C:\Program Files\Microsoft SQL Server\90\Tools\ Binn\VSShell\Common7\ IDE\sqlworkbenchprojectitems\Sql\ SQLFile.sql)
465 Feb 02, 2008 SQL SERVER – Find All The User Defined Functions (UDF) in a Database
464 Feb 01, 2008 SQL SERVER – Find Great Job with Great Pay
463 Jan 31, 2008 SQL SERVER – Top 10 Best Practices for SQL Server Maintenance for SAP
462 Jan 30, 2008 SQL SERVER – FIX : ERROR : The query processor could not start the necessary thread resources for parallel query execution
461 Jan 29, 2008 SQLAuthority New – O’relly Style Book Cover for SQLAuthority
460 Jan 28, 2008 SQLAuthority News – Book Review – Beginners Guide to SQL Server Integration Services Using Visual Studio 2005
459 Jan 27, 2008 SQLAuthority News – SQL Joke, SQL Humor, SQL Laugh – Funny Quotes
458 Jan 26, 2008 SQLAuthority News – Microsoft SQL Server 2000 MSIT Configuration Pack for Configuration Manager 2007
457 Jan 25, 2008 SQL SERVER – 2005 – Database Table Partitioning Tutorial – How to Horizontal Partition Database Table
456 Jan 24, 2008 SQL SERVER – 2005 – Introduction to Partitioning
455 Jan 23, 2008 SQLAuthority News – Download Microsoft SQL Server 2005 Assessment Configuration Pack
454 Jan 22, 2008 SQLAuthority News – Fix : Remote Desktop Copy Paste Stop Working
453 Jan 21, 2008 SQL SERVER – 2005 – Get a row per file of a database as stored in the master database
452 Jan 20, 2008 SQL SERVER – Introduction to Statistical Functions – VAR, STDEVP, STDEV, VARP
451 Jan 19, 2008 SQL SERVER – Introduction to Aggregate Functions
450 Jan 18, 2008 SQL SERVER – 2005 Best Practices Analyzer (January 2008)
449 Jan 17, 2008 SQLAuthority News – Job Description of Database Administrator (DBA) or Database Developer
448 Jan 16, 2008 SQLAuthroity News – Microsoft SQL Server 2000 Assessment Configuration Pack
447 Jan 15, 2008 SQL SERVER – What is – DML, DDL, DCL and TCL – Introduction and Examples
446 Jan 14, 2008 SQL SERVER – Time Out Due to Executing DELETE on Large RecordSet
445 Jan 13, 2008 SQLAuthority News – Find Job Related to SQL Server and Database Administrator and Interview Questions and Answers
444 Jan 12, 2008 SQL SERVER – 2005 – Change Compatibility Level – T-SQL Procedure
443 Jan 11, 2008 SQL SERVER – Reclaim Space After Dropping Variable-Length Columns Using DBCC CLEANTABLE
442 Jan 10, 2008 SQL SERVER – 2005 – Display Fragmentation Information of Data and Indexes of Database Table
441 Jan 09, 2008 SQL SERVER – Execute Same Query and Statement Multiple Times Using Command GO
440 Jan 08, 2008 SQL SERVER – 2005 – Export Data From SQL Server 2005 to Microsoft Excel Datasheet
439 Jan 07, 2008 SQL SERVER – 2005 – Introduction and Explanation to SYNONYM – Helpful T-SQL Feature for Developer
438 Jan 06, 2008 SQL SERVER – Download Frequently Asked Generic Interview Questions
437 Jan 05, 2008 SQL SERVER – Most Frequently Asked Generic Interview Questions
436 Jan 04, 2008 SQL SERVER – 2005 – CROSS APPLY
435 Jan 03, 2008 SQL SERVER – 2005 – Last Ran Query – Recently Ran Query
434 Jan 03, 2008 SQLAuthority New – Best Practices for Speeding Up Your Web Site
433 Jan 02, 2008 SQL SERVER – Fix : Error : 15281 SQL Server blocked access to STATEMENT ‘OpenRowset/OpenDatasource’ of component ‘Ad Hoc Distributed Queries’ because this component is turned off as part of the security configuration for this server
432 Jan 01, 2008 SQLAuthority New – Happy New Year 2008
431 Dec 31, 2007 SQLAuthority News – Thank You to Blog Readers
430 Dec 30, 2007 SQL SERVER – Remove Duplicate Characters From a String
429 Dec 29, 2007 SQL SERVER – Change Password of SA Login Using Management Studio
428 Dec 28, 2007 SQL SERVER – Difference Between Quality Assurance and Quality Control – QA vs QC
427 Dec 27, 2007 SQLAuthority News – Book Review – A Practitioner’s Guide to Software Test Design
426 Dec 26, 2007 SQL SERVER – TRUNCATE Can’t be Rolled Back Using Log Files After Transaction Session Is Closed
425 Dec 25, 2007 SQL SERVER – Mirrored Backup Introduction and Explanation
424 Dec 25, 2007 SQL SERVER – Delete Duplicate Records – Count Duplicate Records Links
423 Dec 24, 2007 SQL SERVER – Object Oriented Database Management Systems
422 Dec 24, 2007 SQLAuthority News – Download Microsoft SQL Server 2000/2005 Management Pack
421 Dec 24, 2007 SQLAuthority News – Jobs, Search, Best Articles, Homepage
420 Dec 23, 2007 SQL SERVER – 2008 – New DataTypes DATE and TIME
419 Dec 22, 2007 SQL SERVER – Difference Between Index Rebuild and Index Reorganize Explained with T-SQL Script
418 Dec 21, 2007 SQL SERVER – Enabling Clustered and Non-Clustered Indexes – Interesting Fact
417 Dec 20, 2007 SQL SERVER – DISTINCT Keyword Usage and Common Discussion
416 Dec 19, 2007 SQL SERVER – Cumulative Update Package 5 for SQL Server 2005 Service Pack 2
415 Dec 19, 2007 SQLAuthority News – RML Utilities for SQL Server
414 Dec 18, 2007 SQL SERVER – Get Information of Index of Tables and Indexed Columns
413 Dec 17, 2007 SQL SERVER – T-SQL Script to Find Details About TempDB
412 Dec 16, 2007 SQL SERVER – Solution – Log File Very Large – Log Full
411 Dec 15, 2007 SQL SERVER – TempDB Restrictions – Temp Database Restrictions
410 Dec 14, 2007 SQLAuthority News – Top 10 Tips for Successful Software Outsourcing
409 Dec 13, 2007 SQL SERVER – Do Not Store Images in Database – Store Location of Images (URL)
408 Dec 12, 2007 SQL SERVER – White Papers: Migration from Oracle Sybase, or Microsoft Access to Microsoft SQL Server
407 Dec 11, 2007 SQL SERVER – Microsoft Synchronization Services for ADO.NET v2.0 CTP1 Refresh
406 Dec 10, 2007 SQLAuthority News – Microsoft SQL Server 2008 Community Technology Preview (November 2007) VHD
405 Dec 09, 2007 SQL SERVER – ACID (Atomicity, Consistency, Isolation, Durability)
404 Dec 08, 2007 SQL SERVER – Generic Architecture Image
403 Dec 07, 2007 SQL SERVER – FIX : Error : 3702 Cannot drop database because it is currently in use.
402 Dec 06, 2007 SQL SERVER – 2005 – Dynamic Management Views (DMV) and Dynamic Management Functions (DMF)
401 Dec 05, 2007 SQL SERVER – UDF – Remove Duplicate Chars From String
400 Dec 04, 2007 SQLAuthority Author Visit – IT Outsourcing to India – Top 10 Reasons Companies Outsource
399 Dec 03, 2007 SQL SERVER – Grouping JOIN Clauses In SQL
398 Dec 02, 2007 SQL SERVER – Q and A with Database Administrators
397 Dec 01, 2007 SQL SERVER – Sharpen Your Skills: Brush up on FILLFACTOR, ISNULL, NULLIF, and % as wildcard and operator
396 Nov 30, 2007 SQLAuthority News – Download SQL Server 2005 Books Online (September 2007)
395 Nov 29, 2007 SQL SERVER – Database Interview Questions and Answers Complete List
394 Nov 28, 2007 SQL SERVER – Correct Syntax for Stored Procedure SP
393 Nov 27, 2007 SQL SERVER – 2005 – List All Stored Procedure in Database
392 Nov 26, 2007 SQL SERVER – Rules of Third Normal Form and Normalization Advantage – 3NF
391 Nov 25, 2007 SQLAuthority News – SQL Server Compact 3.5 Downloads and ReportViewer Visual Studio Download
390 Nov 24, 2007 SQL SERVER – Upgrade Advise – From 2000 to 2005 or 2008
389 Nov 23, 2007 SQL SERVER – 2008 – November CPT5 New Improvement
388 Nov 22, 2007 SQL SERVER – Shrinking Truncate Log File – Log Full – Part 2
387 Nov 21, 2007 SQL SERVER – Generate Incremented Linear Number Sequence
386 Nov 20, 2007 SQL SERVER – Sharpen Your Skills: Joins, Groupings, and Data Types
385 Nov 19, 2007 SQLAuthority News – SQL Server 2008 Community Technology Preview (CTP) Download Now Available
384 Nov 18, 2007 SQLAuthority News – Job Opportunity in Ahmedabad, India to Work with Technology Leaders Worldwide – SQL Server, ColdFusion, ASP.NET
383 Nov 17, 2007 SQL SERVER – 2005 – Best Practices for SQL Server Health Check
382 Nov 16, 2007 SQL SERVER – 2005 – Generate Script with Data from Database – Database Publishing Wizard
381 Nov 15, 2007 SQLAuthority News – Microsoft SQL Server 2005 Assessment Configuration Pack Download
380 Nov 14, 2007 SQLAuthority News – SQL Joke, SQL Humor, SQL Laugh – Database Dilbert
379 Nov 14, 2007 SQLAuthority News – Microsoft SQL Server 2005 MSIT Three Configuration Pack for Configuration Manager 2007
378 Nov 13, 2007 SQL SERVER – DBCC CHECKDB Introduction and Explanation – DBCC CHECKDB Errors Solution
377 Nov 12, 2007 SQL SERVER – FIX : ERROR Msg 1803 The CREATE DATABASE statement failed. The primary file must be at least 2 MB to accommodate a copy of the model database
376 Nov 12, 2007 SQLAuthority News – The Equations of Relativist
375 Nov 12, 2007 SQL SERVER – FIX : ERROR Msg 5174 Each file size must be greater than or equal to 512 KB
374 Nov 11, 2007 SQLAuthority News – SQL Server 2005 Powers Global Forensic Data Security Tool
373 Nov 10, 2007 SQL SERVER – 2005 2000 – Search String in Stored Procedure
372 Nov 09, 2007 SQL SERVER – Versions, CodeNames, Year of Release
371 Nov 08, 2007 SQLAuthority News – Book Review – SQL Server 2005 Management and Administration (Paperback)
370 Nov 07, 2007 SQLAuthority News – 1 Million Visitors in last 1 year
369 Nov 06, 2007 SQLAuthority News – Microsoft Synchronization Services for ADO.NET v2.0 CTP1
368 Nov 05, 2007 SQLAuthority News – Few Add-ons for SQLAuthority
367 Nov 04, 2007 SQLAuthority News – Best Articles on SQLAuthority.com
366 Nov 03, 2007 SQLAuthority News – Best SQLAuthority Articles on Other Popular Sites
365 Nov 02, 2007 SQLAuthority News – Best Downloads on SQLAuthority.com
364 Nov 01, 2007 SQLAuthority News – First Birthday of Blog – 365 Post in One Year
363 Oct 31, 2007 SQL SERVER – Importance of Master Database for SQL Server Startup
362 Oct 30, 2007 SQL SERVER – Business Intelligence (BI) Basic Terms Explanation
361 Oct 29, 2007 SQL SERVER – Disable All Triggers on a Database – Disable All Triggers on All Servers
360 Oct 28, 2007 SQL SERVER – 2008 – Server Consolidation WhitePaper Download
359 Oct 27, 2007 SQL SERVER – 2005 – Get Current User – Get Logged In User
358 Oct 26, 2007 SQL SERVER – Deterministic Functions and Nondeterministic Functions
357 Oct 25, 2007 SQL SERVER – 2005 – Forced Parameterization and Simple Parameterization – T-SQL and SSMS
356 Oct 24, 2007 SQL SERVER – Simple Example of WHILE Loop With CONTINUE and BREAK Keywords
355 Oct 23, 2007 SQL SERVER – Get Permissions of My Username / Userlogin on Server / Database
354 Oct 22, 2007 SQL SERVER – Difference Between @@Version and xp_msver – Retrieve SQL Server Information
353 Oct 21, 2007 SQL SERVER – 2005 – Limitation of Online Index Rebuld Operation
352 Oct 20, 2007 SQL SERVER – Set Server Level FILLFACTOR Using T-SQL Script
351 Oct 19, 2007 SQL SERVER – Types of DBCC Commands When Used as Database Console Commands
350 Oct 18, 2007 SQL SERVER – 2005 – Fix : Error : Msg 7411, Level 16, State 1 Server is not configured for RPC
349 Oct 17, 2007 SQLAuthority News – Book Review – Backup & Recovery (Paperback)
348 Oct 16, 2007 SQL SERVER – Three T-SQL Script to Create Primary Keys on Table
347 Oct 16, 2007 SQL SERVER – 2005 – Driver for PHP Community Technology Preview (October 2007)
346 Oct 15, 2007 SQL SERVER – Explanation and Understanding NOT NULL Constraint
345 Oct 14, 2007 SQL SERVER – Three Rules to Use UNION
344 Oct 13, 2007 SQL SERVER – 2005 – SQL Server Surface Area Configuration Tool Examples and Explanation
343 Oct 12, 2007 SQL SERVER – Pre-Code Review Tips – Tips For Enforcing Coding Standards
342 Oct 11, 2007 SQL SERVER – T-SQL Script to Add Clustered Primary Key
341 Oct 10, 2007 SQL SERVER – UDF vs. Stored Procedures and Having vs. WHERE
340 Oct 09, 2007 SQL SERVER – 2005 – Sample Example of RANKING Functions – ROW_NUMBER, RANK, DENSE_RANK, NTILE
339 Oct 08, 2007 SQL SERVER – 2005 – Connection Property of SQL Server Management Studio SSMS
338 Oct 07, 2007 SQLAuthority News – Latest Interesting Downloads and Articles
337 Oct 06, 2007 SQL SERVER – Executing Remote Stored Procedure – Calling Stored Procedure on Linked Server
336 Oct 05, 2007 SQL SERVER – 2005 – Open SSMS From Command Prompt – sqlwb.exe Example
335 Oct 04, 2007 SQL SERVER – 2005 – Different Types of Cache Objects
334 Oct 03, 2007 SQL SERVER – 2005 – Explanation of TRY…CATCH and ERROR Handling With RAISEERROR Function
333 Oct 02, 2007 SQL SERVER – Find Name of The SQL Server Instance
332 Oct 01, 2007 SQL SERVER – 2005 – OUTPUT Clause Example and Explanation with INSERT, UPDATE, DELETE
331 Sep 30, 2007 SQL SERVER – 2005 Query Editor – Microsoft SQL Server Management Studio
330 Sep 29, 2007 SQL SERVER – Two Connections Related Global Variables Explained – @@CONNECTIONS and @@MAX_CONNECTIONS
329 Sep 28, 2007 SQL SERVER – Introduction and Example for DATEFORMAT Command
328 Sep 27, 2007 SQL SERVER – FIX : Error 3154: The backup set holds a backup of a database other than the existing database
327 Sep 26, 2007 SQLAuthority News – Book Review – Programming SQL Server 2005 [ILLUSTRATED]
326 Sep 25, 2007 SQL SERVER – Effect of TRANSACTION on Local Variable – After ROLLBACK and After COMMIT
325 Sep 24, 2007 SQL SERVER – Order of Result Set of SELECT Statement on Clustered Indexed Table When ORDER BY is Not Used
324 Sep 23, 2007 SQL SERVER – Stored Procedure to Know Database Access Permission to Current User
323 Sep 22, 2007 SQL SERVER – 2005 – Version Information and Additional Information – Extended Stored Procedure xp_msver
322 Sep 21, 2007 SQL SERVER – 2005 – Multiple Language Support
321 Sep 20, 2007 SQL SERVER – FIX : ERROR : 3260 An internal buffer has become full
320 Sep 19, 2007 SQL SERVER – Rename Database to New Name Using Stored Procedure by Changing to Single User Mode
319 Sep 18, 2007 SQLAuthority News – Scale-Out Querying with Analysis Services Using SAN Snapshots
318 Sep 18, 2007 SQL SERVER – UDF – Validate Positive Integer Function – Validate Natural Integer Function
317 Sep 17, 2007 SQLAuthority News – NASDAQ Uses SQL Server 2005 – Reducing Costs through Better Data Management
316 Sep 17, 2007 SQL SERVER – Difference Between UPDATE and UPDATE()
315 Sep 16, 2007 SQLAuthority News – Active Directory Integration Sample Script
314 Sep 16, 2007 SQL SERVER – 2005 – List All The Constraint of Database – Find Primary Key and Foreign Key Constraint in Database
313 Sep 15, 2007 SQLAuthority News – Book Review – Pro T-SQL 2005 Programmer’s Guide (Paperback)
312 Sep 14, 2007 SQLAuthority News – Random Article from SQLAuthority Blog
311 Sep 13, 2007 SQL SERVER – Difference Between EXEC and EXECUTE vs EXEC() – Use EXEC/EXECUTE for SP always
310 Sep 12, 2007 SQLAuthority News – Scrum: Agile Software Development for Project Management
309 Sep 11, 2007 SQL SERVER – Frequency of SQL Server Reboot and Restart
308 Sep 11, 2007 SQLAuthority News – Book Review – SQL Server 2005 DBA Street Smarts: A Real World Guide to SQL Server 2005 Certification Skills
307 Sep 10, 2007 SQL SERVER – 2005 – White Paper – Integrating Visio 2007 and Microsoft SQL Server 2005
306 Sep 10, 2007 SQLAuthority News – Job Opportunity in Ahmedabad, India to Work with Technology Leaders Worldwide
305 Sep 09, 2007 SQL SERVER – 2005 – Start Stop Restart SQL Server From Command Prompt
304 Sep 08, 2007 SQL SERVER – UDF – User Defined Function – Get Number of Days in Month
303 Sep 07, 2007 SQL SERVER – Correlated and Noncorrelated – SubQuery Introduction, Explanation and Example
302 Sep 06, 2007 SQL SERVER – 2005 – Introduction and Explanation to sqlcmd
301 Sep 06, 2007 SQLAuthority News – SQL SERVER 2008 CTP 4 Released
300 Sep 05, 2007 SQL SERVER – SQL Joke, SQL Humor, SQL Laugh – Valid SQL Error
299 Sep 05, 2007 SQLAuthority News – Interesting Read – Using A SQL JOIN In A SQL UPDATE/Delete Statement – Ben Nadel
298 Sep 04, 2007 SQL SERVER – 2005 – Find Tables With Primary Key Constraint in Database
297 Sep 04, 2007 SQL SERVER – 2005 – Find Tables With Foreign Key Constraint in Database
296 Sep 03, 2007 SQL SERVER – 2005 – Search Stored Procedure Code – Search Stored Procedure Text
295 Sep 02, 2007 SQL SERVER – Fix : Error : Msg 3117, Level 16, State 4 The log or differential backup cannot be restored because no files are ready to rollforward
294 Aug 31, 2007 SQL SERVER – 2005 – Find Database Status Using sys.databases or DATABASEPROPERTYEX
293 Aug 30, 2007 SQL SERVER – 2005 – Find Database Collation Using T-SQL and SSMS
292 Aug 29, 2007 SQL SERVER – Difference and Explanation among DECIMAL, FLOAT and NUMERIC
291 Aug 28, 2007 SQL SERVER – Actual Execution Plan vs. Estimated Execution Plan
290 Aug 27, 2007 SQL SERVER – 2005 – Use Always Outer Join Clause instead of (*= and =*)
289 Aug 26, 2007 SQL SERVER – 2005 – No Backup Support For Named Pipes
288 Aug 25, 2007 SQL SERVER – FIX : Error : msg 2540 – The system cannot self repair this error
287 Aug 24, 2007 SQL SERVER – 2005 – T-SQL Script to Attach and Detach Database
286 Aug 23, 2007 SQL SERVER – 2005 – Use of Non-deterministic Function in UDF – Find Day Difference Between Any Date and Today
285 Aug 22, 2007 SQL SERVER – T-SQL Script to Insert Carriage Return and New Line Feed in Code
284 Aug 21, 2007 SQL SERVER – 2005 – Create Script to Copy Database Schema and All The Objects – Stored Procedure, Functions, Triggers, Tables, Views, Constraints and All Other Database Objects
283 Aug 20, 2007 SQLAuthority News – Principles of Simplicity
282 Aug 20, 2007 SQL SERVER – Find Monday of the Current Week
281 Aug 19, 2007 SQLAuthority News – Book Review – Sams Teach Yourself Microsoft SQL Server T-SQL in 10 Minutes
280 Aug 18, 2007 SQL SERVER – Find Last Day of Any Month – Current Previous Next
279 Aug 17, 2007 SQL SERVER – 2005 – Explanation and Script for Online Index Operations – Create, Rebuild, Drop
278 Aug 16, 2007 SQLAuthority News – Subscribed to SQLAuthority Emails
277 Aug 16, 2007 SQL SERVER – 2008 – Book On-Line Link
276 Aug 16, 2007 SQL SERVER – 2005 – Difference and Similarity Between NEWSEQUENTIALID() and NEWID()
275 Aug 15, 2007 SQL SERVER – Insert Data From One Table to Another Table – INSERT INTO SELECT – SELECT INTO TABLE
274 Aug 14, 2007 SQLAuthority News – Book Review – Learning SQL on SQL Server 2005 (Learning)
273 Aug 14, 2007 SQL SERVER – What is SQL? How to pronounce SQL?
272 Aug 13, 2007 SQLAuthority News – Author Visit – Database Architecture and Implementation Discussion – New York, New Jersey Details
271 Aug 12, 2007 SQL SERVER – Fix : ERROR : Msg 1033, Level 15, State 1 The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions, unless TOP or FOR XML is also specified.
270 Aug 11, 2007 SQL SERVER – UDF – Validate Integer Function
269 Aug 10, 2007 SQL SERVER – 2005 – Find Stored Procedure Create Date and Modified Date
268 Aug 09, 2007 SQL SERVER – 2005 – List All The Column With Specific Data Types
267 Aug 08, 2007 SQL SERVER – 2005 – SSMS – Enable Autogrowth Database Property
266 Aug 07, 2007 SQL SERVER – 2005 – List Tables in Database Without Primary Key
265 Aug 06, 2007 SQL SERVER – Fix : Error 2596 The repair statement was not processed. The database cannot be in read-only mode
264 Aug 05, 2007 SQL SERVER – Stop SQL Server Immediately Using T-SQL
263 Aug 04, 2007 SQL SERVER – One Thing All DBA Must Know
262 Aug 04, 2007 SQLAuthority News – Download SQL Server 2005 Samples and Sample Databases
261 Aug 04, 2007 SQLAuthority News – Author Visit – Database Architecture and Implementation Discussion – New York, New Jersey
260 Aug 03, 2007 SQLAuthority News – Microsoft SQL Server Compact 3.5 Server Tools Beta 2 Released
259 Aug 03, 2007 SQL SERVER – Two Different Ways to Comment Code – Explanation and Example
258 Aug 02, 2007 SQLAuthority News – Book Review – SQL Server 2005 Practical Troubleshooting: The Database Engine
257 Aug 02, 2007 SQL SERVER – FIX : Error 945 Database cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server error log for details
256 Aug 01, 2007 SQL SERVER – SQL Joke, SQL Humor, SQL Laugh – Search SQL
255 Aug 01, 2007 SQL SERVER – 2008 – July CTP Released
254 Jul 31, 2007 SQLAuthority News – My Favorite Articles of This Blog
253 Jul 30, 2007 SQLAuthority News – Birthday of SQL Authority Author
252 Jul 29, 2007 SQL SERVER – Data Warehousing Interview Questions and Answers Complete List Download
251 Jul 28, 2007 SQL SERVER – Data Warehousing Interview Questions and Answers – Part 3
250 Jul 27, 2007 SQL SERVER – Data Warehousing Interview Questions and Answers – Part 2
249 Jul 26, 2007 SQL SERVER – Data Warehousing Interview Questions and Answers – Part 1
248 Jul 25, 2007 SQLAuthority News – Interesting Read – Programming Concepts, Structured Thinking Language (STL) and Relationary
247 Jul 25, 2007 SQL SERVER – Data Warehousing Interview Questions and Answers – Introduction
246 Jul 24, 2007 SQL SERVER – 2005 – Server and Database Level DDL Triggers Examples and Explanation
245 Jul 23, 2007 SQL SERVER – UDF – Function to Get Previous And Next Work Day – Exclude Saturday and Sunday
244 Jul 23, 2007 SQL SERVER – UDF – Get the Day of the Week Function
243 Jul 22, 2007 SQLAuthority News – FQL – Facebook Query Language
242 Jul 21, 2007 SQL SERVER – Fix : Error Msg 1813, Level 16, State 2, Line 1 Could not open new database ‘yourdatabasename’. CREATE DATABASE is aborted.
241 Jul 20, 2007 SQL SERVER – Fix : Error Msg 4214 – Error Msg 3013 – BACKUP LOG cannot be performed because there is no current database backup
240 Jul 19, 2007 SQL SERVER – 2005 – SSMS – View/Send Query Results to Text/Grid/Files
239 Jul 19, 2007 SQL SERVER – SPACE Function Example
238 Jul 18, 2007 SQL SERVER – Restore Database Without or With Backup – Everything About Restore and Backup
237 Jul 17, 2007 SQL SERVER – CASE Statement in ORDER BY Clause – ORDER BY using Variable
236 Jul 16, 2007 SQL SERVER – Microsoft White Papers – Analysis Services Query Best Practices – Partial Database Availability
235 Jul 15, 2007 SQL SERVER – SQL Joke, SQL Humor, SQL Laugh – 15 Signs to Identify Bad DBA
234 Jul 14, 2007 SQL SERVER – 2005 Collation Explanation and Translation – Part 2
233 Jul 13, 2007 SQL SERVER – 2005 – Use ALTER DATABASE MODIFY NAME Instead of sp_renameDB to rename
232 Jul 12, 2007 SQL SERVER – Validate Field For DATE datatype using function ISDATE()
231 Jul 11, 2007 SQLAuthority News – SQL Blog SQLAuthority.com Comment by Mr. Ben Forta
230 Jul 11, 2007 SQL SERVER – 2005 – Features Comparison Chart
229 Jul 11, 2007 SQL SERVER – 2008 – Scheduled Launch at an Event in Los Angeles on Feb. 27, 2008
228 Jul 11, 2007 SQL SERVER – Count Duplicate Records – Rows
227 Jul 10, 2007 SQL SERVER – 2005 – List All Stored Procedure Modified in Last N Days
226 Jul 09, 2007 SQL SERVER – Result of EXP (Exponential) to the POWER of PI – Functions Explained
225 Jul 08, 2007 SQL SERVER – FIX : ERROR Msg 244, Level 16, State 1 – FIX : ERROR Msg 245, Level 16, State 1
224 Jul 08, 2007 SQL SERVER – SQL Joke, SQL Humor, SQL Laugh – Generic Quotes
223 Jul 07, 2007 SQL SERVER – Convert Text to Numbers (Integer) – CAST and CONVERT
222 Jul 06, 2007 SQL SERVER – FIX : Error : msg 8115, Level 16, State 2, Line 2 – Arithmetic overflow error converting expression to data type
221 Jul 05, 2007 SQL SERVER – 2005 – Microsoft Document Explorer cannot be shown because the specified help collection ‘ms-help://MS.SQLCC.v9
220 Jul 05, 2007 SQL SERVER – 2005 Best Practices Analyzer Tutorial – Sample Example
219 Jul 04, 2007 SQL SERVER – 2005 Best Practices Analyzer (July BPA)
218 Jul 04, 2007 SQL SERVER – Definition, Comparison and Difference between HAVING and WHERE Clause
217 Jul 03, 2007 SQL SERVER – Comparison : Similarity and Difference #TempTable vs @TempVariable
216 Jul 02, 2007 SQL SERVER – 2005 Comparison SP_EXECUTESQL vs EXECUTE/EXEC
215 Jul 01, 2007 SQL SERVER – Explanation of WITH ENCRYPTION clause for Stored Procedure and User Defined Functions
214 Jun 30, 2007 SQL SERVER – Fix : Error : Server: Msg 131, Level 15, State 3, Line 1 The size () given to the type ‘varchar’ exceeds the maximum allowed for any data type (8000)
213 Jun 29, 2007 SQL SERVER – Recompile All The Stored Procedure on Specific Table
212 Jun 28, 2007 SQL SERVER – 2005 Improvements in TempDB
211 Jun 27, 2007 SQL SERVER – Running Batch File Using T-SQL – xp_cmdshell bat file
210 Jun 26, 2007 SQL SERVER – 2005 List All Tables of Database
209 Jun 26, 2007 SQL SERVER – Explanation and Example Four Part Name
208 Jun 25, 2007 SQL SERVER – Repeate String N Times Using String Function REPLICATE
207 Jun 24, 2007 SQLAuthority News – Book Review – Microsoft(R) SQL Server 2005 Unleashed (Paperback)
206 Jun 24, 2007 SQL SERVER – Comparison Index Fragmentation, Index De-Fragmentation, Index Rebuild – SQL SERVER 2000 and SQL SERVER 2005
205 Jun 23, 2007 SQL SERVER – 2005 Row Overflow Data Explanation
204 Jun 22, 2007 SQL SERVER – Explanation and Comparison of NULLIF and ISNULL
203 Jun 21, 2007 SQLAuthority.com News – iGoogle Gadget Published
202 Jun 21, 2007 SQL SERVER – Retrieve Current Date Time in SQL Server CURRENT_TIMESTAMP, GETDATE(), {fn NOW()}
201 Jun 20, 2007 SQL SERVER – Find Length of Text Field
200 Jun 19, 2007 SQLAuthority.com News – Journey to SQL Authority Milestone of SQL Server
199 Jun 18, 2007 SQL SERVER – Delay Function – WAITFOR clause – Delay Execution of Commands
198 Jun 17, 2007 SQL SERVER – De-fragmentation of Database at Operating System to Improve Performance
197 Jun 16, 2007 SQL SERVER – 2005 – UDF – User Defined Function to Strip HTML – Parse HTML – No Regular Expression
196 Jun 15, 2007 SQL SERVER – sp_HelpText for sp_HelpText – Puzzle
195 Jun 15, 2007 SQL SERVER – 2005 NorthWind Database or AdventureWorks Database – Samples Databases – Part 2
194 Jun 14, 2007 SQL SERVER – Easy Sequence of SELECT FROM JOIN WHERE GROUP BY HAVING ORDER BY
193 Jun 14, 2007 SQL SERVER – Explanation SQL SERVER Hash Join
192 Jun 13, 2007 SQL SERVER – Fix : Error 8629 The query processor could not produce a query plan from the optimizer because a query cannot update a text, ntext, or image column and a clustering key at the same time.
191 Jun 13, 2007 SQL SERVER – Download 2005 Books Online (May 2007)
190 Jun 13, 2007 SQL SERVER – Recovery Models and Selection
189 Jun 12, 2007 SQL SERVER – SQL Joke, SQL Humor, SQL Laugh – Funny Quotes
188 Jun 12, 2007 SQL SERVER – LEN and DATALENGTH of NULL Simple Example
187 Jun 11, 2007 SQL SERVER – Cannot resolve collation conflict for equal to operation
186 Jun 11, 2007 SQL SERVER – 2005 T-SQL Paging Query Technique Comparison (OVER and ROW_NUMBER()) – CTE vs. Derived Table
185 Jun 10, 2007 SQL SERVER – Retrieve – Select Only Date Part From DateTime – Best Practice
184 Jun 10, 2007 SQL SERVER – Fix : Error : An error has occurred while establishing a connect to the server. Solution with Images.
183 Jun 09, 2007 SQL SERVER – Fix : Error : Msg 9514, Level 16, State 1, Line 1 Xml data type is not supported in distributed queries. Remote object ‘OPENROWSET’ has xml column(s).
182 Jun 09, 2007 SQL SERVER – Spatial Database Definition and Research Documents
181 Jun 08, 2007 SQL SERVER – UDF – Function to Display Current Week Date and Day – Weekly Calendar
180 Jun 08, 2007 SQL SERVER – Insert Multiple Records Using One Insert Statement – Use of UNION ALL
179 Jun 07, 2007 SQL SERVER – 2005 Download New Updated Book On Line (BOL)
178 Jun 07, 2007 SQL SERVER – 2008 (Katmai) June CTP Released – Improvement Pillars – Diagram
177 Jun 07, 2007 SQL SERVER – Fix : Error : Error 15401: Windows NT user or group ‘username’ not found. Check the name again.
176 Jun 06, 2007 SQL SERVER Database Coding Standards and Guidelines Complete List Download
175 Jun 05, 2007 SQL SERVER – Database Coding Standards and Guidelines – Part 2
174 Jun 04, 2007 SQL SERVER – Database Coding Standards and Guidelines – Part 1
173 Jun 03, 2007 SQL SERVER Database Coding Standards and Guidelines – Introduction
172 Jun 03, 2007 SQL SERVER – 2005 Explanation and Example – SELF JOIN
171 Jun 02, 2007 SQL SERVER – 2005 – Microsoft SQL Server Management Pack for Microsoft Operations Manager 2005 – Download SQL Server MOM 2005
170 Jun 02, 2007 SQLAuthority News – Subscribe to Feed in Email
169 Jun 01, 2007 SQLAuthority News – Dedicated Search Engine for SQLAuthority – Search SQL Solutions
168 Jun 01, 2007 SQL SERVER – 2005 Constraint on VARCHAR(MAX) Field To Limit It Certain Length
167 May 31, 2007 SQL SERVER – Retrieve Information of SQL Server Agent Jobs
166 May 31, 2007 SQL SERVER – 2005 Change Database Compatible Level – Backward Compatibility – Part 2 – Management Studio
165 May 31, 2007 SQL SERVER – Primary Key Must Not Contain NULL – Primary Key are NOT NULL
164 May 30, 2007 SQLAuthority.com News – Best SQL Job Search – Best SQL Job List – Find SQL Jobs
163 May 30, 2007 SQL SERVER – Trace Flags – DBCC TRACEON
162 May 30, 2007 SQL SERVER – Fix : Error : Server: Msg 544, Level 16, State 1, Line 1 Cannot insert explicit value for identity column in table
161 May 29, 2007 SQL SERVER – 2005 Change Database Compatible Level – Backward Compatibility
160 May 29, 2007 SQL SERVER – User Defined Functions (UDF) Limitations
159 May 28, 2007 SQLAuthority News – Author Visit – Meeting with Readers – Top Three Features of SQL SERVER 2005
158 May 28, 2007 SQL SERVER – SQL Joke, SQL Humor, SQL Laugh – SP
157 May 27, 2007 SQL SERVER – Download Feature Pack for Microsoft SQL Server 2005
156 May 27, 2007 SQL SERVER – 2005 Limiting Result Sets by Using TABLESAMPLE – Examples
155 May 26, 2007 SQL SERVER – 2005 Replace TEXT with VARCHAR(MAX) – Stop using TEXT, NTEXT, IMAGE Data Types
154 May 26, 2007 SQL SERVER – 2005 Find Table without Clustered Index – Find Table with no Primary Key
153 May 25, 2007 SQL SERVER – Change Default Fill Factor For Index
152 May 25, 2007 SQL SERVER – Stored Procedure to display code (text) of Stored Procedure, Trigger, View or Object
151 May 24, 2007 SQL SERVER – Disadvantages (Problems) of Triggers
150 May 24, 2007 SQL SERVER – 2005 Retrieve Configuration of Server
149 May 23, 2007 SQL SERVER – 2005 NorthWind Database or AdventureWorks Database – Samples Databases
148 May 23, 2007 SQL SERVER – 2005 Explanation Left Semi Join Showplan Operator and Other Operator
147 May 23, 2007 SQLAuthority News – New Scoble Plugin of WordPress
146 May 22, 2007 SQLAuthority News – T-Shirts in Action
145 May 22, 2007 SQL SERVER – 2005 Comparison EXCEPT operator vs. NOT IN
144 May 21, 2007 SQL SERVER – SQL Joke, SQL Humor, SQL Laugh – T-Shirt
143 May 21, 2007 SQL SERVER – Top 15 free SQL Injection Scanners – Link to Security Hacks
142 May 21, 2007 SQL SERVER – 2005 Build List Link
141 May 20, 2007 SQL SERVER – SQL Code Formatter Tools
140 May 20, 2007 SQL SERVER – Script/Function to Find Last Day of Month
139 May 19, 2007 SQL SERVER – ASCII to Decimal and Decimal to ASCII
138 May 19, 2007 SQL SERVER – Math Functions for 2005
137 May 18, 2007 SQL SERVER – 2005 Understanding Trigger Recursion and Nesting with examples
136 May 18, 2007 SQL SERVER – 2005 – SSMS Change T-SQL Batch Separator
135 May 17, 2007 SQLAuthority News – Limited Edition T-Shirts Arrived
134 May 17, 2007 SQL SERVER – Disable Index – Enable Index – ALTER Index
133 May 16, 2007 SQL SERVER – Fix : Error 1205 : Transaction (Process ID) was deadlocked on resources with another process and has been chosen as the deadlock victim. Rerun the transaction
132 May 16, 2007 SQL SERVER – Fix: Error 130: Cannot perform an aggregate function on an expression containing an aggregate or a subquery
131 May 15, 2007 SQL SERVER – Binary Sequence Generator – Truth Table Generator
130 May 15, 2007 SQL SERVER – DBCC commands List – documented and undocumented
129 May 14, 2007 SQL SERVER – SQL Joke, SQL Humor, SQL Laugh – Photo
128 May 14, 2007 SQL SERVER – MS TechNet : Storage Top 10 Best Practices
127 May 13, 2007 SQL SERVER – Query to Find First and Last Day of Current Month
126 May 13, 2007 SQL SERVER – UDF – Function to Parse AlphaNumeric Characters from String
125 May 12, 2007 SQL SERVER – 2005 – List all the database
124 May 12, 2007 SQL SERVER – Fix : Error : Msg 6263, Level 16, State 1, Line 2 Enabling SQL Server 2005 for CLR Support
123 May 11, 2007 SQL SERVER – Explanation SQL Command GO
122 May 11, 2007 SQL SERVER – Download Microsoft SQL Server 2005 System Views Map
121 May 10, 2007 SQL SERVER – 2008 Katmai – Download Datasheet Final from Microsoft
120 May 10, 2007 SQL SERVER – Fix: Error : HResult 0x2, Level 16, State 1 Named Pipes Provider: Could not open a connection to SQL Server
119 May 10, 2007 SQL SERVER – 2008 Katmai – Your Data, Any Place, Any Time
118 May 09, 2007 SQL SERVER – Fix : Error 2501 : Cannot find a table or object with the name . Check the system catalog.
117 May 09, 2007 SQLAuthority News – Author Visit – MIS2007 Part II – Database Raid Discussion
116 May 08, 2007 SQL SERVER – Index Optimization CheckList
115 May 08, 2007 SQLAuthority News – Author Visit – The 2007 Marketing Innovation Summit, Las Vegas
114 May 07, 2007 SQL SERVER – Top 10 Hidden Gems in SQL Server 2005
113 May 07, 2007 SQL SERVER – 2005/2000 Examples and Explanation for GOTO
112 May 06, 2007 SQL SERVER – Creating Comma Separate Values List from Table – UDF – SP
111 May 06, 2007 SQL SERVER – UDF – Function to Convert List to Table
110 May 05, 2007 SQL SERVER – 2005 Enable CLR using T-SQL script
109 May 05, 2007 SQL SERVER – UDF – User Defined Function to Find Weekdays Between Two Dates
108 May 04, 2007 SQL SERVER – Fix : Error : Msg 7311, Level 16, State 2, Line 1 Cannot obtain the schema rowset DBSCHEMA_TABLES_INFO for OLE DB provider SQLNCLI for linked server LinkedServerName
107 May 04, 2007 SQL SERVER – Download SQL Server Management Studio Keyboard Shortcuts (SSMS Shortcuts)
106 May 03, 2007 SQL SERVER – DBCC commands to free several SQL Server memory caches
105 May 03, 2007 SQL SERVER – Enable Login – Disable Login using ALTER LOGIC – Change name of the ‘SA’
104 May 02, 2007 SQL SERVER – FIX : ERROR 1101 : Could not allocate a new page for database because of insufficient disk space in filegroup
103 May 02, 2007 SQL SERVER – 2005 TOP Improvements/Enhancements
102 May 01, 2007 SQL SERVER – User Defined Functions (UDF) to Reverse String – UDF_ReverseString
101 May 01, 2007 SQL SERVER – Copy Column Headers in Query Analyzers in Result Set
100 May 01, 2007 SQLAuthority.com 100th Post – Gratitude Note to Readers
99 Apr 30, 2007 SQL SERVER – Collate – Case Sensitive SQL Query Search
98 Apr 30, 2007 SQL SERVER – FIX : ERROR : Msg 3159, Level 16, State 1, Line 1 – Msg 3013, Level 16, State 1, Line 1
97 Apr 30, 2007 SQL SERVER – SET ROWCOUNT – Retrieving or Limiting the First N Records from a SQL Query
96 Apr 29, 2007 SQL SERVER – 2005 Security DataSheet
95 Apr 29, 2007 SQL SERVER – Random Number Generator Script – SQL Query
94 Apr 29, 2007 SQL SERVER – Replication Keywords Explanation and Basic Terms
93 Apr 28, 2007 SQL SERVER – Explanation SQL SERVER Merge Join
92 Apr 28, 2007 SQL SERVER – Restrictions of Views – T SQL View Limitations
91 Apr 28, 2007 SQL SERVER – Good, Better and Best Programming Techniques
90 Apr 27, 2007 SQL SERVER – Query to Retrieve the Nth Maximum Value
89 Apr 27, 2007 SQL SERVER – 2005 Locking Hints and Examples
88 Apr 27, 2007 SQL SERVER – SELECT vs. SET Performance Comparison
87 Apr 26, 2007 SQL SERVER – Difference Between Unique Index vs Unique Constraint
86 Apr 26, 2007 SQL SERVER – Enable xp_cmdshell using sp_configure
85 Apr 26, 2007 SQL SERVER – 2005 – DBCC ROWLOCK – Deprecated
84 Apr 25, 2007 SQL SERVER – Alternate Fix : ERROR 1222 : Lock request time out period exceeded
83 Apr 25, 2007 SQL SERVER – ERROR Messages – sysmessages error severity level
82 Apr 25, 2007 SQL SERVER – 2005 Take Off Line or Detach Database
81 Apr 24, 2007 SQL SERVER – TRIM() Function – UDF TRIM()
80 Apr 24, 2007 SQL SERVER – Six Properties of Relational Tables
79 Apr 24, 2007 SQL SERVER – 2005 Collation Explanation and Translation
78 Apr 23, 2007 SQL SERVER – Fix : Error : 40 – could not open a connection to SQL server.
77 Apr 23, 2007 SQL SERVER – 2005 Query Analyzer – Microsoft SQL SERVER Management Studio
76 Apr 23, 2007 SQL SERVER – Query to Find Seed Values, Increment Values and Current Identity Column value of the table
75 Apr 23, 2007 SQL SERVER – Understanding new Index Type of SQL Server 2005 Included Column Index along with Clustered Index and Non-clustered Index
74 Apr 22, 2007 SQL SERVER – Raid Configuration – RAID 10
73 Apr 22, 2007 SQL SERVER – @@DATEFIRST and SET DATEFIRST Relations and Usage
72 Apr 22, 2007 SQL SERVER – Fix : Error: 1418 – Microsoft SQL Server – The server network address can not be reached or does not exist. Check the network address name and reissue the command
71 Apr 21, 2007 SQL Server Interview Questions and Answers Complete List Download
70 Apr 20, 2007 SQL Server Interview Questions and Answers – Part 6
69 Apr 19, 2007 SQL Server Interview Questions and Answers – Part 5
68 Apr 18, 2007 SQL Server Interview Questions and Answers – Part 4
67 Apr 17, 2007 SQL Server Interview Questions and Answers – Part 3
66 Apr 16, 2007 SQL Server Interview Questions and Answers – Part 2
65 Apr 15, 2007 SQL Server Interview Questions and Answers – Part 1
64 Apr 15, 2007 SQL Server Interview Questions and Answers – Introduction
63 Apr 14, 2007 SQL SERVER – 64 bit Architecture and White Paper
62 Apr 14, 2007 SQL SERVER – CASE Statement/Expression Examples and Explanation
61 Apr 14, 2007 SQL SERVER – Fix : Error: 18452 Login failed for user ‘(null)’. The user is not associated with a trusted SQL Server connection.
60 Apr 13, 2007 SQL SERVER – Stored Procedures Advantages and Best Advantage
59 Apr 13, 2007 SQL SERVER – Script to Find SQL Server on Network
58 Apr 13, 2007 SQL SERVER – 2005 – Disable Triggers – Drop Triggers
57 Apr 12, 2007 SQL SERVER – Fix : Error 1702 CREATE TABLE failed because column in table exceeds the maximum of columns
56 Apr 12, 2007 SQL SERVER – Fix : Error: 3902, Severity: 16; State: 1 : The COMMIT TRANSACTION request has no corresponding BEGIN TRANSACTION.
55 Apr 12, 2007 SQL SERVER – Running 64 bit SQL SERVER 2005 on 32 bit Operating System
54 Apr 11, 2007 SQL SERVER – UDF – User Defined Function to Extract Only Numbers From String
53 Apr 11, 2007 SQL SERVER – 2005 – Explanation of TRY…CATCH and ERROR Handling
52 Apr 10, 2007 SQL SERVER – 2005 – Silent Installation – Unattended Installation
51 Apr 10, 2007 SQL SERVER – SP Performance Improvement without changing T-SQL
50 Apr 09, 2007 SQL SERVER – 2005 Reserved Keywords
49 Apr 08, 2007 SQL SERVER – Search Text Field – CHARINDEX vs PATINDEX
48 Apr 07, 2007 SQL SERVER – DBCC Commands Introduced in SQL Server 2005
47 Apr 06, 2007 SQL SERVER – Fix: Server: Msg 7391, Level 16, State 1, Line 1
46 Apr 05, 2007 SQL SERVER – Performance Optimization of SQL Query and FileGroups
45 Apr 04, 2007 SQL SERVER – Fix: HResult 0x274D, Level 16, State 1 Error: Microsoft SQL Native Client : Login timeout expired.
44 Apr 03, 2007 SQL SERVER – T-SQL Paging Query Technique Comparison – SQL 2000 vs SQL 2005
43 Apr 02, 2007 SQL SERVER – 2005 – Performance Dashboard Reports
42 Apr 01, 2007 SQL SERVER – TempDB is Full. Move TempDB from one drive to another drive.
41 Mar 31, 2007 SQL SERVER – 2005 Best Practices Analyzer (February 2007 CTP)
40 Mar 30, 2007 SQL SERVER – Index Seek Vs. Index Scan (Table Scan)
39 Mar 29, 2007 SQL SERVER – Difference between DISTINCT and GROUP BY – Distinct vs Group By
38 Mar 28, 2007 SQL SERVER – Fix : Error 8101 An explicit value for the identity column in table can only be specified when a column list is used and IDENTITY_INSERT is ON
37 Mar 27, 2007 SQL SERVER – Fix : Error 701 There is insufficient system memory to run this query
36 Mar 25, 2007 SQL SERVER – @@IDENTITY vs SCOPE_IDENTITY() vs IDENT_CURRENT – Retrieve Last Inserted Identity of Record
35 Mar 23, 2007 SQL SERVER – Stored Procedure – Clean Cache and Clean Buffer
34 Mar 22, 2007 SQL SERVER – Fix: Error Msg 128 The name is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted.
33 Mar 21, 2007 SQL SERVER – 2005 Security Best Practices – Operational and Administrative Tasks
32 Mar 20, 2007 SQL SERVER – SQL Commandments – Suggestions, Tips, Tricks
31 Mar 16, 2007 SQL SERVER – Fix: Sqllib error: OLEDB Error encountered calling IDBInitialize::Initialize. hr = 0x80004005. SQLSTATE: 08001, Native Error: 17
30 Mar 15, 2007 SQL SERVER – DBCC RESEED Table Identity Value – Reset Table Identity
29 Mar 10, 2007 SQL SERVER – Union vs. Union All – Which is better for performance?
28 Mar 07, 2007 SQL SERVER – Download 2005 SP2a
27 Mar 07, 2007 SQL SERVER – Script to Determine Which Version of SQL Server 2000-2005 is Running
26 Mar 05, 2007 SQL SERVER – QUOTED_IDENTIFIER ON/OFF and ANSI_NULL ON/OFF Explanation
25 Mar 01, 2007 SQL SERVER – Delete Duplicate Records – Rows
24 Feb 28, 2007 SQL SERVER – T-SQL Script to find the CD key from Registry
23 Feb 26, 2007 SQL SERVER – What is New in SQL Server Agent for Microsoft SQL Server 2005
22 Feb 25, 2007 SQL SERVER – Restore Database Backup using SQL Script (T-SQL)
21 Feb 24, 2007 SQL SERVER – Download SQL Server 2005 Books Online (February 2007)
20 Feb 24, 2007 SQL SERVER – SQL Server 2005 Samples and Sample Databases (February 2007)
19 Feb 20, 2007 SQL SERVER – Creating Comma Separate List From Table
18 Feb 15, 2007 SQL SERVER – FIX : Error 15023: User already exists in current database.
17 Feb 10, 2007 SQL SERVER – Function to Convert List to Table
16 Feb 05, 2007 SQL SERVER – Primary Key Constraints and Unique Key Constraints
15 Feb 01, 2007 SQL SERVER – UDF – Function to Convert Text String to Title Case – Proper Case
14 Jan 31, 2007 SQL SERVER – ReIndexing Database Tables and Update Statistics on Tables
13 Jan 30, 2007 SQL SERVER – Query Analyzer Short Cut to display the text of Stored Procedure
12 Jan 26, 2007 SQL SERVER – SQL Joke, SQL Humor, SQL Laugh
11 Jan 20, 2007 SQL SERVER – Query Analyzer Shortcuts
10 Jan 10, 2007 SQL SERVER – Query to find number Rows, Columns, ByteSize for each table in the current database – Find Biggest Table in Database
9 Jan 01, 2007 SQL SERVER – Simple Example of Cursor
8 Dec 30, 2006 SQL SERVER – Shrinking Truncate Log File – Log Full
7 Dec 20, 2006 SQL SERVER – Fix : Error 14274: Cannot add, update, or delete a job (or its steps or schedules) that originated from an MSX server. The job was not saved.
6 Dec 10, 2006 SQL SERVER – Find Stored Procedure Related to Table in Database – Search in All Stored Procedure
5 Dec 01, 2006 SQL SERVER – Cursor to Kill All Process in Database
4 Nov 30, 2006 SQL SERVER – Simple Cursor to Select Tables in Database with Static Prefix and Date Created
3 Nov 20, 2006 SQL SERVER – Auto Generate Script to Delete Deprecated Fields in Current Database
2 Nov 10, 2006 SQL SERVER – Query to Find ByteSize of All the Tables in Database
1 Nov 01, 2006 SQL SERVER – Query to Display Foreign Key Relationships and Name of the Constraint for Each Table in Database
About these ads