.NETADO.NETAgileAngularArchitectureASP.NETAuthenticationAzureAzure FunctionBIBig DataBlazorBusinessC#Cloud ServiceCosmosDBCSSDebuggingDesignEncryptionEntity FrameworkFYIGoogleHardwareInternetInterviewsJavascriptjQueryLeadershipLINQManagementMicrosoftMobileMS OfficeMS SQLNetworkingNoSQLOOPProject ManagementSoftware DevelopmentSource ControlSSISSSRSSyncfusionTeamTestingTSQLUncategorizedVendor SoftwareVisual StudioWebWeb ServicesWindowsWordPress
Error: OLE DB provider “SQLNCLI11” for linked server “xxxxx” returned message “Unspecified error”. Msg 40515, Level 16, State 2, Line 1 Reference to database and/or server name in ‘xxxxx.sys.sp_tables_info_90_rowset_64’ is not supported in this version of SQL Server. Fix: Create linked server to SQL Azure Database using script. Sources: http://yasqlsb.blogspot.com/2014/07/sql-azure-linked-servers.html
An index is a copy of information from a table that speeds up retrieval of rows from the table or view. Two main characteristics of an index are: Smaller than a table – this allows SQL Server to search the index more quickly, so when a query hits a particular column in our table and if... » read more
Yes, I spelled that correctly. NUL not NULL. NUL is basically a location you can send a backup to. In fact, one of the awesome bonuses of this location is that your backup will take up exactly 0 bytes of space. You got it, absolutely none! Now before you get too excited (and some of you did didn’t... » read more
Even if you’re not writing to different physical drives, you can get faster backups with Microsoft SQL Server when you back up to multiple files. Your exact numbers are going to vary based on your server. Test round 1:Backing up to multiple files on one volume In this test, the backup files were on one... » read more
3 Projects Created MyApp.Client – wwwroot, Pages MyApp.Server – Controller MyApp.Shared – Shared Classes Program.cs File Entry point Main() Pages Folder xxxxx.razor The Pages folder contains components/pages that can be routed and form the Blazor application. The route for each page is determined using the @page directive. Component has a .razor extension. Startup.cs File ConfigureServices() Configure()... » read more
Blazor Vs. Angular Both technology have some great features to attract developers to build their applications on it. But both technologies have some limitations also that make a big difference to decide which technology is used for development. We look at with the help of the difference table Feature Angular Blazor Type Framework Framework Release... » read more
IndexedDB is a way for you to persistently store data inside a user’s browser. Because it lets you create web applications with rich query abilities regardless of network availability, these applications can work both online and offline. IndexedDB is useful for applications that store a large amount of data (for example, a catalog of DVDs in... » read more
Problem: User create SQL Account on local database. Unable to connect using SQL Account. Fix: Make sure “SQL Server and Windows Authentication mode” is selected in Server Properties of SQL Server. Restart database server.