|
|
shruti
shruti
 |
|
Stories kicked by friends of shruti
|
|
submitted by
 pinaldave
5 hours, 27 minutes ago blog.sqlauthority.com — Microsoft Most Valuable Professionals (MVPs) are exceptional technical community leaders from around the world who are awarded for voluntarily sharing their high quality, real world expertise in offline and online technical communities. Microsoft MVPs are a highly select group of experts that represents the technical community’s best and brightest, and they share a deep commitment to community and a willingness to help others.
Kick the story to support Microsoft Event. read more...
1 comment
|
category:  Community | Views: 0
| 
|
tags:
SQLAuthority, SQLServer, Openday, Community, MVP | tag it
Everyones tags: | Your tags: | |
|
|
|
|
|
published 1 month, 15 days ago, submitted by
kpanghmc
1 month, 15 days ago kevinwilliampang.com — Proverbs are used to express universal truths or life lessons in a short and memorable fashion. I find that they are a great way to keep things in perspective, both in life and in work. Because of this, I have assembled 10 programming proverbs that every developer needs in their arsenal. read more...
add a comment
|
category:  Other | Views: 1124
| 
|
| tag it
Everyones tags: | Your tags: | |
No tags
|
|
|
|
|
published 1 month, 15 days ago, submitted by
pinaldave
1 month, 16 days ago blog.sqlauthority.com — Very frequently I have been asked to create a page, post or article where in one page all the important concepts of SQL Server are covered. SQL Server 2008 is very large subject and can not be even covered 1000 of pages. In daily life of DBA there are few commands very frequently used and for novice developers it is good to keep all the important SQL Script and SQL Statements handy.
I have attempted to create cheat sheet for SQL Server 2008 most important commands. User can print this in one A4 size page and keep along with them. This can be used in interviews where T-SQL scripts are being asked.
Let me know your opinion and if you find this useful.
Bookmark it for future use. read more...
2 comments
|
category:  Database | Views: 595
| 
|
tags:
SQLServer, SQL2K8, sqlserver2008, Database, SQLAuthority | tag it
Everyones tags: | Your tags: | |
|
|
|
|
|
published 1 month, 23 days ago, submitted by
pinaldave
1 month, 25 days ago blog.sqlauthority.com — Coding standards and guidelines are very important for any developer on the path of successful career. A coding standard is a set of guidelines, rules and regulations on how to write code. Coding standards should be flexible enough or should take care of the situation where they should not prevent best practices for coding. They are basically the guidelines that one should follow for better understanding.
The concept behind implementing coding standards and guidelines, is that the consistency and uniformity in programming so that if multiple people are working on the same code, it becomes easier to communicate, share with or understand each other’s work.
With the goal of promoting good coding standards and guidelines I have created document which can guide developers. read more...
3 comments
|
category: Database | Views: 311
| 
|
tags:
sqlserver2008, sqlserver2k8, -1, SQL, Database | tag it
Everyones tags: | Your tags: | |
|
|
|
|
|
published 2 months ago, submitted by
pinaldave
2 months, 1 day ago blog.sqlauthority.com — Interview is very important event for any person. A good interview leads to good career if candidate is willing to learn. I always enjoy interview questions and answers series. This is my very humble attempt to write SQL Server 2008 interview questions and answers. SQL Server is very large subject and not everything is usually asked in interview. In interview what matters the most is conceptual knowledge and learning attitude.
I have listed all the series in this post so that it can be easily downloaded and used. All the questions are collected and listed in one PDF which is here to download. If you have any question or if you want to add to any of the question please send me mail or write a comment.
Bookmark this first ever set of interview questions and answers. read more...
2 comments
|
category: Database | Views: 280
| 
|
tags:
SQL2K8, SQL, SQL2008, Interview, sqlserver2008 | tag it
Everyones tags: | Your tags: | |
|
|
|
|
|
published 2 months, 6 days ago, submitted by
 adamtibi
