The author explains an application development approach advocated by many proponents of agile application development that can cause future problems for developers, while potentially sacrificing the integrity and reusability of the data.
2007-11-28
3,689 reads
This article, the third in a series on enterprise architecture, discusses the approaches to developing an enterprise architecture, describing the methods, benefits and pitfalls of each.
2007-11-26
2,140 reads
Some common and not so common connection strings for the .NET SqlConnection object. The article includes .NET sample code and some tricks to increase the supportability of your application.
2007-11-26
6,938 reads
Windows® SharePoint® Services (WSS) 3.0 offers developers many significant improvements for building custom business solutions based on SharePoint sites. One of the biggest developer-focused enhancements has to do with a new infrastructure for handling server-side events.
2007-11-23
3,783 reads
How often do you need to keep a total of all previous rows values when you run a query? This article shows you how you can achieve this.
2007-11-23 (first published: 2006-11-23)
7,074 reads
Part 11 of the series focuses on the process of deploying and maintaining user instance-based applications that employ ClickOnce technology.
2007-11-23
2,037 reads
Often, when developing reports in Reporting Services (SSRS), one has to mix summary information with the details. In Reporting Services, It is not difficult to provide flexible grouping and to display the detail records in a drill-down on-demand method.
2007-11-22
2,369 reads
It is not uncommon to experience the occasional slow down of a SQL Server database. A poorly designed database or a system that is improperly configured for the workload are but several of many possible causes of this type of performance problem.
2007-11-22
4,690 reads
What can't be fixed by CHECKDB? Read this great entry from the former SQL Server Storage Engine lead.
2007-11-21
2,282 reads
This handy control gives you everything you need to control how users input usernames, passwords, select servers, and choose connection types.
2007-11-20
4,108 reads
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
By Steve Jones
I was trolling the docs and noticed the SIGN() function. I have never written...
By ReviewMyDB
The T-SQL Tuesday #201 round-up: nine bloggers on whether temp tables are a friend...
Comments posted to this topic are about the item Admin Rights for Everyone
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
Comments posted to this topic are about the item RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers