Improvements in the SQL Server 2008 T-SQL command
IT Tricks

Improvements in the SQL Server 2008 T-SQL command

Network administrator – SQL Server 2008 is packed with many notable new features. One of these features is improvements in T-SQL statements that reduce the time spent working with these statements. In the first part of this series, we will look at some of T-SQL improvements. Improvements in Intellisense (smart touch sensor) With Intellisense enhancements, […]

SQL Server setup is always available
IT Tricks

SQL Server setup is always available

Database Mirroring solution helps to build a high availability database management system (SQL) in SQL Server which is quite simple and suitable for databases of just below. The need for a high-availability database management system is becoming increasingly urgent, sometimes a vital factor for organizations and companies. However, achieving a high level of readiness (almost […]

Learn about role concepts in SQL Server
IT Tricks

Learn about role concepts in SQL Server

In any database management system, the issue of security and confidentiality always comes first. And with SQL Server, if we take advantage of many advantages of this application, people who do system administration jobs will reduce a lot of burden and pressure at work. With the article below, we will introduce you some basic information […]