(Jovan Popovic) In this article I will show you similarities and differences between SQl Server JSON and DocumentDB query syntax.
Tag: sql server
SQL Server Database Mirroring Report
(Rajendra Gupta) Once Database Mirroring has been configured and put in place, one of the things you need to do is to monitor the mirroring status to make sure things are working as planned. In this tip we will create a process to generate a report, so you can see the status.
5 tricks to boost DBA productivity
(Jack Vamvas) There are limited hours in the day, DBA workloads continue to grow, how you utilise the time is key to a productive DBA . What approaches and methods can a DBA adopt to become more efficient? I’m always looking for work methods to improve productivity but ensuring the risk of the dat
Managing the errorlog file
(Tibor Karaszi) I frequently see recommendations to regularly run sp_cycle_errorlog, so that the errorlog doesn’t become huge. My main concern with that is that the errorlog contains valuable information.
Understanding Stretch Database Functionality in SQL Server 2016
(Arshad Ali) SQL Server is one of the most widely used RDBMS around the world, and one of the reasons for this wide adoption comes from Microsoft’s commitment to add new capabilities that cater to the need of the changing landscape year after year. Along that line, SQL Server 2016 introduces several
SQL SERVER – Failed Rule ‘Valid DSN’ and ‘Valid Database compatibility level and successful connection’
(Pinal Dave) I always try to keep myself up-to-date with latest release of SQL Server. As a part of that I wanted to upgrade my SQL Server 2016 CTP2.2 to CTP2.3 version.
5 tricks to boost DBA productivity
(Jack Vamvas) There are limited hours in the day, DBA workloads continue to grow, how you utilise the time is key to a productive DBA . What approaches and methods can a DBA adopt to become more efficient? I’m always looking for work methods to improve productivity but ensuring the risk of the dat
Managing the errorlog file
(Tibor Karaszi) I frequently see recommendations to regularly run sp_cycle_errorlog, so that the errorlog doesn’t become huge. My main concern with that is that the errorlog contains valuable information.
Understanding Stretch Database Functionality in SQL Server 2016
(Arshad Ali) SQL Server is one of the most widely used RDBMS around the world, and one of the reasons for this wide adoption comes from Microsoft’s commitment to add new capabilities that cater to the need of the changing landscape year after year. Along that line, SQL Server 2016 introduces several
SQL SERVER – Failed Rule ‘Valid DSN’ and ‘Valid Database compatibility level and successful connection’
(Pinal Dave) I always try to keep myself up-to-date with latest release of SQL Server. As a part of that I wanted to upgrade my SQL Server 2016 CTP2.2 to CTP2.3 version.