2 months, 6 days ago adamtibi.net — Focuses on three important rules (with code snippets) that ASP.NET developers should follow to do their part of the SEO process. read more...
add a comment
|
category:  ASP.NET | Views: 489
| 
|
tags:
SEO, ASP.NET | tag it
Everyones tags: | Your tags: | |
|
|
|
|
|
submitted by
pinaldave
2 months, 19 days ago blog.sqlauthority.com — Table-Valued Parameters is a new feature introduced in SQL SERVER 2008. In earlier versions of SQL SERVER it is not possible to pass a table variable in stored procedure as a parameter, but now in SQL SERVER 2008 we can use Table-Valued Parameter to send multiple rows of data to a stored procedure or a function without creating a temporary table or passing so many parameters.
This is one feature all the SQL Server developer were waiting for long time. This article explains how it can be used with very simple words. read more...
1 comment
|
category: Database | Views: 12
| 
|
tags:
SQL, SQLServer, Database, SQLAuthority | tag it
Everyones tags: | Your tags: | |
|
|
|
|
|
submitted by
pinaldave
2 months, 19 days ago blog.sqlauthority.com — Filtered Index is a new feature in SQL SERVER 2008. Filtered Index is used to index a portion of rows in a table that means it applies filter on INDEX which improves query performance, reduce index maintenance costs, and reduce index storage costs compared with full-table indexes. When we see an Index created with some WHERE clause then that is actually a FILTERED INDEX.
I am sure this feature will change how the indexes are created in SQL Server. read more...
1 comment
|
category: Database | Views: 9
| 
|
tags:
SQL, SQLServer, Database, SQLAuthority | tag it
Everyones tags: | Your tags: | |
|
|
|
|
|
submitted by
 wisemx
2 months, 29 days ago blog.sqlauthority.com — Everyday I get lots of question regarding error :
An error has occurred while establishing a connection to the server when connecting to SQL server 2005, this failure may be caused by the fact that under default settings SQL server does not allow remote connection. ( provider: Named Pipes Provider, error: 40 - could not open a connection to SQL server. )
This error happens due to many reasons. There are few solutions already given on my original threads.I encourage to read following two articles first and see if you can find your solution. If you can not find any solution from here, I suggest to read additional suggestions listed below in ticket. read more...
1 comment
|
category: Database | Views: 22
| 
|
tags:
Database | tag it
Everyones tags: | Your tags: | |
|
|
|
|
|
submitted by
pinaldave
3 months, 8 days ago blog.sqlauthority.com — If you have struggled with your datetime format with your application or database. This is one script you will need.
Bookmark it. read more...
add a comment
|
category: Database | Views: 9
| 
|
tags:
Database | tag it
Everyones tags: | Your tags: | |
|
|
|
|
|
published 3 months, 17 days ago, submitted by
pinaldave
3 months, 19 days ago blog.sqlauthority.com — INTERSECT operator in SQL Server 2005 is used to retrieve the common records from both the left and the right query of the Intersect Operator. INTERSECT operator returns almost same results as INNER JOIN clause many times.
When using INTERSECT operator the number and the order of the columns must be the same in all queries as well data type must be compatible.
Let us see understand how INTERSECT and INNER JOIN are related.We will be using AdventureWorks database to demonstrate our example. read more...
3 comments
|
category: Database | Views: 250
| 
|
tags:
SQL, SQLServer, SQLAuthority, Database, 2005 | tag it
Everyones tags: | Your tags: | |
|
|
|
|
|
submitted by
pinaldave
3 months, 19 days ago blog.sqlauthority.com — Let us try to understand this subject with example.
We will use Adventurworks database for this purpose. Table which we will be using are HumanResources.Employee (290 rows), HumanResources.EmployeeDepartmentHistory (296 rows) and HumanResources.Department (16 rows).
We will be running following two queries and observe the output. In the resultset the order of first column (EmployeeID) is different in both the cases when whole resultset is same. When compared both the results they are same but the order of rows is different in both the resultset. read more...
add a comment
|
category: Database | Views: 6
| 
|
tags:
Database | tag it
Everyones tags: | Your tags: | |
|
|
|
|
Sponsored Link: www.carlist.ie
Ads via The Lounge
|