Calling all developers! Does the idea of going from a concept to a prototype in a 54 hour marathon weekend of design and coding sound fun to you? If so, join us!
2008-06-20 (first published: 2008-06-16)
1,029 reads
By using cascading referential integrity constraints, you can define the actions that SQL Server 2005 takes when a user tries to delete or update a key to which existing foreign keys point.
2008-06-20
2,344 reads
This white paper provides an introduction to various features of XQuery implemented in SQL Server 2005 such as the FLWOR statement, operators in XQuery, if-then-else construct, XML constructors, built-in XQuery functions, type casting operators, and examples of how to use each of these features.
2008-06-20
3,551 reads
2008-06-19
9,625 reads
2008-06-19
49 reads
2008-06-19
37 reads
2008-06-19
47 reads
Microsoft SQL Server has steadily gained ground on other database systems and now surpasses the competition in terms of performance, scalability, security, developer productivity, business intelligence (BI), and compatibility with the 2007 Microsoft Office System. It achieves this at a considerably lower cost than does Oracle Database 11g.
2008-06-19
4,197 reads
One of the more interesting new technologies in SQL Server 2005 is database mirroring, allowing you to implement high availability on a database with commodity hardware. Jay Dave brings us a nice description of this technology.
2008-06-18 (first published: 2007-07-17)
15,595 reads
SQL Management Objects(SMO)can be used for customized automation of various database.This article gives an implementation for SMO using C#.
2008-06-18
5,532 reads
By Brian Kelley
Professor Patrick Winston of MIT used to give a one-hour talk about how to...
By Steve Jones
One of the popular features of Redgate Monitor has been the ability to add...
When building the sql-on-k8s-operator, I wanted to make sure it could handle both planned...
We have an AlwaysOn architecture with four replicas: two running in synchronous commit mode...
Comments posted to this topic are about the item The Vector Data Type
Comments posted to this topic are about the item What Power BI DirectQuery does...
What is the vector data type in SQL Server?
See possible answers