Tori Aubé, Author at Virtual-DBA Remote DBA Services & Support - Certified Database Experts

End of Support for SharePoint Workflows 2010 on SharePoint Online

Tori Aubé — Thu, 01 Oct 2020 20:26:47 +0000

It feels like we have to deal with the compounding disruption of innovation on a yearly basis as software companies evaluate their product line, advancing some business solutions while retiring others. As with every other software vendor, the Microsoft 365 product line continues to expand and progress through modern demand, and for SharePoint Online 2010 […]

The post End of Support for SharePoint Workflows 2010 on SharePoint Online appeared first on Virtual-DBA Remote DBA Services & Support - Certified Database Experts.

SQL Server Collation

Tori Aubé — Thu, 14 Jun 2018 16:57:38 +0000

What is Collation? Collation is a set of rules dictating how each group of characters within SQL Server is treated. A list of collations and their definitions can be found using the following query. SELECT name, description FROM sys.fn_helpcollations() WHERE COLLATIONPROPERTY(name, 'CodePage') = 0; There are two types of collations which will appear in the […]

The post SQL Server Collation appeared first on Virtual-DBA Remote DBA Services & Support - Certified Database Experts.

SQL Server Statistics

Tori Aubé — Tue, 05 Dec 2017 17:00:21 +0000

What are Statistics? Statistics are exactly what the name implies. They are statistical information about the distribution and/or correlation of data in the first specified column of indexes or tables in the form of a histogram. Histograms measure the frequency of which a value occurs within a data set. There are two types of statistical […]

The post SQL Server Statistics appeared first on Virtual-DBA Remote DBA Services & Support - Certified Database Experts.

How to Set SSIS Package ‘Connection Timeout’ to Unlimited

Tori Aubé — Thu, 23 Mar 2017 13:00:24 +0000

SUMMARY: When configuring an SSIS OLE DB connection in Microsoft Visual Studio 2015 fails to correctly register the ‘Connect Timeout’ setting of 0 (unlimited), administrators must utilize specific workarounds—either within the Connection Manager or through an XML configuration file—to prevent persistent network-related “Login timeout expired” errors during execution. Despite the utility of these methods for […]

The post How to Set SSIS Package ‘Connection Timeout’ to Unlimited appeared first on Virtual-DBA Remote DBA Services & Support - Certified Database Experts.