Skip Ribbon Commands
Skip to main content
TypeUse SHIFT+ENTER to open the menu (new window).
  
Edit
URLUse SHIFT+ENTER to open the menu (new window).
  
Notes
Use SHIFT+ENTER to open the menu (new window).
  
 
  
Helpful hints in making SQL Server faster and how to diagnose the issues.
 
 
  
Installing and running SQL Server 2008 on Dell PowerEdge Servers wrunning Windows 2008 x64 Enterprise  ( = Skynet servers)
 
  
Using a pre-compiled,parameterized query to speed up LINQ queries.
 
  
Using the HierarchyID data type in SQL Server 2008 to represent data with hierarchal relationships, e.g. trees.
 
  
Wikipedia article on Relational Algebra.
 
 
  
An example of a tree representation of a relational algebra query, including its equivalent SQL statement.
 
  
Nice presentation on relational algebra, including tree representaitons.   Includes SQL and how it is a "bag" (sets with duplicates) language and how it differs from regular set algebras, e.g. dealing with duplicates.
 
  
This command line utility helps you better manage your SQL Compact development efforts. If allows you to script schema and data from any SQL Compact database file to a .sql file, which can be used in any context. The utility is developed in C# with Visual Studio 2008. You can use the resultning script for documentation, programmatical scripting of SQL Compact database files, or migration of schema and data to SQL Server (Express) 2005 or later.
 
  
SqlConnection Connection String Parameter Keywords & Values
 
  
Auditing Failed Logins in SQL Server