News in the Category: SQL Subscribe to the rss of this category.

Total posts: 2411

LINQ to SQL Instantiation

ASPAlliance.com - The #1 ASP.NET Community, May 9, 2008

This article discusses how and when the objects within LINQ to SQL are created and instantiated, and how it maintains a list of the changes that need submitted to the database. It also discusses how t...

SQLXML 4.0 Not Installed in SQL Server 2008

XmlTeams WebLog, May 8, 2008

Prior to SQL Server 2008, SQLXML 4.0 was released with SQL Server and was installed by all SQL Server editions, except in SQL Server Express. Beginning Starting with SQL Server 2008, the latest versi...

Learn SQL Queries in DotNetNuke to reduce administration time

A DotNetNuke blog for tutorials, tips & tricks, May 8, 2008

So, its been a busy month on DNN Creative as weve stepped into the realms of SQL Queries. We've had several enquiries from the readers asking if we know of any ways to speed up the process of updati...

Converting SQL to LINQ, Part 10: Like (Bill Horst)

The Visual Basic Team, May 7, 2008

This post assumes youve read my previous Converting SQL to LINQ posts.   I havent had much in the way of specific requests for more LINQ posts, so Id still welcome any suggestions that people wan...

Silverlight, WCF and LINQ to SQL

John Papa, May 7, 2008

I've had some requests lately to write some articles that work with LINQ to SQL. I've ben focusing on the Entity Framework a lot due to its vast nature and that fact that its still relatively ...

There Is Always Risk In Portability

K. Scott Allen, May 7, 2008

After my last post, someone asked me if the "portable" repository pattern was really a good idea. He was referring to the fact the LINQ queries in the MVC Storefront and Background Motion applicatio...

Should repositories be tested in isolation?

Patrik Löwendahls shout, May 6, 2008

The last couple of years I've been using TDD as my main philosophy when writing code. In the beginning I was really static in my testing, everything was tested in isolation, but over time I've become ...

Speaking at the Patterns and Practices Summit

Guy Barrettes WebLog, May 6, 2008

I'm at the Patterns & Practices Summit in Quebec City and I'll give a talk about data access layer.  Sounds boring?  What if I mix some LINQ to SQL with some multi layered architect...

Microsoft Hiring Program Managers for SQL

Microsoft Certified Professional Magazine Online | News, May 5, 2008

Anyone interested in working for Microsoft on future editions of SQL Server might want to check out this blog post from Lead Program Manager Debra Dove....

Reports Aplenty

Microsoft Certified Professional Magazine Online | Todays Top Picks, May 5, 2008

WSUS' reports sometimes aren't enough -- tap SQL Server Management Studio Express Edition to get what you need....

Implementing SqlBulkCopy in Linq to Sql

Wortzels blog, May 5, 2008

As I already mentioned in one of my previous post, the SqlBulkCopy is a powerful tool which gives us an option to perform insertion for a large amount of data. The evolution of the ADO.NET creates us ...

Entity Framework Q&A - Lazy Loading, ObjectContext, and LINQ

John Papa, May 5, 2008

I've received hundreds of questions regarding the Entity Framework and LINQ. Obviously developers are very interested in the Entity Framework and its data access and modeling implications.  ...

Bad SQL Mistake For One Forum Goer

Jason N. Gaylords Blog, May 5, 2008

This isn't funny, but it is. It should be a daily WTF. Wally just sent me this forum post where someone deleted a little more than anticipated. It sounds like this guy can be in quite a lot of trouble...

GeoTwitter.Net is alive as an open source project.

Al Pascual, May 3, 2008

This post is part of a series about GeoTwitter and GeoRSS. I was in my spare time developing a proof of concept called GeoTwitter, after gathering all requirements I decide it to make the project open...

GeoTwitter.Net is alive as an open source project.

Al Pascual, May 3, 2008

This post is part of a series about GeoTwitter and GeoRSS. I was in my spare time developing a proof of concept called GeoTwitter, after gathering all requirements I decide it to make the project ope...

SQL SERVER - How to Rename Database Objects to Comply With Naming Conventions

Journey to SQL Authority with Pinal Dave, May 2, 2008

Christopher Miller read article of SQL SERVER Database Coding Standards and Guidelines Complete List Download and came up with wonderful SQL Server Script to rename all their database constraint with ...

Why there is still a limitation in LINQ to SQL?

Al Pascual, May 2, 2008

LINQ to SQL was going to be the solution that all developers have been asking for to be able to use databases. Now developers would be able to interact with a database using C# and SQL language togeth...

DotNetSlackers Article Published - Review: SQL Server Integration Services Using Visual Studio 2005 – A Beginners Guide

