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
Additional Articles
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
Featured Blog: CHECKDB From Every Angle: Can CHECKDB repair everything?
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
.NET Building Blocks: Build a Configurable Database Credential Selector
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
Enterprise Architecture: Connect-Dots for Adults, Part 2
This article, the second in a series, discusses what items could be contained in the enterprise architecture and touches briefly on how to organize the objects.
2007-11-20
2,301 reads
Declarative Management Framework - Performing Policy Management
The Declarative Management Framework is a new policy based management framework included with the upcoming SQL Server 2008. Using this feature administrators can define policies to govern their SQL Server environments much like in the Windows environment. This article, written based on the SQL Server "Katmai" July CTP introduces you to the DMF and shows you how you can perform policy management.
2007-11-19
2,087 reads
Blogs
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
When Your Microsoft Fabric Capacity Runs Out: Optimize, Scale Up, Scale Out, or Isolate?
By James Serra
Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform....
Forums
The New World Of AI Robots
Comments posted to this topic are about the item The New World Of AI...
Logic question in a WHERE clause using IIF?
Thanks in advance, I'm trying to avoid using IIF for performance reasons, but the...
Execute as failure
Security has long been a problem for me. Every time I think I understand...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers