SQL Server Latest Updates (Mar.-Apr. 2018)

Directly from the SQL Server Release Service blog, here the latest updates for SQL Server 2014 SP2, 2016 SP1 and 2017 RTM:

Cumulative Update #5 for SQL Server 2017 RTM

Cumulative Update #6 for SQL Server 2017 RTM

Cumulative Update #11 for SQL Server 2014 SP2

Cumulative Update #8 for SQL Server 2016 SP1

The SQL Server 2016 Service Pack 2 is available here.

You can also download the new OLE DB driver for SQL Server.

…Stay Tuned! 🙂

How to Fix Corruption Related Issues in SQL Server Database

SQL database is a popular and useful relational database, but it is not free from technical flaws. SQL users often face various corruption related issues in SQL Server database. These issues occur due to the damage or corruption in the database of SQL Server. As these are common issues, SQL users must have clear concept regarding these issues. We will be discussing some major corruption related issues of SQL database and their symptoms. Users will also learn the remedial methods of these issues from this post. Let’s begin our discussion with the SQL Server errors and their symptoms.

Issues Related to SQL Server Corruption

Due to damaged or corrupt SQL Server database, users have to encounter different issues. We will discuss three major issues here.

SQL Fatal Error 823:

This error is caused by database corruption or some discrepancies of file system. It indicates that underlying hardware or driver situated n the path of I/O request is having some problem. This problem will generate some error messages that will display these information:

  • Operating system’s error code and error description
  • The file name that was executed against I/O operation
  • If I/O operation request is written or read

SQL Error 5172

This error is caused by unhealthy MDF files. It occurs due to the mismatched header file information, so accessing data becomes really tough. In such cases, recovering damaged SQL database is very important. Here are the major causes of error 5172:

  • Sudden shutdown of system
  • Hardware malfunctioning
  • Improper shut down of SQL Server
  • Virus or Malware attack

3. SQL Error 8946: If a particular assigned page does not contain valid page header, error 8946 can appear. If the header gets damaged, the entire page faces corruption. This results in data loss and inaccessible file. Power failure, hardware problems, virus attack, etc. are responsible for this particular error.

How to Resolve Corruption Related Issues in SQL Server Database

If you are facing one of the above corruption based issues in your SQL database, it means the database has been corrupt or damaged. The only way to resolve these issues is to free the SQL database from all types of corruption. To repair the corrupt database of SQL Server, users can adopt any of the two different methods. One is called manual method and another is called one-stop method.

Method 1: Manually Fix SQL Database Corruption

If users want to fix their corrupt SQL database manually, they can try these different methods. First of all, they can restore updated backup of SQL Server. They can also try database console commands to repair database. DBCC Repair commands that can fix minor corruption of SQL database.

Limitations of Manual Technique

These manual methods have got some limitations too. The biggest limitation is that none of these methods guarantee to recover SQL Server database. Moreover, all these methods take a lot of time to perform. Users need to be technically expert to execute these steps. Inexperienced people needs to be careful about their database, when performing these methods. Also, major corruptions cannot be fixed by these methods.

Method 2: Fix Corrupt SQL Server Database using Sure-Shot Solution

It is clear from above discussion that manual methods cannot fix damaged database for sure. To repair corrupt database, users have to apply the one-stop solution. Using third-party tools is called sure-shot solution as they can fix all types of database corruption. SysTools SQL Database Repair is such a tool that can remove both major and minor SQL Server database corruption. It can fix corruption of SQL Server 2016 & all previous versions. This program is also capable of recovering data from MDF files affected by Wallet Ransomware.

Conclusion

If you are facing any of these corruption related issues in SQL Server database, be sure that SQL Server has been damaged. Users need to fix the SQL Server in order to get rid of these issues. we have mentioned some methods to make your SQL database corruption free. Users can try manual methods, but there is no guarantee that the damaged database will be fixed for sure. One can also try the third party tool to recover corrupted database. It can easily fix the damage of SQL Server and all related issues will get solved.

SQL Server Latest Updates (Feb. 2018)

Directly from the SQL Server Release Service blog, here the latest updates for SQL Server 2014 SP2, 2016 SP1 and 2017 RTM:

Cumulative Update #4 for SQL Server 2017 RTM

Cumulative Update #10 for SQL Server 2014 SP2

Cumulative Update #7 for SQL Server 2016 SP1

…Stay Tuned! 🙂

Agile@School – settima lezione

Agile@School – settima lezione

Il club delle 6

Settimo appuntamento presso la scuola rodigina IIS Viola/Marchesini per il progetto Agile@School nella giornata di ieri 24 gennaio 2018. Si è giunti alla parte finale dove cerchiamo di mettere insieme tutte le parti finora studiate. Ci siamo dati come obiettivo quello di realizzare una semplice app per l’accesso a Twitter mettendo in gioco le conoscenze apprese.

1.png

View original post 313 more words

Agile@School – Inizio

Agile@School – Inizio

Il club delle 6

Anche l’ITI F.Viola/Marchesini di Rovigo si è unito ufficialmente al progetto esperimento/laboratorio Agile@School basato sull’idea e il supporto di Alessandro Alpi.

Immagine

Il tutto è stato inserito nelle attività ufficiali di alternanza scuola-lavoro dei ragazzi delle due quinte dell’istituto rodigino.

Il laboratorio ha come obiettivo introdurre i ragazzi ai concetti Agile e di lavoro in team: si mettono le mani in pasta e si utilizzano strumenti all’avanguardia del mondo professionale per realizzare un’app con Xamarin.

Nelle tre ore di laboratorio abbiamo toccato svariate argomentazioni e devo fare i complimenti ai ragazzi per essere stati complici e attivi in questo inizio di percorso tutto da esplorare.

  • Abbiamo introdotto i primi concetti e terminologia del mondo Agile e delle sostanziali differenze di cosa vuol dire fare un software per hobby/studio e farlo professionalmente.
  • Abbiamo esplorato le funzionalitĂ  di base di VSTS (Visual Studio Team Services) creando varie tipologie di PBI e mettendole…

View original post 158 more words

Agile@School – sesta lezione

Agile@School – sesta lezione

Il club delle 6

Sono ripresi oggi gli appuntamenti all’ITI F.Viola / Marchesini di Rovigo di Agile@School dopo le vacanze: siamo al sesto episodio su dieci. Come ripromesso negli episodi precedenti abbiamo ripreso in mano dei principi Agile/DevOps che negli ultimi incontri erano stati parcheggiati in favore di approfondimenti tecnologici su Xamarin Forms.

Continuous Delivery

View original post 219 more words

SQL Server Latest Updates (Dec. 2017)

Directly from the SQL Server Release Service blog, here the latest updates for SQL Server 2014 SP2:

Cumulative Update #9 for SQL Server 2014 SP2

Happy new year and…

…Stay Tuned! 🙂