SQL Server Archives - Page 109 of 393 - SQL Authority with Pinal Dave

Blogging Best Practices – Getting Started with Blogging – Part 2

May 21, 2013

Abstract of my Pluralsight Course Building a Successful Blog Module – Getting Started with Blogging. [youtube=http://www.youtube.com/watch?v=12p4j4Ht8os] Choosing a Blog Host If you’ve recently decided to start blogging, the very first thing you have to decide on is which hosting service to use. There are many blog hosts: Blogger, WordPress, Typepad, to name…

Blogging Best Practices – Pluralsight Online Course Based on My Experience

May 19, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Best Practices, Blogging

I have been blogging for more than 6.5 years and I have so far written over 2500 articles on this blog and every blog has been journey itself. Over six years I have not missed any single blog and no matter what happens I keep on blogging every day, month after…

SQL SERVER – Weekly Series – Memory Lane – #029

May 18, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Memory Lane

Here is the list of selected articles of SQLAuthority.com across all these years. Instead of just listing all the articles I have selected a few of my most favorite articles and have listed them here with additional notes below it. Let me know which one of the following is your…

SQL SERVER – Solution to Puzzle – REPLICATE over 8000 Characters

May 17, 2013

Pinal Dave

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

SQL Function

Earlier this week, I asked a puzzle about how REPLICATE works with 8000 and over 8000 characters. I strongly suggest to read the original blog post where I have described the problem in detail SQL SERVER Puzzle – REPLICATE over 8000 Characters. Just quick to summarize the puzzle. Here is the quick…

SQL SERVER – How to use xp_sscanf in Real World Scenario?

May 14, 2013

Pinal Dave

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

SQL Scripts

I need your help. I recently came across extended stored procedure xp_sscanf. After reading a lot about it and searching online, I could not figure out how and where in real world, I will use this function. Microsoft documentations suggest that this extended stored procedure reads data from the string…

SQL SERVER – Puzzle and Answer – REPLICATE over 8000 Characters

May 13, 2013

Pinal Dave

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

SQL Function

It has been a long time since we have played a puzzle over this blog. This Monday, let us play a quick puzzle. SQL Server have REPLICATE function which will replicate the string passed as many as times as the second parameter. For example execute following string. SELECT 'Ha'+REPLICATE('ha',20) The script…

SQL SERVER – Weekly Series – Memory Lane – #028

May 11, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Memory Lane