DotNetShoutout

SQL

3
Shouts

Shout it

AcroDB. Business Logic

posted by

http://oleksiy.myopenid.com/ 1136 days, 12 hours, 41 minutes ago

Previously I have talked only about entity creation and maintain. But what if we need to add some business logic to this entity. For example, we have a table of Pages, and you need to fetch all cities of some country? (more)

category: Data | clicked: 0 | comment | | source: oleksiy.squarespace.com

| flag as spam

tags: db migrations, C#, SQL, MongoDB, Linq, DB

3
Shouts

Shout it

Useful SQL Script to generate Countries & US States

posted by

deanomachino 1137 days, 16 hours, 59 minutes ago

Useful SQL Script to generate Countries & US States I'm currently working on a project where I need to quickly insert a list of Countries and Us States into a database table. This is not the first time that I've needed to have a useful script handy for this sort of thing. I had a quick look around the net and couldn't find exactly what I needed. So, I've put together two scripts, one to create a table of US States and one to create a table of Countries. Download the two scripts: Countries - her... (more)

category: Data | clicked: 0 | comment | | source: www.deanhume.com

| flag as spam

tags: SQL, scripts

4
Shouts

Shout it

Script Data in MS SQL Server 2008 Database Tables using Generate SQL Server Script Wizard

published 1138 days, 21 hours, 53 minutes ago posted by

eralper 1139 days, 22 hours, 32 minutes ago

Script Data in MS SQL Server 2008 Database Tables using Generate SQL Server Script Wizard MS SQL Server 2008 has new Generate Scripts option which enables sql programmers to script data in SQL Server database tables. SQL developers can script data from sql tables into a script file, to the clipboard or script data on a new sql query window. Script data can be used to export and/or import table data from one database to another database. The Script Data option creates INSERT statements foreach row ... (more)

category: Data | clicked: 0 | comment | | source: www.kodyaz.com

tags: SQL 2008, SQL, script data

3
Shouts

Shout it

Database Publishing Wizard – Generate Script for Schema and Data

published 1138 days, 21 hours, 53 minutes ago posted by

Praveen 1140 days, 1 hour, 42 minutes ago

Easily Secure SharePoint Documents Based on Metadata. By Titus Labs. When working with databases we may get a requirement to generate the script for the schema and sometimes generate the script for data too. For generating script for Schema is what we will do usually in the projects, but generating the script for data is not everyone requirement. But sometimes we need to do that as well. So this article explains both generating the script for Schema and data. There is a cool feature from Microsoft sql... (more)

category: Data | clicked: 0 | comment | | source: praveenbattula.blogspot.com

tags: Data Publishing, SQL, script

7
Shouts

Shout it

SQL SERVER – Retrieve and Explore Database Backup without Restoring Database – Idera virtual database « Journey to SQL Authority with Pinal Dave

published 1139 days, 22 hours, 39 minutes ago posted by

pinaldave 1141 days, 22 hours, 59 minutes ago

I recently downloaded Idera’s SQL virtual database, and tested it. There are a few things about this tool which caught my attention. My Scenario It is quite common in real life that sometimes observing or retrieving older data is necessary; however, it had changed as time passed by. The full database backup was 40 GB in size, and, to restore it on our production server, it usually takes around 16 to 22 minutes, depending on the load server that is usually present. This range in time varies from one ser... (more)

category: Data | clicked: 1 | comment | | source: blog.sqlauthority.com

tags: SQL, SQLServer, pinaldave, SQLAuthority

5
Shouts

Shout it

Marquee de Sells: Chris's insight outlet - Chris Sells

published 1141 days, 21 hours, 19 minutes ago posted by

jantu 1142 days, 17 hours, 53 minutes ago

The "db" was an EF object context object, but it could just as easily been a LINQ to SQL context. Once I ran this code, it failed at run-time with a null reference exception on Category. "That's strange," I thought. "Some of my categories are null, but I expect the 'like' operation in SQL to which Contains maps to skip the null values." That should've been my first clue.Clue #2 was when I added the null check into my Where expression and found that their were far fewer results than I expected. Some exper... (more)

category: How To | clicked: 0 | comment | | source: sellsbrothers.com

