Database

TwitterFacebook
Get flash to fully experience Pearltrees
https://www.simple-talk.com/sql/sql-tools/the-sqlcmd-workbench/

The SQLCMD workbench

/* Robyn and Phil feel strongly that there are two striking features in SSMS that extends its usefulness dramatically. The first is the Template, and the second is the powerful functionality hidden by those strange words 'SQLCMD Mode'.
Informatica

Query Hints

Have you been using MySQL for your web applications since your first foray into website development? Perhaps you now run, or are thinking about running, your own server and you will set up MySQL because that is what you have always used. Did you know there are alternatives? http://techportal.inviqa.com/2012/03/15/mysql-alternatives-to-mysql/

MySQL Alternatives to MySQL – techPortal

DTC

NO SQL

SSIS

SSAS Analysis Services

CTE Common Table Expressions

Daylight Savings Timezones

Table Value Parameters

Replication

CLR Functions

Dimensional Modeling

Paging

SQL Issues

Extended Properties

Geography

Computed Columns

.Net in SQL

The U.S. Department of has launched a set of new online tools for software developers to tap into DOL data for use in applications. The DOL's new first-of-its-kind federal Website is aimed at making it easier for software developers to incorporate Labor Department data into online and mobile applications. http://www.eweek.com/c/a/IT-Infrastructure/US-Department-of-Labor-Launches-Online-Tools-to-Help-Developers-Build-Apps-261910/

U.S. Department of Labor Launches Online Tools to Help Developers Build Apps - IT Infrastructure

Data Cleansing

SQL Queries

Performance

Database Mail

We would like to remind all customers that Mainstream Support for SQL Server 2005 Service Pack 3 and SQL Server 2005 Service Pack 4 will end on April 12, 2011 , and Service Pack Support for SQL Server 2008 Service Pack 1 will end on October 11, 2011. Microsoft is ending support for these products as part of our Support Lifecycle policy, found in http://support.microsoft.com/lifecycle .

End of Mainstream Support for SQL Server 2005 and End of Service Pack Support for SQL Server 2008 SP1 - Microsoft SQL Server Release Services

http://blogs.msdn.com/b/sqlreleaseservices/archive/2011/01/27/end-of-mainstream-support-for-sql-server-2005-and-end-of-service-pack-support-for-sql-server-2008-sp1.aspx
Log Shipping

BI

CouchDB Comes to Android - Mobile and Wireless from eWeek

Couchio, "corporate sponsor of the CouchDB post-relational database," on Aug. 12 announced the availability of the first release of a CouchDB software development kit for mobile devices running Google's Android operating system. http://www.eweek.com/c/a/Mobile-and-Wireless/CouchDB-Comes-to-Android-139698/
Profiling