Microsoft Sync Framework is a comprehensive platform for synchronizing offline and online data, and facilitates collaboration and offline access for applications, services and devices alike. It is protocol- and database-independent and includes technologies and tools that enable device roaming, sharing and the ability to take networked data offline before synchronizing it back at a later point in time.
David Poole takes a look at the Massively Parallel Processing world for database servers.
A good employee should try to affect the bottom line in their company, striving to make a difference. Steve Jones passes on some advice on how to do that today.
To ensure that queries run as efficiently as possible, the database administrator needs to monitor performance to find inefficient queries. This article focuses on exploring how a DBA can monitor the I/Os against an instance of SQL Server, using Dynamic Management Objects, or more commonly know as Dynamic Management Views (DMVs) and Functions (DMFs).
Today Steve Jones looks at the new release of restore technology from Red Gate software that allows you to "fool" SQL Server.
This is just a quick one prompted by a question on the SSIS Forum, how to programmatically add a precedence constraint (aka workflow) between two tasks. To keep the code simple I’ve actually used two Sequence containers which are often used as anchor points for a constraint. Very often this is when you have task that you wish to conditionally execute based on an expression.
On Aug 18, 2010 there is a SQL Social meeting in Kent, UK. Read about the details and attend if you are in the area.
Is there such a thing as too much attention to the performance of SQL? It isn’t only a question of time and inclination, but also of the resilience and flexibility of the code.
A Technique to deal with moving data from multiple schemas into one table
Did your company lose data last year? It can be hard to know, especially when even laws designed to ensure breaches are reported have loopholes. Steve Jones thinks this is a bad idea.
By Steve Jones
With the AI push being everywhere, Redgate is no exception. We’ve been getting requests,...
By Steve Jones
fawtle – n. a weird little flaw built into your partner that somehow only...
AWS recently added support for Post-Quantum Key Exchange for TLS in Application Load Balancer...
Hi all, I recently moved to a new employer who have their HA setup...
Comments posted to this topic are about the item Semantic Search in SQL Server...
Comments posted to this topic are about the item Encoding URLs
I have this data in a table:
CREATE TABLE Response ( ResponseID INT NOT NULL CONSTRAINT ResponsePK PRIMARY KEY , ResponseVal VARBINARY(5000) ) GOIf I want to get a value from this table that I can add to a URL in a browser, which of these code items produces a result I can use? See possible answers