SQL Server

Installing SQL Server 2014 CTP1

  • After downloading the SQL Server 2014, mount the media file downloaded and run “setup.exe”
  • In SQL Server Installation Centre click on “Installation”

image

  • Click on “New SQL Server stand-alone installation or add features to an existing installation”

image

Note that if you have any of previous versions of SQL Server installed on your machine the setup process will fail because this release of SQL Server cannot be installed in until the existing instances of SQL Servers are uninstalled.

image

If you click on “Failed” you can read the complete error message that is “Previous SQL product installation failed. A SQL product other than SQL Server 2014 CTP1 is detected. You cannot install this release until the existing instances of SQL products are uninstalled.”

image

Continue reading “Installing SQL Server 2014 CTP1” →

Administartion, SQL Server, T-SQL

How to define database owner SQL server wide

What does it actually mean that the database doesn’t have a database owner?! It seems odd, but, it is possible. In some cases that the database is created by an application it really happens that the database doesn’t have any database owner. For instance, the databases  generated by CRM Deployment Manager doesn’t have database owner. So what if we had a bunch of databases in the SQL Server that doesn’t have any database owners? Okay, let me explain. I’ve faced to a situation that we needed to create some database diagrams for many databases and all of those databases where CRM databases created by CRM Deployment Manager. Hence, when we were trying to generate a database diagram an error message were raising saying the database doesn’t have DB owner.  So it was very time consuming if we wanted to define a DB owner for each database individually using the GUI. The following code will define a particular database owner for the databases server wide. (In our situation it was a service user.)

Continue reading “How to define database owner SQL server wide” →

SQL Server

Microsoft SQL Server 2014 Community Technology Preview 1 (CTP1) is ready to download

SQL server 2014 Community Technology Preview 1 (CTP1) is ready to download here: http://technet.microsoft.com/en-us/evalcenter/dn205290.aspx

Key Features

Project code-named “Hekaton”

One of the most exciting features in this version is a project code-named “Hekaton” that provides in-memory OLTP capabilities. As Hekaton is built into core SQL Server database it will improve the performance of the database applications significantly. It is more interesting that Hekaton is installed with SQL Server 2014 engine that means no additional action is needed to use the benefits of in-memory processing without rewriting the database application. It is really awesome that it can increase performance of existing database application without having to upgrade the hardware. Microsoft claims that Hekaton is easy to deploy and allows to access the other features in SQL Server, while taking the advantage of in-memory performance.

Continue reading “Microsoft SQL Server 2014 Community Technology Preview 1 (CTP1) is ready to download” →

SQL Server, T-SQL

Drop tables from selected schemas database wide

In my previous post called “How to drop tables database wide using T-SQL” I’ve explained that how we could delete all tables database wide in SQL Server. But, what if there are some other schemas other than “dbo” and some tables that are created in those schemas? If we just delete “[dbo].” from the code we will obviously face to the following error message: “Cannot find the object “TABLE_NAME” because it does not exist or you do not have permissions.” for those tables that are not under “dbo” schema. So, we need to retrieve all schemas and their related tables. This approach is really helpful when we are implementing an ETL process that is designed to delete the tables from particular schemas and recreate the tables and populate new data. This is a common way for staging to delete and recreate tables instead of updating existing tables as update is really costly.

So, let’s write some codes.

Continue reading “Drop tables from selected schemas database wide” →