A Better English Query
Someone is trying to build a better query engine for the web, something beyond a search engine. Steve Jones comments on the possible implications for databases if this works.
2009-03-22
753 reads
Articles
A Better English Query
Someone is trying to build a better query engine for the web, something beyond a search engine. Steve Jones comments on the possible implications for databases if this works.
2009-03-22
785 reads
A Better English Query
Someone is trying to build a better query engine for the web, something beyond a search engine. Steve Jones comments on the possible implications for databases if this works.
2009-03-22
719 reads
Ordering Tables To Preserve Referential Integrity
When moving data in related tables between databases, the order sometimes matters. New author Glen Cooper brings us an article that discusses the issues in maintaining referential integrity.
2009-03-20
6,296 reads
Introducing New Features In The VSTS Database Edition GDR
In this article, we focus specifically on highlighting new features in the GDR, including its support for offline schema development, tools that support new processes that you can use when you develop a database schema, and features that support database administration.
2009-03-20
2,208 reads
The Flaws of the Classic Data Warehouse Architecture, Part 1
Visit ten randomly picked customers that own a data warehouse architecture, and you will see that at least eight have developed a classic data warehouse architecture (CDWA). What do I mean by a CDWA? In a CDWA, data is copied periodically from production systems to the central data warehouse.
2009-03-20
6,058 reads
Clustered SQL Server 2005/2008 Installation Using Mount Points
If you are in a clustered environment, check out this article from James Greaves. Here we learn how to deal with the clustered disk space and mount points.
2009-03-19
6,175 reads
Creating Striped Backups - SQL School Video
This SQL School video shows how you can speed up your backup process by striping the backup across multiple disks. MVP Andy Warren narrates.
2009-03-19
3,621 reads
Monitoring Your Servers : Data Collection vs. Performance Advisor
An article sponsored by SQL Sentry that compares how the Data Collector in SQL Server 2008 and SQL Sentry's Performance Advisor can be used with your SQL Server. Written by MVP Aaron Bertrand.
2009-03-19
6,753 reads
Avoiding cursors with SQL Server 2005
Sometimes cursors are necessary when executing queries in SQL Server, but most of the time they can be avoided entirely. This article shows where cursors can traditionally be used, and how you can use features packaged in SQL Server 2005 to avoid them.
2009-03-19
5,627 reads
Blogs
2025 Wrapped for Steve
By Steve Jones
I’ve often done some analysis of my year in different ways. Last year I...
The Book of Redgate: Spread across the world
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
Merry Christmas
By John
Today is Christmas and while I do not expect anybody to actual be reading...
Forums
Finding Motivation
Comments posted to this topic are about the item Finding Motivation
The Last Binary Value of the Year
Comments posted to this topic are about the item The Last Binary Value of...
SQL Art, Part 2: New Year Fireworks in SSMS
Comments posted to this topic are about the item SQL Art, Part 2: New...
Question of the Day
The Last Binary Value of the Year
What does this code return?
SELECT cast(0x2025 AS NVARCHAR(20))Image 1:
Image 2: 
Image 3: 
Image 4: 
See possible answers