Pencil Bros. Geology, Inc., May 2, 2008

My first DotNetSlackers article has been published: Review: SQL Server Integration Services Using Visual Studio 2005 A Beginners Guide. Occasionally in life, the right thing shows up at the right ...

Why there is still a limitation in LINQ to SQL?

Al Pascual, May 2, 2008

LINQ to SQL was going to be the solution that all developers have been asking for to be able to use databases. Now developers would be able to interact with a database using C# and SQL language togeth...

SQLAuthority News - Write for SQLAuthority

Journey to SQL Authority with Pinal Dave, May 1, 2008

I always enjoy writing for my readers. Many times, I receive very good note, comments or article from my great experts of SQL Server. I really enjoy learning from my reader.If you are reader of SQLAut...

FIX: The value in the <ZIndex> tag for an item in the .rdl file is changed after you make a small change in a SQL Server 2005 Reporting Services report

kbAlertz.com :: Visual Studio 2005, May 1, 2008

950117 ... FIX: The value in the tag for an item in the .rdl file is changed after you make a small change in a SQL Server 2005 Reporting Services reportThis RSS feed provided by kbAlerz.com.Visit kb...

Count in LINQ using Lambda Expressions

Jason N. Gaylords Blog, May 1, 2008

I had a table that contained a couple of columns defined in SQL 2005 as tinyint. In SQL, I'd generally write something like: SELECT COUNT(EmailOptIn) FROM Members WHERE EmailOptIn = 1 O...

11 DotNetNuke Video Tutorials - Powerful Efficient Techniques for DotNetNuke Administration using SQL

A DotNetNuke blog for tutorials, tips & tricks, May 1, 2008

DNN Creative have released issue 32 of the DotNetNuke Magazine.This very special issue of DNN Creative Magazine is dedicated to improving the efficiency of your administration time with DotNetNuke.In ...

Linq to Sql support added to LLBLGen Pro

Frans Boumas blog, May 1, 2008

Imagine, you're sitting at your desk and you're using the Linq to Sql designer in VS.NET 2008 and you have, say, 50 entities in your model. You're happy about how things are progressing. It took a wh...

ASP.NET Connections Slides and Samples Posted

Rick Strahls WebLog, May 1, 2008

I've posted my session slides and samples from my ASP.NET Connections sessions last week in Orlando. I did three sessions at the conference and you can check out the slides and samples here. All three...

Introduction to SQL Queries with SQL Server Express, DotNetNuke and Vista - 4 Videos

DNN Creative Magazine for DotNetNuke, April 30, 2008

In this tutorial we provide a quick start guide to using SQL queries with SQL Server Express. In particular we demonstrate how to set up SQL Server Express so that you can execute SQL queries on your ...

SQL Queries for Exporting DotNetNuke Users and Working with Security Roles - 2 Videos

DNN Creative Magazine for DotNetNuke, April 30, 2008

In this tutorial we demonstrate using SQL queries for working with DotNetNuke security roles and users. Using SQL queries can help you to easily maintain and manipulate the registered user and securi...

Working with Shadow / Copied Modules and SQL in DotNetNuke - 5 Videos

DNN Creative Magazine for DotNetNuke, April 30, 2008

In this tutorial we demonstrate how to use shadow / copied modules. This is an essential and powerful administration task that can enhance your DotNetNuke portals and reduce administration time. Shad...

Issue 32 - Powerful Efficient Techniques for DotNetNuke Administration using SQL

DNN Creative Magazine for DotNetNuke, April 30, 2008

May 2008 Welcome to issue 32 of DNN Creative Magazine This is a very special issue dedicated to improving the efficiency of your administration ...

SQL SERVER - Find Table in Every Database of SQL Server - Part 2

Journey to SQL Authority with Pinal Dave, April 30, 2008

Yesterday I wrote about SQL SERVER - Find Table in Every Database of SQL Server. Today we will see another method how we can achieve the same result using Information_Schema view. Refer my previous ar...

SQL SERVER - Find Table in Every Database of SQL Server

Journey to SQL Authority with Pinal Dave, April 29, 2008

Just a day ago, one of the Jr. Developer requested that if I can help her with finding one particular table in every database on SQL Server. We have many Database Server and on some of the Database Se...

SSIS Packet Componentization

Simple Talk, April 29, 2008

In this article, David Leibowitz describes methods for scalable SQL Server 2005 Integration Services package creation. If youre no stranger to OOP, then the methods described will fit nicely in your e...

SQL SERVER - Download FAQ Sheet - SQL Server in One Page

Journey to SQL Authority with Pinal Dave, April 28, 2008

One of the most popular request I have received on this blog is to create one page which list all the SQL Server FAQs. SQL Server technology is very broad as well very deep. This is my humble attempt ...

