(Pinal Dave) I have been seeing many customers moving their SQL Server to Cloud. Few of them have chosen Microsoft Azure platform to host their production server and few others have selected other cloud platforms like AWS.
Tag: sql server
Why has my Azure Load Balancer stopped working?
(Denny Cherry) Azure and the load balancers can be annoying little things. Especially when you are doing maintenance on your Azure environment, or setting it up for the first time. One of the quirks you may run into is that if you leave an Azure Load Balancer sitting for to long with no machines beh
SQL Agent for Azure SQL Database? Not quite
(blobeater) The following post shows my preferred way to automate / schedule some code against my Azure SQL Database. No it is not PowerShell or Azure Runbooks but it is definitely my favourite way.
Next on the Menu – counter, histogram, and pair matching targets
(boB ‘The Tool Man’ Taylor) In this SQL Snack I will examine the three remaining targets (I don’t plan on covering the ETW sync target as it is out of scope for this series). The counter, histogram and pair matching targets are very simple and straight forward to use and consume.
Update SQL Server Applications on Ubuntu Linux with Apt
(Daniel Farina) You are a SQL Server DBA that is used to working on Windows environments and you started working with SQL Server on Linux. Suddenly you realize the arrival of SQL Server on Linux brings more challenges for you.
SQL SERVER – Database Mail Error: The SMTP Server Requires a Secure Connection or the Client Was Not Authenticated. The Server Response Was: 5.5.1 – Using Gmail
(Pinal Dave) In my earlier blog, we saw one possible cause database mail error due to SSL settings. Today we will learn about another Database Mail Error.
Six sample databases for SQL Server and how to find them
(Michael Otey) It used to be that finding and using a sample SQL database was quite simple. In fact, the venerable Pubs database…
Quickly Change SQL Job Owners
(Jason Brimhall) It is not unusual to find a server where some random user created a bunch of jobs to be run by SQL Agent.
Connect SQL Server to AS400 with a Linked Server
(Jack Vamvas) Question: I need to set up a Linked Server between SQL Server 2016 and AS400 to extract data from a file and import the data onto a table on a SQL Server database.
SQL SERVER – gMSA: The Service Did Not Start Due to a Logon Failure
(Pinal Dave) This is one of the most common errors which is seen my most DBA when they are using a domain account as the service account. In this blog, we would learn about the cause and solution of error The service did not start due to a logon failure while using gMSA.