|
|
|
|
|
Total Hits: 1 | Today: 0
|
Author: Vivek Johari
|
Rating:
|
|
Sometimes we need a column whose values can uniquely identifying the rows in the table. To achieve this purpose, this column should contains the unique values and it can’t contains the NULL or empty values. We can use this column in the “Where” clause of the Select statement to retrieve the data from the table quickly....
|
|
|
|
Total Hits: 21 | Today: 0
|
Author: M.M.Al-Farooque Shubho
|
Rating:
|
|
We are in the process of optimizing an SQL Server database, and so far we have done lots of things. We applied indexing in our database tables and then re-factored the TSQL’s to optimize the data access routines. If you are wondering where we did all these and what are the things we have exactly done, take a look at the following articles in this series:
Top 10 steps to optimize data access in SQL Server. Part I (Use Indexing)...
|
|
|
|
Total Hits: 38 | Today: 0
|
Author: Muhammad Shujaat Siddiqi
|
Rating:
|
|
LINQ To SQL is great as an ORM tool. Not only it provides ease of access to data in our data oriented applications. It is also very easy to learn. In this article we will be discussing about SET based operations for database operations using LINQ To SQL....
|
|
|
|
Total Hits: 138 | Today: 0
|
Author: Jeff Prosise
|
Rating:
|
|
Now that ASP.NET 2.0 is a shipping product, it seems appropriate to revisit an issue that tops the new features wish lists of many developers: a SQL Server™ site map provider.
As you probably know, ASP.NET 2.0 vastly simplifies the process of building data-driven site navigation interfaces. You build a site map, slap a SiteMapDataSource control onto the page, and bind a Menu or TreeView control to the SiteMapDataSource. The SiteMapDataSource uses the default site map provider (typically XmlSi...
|
|
|
|
Total Hits: 76 | Today: 0
|
Author: novick software
|
Rating:
|
|
After the recent destruction of IIS based Web sites by the CodeRed and NIMBDA viruses, insuring security for Web applications has become everyone's job. This article gives a plan for recovering from virus attacks, securing the server and protecting from further attacks. It points the user directly resources that can speed the process. The outline of the plan is:
1. Recover from Infection or Rebuild
2. Install Operating System Upgrades and Patches
3. Verify that the system is...
|
|
|
|
Total Hits: 99 | Today: 0
|
Author: Narayana Vyas Kondreddi
|
Rating:
|
|
Experts from within and outside Microsoft have always said that running Profiler on a production environment is not a recommended practice, as it could degrade the performance of the server. Instead they suggest doing server side tracing via SQL Trace system stored procedures. But DBAs often questioned this by asking, what if I profile the production server, from a different PC? Well, I haven't heard a convincing answer to this whole thing about Profiler vs. server side tracing yet, but I attend...
|
|
|
|
Total Hits: 218 | Today: 0
|
Author: .NETDJ News Desk
|
Rating:
|
|
TimeSpring Software Corporation has announced the availability of a free version of its TimeData continuous data protection (CDP) software, which allows SQL Server 2005 Customer Technology Preview (CTP) users to test and migrate real-time production data from SQL Server 2000 without shutting down, slowing down or exporting data, the company says....
|
|
|
|
Total Hits: 151 | Today: 0
|
Author: Paragon Corporation
|
Rating:
|
|
In this article we will delve into the features of the PostgreSQL object-relational database environment and what makes it special. We will focus on features that make PostgreSQL different from most relational database management systems (RDBMS)....
|
|
|
|
Total Hits: 97 | Today: 0
|
Author: Jesper Lind and Scott Oveson
|
Rating:
|
|
This article steps through the process of implementing a plug-in viewer and integrating the viewer into Analysis Services. Provides stub code to enable viewer developers to quickly write a plug-in viewer into Analysis Services....
|
|
|
|
Total Hits: 152 | Today: 0
|
Author: Muthusamy Anantha Kumar aka The MAK
|
Rating:
|
|
Part 1 and Part 2 of this series discussed Power Shell installation and simple SMO, WMI cmdlets. Part 3 covered how to script PowerShell and connect to SQL Server.
Part 4 explained how to use a PowerShell script to loop through the content of a file and connect to different servers. Part 5 examined creating a SQL Server database using PowerShell and SMO. Part 6 talked about backing up a SQL Server database using PowerShell and SMO. Part 7 illustrated how to list all of the objects in a da...
|
|
|
|
Total Hits: 189 | Today: 0
|
Author: Ty Anderson
|
Rating:
|
|
In the past 12 months, Microsoft has released major versions of Visual Studio (Team System), SQL Server, Windows, SharePoint, and Office. Any one of these products alone would provide enough new features and development possibilities to keep me writing into next year (both code and articles!). Clearly it is a monumental year in Redmond and they aren't finished, as the release of Windows Server 2008 looms later this year.
Windows Server 2008 promises to be a boon to developers because it provi...
|
|
|
|
Total Hits: 201 | Today: 0
|
Author: Brian Kelley
|
Rating:
|
|
Query Analyzer offers a highly configurable integrated development environment (IDE). Some of the areas Brian looks at are how to modify the fonts and colors, set connection settings, choose scripting options, and customizing file and result set options. Learn how to make the most of the IDE and make it work for you. In this article we'll look at:
Customizing the toolbar
Editing shortcuts
Adding custom tools
Setting file options
Configuring the editor
Setting result output...
|
|
|
|
Total Hits: 173 | Today: 0
|
Author: MSDN
|
Rating:
|
|
The top of the stack is the API or object library layer. Applications connect to Microsoft® SQL Server through either API functions or interfaces exposed by an object library. Examples of APIs used to access SQL Server include ODBC and DB-Library. Examples of object libraries used to access SQL Server include OLE DB, ADO, and ADO.NET. Because ADO ultimately uses OLE DB to communicate with the server, there are really just two object libraries commonly used by Windows applications to communicate ...
|
|
|
|
Total Hits: 572 | Today: 0
|
|
Rating:
|
|
Hierarchies are sometimes difficult to store in SQL tables...things like trees, threaded forums, org charts and the like...and it's usually even harder to retrieve the hierarchy once you do store it. Here's a method that's easy to understand and maintain, and gives you the full hierarchy (or any piece of it) very quickly and easily....
|
|
|
|
Total Hits: 511 | Today: 0
|
|
Rating:
|
|
This step-by-step article demonstrates how to program the SQL Snapshot and SQL Distribution controls by using Microsoft Visual C# .NET. You can use the SQL Server 2000 Replication ActiveX controls to embed replication functionality in custom applications....
|
|
|
|
Total Hits: 5569 | Today: 0
|
|
Rating:
|
|
This comprehensive collection of SQL Server database interview questions help you prepare for your interviews....
|
|
|
|
Total Hits: 3322 | Today: 0
|
Author: Jesudas Chinnathampi
|
Rating:
|
|
This article is a continuation of the article "Inserting Images into SqlServer in ASP .NET". In this discussion, we will see, how to retreive an image from SqlServer database in ASP .NET. We need to take care of two aspects while displaying/retrieving ....
|
|
|
|
Total Hits: 2594 | Today: 0
|
Author: Jesudas Chinnathampi
|
Rating:
|
|
Read this article to know about, how to insert an image into a SqlServer database. You will also learn about the prerequistes for inserting an image into SqlServer. All aspects that need to take care in ASPX page and in database are discussed..............
|
|
|
|
Total Hits: 20 | Today: 0
|
Author: Shabdar Ghata
|
Rating:
|
|
This sample code explains you how you can store images in SQL Server database. It uses ADO.Net System.Data.SqlClient namespace. Images can be stored in sql server using Sql parameters....
|
|
|
|
Total Hits: 76 | Today: 0
|
Author: Amir Netz
|
Rating:
|
|
Today's organizations rely on highly sophisticated and complex analysis of the information stored in their databases. In the past, a uniform and easy calculation was common—for example, one that tracks the movement of products to and from a single warehouse. Now, database analysis in business domains, such as securities, account balances, budgets, and insurance policies and claims, is semiadditive—straightforward with some factors and variable with others, notably when tracking data over time. F...
|
|
|
|
|
|
