Archive for the ‘SQL’ Category

Standalone SQLCMD for Microsoft SQL Server Management

March 25, 2012

Install both SQLCMD and the SQL Native Client.

Microsoft® SQL Server® 2008 R2 Command Line Utilities
The SQLCMD utility allows users to connect to, send Transact-SQL batches from, and output rowset information from SQL Server instances. The bcp utility bulk copies data between an instance of Microsoft SQL Server 2008 R2 and a data file in a user-specified format. The bcp utility can be used to import large numbers of new rows into SQL Server tables or to export data out of tables into data files.

SqlCmdLnUtils.msi, X86 PackageX64 PackageIA64 Package

(more…)

Free Microsoft Press ebook- Introducing Microsoft SQL Server 2012

March 24, 2012

Introducing Microsoft SQL Server 2012 includes 10 chapters:

PART I DATABASE ADMINISTRATION (by Ross Mistry)
1. SQL Server 2012 Editions and Engine Enhancements
2. High-Availability and Disaster-Recovery Enhancements
3. Performance and Scalability
4. Security Enhancements
5. Programmability and Beyond-Relational Enhancements

(more…)

Introduction to Databases – Free Online course by Stanford Engineering

October 19, 2011

It is being offered free and online to students worldwide, October 10 – December 12, 2011. Students have access to lecture videos, are given assignments and exams, receive regular feedback on progress, and participate in a discussion forum. Those who successfully complete the course will receive a statement of accomplishment. Taught by Professor Jennifer Widom, the curriculum draws from Stanford’s popular Introduction to Databases course. A high speed internet connection is recommended as the course content is based on videos and online exercises.

SQL Server 2008 Service Pack 3

October 8, 2011

Microsoft SQL Server 2008 Service Pack 2 is not a prerequisite for installing SQL Server 2008 Service Pack3. These packages may be used to upgrade any of the following editions of SQL Server 2008: Enterprise, Standard, Evaluation, Developer, Workgroup

SQL Server 2008 SP3 contains the cumulative updates of SQL Server 2008 SP2 cumulative update package 1 to 4, and fixes to issues that have been reported through our customer feedback platforms. These include supportability enhancements and issues that have been reported through Windows Error Reporting.

Testing SQL connectivity without installing any tools

October 7, 2011

On your desktop, create an empty text file and saved it as “TestSQL.UDL”

Double-click on the file “TestSQL.UDL” and a SQL connectivity window popup for your testing of remote SQL connections.

Oracle SQL Developer

April 22, 2011

Oracle SQL Developer is a free and fully supported graphical tool for database development. With SQL Developer, you can browse database objects, run SQL statements and SQL scripts, and edit and debug PL/SQL statements. You can also run any number of provided reports, as well as create and save your own. SQL Developer enhances productivity and simplifies your database development tasks .

Oracle SQL Developer 3.0 is now available for download  (29 March 2011)

Microsoft SQL Server 2005 Service Pack 4 RTM

January 14, 2011

Service Pack 4 (SP4) for Microsoft SQL Server 2005 is now available for download.

Version: 9.00.5000.00
Date Published: 12/17/2010

SQL Server 2005 service packs are cumulative, and this service pack upgrades all service levels of SQL Server 2005 to SP4 . You can use these packages to upgrade any of the following SQL Server 2005 editions:

  • Enterprise
  • Enterprise Evaluation
  • Developer
  • Standard
  • Workgroup

SQL Server 2005 SP4 includes SQL Server 2005 SP3 cumulative update 1 to 11, customer requested fixes, along with instances of the SQL Server 2005 SP4 database Engine support for DAC operations.

Peer-to-peer support is available in the SQL Server 2005 forums.

Note: To obtain SQL Server 2005 Express Edition obtain the SP4 version of Express or Express Edition with Advanced Services.

SQL Language Statement Types

October 16, 2010

SQL Language comprised of 4 major statement parts.

– Data Manipulation Language (DML) statements affect the records in a table  
– Data Definition Language (DDL) statements handle the design of objects (e.g. databases, tables, stored procedures)
– Data Control Language (DCL) statements control the level of access to securables
– Transaction Control Language (TCL) statements manage transactions.

SQL Server 2008 R2 Update for Developers Training Kit

April 27, 2010

SQL Server 2008 R2 offers an impressive array of capabilities for developers that build upon key innovations introduced in SQL Server 2008. The SQL Server 2008 R2 Update for Developers Training Kit is ideal for developers who want to understand how to take advantage of the key improvements introduced in SQL Server 2008 and SQL Server 2008 R2 in their applications, as well as for developers who are new to SQL Server. The training kit is brought to you by Microsoft Developer and Platform Evangelism.

Cumulative updates after SQL Server 2008 Service Pack 1

May 27, 2009

KB970365

Build 10.00.2714 (cumulative update). This cumulative update package was released on May 18, 2009. The parent build of this build is 10.00.2710. Cumulative update package 2 for SQL Server 2008 SP1 (KB 970315)

Build 10.00.2710 (cumulative update). This cumulative update package was released on April 15, 2009. The parent build of this build is 10.00.2531. Cumulative update package 1 for SQL Server 2008 SP1 (KB 969099)

Build 10.00.2531 (SQL Server 2008 Service Pack 1). This is the build of SQL Server 2008 Service Pack 1 that was released on April 7, 2009. List of the bugs that are fixed in SQL Server 2008 SP1 (KB 968369)