SQL Tips and Tricks Archives - Page 222 of 536 - SQL Authority with Pinal Dave

SQL SERVER – Puzzle #1 – Querying Pattern Ranges and Wild Cards

June 11, 2013

SQL, SQL Puzzle, SQL Server, SQL Tips and Tricks

Note: Read at the end of the blog post how you can get five Joes 2 Pros Book #1 and a surprise gift. I have been blogging for almost 7 years and every other day I receive questions about Querying Pattern Ranges. The most common way to solve the problem…

SQL SERVER – New SQL Server 2012 Functions – Webinar by Rick Morelan

June 10, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Joes 2 Pros

My friend Rick Morelan is a wonderful speaker and listening to him is very delightful. Rick is one of the speakers who can articulate a very complex subject in very simple words. Rick has attained over 30 Microsoft certifications in applications, networking, databases and .NET development, including MCDBA, MCTS, MCITP, MCAD,…

SQL SERVER – The Story of a Lesser Known Startup Parameter in SQL Server – Guest Post by Balmukund Lakhani

June 10, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Server Management Studio

This is a fantastic blog post from my dear friend Balmukund ( blog | twitter | facebook ). He had presented a fantastic session in our last UG and there were lots of requests from attendees that he blogs about it. Well, here is the blog post about the same very popular…

SQL SERVER – 2014 Announced and SQL Server 2014 Datasheet

June 9, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Server

Earlier this week Microsoft has announced SQL Server 2014. The release date of Trial of SQL Server to be believed later this year.

SQL SERVER – QUOTED_IDENTIFIER ON/OFF Explanation and Example – Question on Real World Usage

June 7, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

This is a follow up blog post of SQL SERVER – QUOTED_IDENTIFIER ON/OFF and ANSI_NULL ON/OFF Explanation. I wrote that blog six years ago and I had plans that I will write a follow up blog post of the same. Today, when I was going over my to-do list and…

SQL SERVER – Script to Update a Specific Column in Entire Database

June 4, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Joins

Last week, I have received a very interesting question and I find in email and I really liked the question as I had to play around with SQL Script for a while to come up with the answer he was looking for. Please read the question and I believe that…

SQLAuthority News – Advantages of Distance Learning

June 2, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Training

Distance education is extremely popular – almost overnight, it seems. Almost everyone has taken an online course, or knows someone who has, or is considering joining an online school. There are many advantages and disadvantages to attending an online school – but the same can be said of attending a…