tags: EF, SQL, Linq

3
Shouts

Shout it

Sql Server error message

posted by

Praveen 1143 days, 14 hours, 7 minutes ago

If your Sqlserver gives error like "don't allow remote connections" etc…. Or error like A connection was successfully established with the server, but then an error occurred during the login process. (provider: Named Pipes Provider, error: 0 - No process is on the other end of the pipe.) Main cause for this error is, you are trying to connect to remote sqlserver, but on that server, remote connections option was disabled. Do th... (more)

category: Data | clicked: 0 | comment | | source: praveenbattula.blogspot.com

| flag as spam

tags: SQL

4
Shouts

Shout it

Daily tech links for .net and related technologies - Apr 5-7, 2010 - Sanjeev Agarwal

posted by

sanjeevana 1146 days, 2 hours, 40 minutes ago

HTML 5 is Born Old - Quake in HTML 5 Example, Image Preview in ASP.NET MVC - Imran, Advanced ASP.NET MVC 2 - Brad Wilson, How to Serialize/Deserialize Complex XML in ASP.Net / C# - Impact Works, Ban HTML comments from your pages and views - Bertrand Le Roy , Measuring ASP.NET and SharePoint output cache - Gunnar Peipman, Eye Candy vs. Bare-Bones in UI Design - Max Steenbergen , Empathizing Color Psychology in Web Design - Anastasia Miles Design is a Side Effect - Cranky , Contrast is King -... (more)

category: Web Dev | clicked: 0 | comment | | source: weblogs.asp.net

| flag as spam

tags: SQL, Web Service, UX, Agile, Architecture, Ajax

7
Shouts

Shout it

html, css, php, javascript and more cheat sheets

published 1142 days, 19 hours, 5 minutes ago posted by

http://quachnguyen.myopenid.com/ 1146 days, 15 hours, 26 minutes ago

HTML, CSS, PHP, javascript And More Cheat Sheets | 2.31 MB Cheat sheets are really helpful in revising the codes as there are so many codes which we cannot remember always but cheat sheets are of great help in keeping yourself updated with the codes. Cheat sheets are also helpful for beginner developers and designers in learning and remembering codes better. A truly great resource for upcoming developers. The purpose of this post is to provide all the cheat sheets useful for designers and develope... (more)

category: Web Dev | clicked: 0 | comment | | source: code2code.info

tags: SQL, JavaScript, CSS, HTML

4
Shouts

Shout it

Download SQL Server 2008 R2 Developers Training Kit

published 1148 days, 18 hours, 29 minutes ago posted by

eralper 1149 days, 18 hours, 52 minutes ago

With the t-sql enhancements and t-sql improvements introduced with MS SQL Server 2005 and with MS SQL Server 2008, coding in t-sql is enabling many difficult tasks to be implemented easier in less code. (more)

category: Data | clicked: 0 | comment | | source: www.kodyaz.com

tags: Training, SQL, SQLSERVER2008, SQLServer

5
Shouts

Shout it

SQL SERVER – World Shapefile Download and Upload to Database – Spatial Database « Journey to SQL Authority with Pinal Dave

published 1150 days, 22 hours, 8 minutes ago posted by

pinaldave 1151 days, 16 hours, 24 minutes ago

During my recent, training I was asked by a student if I know a place where he can download spatial files for all the countries around the world, as well as if there is a way to upload shape files to a database. Here is a quick tutorial for it. VDS Technologies has all the spatial files for every location for free. You can download the spatial file from here. If you cannot find the spatial file you are looking for, please leave a comment here, and I will send you the necessary details. Unzip the file to... (more)

category: Data | clicked: 0 | comment | | source: blog.sqlauthority.com

tags: SQL Server, SQL, pinaldave, SQLAuthority

3
Shouts

Shout it

Sample T-SQL Cursor Example Code

posted by

eralper 1152 days, 13 hours, 22 minutes ago

T-SQL Cursor Example Code Here is a T-SQL cursor example code created for looping selecting a list of email addresses for emailing. The select query in the definition of the example t-sql cursor returns the ex... (more)

category: Data | clicked: 1 | comment | | source: www.kodyaz.com

| flag as spam

tags: cursors, SQL, syntax, T-SQL

