Log In | Register

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

AhmadOsama

ASIA'S FIRST SQL SERVER CONFERENCE IS HAPPENING IN BANGALORE. HAVE YOU REGISTERED?

Ahmad Osama

About Ahmad Osama

Ahmad Osama is a MCP Database Administrator/Developer. Ahmad started his career in the sales industry working as database executive; responsible for report writing, application development and basic database administration. In 2008 he joined World Fashion Exchange as Database Administrator. While in this role he focused on troubleshooting and performance tuning. In 2010 he joined The Perfect Future Technologies and has been awarded as best new comer and expert of the year working as database administrator on one of largest political database in the world. Ahmad has experience in database administration, SSIS, performance tuning, VLDBs and web development. When not working on SQL Server, he can be found glued to his Xbox.

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

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

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

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

 

Regards

Ahmad Osama

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

Follow me on Twitter |  […]

Constraint to limit VARCHAR max character length in SQL Server

A business need may arise to limit a VARCHAR column to a certain length. Consider a scenario where in an application has a 10000 character limit for a column. The VARCHAR(max) is the suitable data type choice for this column. However a VARCHAR(max) column is not limited to 10000 characters. In that case we […]

Newsletter_Footer