Do you use identity values? Do missing values ever cause problems? Maybe you need to look for missing invoices? Stephen Lasham brings us a technique for finding those missing values in a sequence.
2006-04-03
14,791 reads
In this article I will show you how you can implement security on a WCF service. There are many options and extensibility points for implementing security in WCF. You can also use specific products, such as the Windows 2003 Server Authorization Manager, together with WCF to implement the authorization requirements of a solution. Out of the box, WCF supports Windows credentials, Username Tokens and X.509 Digital Certificates as security credentials.
2006-04-03
1,557 reads
Performance tuning is an ongoing battle in SQL Server, but having a little knowledge up front when designing an application can greatly reduce the efforts. Do you know which performs better: stored procedures or triggers? There aren't many places where the two are interchangeable, but knowing the impacts of each might change the way you build an application. Read about this analysis by Vijaya Kumar.
2006-03-31 (first published: 2004-08-30)
40,408 reads
InfoPath forms can be saved to XML, these XML Files can later be used in SSIS XMLSource adapter to pull out the data in tables and columns. However, there are some common problems you may meet in these scenarios. This article describes how to work around these potential problems. The issues mentioned in this article is not only specific to InfoPath files, it can also be referenced in other similar situations as well.
2006-03-31
1,878 reads
It is something you do rarely, but with SQL Server 2005 and ten services, there are more decisions to make. Steve Jones gives some advice on which service accounts to choose and some common problems with others.
2006-03-30
18,814 reads
Most of the time, it's the simplest tools that have the biggest impact on our lives. If you have a camera and believe, like Leonardo DaVinci, that simplicity is the ultimate sophistication, then why not enter Red Gate's Ingeniously Simple Tools photo competition...
To enter is simple. All you need to do is send us a photo of your favorite, simple tool.
2006-03-30
1,803 reads
One of our expert authors has written some encryption tools for the community to use. However as he readies an extensive series, he's looking for some testers that want to work with encryption on the SQL Server 2000 servers.
2006-03-29
8,391 reads
There are many changes in SQL Server 2005, especially for the SQL Server developer. New options, features, and changes in the way you program. New author M. Choirul Amri brings us the first in a series on the changes from the point of the developer.
2006-03-29
13,997 reads
Doug Reilly gives his personal perspective on the responsibilities of a cancer-surviving software developer.
2006-03-29
2,420 reads
One of our community is working on a thesis for his graduate degree on the effects of outsourcing on knowledge transfer among software engineers. He's got an anonymous survey setup, so if you have a few minutes, lend a helping hand.
2006-03-28
2,692 reads
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
You can find the slides and SQL scripts for my session “Spice up your...
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Wa:082374977784 Ruko Mayor Oking Blok B. 1, Jl. Mayor Oking No. 35, RT 002/001,...
Wa:082374977784 Komp. Bojong Indah Cengkareng, Jl. Pakis Raya No.88 H, RT.9/RW.6, Rw. Buaya, Kecamatan...
Telp/Wa 628218200203 Gedung Metro, Jl. Samanhudi No.103 Lt. Dasar No. 101, 102, Ps. Baru,...
In Azure SQL Database Hyperscale Edition, how many geo-replicas can be created?
See possible answers