Sunday , 25 June 2017

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 »

SERVERPROPERTY in SQL Server

SERVERPROPERTY in SQL Server First of all let me explain what is serverproperty in sql server. Serverproperty in sql server is built in system function. This system function is important because you get a lot of useful information regarding to your SQL Server. This article will show you how to get all information you need about your SQL Server. For …

Read More »

How to hash a text in SQL Server

How to hash a text in SQL Server In this article I am going to show you how to hash a text in SQL Server. First let me explain what is hashing or hash function? “A hash function is any function that can be used to map digital data of arbitrary size to digital data of fixed size, with slight differences in input …

Read More »

Rad Studio XE7 (Delphi and C++)

Rad Studio XE7 (Delphi and C++) The complete solution to build connected apps for Windows, Mac, iOS, Android, Gadgets and Wearables Embarcadero® RAD Studio XE7 is the complete software development solution for rapidly building native applications for Windows, Mac, iOS and Android from a single codebase. Modernize existing Windows applications and create highly connected apps for gadgets and wearables. Deliver …

Read More »

Creating triggers in SQL Server

Creating triggers in SQL Server Creating triggers in SQL Server in SQL Server is similar to create a stored procedure. You can create triggers only when certain actions are fired. Triggers can be fired only before (insert, update, delete) and after (insert, update, delete). Creating triggers in SQL Server is very easy. In this article you are going to create a trigger …

Read More »

Searching all tables in sql server

Searching all tables in sql server Imagine a case where you want to see on which table there is a value or string of  ‘Barlet’ and you have 50+ tables on your database. Searching all tables in sql server one by one will be a huge pain and a waste of time. In this article you will see how to search all tables in …

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 »

Stored Procedure vs Functions

Stored Procedure vs Functions In this article I am going to show you the differences between a Function and a Stored Procedure in sql server. They are both stored in the database server. First let me show you how you can create user defined function and a stored procedure. I am going to create a simple function that will add …

Read More »

What is a Stored Procedure

What is a Stored Procedure What is a Stored Procedure? Stored procedures are a group of SQL Statement that run in a single execution plan. Stores procedures are created and saved in the database, so you can reuse it whenever you need it. They can accept input parameter and reduce the network traffic. Stored procedures are good for security and they prevent …

Read More »

Filter between dates in sql server

Filter between dates in sql server In every application of yours, you are going to do some kind of filtering. In this article you will learn how to filter your data between dates. The same way can be use to filter any other numbers as well. I am going to show you how to filter data in 2 ways. The first way …

Read More »

Capitalizing first word in SQL Server

Capitalizing first word in SQL Server In this article I am going to show you how to use simple function in SQL Server to manipulate with your texts or strings. Imagine you have a bunch of texts in lowercase and they all need to be uppercase or vice versa? You will have to rewrite all that boring thing one by …

Read More »

Database Connection in ASP.NET with C#

Database Connection in ASP.NET with C# In this article you are going to learn how to connect into the database from ASP.NET using C#. First of all you need to create a new empty web application. In the web form add a button and grid view. You are going to load the grid view with data from database on button click. …

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 »

Delete Truncate and Drop

Delete Truncate and Drop In this article I am going to explain the differences between delete, truncate and drop commands in sql server. Let me start by saying that these commands are similar but not the same. Every command does its unique work against the server. I can say that when using any of these three commands you should think …

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 »