ASP.NET News from Blogger:
Simple Talk
Total News: 900
When working with databases, the use of SQL Server Integration Services (SSIS) is a skill that often needs to be acquired quickly, from scratch. Up until now, it has been a curiously frustrating searc...
Prefetching can make a surprising difference to SQL Server query execution times where there is a high incidence of waiting for disk i/o operations, but the benefits come at a cost. Mostly, the Query ...
SQL Server AlwaysOn provides a high-availability and Disaster-recovery solution for SQL Server 2012. It makes use of existing SQL Server features, particularly Failover Clustering, and provides new ca...
the biggest new feature in C# 5 is Async, and its associated Await (contextual) keyword. Anybody who is faced with creating Metro applications for Windows 8 is having to tackle the very different min...
In this excerpt from his book Troubleshooting SQL Server: A Guide for the Accidental DBA, Jonathan Kehayias provides a guide to identifying the causes, reacting to, and ultimately preventing the dread...
SQL Views are essential for the database developer. However, it is common to see them misued, or neglected. Joe Celko tackles an introduction to the subject, but there is something about the topic th...
As well as running TSQL and PowerShell, the free SQL Scripts Manager tool can also run Python scripts. This allows even more sophisticated scripting possibilities for managing automated database tasks...
At RedGate Software, I work on a .NET obfuscator called SmartAssembly. Various features of it use a database to......
In this excerpt from his new book, Practical Performance Profiling: Improving the Efficiency of .NET Code, Jean-Phillipe Gouigoux discusses the Dispose mechanism and the finalization process in the c...
Generally, you will have no need to worry about the number of virtual log files in your transaction log. However, if you use the default settings for 'auto-grow', you can end up with such 'fragmentati...
Peldi is one of the most likeable of the new hybrid IT generation; part entrepreneur, part geek. Balsamiq is Peldi's creation, a tool for creating mockups of software. Balsamiq has shown what a good f...
Classes should have dependencies only on abstract, rather then concrete, clesses. To get around this, you can choose between Service Locator and Dependency Injection techniques. ASP.NET MVC uses 'Dep...
Excited about the new async/await feature in C# 5? Can't run your application on .NET 4.5 yet? Well that's......
Despite the neglect of the basic ODBC drivers over the years, they still afford a neat way of reading from, and writing to, CSV files; and to be able to do so in SQL as if they were tables is somewha...
Some types of development work are much more effectively accomplished if the developer can work directly on SQL Server Databases from Visual Studio, alongside the application code, rather than consta...
In this sample chapter from his book SQL Backup and Restore, Shawn McGehee discusses partial backups, how they're used, and how to avoid potential problems when restoring from a partial backup....
It is hard to categorize Josh Klein. Author, Technologist, Developer, Entrepreneur, polymath? He has participated in several startups, and is a popular speaker at conferences. He describes himself as ...
Since the announcement of Windows 8 and its 'Metro' interface, the .NET community has wondered if the skills they've......
MongoDB is one of the more intriguing 'NoSQL' databases to emerge from 'Cloud' computing. Sometimes, the best way of understanding a rather different technology is to get stuck-in and try it out, so J...
Before creating a data application in Windows Azure, it is important to make choices based on the type of data you have, as well as the security and the business requirements. There are a wide range o...
The 'bin packing' problem isn't just a fascination for computer scientists, but comes up in a whole range of real-world applications. It isn't that easy to come up with a practical, set oriented solu...
When you start an ASP.NET MVC project, you choose one of a number of project templates or starter kits. The ones that Visual Studio provide are very useful, but you can create your own if you want, an...
A combination of PowerShell and HTML can provide the basis of an easily-scanned report on the basic state of a whole group of servers. Sean combined a range of routine health-checks to provide himsel...
Is the performance boost from writing code that can fully exploit all available cores worth the cost of the additional programming complexity? Right now, with quad-core processors that, at best, can m...
Is it realistic to keep to principles of 'Test-First' and 100% coverage for unit tests when in the heat of developing commercial C# applications? Does rigorous unit-testing lead naturally to good desi...
After having converted a whole lot of training materials based on VB.NET into C#, Andy Wise Owl Brown decided to write a tongue-in-cheek rant whilst he could still remember the pain-points. 'Convert t...
A heartwarming tale of dogged perseverance and Community collaboration to solve some SQL Server string-related headaches....
If you are relying on using 'best-practice' percentage-based thresholds when you are creating an index maintenance plan for a SQL Server that checks the fragmentation in your pages, you may miss occ...
For some reason, Sharepoint developers haven't taken to PowerShell with the same enthusiasm as the DBAs and SysAdmins. Dave McMohan is a man on a mission to explain that PowerShell can provide plenty ...
You can automate .NET Reflector processes, and run .NET Reflector from within a .NET application, from within ASP.NET or even within ASP.NET MVC. What is more you can host a reflector Add-in. This ope...
Glenn Berry works as a Database Architect at Avalara in Bainbridge Island, Washington. He is a SQL Server MVP, and has a whole collection of Microsoft certifications, including MCITP, MCDBA, MCSE, MCS...
Under the pseudonym of 'SwePeso', Peter Larsson is famous on SQL forums for the amazing performance he can get from SQL. How does he do it? In the first of a series of articles, Peter explains his sec...
Sharepoint allows you to run recurring processes in background on a schedule. These are Timer Jobs. It is easy to get confused by the process of writing, scheduling, administering and updating timer ...
Phil, in a guest editorial for Simple-Talk, puzzles over the possibility that a SQL Server System table commits sins against relational theory. Maybe the answer isn't that simple.......
When you are using SSIS, there soon comes a time when you are confronted with having to do a tricky task such as searching for particular connection strings in all your SSIS packages, or checking the ...
The neat separation between processing and rendering in ASP.NET MVC guarantees you an application design that is inherently teastable. It doesn't guarantee that your application will be well-designed ...
In the last installment, I used the SQL Monitor tool to get a snapshot view of the current state of the servers at Red Gate that are giving us trouble. That snapshot suggested some areas where I shoul...
Everyone runs into performance issues at some point, even Red Gate software. Some of our internal systems were running into some serious bottlenecks. What if I were to, oh, I don't know, use a certain...
In the first of a series of articles on automating the process of building, modifying and copying SQL Server databases, Phil Factor demonstrates how one can generate TSQL scripts for databases, selec...
With the arrival of F# 3.0 Microsoft announced a wide range of improvements such as type providers that made F# a viable alternative to their other .NET languages as a general purpose workhorse. So ...
We all appreciate that, in general, XML documents or fragments are held in strings as text markup. In SQL Server, XML variables and columns are instead tokenised to allow rapid access to the data with...
The arrival of the (MAX) data types in SQL Server 2005 were one of the most popular feature for the database developer. At the time, there was a lot of discussion as to whether this freedom from havi...
Occasionally, when you install identical databases on two different SQL Server instances, they will behave in surprisingly different ways. Why? Most likely, it is down to different configuration setti...
If you just assume that your application's slowness is the fault of the database, then that is a quick route to a smug DBA if it later turns out youre wrong. Far better to know for sure how much of yo...
We're currently trying to build a service that lets developers silently update their application. We want desktop developers to enjoy all the same advantages as those who code for web. Desktop softwar...
At last, weve woken up to the worrying fact that there just arent enough good programmers to go around. Instead of aiming to get a generation of students interested in building their own software, edu...
Static code analysis is used a lot by application programmers, but there have been surprisingly few tools for SQL development that perform a function analogous to Resharper, dotTest, or CodeRush. Wou...
Chuck Moore is still the radical thinker of Information Technology, After an astonishing career designing languages (e.g. FORTH), browser-based computers, CAD systems and CPUs, he is now energetical...
One of the more popular counters used by DBAs to monitor SQL Server performance, the Buffer Cache Hit Ratio, is useless as a predictor of imminent performance problems. Worse, it can be misleading. Jo...
Developing a Sharepoint application would have all the fun of a video game, if only you had infinite lives. Dangers lurk hidden out there which, if you run into them, can be a blow to your project and...
View Other bloggers