(Rajendra Gupta) In previous tips we have seen how to install SQL Server and administration tips for SQL Server on Linux. In this tip, I will show you how to change the default backup location on a Linux based SQL Server instance compared to a Windows based SQL Server.

(Pinal Dave) Sometimes some behaviors in SQL Server are unexpected and that’s the right time when an expert need to be engaged. In this blog post we will learn about how automatic startup sometimes does not work in SQL Server Services.

The video demo will walk you through all the steps required to create / configure AlwaysOn availability Group in SQL Server 2016. Below items are covered.

(Arun Sirpal) So the decision to move to the cloud has been made but there is a fear from people that once it happens they will lose control of their job function. Does this sound familiar? DBA’s, you will be needed but expect some sort of change (That’s my opinion).

(Joseph Sack) As of this writing, the default compatibility level for new databases created in Azure SQL Database is 130. Very soon, we’ll be changing the Azure SQL Database default compatibility level for newly created databases to 140.

(Jack Vamvas) This Powershell script will Check on all Windows servers that a service which was meant to start has failed. Excludes services which are not meant to start

(Kenneth Fisher) You’ve installed SSDT, created an SSIS project, created any packages you need and now you want to place that project and its packages onto the SQL instance so you can run them. FYI there are several ways to do this using package or project deployment, I’m just going to talk about on

(Pinal Dave) In SQL Server, there are many methods to find out the column names in a table. If you want to find out the column names based on the ordinal position you can do it querying system view size. Columns. Do you know that you can also do this by using COL_NAME() system function?

(James Serra) Data virtualization goes by a lot of different names: logical data warehouse, data federation, virtual database, and decentralized data warehouse. Data virtualization allows you to integrate data from various sources, keeping the data in-place, so that you can generate reports and das

(Ryan J. Adams) In this post I’ll point you to some options to sync SQL logins and then I’ll demo my favorite option in a video. If you are using Availability Groups or Mirroring you know you need to sync SQL logins and jobs among replicas.