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'. Here they try to demonstrate how useful SQLCMD can be to anyone who is tasked with having to administer a database.*/ Contents Introduction /* There are two ways of using SSMS to automate repetitive tasks that involve TSQL.
The other system uses macro-substitution at Runtime and involves SQLCMD mode. .Why bother with SQLCMD? Adding a user or a group Imagine you have to create a server login for a user and then grant him access to the current database: You open up a query window in SSMS and check that you are in SQLCMD mode (Query --> SQLCMD mode). Here is a sample Macro Script to add a windows user or group to your database in the role you specify.
--the user to do :setvar rolename "sales" :setvar membername "Kilgore" :setvar login "SimpleTalk\KilgoreTrout" Go !!
2008 – Introduction to Merge Statement – One Statement for INSERT, UPDATE, DELETE. MERGE is a new feature that provides an efficient way to perform multiple DML operations. In previous versions of SQL Server, we had to write separate statements to INSERT, UPDATE, or DELETE data based on certain conditions, but now, using MERGE statement we can include the logic of such data modifications in one statement that even checks when the data is matched then just update it and when unmatched then insert it. One of the most important advantage of MERGE statement is all the data is read and processed only once.
In previous versions three different statement has to be written to process three different activity (INSERT, UPDATE or DELETE), however using MERGE statement all update activity can be done in one pass of database table. This is quite an improvement in performance of database query. Let’s create Student Details and StudentTotalMarks and inserted some records. Student Details: StudentTotalMarks: Now we will write MERGE process for tables created earlier. Like this:
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. U.S. Department of Labor Launches Online Tools to Help Developers Build Apps - IT Infrastructure. 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.
The site features published APIs (application program interfaces) and SDKs (software development kits) that enable developers to remotely access data collected by the department. The tools, available at are part of the Labor Department's ongoing efforts to increase transparency, participation and collaboration through the administration's Open Government Initiative, Labor Department officials said. "While a handful of other federal agencies are making data available through one or more APIs, the inclusion of SDKs is a federal first," said Deputy Secretary of Labor Seth Harris, in a statement. Darryl K.
SQL Queries. Performance. Database Mail. Replication Programming. End of Mainstream Support for SQL Server 2005 and End of Service Pack Support for SQL Server 2008 SP1 - Microsoft SQL Server Release Services. 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 Customers are encouraged to prepare and execute on their upgrade and/or sustained engineering plans as early as possible for these SQL versions.
Remaining current on your SQL Server version ensures that your product remains supported per the Support Lifecycle policy. Additionally, your software benefits from the many enhancements, fixes, and security updates provided through the latest releases. For SQL Server 2005 SP3 and SQL Server 2005 SP4, Microsoft will continue to provide technical support which also includes security updates during the duration of extended support. Thank you, Christina Gendrano.
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. The CouchDB for Android SDK is available as a free download. The company said, "Designed to take full advantage of CouchDB's peer-to-peer sync facilities, CouchDB for Android allows developers to build Web or native applications that work even if the Internet connection is slow, intermittent or completely down.
With continuous access to a local copy of data, developers can leverage their existing knowledge about Web technologies to quickly build collaborative business applications on mobile devices. " CouchDB is described by Wikipedia as "a free and open-source document-oriented database written in the Erlang programming language. It is a NoSQL product designed for local replication and to scale vertically along a wide range of devices. " Darryl K.