Saturday , 24 June 2017
Home » Tag Archives: sql

Tag Archives: sql

Function that converts characters from Latin to Cyrillic

Function that converts characters from Latin to Cyrillic in SQL Server Image you have a text which is written in Latin characters but you need them to be in Cyrillic characters. What will you do? Are you going to write that again from the beginning with Cyrillic characters? Of course not. Why loose all the precious time by typing again?! …

Read More »

SQL Server Security

SQL Server Security One of the most important jobs of a SQL Server Database Administrator (DBA) is to secure all databases. In this article you are going to learn what to do in order to have solid secure database. If you fail securing your database(s) most likely you will lose your job. It is the DBA’s responsibility to see the problem first and …

Read More »

Reset sa password in SQL Server

Reset sa password in SQL Server Reset sa password in SQL Server is one of the questions that is asked in a lot of forums. In this article I am going to show the steps of resetting you sa (system administrator) password. Well first of all you need to log in to the sql server using your windows authentication. Once …

Read More »

Generate copy of your database

Generate copy of your database Sometimes you may want to create the copy of your database structure. In order to create tables, functions stored procedures one by one in SQL Server you can generate a script that can create the same database structure for you. This is done very easy with SQL Server Management Studio. So first you’re going to …

Read More »

Query Designer in SQL Server

Query Designer in SQL Server In this article you will learn how to create queries using Query Designer in SQL Server. You don’t need to have any SQL knowledge for using Query Designer in SQL Server, with Query Designer you can create queries easily. To open query designer first you need to open Query Editor. You can open query editor …

Read More »

Restore your database in sql server

Restore your database in sql server In this article you will understand how to restore your database from your database backup file. If you don’t know how to create database backup please read my article about Database Backup first. In SQL server you can restore your database in several ways. First I am going to show you how to use SQL Server …

Read More »