(Michael Otey) It used to be that finding and using a sample SQL database was quite simple. In fact, the venerable Pubs database…
Tag: sql server
(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.
(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.
(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.
(James Serra) I have heard some people say if you have a data warehouse, there is no need for cubes (when I say “cubes” I am referring to tabular and multidimensional OLAP models). And I have heard others say if you have OLAP cubes, you don’t need a data warehouse.
(Greg Larsen) When you are setting up a new SQL Server machine you need to determine how big you should make tempdb. Not an easy task to get it right out of the box.
(Shreyas R Gowda) Today, I was working with one of my clients with an issue where the application fails to connect to SQL server. The issue was encountered with the restart of the SQL services. The initial connections go through but within a very short duration the connections starts to fail.
(lukaseder) One of the things that confuse SQL users all the time is how DISTINCT and ORDER BY are related in a SQL query.
(Denny Cherry) A really great feature in Azure SQL DB went GA today. That feature gives you and SQL DB the ability to automatically fail databases over to a Secondary replia, without having to configure your application to handle that failover. You point your application at a VIP and that VIP will a
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
(Pinal Dave) Have you ever configured database mail using Gmail account? There are many articles on the internet describing the steps. In this blog, we would learn about fixing an error “The SMTP server requires a secure connection or the client was not authenticated” which you might see when databa