サクサク読めて、アプリ限定の機能も多数!
トップへ戻る
都知事選
www.red-gate.com
I’ve quietly resolved performance issues by re-writing slow queries to avoid DISTINCT. Often, the DISTINCT is there only to serve as a “join-fixer,” and I can explain what that means using an example. Let’s say we have the following grossly simplified schema, representing customers, products, and product categories:
Without a doubt, Entity Framework is a quick and satisfactory way of producing a database-driven web application. As performance becomes more important, it does, however, require some knowledge of the traps that you need to avoid, and of the wrinkles that impact performance. Ben Emmett gives a practical guide. Compared to writing your own SQL to access data, you can become miraculously more produc
To design, or redesign, a database of any complexity, the Entity-Relationship modelling tool becomes essential. The specialized tools that have dominated the industry for a long while are expensive and are installed on a workstation. Now that browser technology has progressed so rapidly, the online database modelling tools have become viable and are starting to attract the attention of database de
You'd have thought that memory leaks were a thing of the past now that we use .NET. True, but we can still hit problems. We can, for example, prevent memory from being recycled if we inadvertently hold references to objects that we are no longer using. However, there is another serious memory problem in .NET that can happen out of the blue, especially if you are using large object arrays. Andrew H
ASP.NET v4 is released with Visual studio 2010. Web developers are presented with a bewildering range of new features and so Ludmal De Silva has described what he considers to be the most important new features in ASP.NET V4 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 th
The Designers of CSS never envisaged the demands that we make of styles. However, preprocessors such as SASS can provide the obvious missing features such as constants, selector inheritence and nesting. Compass can in turn use SASS to provide a simple browser-independent way of expressing complex layout. SASS and Compass have become a mainstream alternative to writing standard CSS code. However si
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. Subscribe for more articles Fortnightly newsletters help sharpen your skills and keep you ahead, with articles, ebooks and opinion to keep you
Some programming conventions are best represented in a chart. Nobody will claim that XPath or CSS are entirely intuitive, as they are terse, economical ways of identifying elements in a hierarchy. However, a chart with recipes and examples is a different matter. Suddenly, apps like Selenium IDE are made easier. A little learning is a dangerous thing.” [Alexander Pope, An Essay on Criticism] Have y
You develop an ASP.NET MVC application by extending it; customising any default logic that you wish to change with your own implementation. Simone starts a tour of the extensibility points of ASP.NET MVC, by looking at the beginning of the pipeline, the Routing Module, and gives a practical example of writing an extension, with source code: a way of 'watermaking' images 'on the fly'. Introduction
It has always seemed strange to Phil that SQL Server has such complete support for XML, yet is completely devoid of any support for JSON. In the end, he was forced, by a website project, into doing something about it. The result is this article, an iconoclastic romp around the representation of hierarchical structures, and some code to get you started. “The best thing about XML is what it shares w
Because ASP.NET MVC has been designed with extensibility as its design principle; almost every logical step of the processing pipeline can be replaced with your own implementation. In fact, the best way to develop applications with ASP.NET MVC is to extend the system, Simone starts a series that explains how to implement extensions to ASP.NET MVC, starting with the ones at the beginning of the pip
Redgate Test Data ManagerImprove your release quality and reduce your risk, with the flexibility to fit your workflow
Virtualization is a powerful technology, but it comes with its own host of monotonous and time-consuming tasks, no matter how big or small your organization is. Eliminating these mind-numbing tasks (and the potential for error which they bring with them) is a goal with striving for, and well within your reach. Jonathan Medd explains. Virtualised environments can range pretty wildly in size; from o
When you have to routinely collect data from Performance Monitor Counters, it soon becomes easier and more convenient to use PowerShell. SQL Server MVP Laerte Junior was inspired to create a script, and guides us through its useful functions. 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), an
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 served 10 years on ANSI/ISO SQL Standards Committee and contributed to the SQL-89 and SQL-92 Standards. He ha
With Clojure soon to be ported to the .NET framework, as ClojureCLR, we felt that the time had come to see what the fuss was all about amongst the Java Geeks. We sent Richard Morris to find out from the creator of Clojure, Rich Hickey. 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 with
Donald Knuth is an extraordinary man. As well as inventing 'Literate Programming' and writing the most important textbook on programming algorithms, he is also famous for designing and programming one of the most widely-used digital typesetting systems ever, even designing the fonts that went with it. He also pioneered the use of 'Open-source' software. Knuth is a man of engaging charm and enthusi
Serverless authentication methods refer to approaches for managing user identity and access without the need for traditional server-based authentication systems. Instead of relying on a dedicated server, authentication tasks are outsourced to cloud-based services or specialized third-party providers. This allows developers to focus on application logic while leveraging secure, scalable, and often
For Windows programmers, Linus Torvalds work has suddenly become relevant. No, we don't mean Linux, but Git. This distributed Source Control system now works sweetly as a nut on Windows. We contacted Linus for a second interview; this time to talk mainly about Git, but also to catch up with his thoughts about computer languages. “Thinking that file locking is a feature is just a sign that you have
An introduction to SQL Log RescueLog analysis and undo for SQL Server 2000SQL Log Rescue is a log analysis tool which lets you explore your logs to view information on database transactions. If you have accidentally deleted, inserted, or modified your data, SQL Log Rescue will help you put things right. SQL Log Rescue protects your data in the event of mistakes or accidents, recovering dropped tab
If database design is done right, then the development, deployment and subsequent performance in production will give little trouble. A well-designed database 'just works'. There are a small number of mistakes in database design that causes subsequent misery to developers, managewrs, and DBAs alike. Here are the ten worst mistakes No list of mistakes is ever going to be exhaustive. People (myself
A Personal Perspective on the Responsibilities of a Cancer-surviving Software Developer My family has a genetic predisposition towards cancers of all sorts. My father died of cancer in 1975. At home, of course, we talked about what was going on in some detail. However, my father did not feel able to inform his employers of his condition, and I would not be surprised if only one or two close friend
このページを最初にブックマークしてみませんか?
『Redgate Software - End-to-end Database DevOps Solutions and Tools For SQL Ser...』の新着エントリーを見る
j次のブックマーク
k前のブックマーク
lあとで読む
eコメント一覧を開く
oページを開く