In this article, we will explore another variation of this mechanism, called Web Synchronization, with SQL Server 2005 Express Edition instances operating as merge replication subscribers connecting to a publisher via HTTPS protocol.
2008-03-17
998 reads
2008-03-16
34 reads
2008-03-16
37 reads
SQL Server 2005 brings a new feature to T-SQL with Common Table Expressions, which make it possible for more complex subquery expressions than in previous versions. Recursion is a common use and Peter He takes a look at how well these new structures perform.
2008-03-14 (first published: 2007-05-08)
18,196 reads
SQL Server expert Jeff Moden discusses a common problem seen in many update statements.
2008-03-14
12,618 reads
With SQL Server 2005 recently released, one of the things that many people are looking for are some guidelines for working with the new product. New author NandaKishore brings us a list of best practices that should give you a start.
2008-03-14 (first published: 2006-01-04)
121,500 reads
This paper describes the Fuzzy Lookup and Fuzzy Grouping transformations that are part of SQL Server 2005 Integration Services (SSIS). These SSIS transformations are useful for improving the data quality of existing data as well as new data that is being loaded into your database.
2008-03-14
1,809 reads
Understanding different types of failovers/Role Switching and How do they internally work in database mirroring.
2008-03-14
1,255 reads
Importing data files is always a challenge for a DBA, especially when the files might vary in format. Having one codebase is important and new author Mark Balasundram brings us the template for a high performance application to do just that.
2008-03-13 (first published: 2007-04-04)
17,542 reads
Vote for Service Pack 3!!! For SQL Server 2005. As of now, Microsoft has no plans to release Service Pack 3 for SQL Server 2005. I sent them our poll results, but we need more votes. Let them know this is important by voting on Connect. Vote Now!!!! Update: There's a post that they hear […]
2008-03-13 (first published: 2008-02-17)
37 reads
Fabric inbound network protection involves two tenant-level controls: Private Link and Block Public Internet...
Most apps that call an LLM send every request to the same model. That...
By Steve Jones
“The foundation of maturity: Just because it’s not your fault doesn’t mean it’s not...
Comments posted to this topic are about the item AI Observability Challenges in FinOps...
Hello everyone , I am planning to migrate a database from SQL Server 2014...
Comments posted to this topic are about the item SQL Agent Job Automated Change...
Where do I check for the existence of a Database Master Key (DMK) in SQL Server 2025?
See possible answers