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.
.NETADO.NETAgileAngularArchitectureASP.NETAuthenticationAzureAzure FunctionBIBig DataBlazorBusinessC#Cloud ServiceCosmosDBCSSDebuggingDesignEncryptionEntity FrameworkFYIGoogleHardwareInternetInterviewsJavascriptjQueryLeadershipLINQManagementMicrosoftMobileMS OfficeMS SQLNetworkingNoSQLOOPProject ManagementSoftware DevelopmentSource ControlSSISSSRSSyncfusionTeamTestingTSQLUncategorizedVendor SoftwareVisual StudioWebWeb ServicesWindowsWordPress
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.
DymoAddInClass – Set Label Template
Setting Label Template for Dymo printers. using Dymo; private DymoAddInClass _dymoAddin = new DymoAddInClass(); dymoAddin.OpenURL("https://account01.blob.core.windows.net/label01.label") dymoAddin.Open(System.IO.Path.Combine(System.IO.Directory.GetCurrentDirectory(), @"C:\Label01.label")); labelFileNamelbl.Text = _dymoAddin.FileName; Sources: http://developers.dymo.com/tag/dls-sdk/
How to save CSV file as UTF-8 with Notepad
The steps are as given below: Open the CSV file with Notepad. Navigate to File > Save As option. A screenshot of the menu is as shown below:Notepad File Menu Next, select the location to the file. The Save As window appears as shown below:Save As option in Notepad Select the Save as type option as All Files(*.*). Specify the file name with .csv extension. From Encoding drop-down list, select UTF-8 option.... » read more
Convert DataTable to CSV Download
private void WriteDelimitedData(DataTable dt, string fileName, string delimiter) { //prepare the output stream Response.Clear(); Response.ContentType = "text/csv"; Response.AppendHeader("Content-Disposition", string.Format("attachment; filename={0}", fileName)); Response.ContentEncoding = System.Text.Encoding.UTF8; //write the csv column headers for (int i = 0; i < dt.Columns.Count; i++) { Response.Write(dt.Columns[i].ColumnName); Response.Write((i < dt.Columns.Count - 1) ? delimiter : Environment.NewLine); } //write the data foreach (DataRow... » read more
VisualSVN Server
VisualSVN Server allows you to easily install and manage a fully-functional Subversion server on the Windows platform. Thanks to its robustness, unbeatable usability and unique enterprise-grade features, VisualSVN Server is useful both for small business and corporate users. https://www.visualsvn.com/server/
ALLOW_PAGE_LOCKS
ALLOW_PAGE_LOCKS = { ON | OFF }Applies to: SQL Server 2008 through SQL Server 2017. Specifies whether page locks are allowed. The default is ON. ONPage locks are allowed when accessing the index. The Database Engine determines when page locks are used. OFFPage locks are not used.
ALLOW_ROW_LOCKS
ALLOW_ROW_LOCKS = { ON | OFF }Applies to: SQL Server 2008 through SQL Server 2017. Specifies whether row locks are allowed. The default is ON. ONRow locks are allowed when accessing the index. The Database Engine determines when row locks are used. OFFRow locks are not used.