Log in | Register

SQL Geek, Author at SQL Server Blogs, Events, Webcasts, Videos, SQL Server learning & education SQL Geek, Author at SQL Server Blogs, Events, Webcasts, Videos, SQL Server learning & education

About SQL Geek

This author has not yet filled in any details.
So far SQL Geek has created 170 entries.

The Power of Networking

Networking is to interact with others to exchange information and develop professional and social contacts. This statement itself speaks about the power of networking. We do network with people in our day to day life in offices, gym, meetings, malls and other public places. However, this isn’t professional networking. We meet, we talk and […]

By |April 16th, 2016|Categories: SQL Conference, SQL Events||0 Comments

How to get benefited from a conference

Attending a seminar or conference is perhaps a very smart idea to improve your business’s future, but several business owners and employees, working every day in the world of business, miss out on these helpful and vital meetings simply due to sheer negligence and ignorance. These seminars and conferences are aimed at providing you […]

Benefits of blogging

Few years ago, people looked puzzled if they were told about blogs and writing blogs as a profession. They were reluctant to believe that blog is the single most important way to promote a business, cause or even a person.

However, nowadays most of the people are very familiar with the profession and passion of […]

5 Reasons your employee should attend conferences

If you want to speak good in front of the other people then attending the meeting and to speak there is the best way you can change yourself. In this article, we will be discussing the main 5 Reasons your employee should attend conferences. Especially for the diverse conference meetings, it is very significant […]

By |May 29th, 2015|Categories: SQL Conference|Tags: , , |0 Comments

Conference and the learning: The real benefit of demands

Are you one of those, who just cannot get to see what exactly the actual benefit of attending the conferences is? Then it is high time that you can quickly gather knowledge. To encourage the classicist demands and the assistantships that are useful for extra understanding of the subjects and the matters included in […]

Conference and Networking benefits

Conference and networking are two sides of the coin. In today’s world of advanced technology, one can attend conferences, online and benefit from them. Every other big conference whether it’s Microsoft’s Build or Apple’s WWDC is available live over the internet. The conference sessions are even available for download for later use. With that […]

SQL Server new query window shortcut

Shortcuts help you to do your work swiftly and with increased productivity. In this blog we’ll look at new query window shortcut every SQL Server geek should know


Window + R -> ssms.exe
Open SQL Server management studio

Open a new query window

Move among open query windows

Execute All or selected queries

Ctrl […]

SQL Server error message 3159

One of my friends working on SQL Server 2000 to 2005 faced following issue.

Msg 3159, Level 16, State 1, Line 1
The tail of the log for the database “databasename” has not been backed up.
Use BACKUP LOG WITH NORECOVERY to backup the log if it contains work you do not want to lose.

SQL function to get weekday – weekly calendar

In this blog post we’ll look at a way to list out all week days of a week a particular date belongs too. This can be even referred to as weekly calendar. This comes handy in reporting. A SQL function to get week days of particular date is given below

First, create the below function […]

Insert multiple rows using single Insert statement in SQL Server

This is a very basic problem sometimes newbies struggle with. I have seen developers writing 10 different insert statements to insert 10 rows in a table.  This can be simplified in multiple ways as shown below


Like us on FaceBook  |  Join the fastest growing SQL Server group on FaceBook

Follow me on Twitter |  Follow […]