SQL Server 2008 - Cheat Sheet - One Page PDF Download

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

Avoid the Managed Extensibility Framework

tirania.org — As a .NET developer, you should avoid using the newly released Managed Extensibility Framework as its license prevents its use beyond the Windows platform. This will prevent your .NET software from running on Linux or MacOS in the future. Luckily, there is a cross platform solution available today that has no platform limitations: Mono.Addins. read more...

add a comment | category: Mono | Views: 13

SQL SERVER - 2005 - Difference Between INTERSECT and INNER JOIN

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

SQL SERVER - How to Retrieve TOP and BOTTOM Rows Together using T-SQL

published 8 months, 19 days ago, submitted by pinaldave 8 months, 19 days ago

blog.sqlauthority.com — UNION ALL does not work all the time. There is great discussion about it. If you have any suggestion, please provide it. read more...

4 comments | category: Database | Views: 12

Type less in SQL Server 2008 (variable init and multi row inserts)

published 8 months, 25 days ago, submitted by powerrush 8 months, 25 days ago

simple-talk.com — Among the large number of new features in SQL Server 2008 there are two, almost insignificant features, that I use almost constantly. These are variable initialization and the values clause of insert statements that now accept multiple rows. read more...

add a comment | category: Database | Views: 5

AlligatorTags.com - The PopURLs.com for ASP.net

alligatortags.com — Aggregating the latest ASP.net news, tips and tricks from across the web in one place, refreshed daily. read more...

5 comments | category: ASP.NET | Views: 3

MSDN Reader!! A Must Have Application!

aneef.net — he MSDN Reader allows you to browse through MSDN Magazine articles like never before. Read through articles, view figures and code snippets in an intuitive and easy-to-use experience. read more...

1 comment | category: Windows Presentation Foundation | Views: 11

An easier Table Design View in Sql Server Management Studio

published 9 months, 28 days ago, submitted by rstrahl 9 months, 29 days ago

west-wind.com — One of the things that bugs me no end in Sql Server Management Studio is that the table designer's UI is a pain to use. Entering column properties is an excercise in mousercise. It turns out there's an easier way to do this with custom views in the DataBase Diagram Designer. read more...

3 comments | category: Database | Views: 13