Pivot Table
Used to convert rows to columns. Example 1: Example 2: Sources: https://builtin.com/articles/sql-pivot
Author
Sequence Container
The Sequence container defines a control flow that is a subset of the package control flow. Sequence containers group the package into multiple separate control flows, each containing one or more tasks and containers that run within the overall package control flow. The Sequence container can include multiple tasks in addition to other containers. Adding... » read more
Get Code From TortoiseSVN
To obtain a working copy you need to do a checkout from a repository. Select a directory in windows explorer where you want to place your working copy. Right click to pop up the context menu and select the command TortoiseSVN → Checkout…, which brings up a dialog box: URL: of repository: URL of repository folder. Checkout directory: Location of folder on... » read more
Transactional Replication vs Availability Groups
Transactional Replication Configuration is not that easy. Replication is always table level. Lot of maintenance work. There is a latency and latency may increase in busy system. Need to configure it for each table. Not a high availability option.You can use it as a DR strategy. AlwaysOn High Availability and Disaster recovery strategy.Built on top of Windows Failover Clustering... » read more
SQL Server AlwaysOn
SQL Server AlwaysOn provides a high-availability and Disaster-recovery solution for SQL Server. An availability group supports one set of primary databases and one to eight sets of corresponding secondary databases. Each set of availability database is hosted by an availability replica. Two types of availability replicas exist: a single primary replica. which hosts the primary databases, and one... » read more
Dimensions CM
https://www.microfocus.com/en-us/products/dimensions-cm/overview Change and configuration management that streamlines development to release faster Software change and configuration management for Agile development.
Unable to Remove FileGroup
Error: The filegroup ‘xxxxxx’ cannot be removed because it is not empty. Fix: Remember to remove the partition the filegroup belongs to.
Searching for Files in Windows File Explorer
Searching for files in Windows File Explorer *text All files ending with text.
Dymo – Print Multiple Labels
Sources:
Dymo – Print from ASP.NET
The following only works if you are able to install Dymo SDK the server. Otherwise, you have to use the Javascript way.