Tag: Microsoft SQL Server

How to Configure an Azure Point-to-Site VPN – Part 3

This blog post is the last of this series and which will demonstrate how to configure a Point-to-Site VPN step-by-step. In my first blog post, I demonstrated how to configure a virtual network and a dynamic routing gateway. This was followed…

Read More >

SQL Server Replication Quick Tips

There is a time in every SQL Server DBA career where a mail came in with a “replication is not working, please check” message. This article is intended to provide with quick tips on how to handle common replication errors…

Read More >

Microsoft PowerBI: News from WPC

During the Worldwide Partner Conference (WPC) that happened last month, Microsoft made public some of the new functionalities that we can expect to see soon on Microsoft PowerBI. If you were on another planet in the last few months, and…

Read More >

SSAS Database Doesn’t Show Up in SharePoint 2013 Dashboard Designer

Howdy everyone, Just a quick tip for everyone that is struggling to configure SharePoint Server 2013 PerformancePoint  to connect to a SQL Analysis Services 2012 or 2014 cube. After a new SharePoint Server 2013 installation, I have tried to create…

Read More >

SQL Server Error: 18056, Severity: 20, State: 29

Howdy everyone, One of the most frequent error messages I come across when dealing with SQL Server, particularly SQL Server 2008 R2, is Error 18056, Severity: 20, State: 29. Not only do I constantly see this error message in the SQL logs,…

Read More >

On the Road with Laerte

For the month of October, Microsoft PowerShell MVP, Laerte Junior will be touring Brazil and Europe for various SQL Server-related speaking engagements. “Thankfully, I am working at a company that fully supports their employees to speak and participate in community…

Read More >

How to Configure an Azure Point-to-Site VPN – Part 2

This blog post is the second in a series of three which will demonstrate how to configure a Point-to-Site VPN step-by-step. In my first blog post, I demonstrated how to configure a virtual network and a dynamic routing gateway. Today’s…

Read More >

How to Configure an Azure Point-to-Site VPN – Part 1

This blog post is the first in a series of three which will demonstrate how to configure a Point-to-Site VPN step-by-step. Today’s post will teach you how to configure a virtual network and a dynamic routing gateway, and the following…

Read More >

SQL Server and OS Error 1117, Error 9001, Error 823

Along with other administrators, life of us, the DBAs are no different but full of adventure.  At times, we encounter an issue which is very new for us, rather, one that we have not faced in the past.  Today, I…

Read More >

Interesting Behavior of MaxCmdsInTran Parameter

I recently worked on transactional replication issue and discovered interesting behavior of the log reader agent switch called MaxCmdsInTran and wanted to share it with you guys. Lets take a look at  the use of this switch by looking at the msdn documentation…

Read More >
Page 5 of 51« First Page...34567...10...Last Page »