06 2021 档案
摘要:Cookie Category Cookie category definition (noun) A cookie category is a set of cookies defined by their function. Cookie categories may include perfo
阅读全文
摘要:cannot apply the specified columns kentico Pagination in union query of two page type The error has 2 specific messages in it: [SqlHelper.ReplaceColum
阅读全文
摘要:System.NotSupportedException: [DataTypeManager.GetFieldType]: SQL type 'datetimeoffset' is not registered, register the type with method RegisterDataT
阅读全文
摘要:How .NET Standard work A little journey under the hood of .NET Standard implementation If you deal with Microsoft technologies you’ve probably heard a
阅读全文
摘要:Deleting 1 millions rows in SQL Server I am working on a client's database and there is about 1 million rows that need to be deleted due to a bug in t
阅读全文
摘要:Get size of all tables in database 回答1 SELECT t.NAME AS TableName, s.Name AS SchemaName, p.rows, SUM(a.total_pages) * 8 AS TotalSpaceKB, CAST(ROUND(((
阅读全文
摘要:Unable to load DLL 'Microsoft.Data.SqlClient.SNI.x64.dll' Take a look at the following two references: Unable to load native SNI (Server Name Indicati
阅读全文
摘要:What is the difference between SqlCommand.CommandTimeout and SqlConnection.ConnectionTimeout? Is there any difference between SqlCommand.CommandTimeou
阅读全文
摘要:Reference Microsoft.SqlServer.Smo.dll I need to use Server class which is stored in Microsoft.SqlServer.Smo.dll I don't see this assembly in usual Ref
阅读全文
摘要:Execute a large SQL script (with GO commands) I need to execute a large set of SQL statements (creating a bunch of tables, views and stored procedures
阅读全文
摘要:For SameSite cookie with subdomains what are considered the same site? For the samesite cookie attribute I'm not clear on if I set a cookie with domai
阅读全文
摘要:How to handle multiple cookies with the same name? Say for example I had an application sending the following HTTP headers to set to cookie named "a":
阅读全文
摘要:How can I show the table structure in SQL Server query? 回答1 For SQL Server, if using a newer version, you can use select * from INFORMATION_SCHEMA.COL
阅读全文
摘要:SQL Server Cursor Explained By Examples Summary: in this tutorial, you will learn how to use the SQL Server cursor to process a result set, one row at
阅读全文
摘要:SQL Server Cursor – When (Not) to use them? I’ll try to give an objective answer to the question – “When you should use SQL Server cursors and when no
阅读全文
摘要:Automate SQL database backups using Maintenance Plans In this article, we are going to learn how we can automate the backup of the SQL database using
阅读全文
摘要:Error Message – The index ” is dependent on column ”.ALTER TABLE ALTER COLUMN ” failed because one or more objects access this column. It is always an
阅读全文
摘要:What is a host only cookie? First of all, it is not possible for foo.com to set a cookie that can be read by bar.com. Host-only only protects example.
阅读全文
摘要:ASP.NET MVC Interview Questions with Answers The whole purpose of this article is to quickly brush up your MVC knowledge from ASP.NET MVC interview pe
阅读全文
摘要:ASP.Net MVC cookies - tamper resistant? Simply set the forms authentication protection method to Encryption and validation. This will protect against
阅读全文
摘要:How To: Configure MachineKey in ASP.NET 2.0 Summary This How To explains the <machineKey> element in the Web.config file and shows how to configure th
阅读全文
摘要:Is EnableViewStateMAC=true compulsory for ViewStateEncryption in an ASP.Net Website? 问题 I'm currently fixing some Security issues in our ASP.net websi
阅读全文
摘要:Uses for MachineKey in ASP.NET 回答1 MachineKey is used for: ViewState encryption and validation Forms Authentication (or Federated Authentication) uses
阅读全文
摘要:5月底更新后桌面右下角出现的新闻资讯怎么删除? 英文版的是News and interests
阅读全文
摘要:Generate self-signed certificates You can use PowerShell to generate self-signed certificates. The PKI Client can be used to generate a self-signed ce
阅读全文
摘要:A Walkthrough of SQL Schema This article gives an overview of SQL Schema and its usage in SQL Server. Introduction to Schema A SQL database contains m
阅读全文
摘要:一个organization下有多个projects,一个project下有多个repositories 在这个链接添加用户,附带Basic权限 https://dev.azure.com/[organization name]/_settings/users 邀请用户加入project https
阅读全文
摘要:Implementing Domain Driven Design A practical guide for implementing the Domain Driven Design with the ABP Framework. OVERVIEW This is a practical gui
阅读全文
摘要:How to Upgrade VMware Workstation Pro v15.5 to v16 https://my.vmware.com/en/web/vmware/downloads/info/slug/desktop_end_user_computing/vmware_workstati
阅读全文
摘要:API Changes in Kentico 8 Martin Hejtmanek — Apr 16, 2014 Provider API changed to DataQuery I mentioned this as well as what DataQuery is in my previou
阅读全文
摘要:How to use git commands after enable gitlab's second-factor authentication As explained in using gitlab token to clone without authentication, you can
阅读全文
摘要:遇到的问题,property的get有逻辑,然后DataMember给了field 这种情况,应该把DataMember给property,可以确保触发get的逻辑 WCF: DataMember attribute on property vs. member In general, you sh
阅读全文
摘要:Why does the C# DataMember attribute allow serialization of private fields and properties? Isn't the principle of self-encapsulation much more fundame
阅读全文
摘要:27.甲、乙两书架各有若干本书. 如果从乙架5本书放到甲架上,那么此时甲架上的书是乙架上剩余的书5倍; 如果从甲架拿5本书放到乙架上,那么此时甲架上剩余的书是之架上的书的3倍, 问原来甲架、乙架各有书多少本? 解答: 假设甲架有书x本,乙架有书y本。 根据题干,可以列出下面2个等式 等式1 x+5=
阅读全文
摘要:Retargeting All Projects in a Solution to .NET 4.5.2 The MSDN documentation "Migration Guide to the .NET Framework 4.5" and "How to Configure an App t
阅读全文
摘要:IIS Tunning Recommendations against Slow http Attacks If an HTTP request is not complete, or if the transfer rate is very low, the server keeps its re
阅读全文
摘要:How to fix: Conversion failure. Could not find ‘Select.Html.dep’. (Updated in December 2016). SelectPdf Html To Pdf Converter needs 2 files to work. T
阅读全文
摘要:What is the difference between CORS and CSPs? 问题 From my perspective, the technologies referred to as Cross-Origin Resource Sharing (CORS) and Content
阅读全文
摘要:Security headers quick reference Learn more about headers that can keep your site safe and quickly look up the most important details. This article li
阅读全文
摘要:Missing dollar riddle The missing dollar riddle is a famous riddle that involves an informal fallacy. It is old, dating back to at least the 1930s, al
阅读全文
摘要:Where Did the Other Dollar Go, Jeff? 多出来的一美元 三名游客来到一家旅馆,经理告诉他们,三人间的价格是30美元。游客每人掏出10美元,入住了房间。 第二天退房时,经理意识到,这间客房的定价应该是25美元,便要求服务员将多收的5美元退还给客人。服务员不诚实,仅向每
阅读全文
摘要:http://www.ruanyifeng.com/blog/2021/06/weekly-issue-161.html CAP 定理解读(英文) 这篇文章从学术角度,详细解读分布式系统的 CAP 定理,写得很好。CAP 定理的核心含义就是,发生故障时,开发者必须选择,优先满足一致性还是可用性。 Y
阅读全文
摘要:cookie默认的生命周期,是跟着session走的。session结束了,cookie也就被自动清除了。不过可以设置cookie的过期时间来避免自动清除 Cookies are deleted when I close the browser? The default cookie lifetim
阅读全文
摘要:Using more than one index per table is dangerous? 问题 In a former company I worked at, the rule of thumb was that a table should have no more than one
阅读全文
摘要:Multiple Indexes vs Multi-Column Indexes 问题 I've just been adding an Index to a table in SQL Server 2005 and it got me thinking. What is the differenc
阅读全文
摘要:SQL Server Index Naming Conventions [closed] 回答1 I use PK_ for primary keys UK_ for unique keys IX_ for non clustered non unique indexes UX_ for uniqu
阅读全文
摘要:What's different between INTERSECT and JOIN? 1.INTERSECT just compares 2 sets and picks only distinct equivalent values from both sets. It's important
阅读全文
摘要:Does EXCEPT execute faster than a JOIN when the table columns are the same To find all the changes between two databases, I am left joining the tables
阅读全文
摘要:Bad habits : Putting NOLOCK everywhere [See an index of all bad habits / best practices posts] I went through the archive above, and was quite surpris
阅读全文
摘要:Understanding the Impact of NOLOCK and WITH NOLOCK Table Hints in SQL Server Every once in a while, SQL Server database administrators find themselves
阅读全文
摘要:with(nolock) or (nolock) - Is there a difference? Everything is based on the assumption that with(nolock) is entirely appropriate for the situtation.
阅读全文
摘要:What is “with (nolock)” in SQL Server? Can someone explain the implications of using with (nolock) on queries, when you should/shouldn't use it? For e
阅读全文