Tag Archives: sql server

How to build , Manage and monitor your SQL Server replication

Hello my friends this my small posts in SQL Server replication it is not everything about replication but at least it is the what any DBA should know it What is SQL Replication? Types of SQL Replication Replication Overview  How … Continue reading

Gallery | Tagged , , , | Leave a comment

Insert into table with default values only

In this article you will find how to insert a row without any specified values in SQL Server table, if the columns have default values. I recently had this issue. I had a table with only two columns one of … Continue reading

Posted in SQL Server 2008, SQL Server 2012, SQL Server 2014, SQL Server Denali | Tagged , , , , , , | Leave a comment

High Availability in Microsoft SQL Server 2012

This gallery contains 1 photo.

Down or Up the ? Is. The main goal of a high availability solution is to minimize the impact of downtime. A sound strategy for this optimally balance business processes and SLA (Service Level Agreements) with technical capabilities and infrastructure … Continue reading

Gallery | Tagged , , , | Leave a comment

What we Should know before going to upgrade to SQL Server 2014(2/4)

Hello my Followers in the last previous post  i covered some points not supported in SQL Server 2014 in the new Technology and Feature Memory-Optimized-Table : Memory Optimized table doesn’t support Alter. We can’t create index after we create the table but … Continue reading

Gallery | Tagged , , , , , , , | Leave a comment

What we Should know before going to upgrade to SQL Server 2014(1/4)

Hi dears i think all (DBA / DB Analyst / BI developer / SQL Developer) knowing about new Improvement in the world of databases new Enhancement in the world of databases  How the Query will be faster by  SQL Server 2014…ETC , but … Continue reading

Gallery | Tagged , , | Leave a comment

The History of SQL Server

Video | Posted on by | Tagged , | Leave a comment

SQL Server 2012 SP2

This gallery contains 1 photo.

Announcing the release of SQL Server 2012 Service Pack 2. It’s now available to all customers with existing SQL Server 2012 deployments for download on the MSFT download center. http://cic.ms/VeM8zp

Gallery | Tagged , | Leave a comment