Previous
T-SQL Enhancements In SQL Server 2005 - Level 200
White Papers A lot has changed in the world of T-SQL with the next version of SQL Server. See how efficient you can become with the new T-SQL enhancements. In this webcast take a look at the new T-SQL enhancements and SQL Server data types and see how to choose...
[July 31, 2007, 3:48]
MSDN Webcast: SQL Server 2005 Masterclass: The New Features Of T-SQL In SQL Server 2005 (Level 300)
White Papers Something has come along: Transact-SQL (T-SQL) in Microsoft SQL Server 2005.This webcast describes the new features of T-SQL that provide a powerful way to manage relational data and make the developer's life easier.
[December 7, 2005, 23:00]
Microsoft T-SQL Performance Tuning Part 2: Analyzing And Optimizing T-SQL Query Performance On Microsoft SQL Server Using Indexing Strategies
White Papers This paper describes a variety of performance tuning techniques that you can apply to your Microsoft SQL Server Transact-SQL programs. In many cases, you could use the graphic user interface provided in Microsoft SQL Enterprise Manager or Microsoft...
[October 25, 2005, 3:00]
Microsoft T-SQL Performance Tuning Part 4: Analyzing And Optimizing T-SQL Query Performance On Microsoft SQL Server Using SHOWPLAN Output And Analysis
White Papers This paper will teach you the basic techniques used to tune SELECT statements on Micosoft's SQL Server 2000 relational database management system. The paper will also teach you the techniques available using Microsoft's graphical user interfaces...
[October 25, 2005, 3:00]
DON'T USE: Data Guard In Oracle Database 10g SQL Apply Best Practices
White Papers With Data Guard SQL Apply in Oracle Database 10g, Oracle is addressing the requirements of the business community for an online disaster recovery solution that also provides a means to offload reporting and decision support operations from the...
[November 29, 2006, 13:17]
TOP Keyword In SQL Server Yukon
White Papers TOP keyword is a one of those keywords that has been added by Microsoft to the ANSI SQL. Often developers who are used to T-SQL and are in the process of adapting themselves to PL-SQL find this key word suddenly missing.
[November 22, 2006, 0:00]
TRY...CATCH Keyword In Yukon
White Papers Yukon has added many new keywords to the T-SQL vocabulary. These additions to the T-SQL increase the expressive power of the queries. This paper would be primarily discussing this new construct that has been added to T-SQL, which is TRY.CATCH.
[November 22, 2006, 0:00]
Exchange 2007 Store Related Changes And Improvements
White Papers During the early stages of the development phase of Exchange Server 2007, rumors about changing the store to SQL circulated the Internet. But these plans were dropped relatively quickly and chances are people won't see an Exchange product where the...
[February 19, 2007, 0:00]
MSDE Plus
Downloads MSDE Plus is a fully featured tool for Microsoft Data Engine (MSDE) and Microsoft SQL Server 7.0/2000 users and developers. Manage MSDE/MS SQL Server, create and compile any server objects, and edit data using this application.
[March 30, 2006, 16:16]
SQL UpperCase
Downloads SQL UpperCase is great utility for database developers, which faciliates SQL developing. You don't have to press Shift or Caps Lock button every time you write SQL reserved word. SQL UpperCase makes it for you.
[December 15, 2005, 22:01]
Spida Bites Microsoft SQL Servers
News A new worm that targets Microsoft SQL Server software has begun squirming through the Internet, according to experts. Even though SecurityFocus is currently tracking almost 100 infections per hour, the worm's only way to infect a system is if the...
[May 22, 2002, 10:02]
XSQL Object Search
Downloads Search on one or all databases choose to find the objects that meet the search criteria on one database or on all databases in the selected SQL Server. Search the name or the definition choose to search on the name of the objects, the T-SQL...
[February 1, 2008, 2:16]
Ten Reasons Why You Should Upgrade To SQL Server 2005
News Most IT pros are working in SQL Server 2000 and still supporting SQL Server 7 databases (a few folks are even supporting SQL Server 6.5 databases). With the arrival of SQL Server 2005, we're often asked: "Should I upgrade?
[March 13, 2006, 10:45]
Microsoft Fails Slammer's Security Test
News In the case of SQL Slammer, it seemed that Microsoft had done it right. In this case, Microsoft urged customers to fix a vulnerability in the SQL Server 2000 software, but it apparently hadn't taken its own advice.
[January 28, 2003, 8:39]
Security Wake-up Call
News Protecting the server is simple: Just change the password on your sa account to a strong one and block access to your SQL server from the public Internet. A worm targeting SQL Servers had hit company and commercial data centers around the world.
[February 11, 2003, 9:46]
SQL-Batch Suite
Downloads SQL-Batch Suite basic concept is understanding that the user doesn't want complex features and doesn't want to hear about technicalities like databases, SQL queries, join tables, look-up tables and other IT Experts terminology.
[February 28, 2006, 0:16]
Microsoft's Turning Tide May Strand Customers
News The first wave is tied to the next version of SQL Server, known as Yukon, as well as to updated developer tools, known as Whidbey. Sitner said individual development teams that rely on SQL Server or components of Visual Studio will have to "work...
[March 15, 2004, 13:00]
SQL Object Decrypter
Downloads SQL Object Decrypter is a unencrypt software for SQL Server 7, SQL Server 2000, SQL Server 2005, and SQL Server 2005. SQL Object Decrypter is a Shareware program. Express with examining stored procedures, triggers, views and user-defined functions.
[April 7, 2008, 20:31]
Five Years Ago: Sybase Slates 'ridiculous' SQL Server Claims
News At the DB Expo show in New York yesterday, Microsoft said it had more than doubled its SQL Server sales to over two million users, citing customer and developer demand. Customers have told us that they prefer Microsoft SQL Server because its...
[December 4, 2001, 6:00]
Worm Exposes Laziness And Microsoft Bugs
News The Sapphire worm that hit servers running Microsoft SQL this weekend was a wake-up call for anyone who thought the Internet had become a safer place following increased attention by corporate and government leaders.
[January 27, 2003, 7:02]
