How to fix Windows could not start the SQL Server (MSSQLSERVER) on Local Computer error How to fix Windows could not start the SQL Server (MSSQLSERVER) on Local Computer error [More]
Free Microsoft e-Books - Windows 10, Windows 8.1, Windows 8, Windows 7, Office 2013, Office 365, SharePoint 2013, Dynamics CRM, PowerShell, Exchange Server, Lync 2013, System Center, Azure, Cloud, SQL Server Get Free official Microsoft e-Books covering diferent topics. [More]
Saving Changes is Not permitted– How to fix SQL server Designer restriction How to fix the Designer showing Error "Saving changes is not permitted" on SQL server [More]
Free eBooks from Microsoft Press - Programming Windows Store Apps with HTML, CSS and JavaScript and Introducing Microsoft SQL Server 2014 Programming Windows Store Apps with HTML, CSS and JavaScript is a free eBook from Microsoft written by Kraig Brockschmidt. It is the Second edition of this book where lot of more topics are added, 478 pages are added to the first version. The S... [More]
How to change a column to identity–SQL Server First of all, there is no direct way to do this. You have two options to do this 1. Add all the contents to a new table with Identity column and copy data to that table. Drop the current table and you may rename the table. CREATE TABLE dbo.Tmp_N... [More]
The conversion of a varchar data type to a datetime data type resulted in an out-of-range value When I executed a query on my website it threw the following exception The conversion of a varchar data type to a datetime data type resulted in an out-of-range value. The conversion of a varchar data type to a datetime data type resulted in an o... [More]
Free Online Training on SQL Server 2008 R2 Free online training on SQL Server 2008 R2 on Virtual Tech Days. Date, Time and Topics 2nd May, 2011 (2:30 pm - 3:45 pm) - Managing and Optimizing Resources for SQL Server 3rd May, 2011 (2:30 pm - 3:45 pm) - Optimizing and Tuning Full Text Se... [More]
Remove Duplicate rows from table - SQL Server I just came to a situation where I have duplicate entries in a table (all fields are identical) and I want to remove the duplicates. After a search I found a simple solution for my problem. In my case, there were 2 duplicate entries for each record.... [More]
Fix - Cannot connect to WMI provider – Invalid class - SQL Server 2008 When I tried to open the SQL Server Configuration Manager, it was showing the error message above. I just had a search and found an article on Martin Poon - Microsoft MVP blog [SQL Server], which have a solution for this issue, It tells to Run the f... [More]
Free SQL Script Generator - generate scripts to recreate the data, tables, stored procedures, views, triggers, keys, indexes and more. Using SQLScriptGenerator you can connect to your local or remote SQL Server and generate T-SQL script of the whole database or just database structure or just data or specific database objects. In the result it generates one or several *.s... [More]