Wednesday, March 4, 2015

SQL Server 2014 Express LocalDB

No comments:

Microsoft SQL Server 2014 Express LocalDB is an execution mode of SQL Server Express targeted to program developers. LocalDB installation copies a minimal set of files necessary to start the SQL Server Database Engine. Once LocalDB is installed, developers initiate a connection by using a special connection string. When connecting, the necessary SQL Server infrastructure is automatically created and started, enabling the application to use the database without complex or time consuming configuration tasks. Developer Tools can provide developers with a SQL Server Database Engine that lets them write and test Transact-SQL code without having to manage a full server instance of SQL Server. An instance of SQL Server Express LocalDB is managed by using the SqlLocalDB.exe utility. SQL Server Express LocalDB should be used in place of the SQL Server Express user instance feature which is deprecated.

https://msdn.microsoft.com/en-us/library/hh510202.aspx

Friday, February 28, 2014

Sample MS SQL trigger code

No comments:
CREATE TRIGGER trg_users
ON  dbo.users
FOR  INSERT,UPDATE
AS
BEGIN
    RAISERROR('This is a test', 16, 1)
END
GO

Sunday, December 15, 2013

Bring back New Tab page in Google Chrome browser

No comments:
Goto:
1. chrome://flags/
2. Search for: Enable Instant Extended API Mac, Windows, Chrome OS
3. Select Disable from the drop-down below.
4. Click the Relaunch now button below