4
Shouts

Shout it

Daily tech links for .net and related technologies - Mar 29-31, 2010 - Sanjeev Agarwal

published 1152 days, 2 hours, 33 minutes ago posted by

sanjeevana 1152 days, 23 hours, 26 minutes ago

Querying the Future With Reactive Extensions - Phil Haack, Creating an OData API for StackOverflow including XML and JSON in 30 minutes - Scott Hanselman, MVC Automatic Menu - Nuri Halperin, jqGrid for ASP.NET MVC - TriRand Team, Foolproof Provides Contingent Data Annotation Validation for ASP.NET MVC 2 -Nick Riggs, Using FubuMVC.UI in asp.net MVC : Getting started - Cannibal Coder, Building A Custom ActionResult in MVC 2 To Download Excel Files - Malcolm Sheridan, Dynamic Select Lists with MVC and jQuer... (more)

category: Web Dev | clicked: 1 | 1 comment | | source: weblogs.asp.net

tags: SQL, Web Service, UX, Architecture, Ajax

4
Shouts

Shout it

Daily tech links for .net and related technologies - Mar 26-28, 2010 - Sanjeev Agarwal

published 1154 days, 20 hours, 45 minutes ago posted by

sanjeevana 1155 days, 23 hours, 57 minutes ago

Creating Rich View Components in ASP.NET MVC - manzurrashid, Diagnosing ASP.NET MVC Problems - Brad Wilson, Templated Helpers & Custom Model Binders in ASP.NET MVC 2 - gshackles, The jQuery Templating Plugin and Why You Should Be Excited! - Chris Love, Web Deployment Made Awesome: If You're Using XCopy, You're Doing It Wrong - Scott Hansleman, Dynamic User Specific CSS Selection at Run Time - Misfit Geek, Sending email from ASP.NET MVC through MVC and MSMQ Part 2 - Andrew Siemer, Data W... (more)

category: Web Dev | clicked: 0 | comment | | source: weblogs.asp.net

tags: Silverlight, C#, SQL, Web Service, Architecture, MVC 2, Ajax

6
Shouts

Shout it

Daily tech links for .net and related technologies - Mar 23-25, 2010 - Sanjeev Agarwal

posted by

sanjeevana 1159 days, 2 hours, 12 minutes ago

Introducing Browsers Providers in ASP.NET 4 - osbornm, ASP.NET 4.0 Part 14, More Control Over Session State - hmobius, Editable MVC Routes (Apache Style) - nberardi, ASP.NET Performance Framework - karlseguin, Silverlight 4 + RIA Services - Ready for Business: Localizing Business Application - Brad Abrams, Make your Silverlight applications Speak to you with Microsoft Translator and Simulate Geo Location in Silverlight Windows Phone 7 emulator - Tim Heuer, Styles for XAML (Silverlight & WPF) - ... (more)

category: Web Dev | clicked: 0 | comment | | source: weblogs.asp.net

| flag as spam

tags: Silverlight, SQL, Web Service, UI, Architecture, Ajax

5
Shouts

Shout it

How To Drop All Indexes From A Database

published 1160 days, 17 hours, 22 minutes ago posted by

HatimR 1160 days, 22 hours, 44 minutes ago

I was doing some performance tweaking of a batch job that was hanging and i was suspecting the indexes in the database to have something to do with it shocking up so I used this script to clear all indexes. (more)

category: Data | clicked: 0 | comment | | source: hatim.indexdev.net

tags: Dropping Indexes, SQL

7
Shouts

Shout it

SQL SERVER – Interview Questions & Answers Needs Your Help « Journey to SQL Authority with Pinal Dave

published 1162 days, 19 hours, 52 minutes ago posted by

pinaldave 1163 days, 4 hours, 26 minutes ago

About an year ago, I had posted SQL Server related Interview Questions and Answers. It was very well received in community. I have received many comments, suggestions and emails on this subject. I am planning to upgrade the Interview Questions and Answers and take it to next level. Here, I need your help. Please your comments, suggestions, expectation or potential interview Question (along with answer) here. Your input will be very valuable. As time goes by we all learn and get better. There were few th... (more)

category: Data | clicked: 0 | 1 comment | | source: blog.sqlauthority.com

