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

sql_geek

SQLServerGeeks Annual Summit 2016 IS HAPPENING IN BANGALORE. HAVE YOU REGISTERED?

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||Comments Off on The Power of Networking

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 […]

By |June 3rd, 2015|Categories: SQL Conference, SQL Events, SQL Server|Tags: , , |Comments Off on How to get benefited from a conference

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 […]

By |May 30th, 2015|Categories: SQL Conference|Tags: , , |Comments Off on Benefits of blogging

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: , , |Comments Off on 5 Reasons your employee should attend conferences

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 […]

By |May 27th, 2015|Categories: SQL Conference|Tags: , , |Comments Off on Conference and the learning: The real benefit of demands

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 […]

By |May 12th, 2015|Categories: SQL Conference|Tags: , , , |Comments Off on Conference and Networking benefits

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

Shortcut
Usage

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

CTRL + N
Open a new query window

CTRL + TAB
Move among open query windows

CTRL + E
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.
[…]

By |April 12th, 2015|Categories: Database Administration, SQL Server, SQL Server Accidental DBA Series|Tags: , , |Comments Off on SQL Server error message 3159

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 […]

By |April 10th, 2015|Categories: Database Development, SQL Server, SQL Server Accidental DBA Series, Transact-SQL|Tags: , , |Comments Off on SQL function to get weekday – weekly calendar

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

 

Regards

Ahmad Osama

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

Follow me on Twitter |  […]

By |April 7th, 2015|Categories: Database Development, SQL Server, SQL Server Accidental DBA Series, Transact-SQL|Tags: , |Comments Off on Insert multiple rows using single Insert statement in SQL Server
Newsletter_Footer