(Pinal Dave) While trying to create linked server, sometimes there are errors. One of the error is below which is related to TCP Provider.

(James Serra) As I mentioned in my recent blog Use cases of various products for a big data cloud solution, with so many products it can be difficult to know the best products to use when building a solution. When it comes to building an enterprise reporting solution, there is a recently released r

(Greg Larsen) As a DBA your #1 responsibility is to make sure that each of your SQL Server databases are backed up. Without recent backups you will not be able to recover your database without potentially losing many days of database updates.

(Jason Thomas) A couple of days ago, a new custom visual was released for Power BI – PowerApps (in preview mode). As mentioned in the team blog, there are a ton of use cases–

(Joe Chang) there is some degree of press hysteria, lawsuits etc. concerning the kernel vulnerabilities of Intel processors with out-of-order execution (which originates to Pentium Pro), so I did a quick check.

(Pinal Dave) While saving maintenance plan on my lab server, I encountered below error in SQL Server Management Studio. Let us see how to solve the error related to OLE DB Error.

(Kenneth Fisher) tl;dr: When using a windows or active directory authenticated id you do not put the username or password into your connection string.

(Jason Brimhall) We all probably use SQL Server Management Studio (SSMS) on a very frequent basis. Just for giggles, lets just say that means we use it at least once a day. I think it is safe to say, we have all been wanting to see something cool released for SSMS for a very long time.

(Greg Larsen) When you install a SQL Server instance you have the opportunity to identify the default location for your instance database backups. If you don’t change the default location for your installation your default backups location will be “C:Program FilesMicrosoft SQL ServerMSSQL13.MSSQ

(Siddharth Mehta) In the last tip, we learned how to perform trend analysis using Power BI Desktop. Different types of analysis like trends, forecasting, aggregation, etc. is done on data with the base assumption that data belongs to the same entity.