SQL String User Function Workbench: part 2

Simple Talk, April 28, 2008

In which Robyn and Phil continue with their popular series on TSQL String User-functions. In this final episode, they pull together the themes from their TSQL String Array Workbench and String User Fu...

SQL SERVER - Query Analyzer Shortcuts - Part 2

Journey to SQL Authority with Pinal Dave, April 27, 2008

I enjoy reader’s articles to read as much as I enjoy expert’s articles. One of blog reader Praveen Barath always have good ideas to share. Here is Praveen Barath’s comment on my previous article Query...

Oh how type inference is missed

Granville Barnett, April 27, 2008

After using F# for a while I switched back to Haskell a few days ago (the project I was working on was done in Haskell a few years ago) and I must admit the explicit definition of a functions' type se...

SQL SERVER - Optimization Rules of Thumb - Best Practices - Readers Article

Journey to SQL Authority with Pinal Dave, April 26, 2008

This article has been written by blog reader and SQL Server Expert Praveen Barath in response to my previous article SQL SERVER - Optimization Rules of Thumb - Best Practices.Well Query Optimizations ...

SQL Injection Attacks on IIS Web Servers

Guy Barrettes WebLog, April 26, 2008

There have been conflicting reports about SQL Server injection attacks and a possible new IIS vulnerability. This is not related to a new IIS or SQL or ASP.NET vulnerability A bot is scanning th...

Encrypting and Decrypting Data to and from a Database

The Code Project Latest Articles, April 26, 2008

Automatically decrypt data when retrieving it from a database....

CodeSnip: How to make use of parameterized cursor in Oracle

ASPAlliance.com - The #1 ASP.NET Community, April 25, 2008

Often it is convenient to pass a given set of values as input parameter to a cursor. It is very useful where nested cursors are used. Parameterizing the cursor makes it more usable and avoids the limi...

All Hail King Nerd!

Did it with .NET, April 25, 2008

Jason Follas has done it again! He has trumped all of our feeble geeky efforts to firmly establish himself as the reigning "King Nerd." Over the years, Jason repeatedly has proven his ...

SQLAuthority News - Authors Personal Bookmarks

Journey to SQL Authority with Pinal Dave, April 25, 2008

Just like everybody else I also keep my personal bookmarks of websites. Recently I have reorganized my bookmarks in two categories. Please visit them and let me know your opinion.SQLAuthority BEST Art...

SQL SERVER - Optimization Rules of Thumb - Best Practices

Journey to SQL Authority with Pinal Dave, April 25, 2008

There are few rules for optimizing slow running query. Let us look at them one by one see how it can help.Rule # 1 : Always look at query plan first.I always start looking at query plan. There is alwa...

Using LINQ to SQL makes life easier. An introduction of LINQ to SQL.

Al Pascual, April 24, 2008

LINQ to SQL came out with 3.5 and I am still amazed that many people accomplished to stay away from that simple technology. When you ask them, they've heard about but they are not sure how everyth...

Using LINQ to SQL makes life easier. An introduction of LINQ to SQL.

Al Pascual, April 24, 2008

LINQ to SQL came out with 3.5 and I am still amazed that many people accomplished to stay away from that simple technology. When you ask them, they've heard about but they are not sure how everyth...

SQLAuthority News - Download Microsoft Office Visio 2007 Professional SQL Server Add-In

Journey to SQL Authority with Pinal Dave, April 24, 2008

Visio Infrastructure for SQL Servers is a tool which is meant for IT administrators who require constant interactions with the users for the installations of the SQL server in any IT infrastructure. V...

(Mis)Adventures with AdventureWorks

mikes web log, April 23, 2008

After many centuries (seemingly) of using Northwind as our sample database for examples in the code, we gradually moved over to using AdventureWorks. Among other reasons, we thought it would be handy ...

SQL Server 2005 datetime validation

RegexLib.com - Recent Patterns, April 23, 2008

This expression validates most legal dates for a SQL Server 2005 datetime format. It includes checking for leap years. (Written for a default U.S. install, not sure what results would be on versions f...

SQL SERVER - Converting Subqueries to Joins

Journey to SQL Authority with Pinal Dave, April 23, 2008

There are always more than one way to do one thing in any programming languages. In SQL Server there are always more than one way to achieve same result set. It is quite often I see that developers wr...

SQL SERVER - Better Performance - LEFT JOIN or NOT IN?

Journey to SQL Authority with Pinal Dave, April 22, 2008

First of all answer this question : Which method of T-SQL is better for performance LEFT JOIN or NOT IN when writing query? Answer is : It depends! It all depends on what kind of data is and what k...

Product Spotlight