Reorganize permissions in SQL Server 2005 step by step
Learn how to reorganize permissions in SQL Server 2005 in a multiple database environment.
2007-11-29
3,160 reads
Additional Articles
Data Points: Data Binding in WPF
With WPF, you can perform data manipulation using Microsoft® .NET Framework code, XAML, or a combination of both.
2007-11-28
2,077 reads
Too Simple, Too Soon
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
Enterprise Architecture – Connect-the-Dots for Adults, Part 3
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
SQL Server Connection Strings
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
Events in SharePoint 2007
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
Running totals in SQL Server queries
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
SQL Server 2005 Express Edition - Part 11 - ClickOnce Deployment and Maintenance Options
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
Reporting at the Top
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
Troubleshooting Performance Problems in SQL Server 2005
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
Blogs
Overcoming Imposter Syndrome: A Plan
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
Advice I Like: Celebrate Success
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Forums
Increase Deadlock Detection
Comments posted to this topic are about the item Increase Deadlock Detection
A Tool is Better than a Script
Comments posted to this topic are about the item A Tool is Better than...
Understanding Deadlock Victim Selection in SQL Server
Comments posted to this topic are about the item Understanding Deadlock Victim Selection in...
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers