News in the Category:
SQL 
Total posts: 2411
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...
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...
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...
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...
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 ...
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...
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 ...
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 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....
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....
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 ...
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. ...
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...
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...
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...
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 ...
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...
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 ...
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...
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...
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...
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...
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 ...
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...
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...
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 ...
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...
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...
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 ...
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...
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...
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...
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 ...
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...
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...
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...
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 ...
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...
The Code Project Latest Articles, April 26, 2008
Automatically decrypt data when retrieving it from a database....
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...
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 ...
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...
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...
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...
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...
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...
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 ...
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...
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...
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...