はてなブックマーク

https://www.red-gate.com/simple-talk/development/dotnet-development/entity-framework-performance-and-what-you-can-do-about-it/ Compared to writing your own SQL to access data, you can become miraculously more productive by using Entity Framework (EF). Unfortunately, several traps that are easy to fall into have given it a reputation for performing poorly; but it doesn’t have to be this way! The pe

https://www.red-gate.com/simple-talk/databases/sql-server/database-administration-sql-server/five-online-database-modelling-services/ Advances in web-based technologies, particularly HTML5, have made online data modeling a more credible option than ever. Tools have emerged that make it easy and efficient to design a database and generate the SQL code for a specific database product, offering a via

A List object’s underlying implementation is an array and when it needs to grow, .NET allocates a new, larger array and throws the old one away. All that’s needed to start to cause problems with fragmentation is to put some other object on the LOH before the array needs to grow. The main effect here is that you might be surprised how small the size is that your ‘large’ list can grow to before .NET

https://www.red-gate.com/simple-talk/development/dotnet-development/asp-net-4-0-features/ The focus of Microsoft’s latest ASP.NET 4has mainly been on improving the performance and Search-engine Optimization (SEO). In this article, I’ll be taking a look at what I think are the most important new features in ASP.NET 4. Output cache extensibility Session state compression View state mode for individu

https://www.red-gate.com/simple-talk/development/dotnet-development/using-sass-and-compass-in-asp-net-mvc-with-web-workbench/ SASS and Compass have become a mainstream alternative to writing standard CSS code. However since SASS and Compass are a relatively new, open source, superset of the CSS language there is no native support in Visual Studio. Through the use of a third party tool, Web Workben

Get the latest Opinion, Podcasts, Webinars, and Events, delivered straight to your inbox. Register Log in They had gone quiet, with pretty much all discussion happening on articles, so they’ve been quietly discontinued. We recommend our sister site SQLServerCentral.com, which has a thriving community of experts and enthusiasts, and a Q&A site for SQL questions.

ProtectReliable test data management, automating repetition out of the process

https://www.red-gate.com/simple-talk/development/dotnet-development/xpath-css-dom-and-selenium-the-rosetta-stone/ A little learning is a dangerous thing.” [Alexander Pope, An Essay on Criticism] Have you absorbed some knowledge of XPath or CSS or DOM, and tried to put it to use, and then realized that you do not know all the right incantations? Curiously, these three technologies are all designed

Introduction In the previous article I introduced the concept of extensibility, and described where ASP.NET MVC can be extended: With this article I’ll be starting a guided tour around these extensibility points, beginning with the first ones that are encountered when a request hits the application: the routing module. Before I demonstrate how to extend the routing module, let’s quickly review the

https://www.red-gate.com/simple-talk/databases/sql-server/t-sql-programming-sql-server/consuming-json-strings-in-sql-server/ “The best thing about XML is what it shares with JSON, being human readable. That turns out to be important, not because people should be reading it, because we shouldn’t, but because it avoids interoperability problems caused by fussy binary encoding issues. Beyond that, th

https://www.red-gate.com/simple-talk/development/dotnet-development/an-introduction-to-asp-net-mvc-extensibility/ If you are not extending, you are not doing it right: this is the main tenet that you must keep in mind while developing web applications with ASP.NET MVC. I admit this is a strong statement, but over the next few months I’m going to explain why extending is the right way to develop wi

https://www.red-gate.com/simple-talk/databases/sql-server/database-administration-sql-server/gathering-perfmon-data-with-powershell/ I was reading an excellent article by Allen White (Twitter|Blog) on Performance Data Gathering (to which I give all the credit for inspiring this module), and that’s when a PowerShell apple fell on my head: “Why not make a function that facilitates this?” As a DBA, o

Get the latest Opinion, Podcasts, Webinars, and Events, delivered straight to your inbox. Register Log in Joe Celko is one of the most widely read of all writers about SQL, and was the winner of the DBMS Magazine Reader's Choice Award four consecutive years. He is an independent consultant living in Austin, TX. He has taught SQL in the US, UK, the Nordic countries, South America and Africa. He ser

Get the latest Opinion, Podcasts, Webinars, and Events, delivered straight to your inbox. Register Log in According to the combined wisdom of the online pundits, Rich Hickey, the creator of Clojure, is set to become one of the most influential figures in technology within the next few years. “I think programmers have become inured to incidental complexity… when they encounter complexity, they cons

Get the latest Opinion, Podcasts, Webinars, and Events, delivered straight to your inbox. Register Log in It is often said that entrepreneurial companies tend to reflect the personality of their founder, and nowhere was this more true than at Microsoft. Bill Gates was by turns very brilliant, very arrogant, a master marketer, a win-at-any-cost competitor – and so was his company. A lot of people h

Get the latest Opinion, Podcasts, Webinars, and Events, delivered straight to your inbox. Register Log in “Thinking that file locking is a feature is just a sign that you haven’t been taking your medication lately.” From 1991 until 2002, the Linux kernel source was passed around as patches or archived files, and there was no formal source control system, mainly because of the difficulties caused b

Redgate Test Data ManagerImprove your release quality and reduce your risk, with the flexibility to fit your workflow

https://www.red-gate.com/simple-talk/databases/sql-server/database-administration-sql-server/ten-common-database-design-mistakes/ No list of mistakes is ever going to be exhaustive. People (myself included) do a lot of really stupid things, at times, in the name of “getting it done.” This list simply reflects the database design mistakes that are currently on my mind, or in some cases, constantly