Always remain updated about current software development trends
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....
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 and quick to test. For that, attention to use-cases and the...
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 should focus some time, primarily in which queries were being...
Michael Sorens continues his series on Source Control with Subversion and TortoiseSVN by describing several ways one can use to share code among several projects.
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 monitoring tool to identify the bottlenecks, figure out...
The majority of companies that suffer a major data loss subsequently go out of business. Wesley David remembers vividly the day when the organisation he worked for found that they couldn't restore their data, and the subsequent struggles that ensued. Shoulda-woulda-coulda.
Many developers have argued persuasively that each database developer in a team needs to work as sole user of a dedicated database-development environment whilst creating or updating databases. I'm not so sure. Are we in danger of trying to change database...
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, selected database objects, or table contents from PowerShell and...
With database applications, the process of test and integration can be frustratingly slow because so much of it is based on manual processes. Everyone seems to agree that automation of the process provides the answer to accomodating shorter development cycles,...
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 within. This is fine, but can cause some odd problems, auch as...
Advertise
Here
Advertise
Here
c# asp.net .net intermediate dev windows sql silverlight beginner sql server advanced wpf architect c++ javascript mysql html5 tsql mobile c#4.0