Tags » SQL Tips And Tricks

MySQL - UDF - Validate Integer Function

There is a default function in SQL Server called ISNUMERIC to determine if the string is numeric. In SQL Server ISNUMERIC returns 1 for non numerials also. 204 more words

SQL Authority

SQL SERVER - SSMS: Transaction Log Shipping Status Report

History has its own way to define now civilizations thrived. Most of the cities flourished in the river side and transporting lumber was one of the key activity. 698 more words

SQL Authority

SQL SERVER - Andy Defines Basic RDBMS: Isolation in Processes - Notes from the Field #038

: This is a new episode of Notes from the Field series. Every time I give an introductory note, however, this time there is no need of intro note. 577 more words

SQL Authority

SQL Authority News - Webinar: SQL Server 2014 In-Memory OLTP and SafePeak In-Memory Caching

In the past couple of months many of us heard about the new SQL Server 2014 and its In-Memory technologies, such as In-Memory OLTP for high-transactional application and the ColumnStore INDEX’s for BI apps. 351 more words

SQL Authority

SQL SERVER - Finding Object Dependencies in SSMS - SQL in Sixty Seconds #071

While we are doing development, we create and drop objects. We build new things and we need to understand the relationships between database objects when we are doing various activities in SQL Server. 181 more words

SQL Authority

SQL SERVER - Free Entry to SQLPASS 2014 is Possible

The other day, I received an email from Dell and I was extremely delighted to read it. It contained details how one can go for FREE to SQLPASS. 380 more words

SQL Authority