tags: SQL, SQLServer, pinaldave, SQLAuthority

4
Shouts

Shout it

Daily tech links for .net and related technologies - Mar 18-21, 2010 - Sanjeev Agarwal

posted by

sanjeevana 1163 days, 21 hours, 25 minutes ago

TDD kata for ASP.NET MVC controllers (part 2) -David, Take Control Of Web Control ClientID Values in ASP.NET 4.0 - Scott Mitchell, Inside the ASP.NET MVC Controller Factory - Dino Esposito, Microsoft, jQuery, and Templating - stephen walther, Cross Domain AJAX Request with YQL and jQuery - Jeffrey Way, T4MVC Add-In to auto run template -Wayne...... (more)

category: Web Dev | clicked: 0 | comment | | source: weblogs.asp.net

| flag as spam

tags: Silverlight, SQL, Architecture, Ajax, WCF

7
Shouts

Shout it

SQL SERVER – Difference Between ROLLBACK IMMEDIATE and WITH NO_WAIT during ALTER DATABASE « Journey to SQL Authority with Pinal Dave

published 1163 days, 20 hours, 16 minutes ago posted by

pinaldave 1164 days, 20 hours, 56 minutes ago

Today, we are going to discuss about something very simple, but quite commonly confused two options of ALTER DATABASE. The first one is ALTER DATABASE …ROLLBACK IMMEDIATE and the second one is WITH NO_WAIT. Many people think they are the same or are not sure of the difference between these two options. Before we continue our explaination, let us go through the explanation given by Book On Line. ROLLBACK AFTER integer [SECONDS] | ROLLBACK IMMEDIATE Specifies whether to roll back after a specified numb... (more)

category: Data | clicked: 0 | comment | | source: blog.sqlauthority.com

tags: SQL, SQLServer, pinaldave, SQLAuthority

9
Shouts

Shout it

Entity Framework 4.0: Optimal and horrible SQL

published 1163 days, 20 hours, 16 minutes ago posted by

gpeipman 1165 days, 21 hours, 57 minutes ago

Lately I had Entity Framework 4.0 session where I introduced new features of Entity Framework. During session I found out with audience how Entity Framework 4.0 can generate optimized SQL. After session I also showed guys one horrible example about how awful SQL can be generated by Entity Framework. In this posting I will cover both examples. (more)

category: How To | clicked: 0 | 1 comment | | source: weblogs.asp.net

tags: OR/M, SQL, entity framework 4.0

Welcome!

SQL

AcroDB. Business Logic

Useful SQL Script to generate Countries & US States

Script Data in MS SQL Server 2008 Database Tables using Generate SQL Server Script Wizard

Database Publishing Wizard – Generate Script for Schema and Data

SQL SERVER – Retrieve and Explore Database Backup without Restoring Database – Idera virtual database « Journey to SQL Authority with Pinal Dave

Marquee de Sells: Chris's insight outlet - Chris Sells

Sql Server error message

Daily tech links for .net and related technologies - Apr 5-7, 2010 - Sanjeev Agarwal

html, css, php, javascript and more cheat sheets

Download SQL Server 2008 R2 Developers Training Kit

SQL SERVER – World Shapefile Download and Upload to Database – Spatial Database « Journey to SQL Authority with Pinal Dave

Sample T-SQL Cursor Example Code

Daily tech links for .net and related technologies - Mar 29-31, 2010 - Sanjeev Agarwal

Daily tech links for .net and related technologies - Mar 26-28, 2010 - Sanjeev Agarwal

Daily tech links for .net and related technologies - Mar 23-25, 2010 - Sanjeev Agarwal

How To Drop All Indexes From A Database

SQL SERVER – Interview Questions & Answers Needs Your Help « Journey to SQL Authority with Pinal Dave

Daily tech links for .net and related technologies - Mar 18-21, 2010 - Sanjeev Agarwal

SQL SERVER – Difference Between ROLLBACK IMMEDIATE and WITH NO_WAIT during ALTER DATABASE « Journey to SQL Authority with Pinal Dave

Entity Framework 4.0: Optimal and horrible SQL

Open ID Login

Standard Login

Forgot Password?

Sign up