News in the Category:
SQL 
Total posts: 2584
Journey to SQL Authority with Pinal Dave, July 25, 2008
I frequently get request for SQLAuthority T-Shirts. After continuous requests from many of loyal readers, I am posting link to SQLAuthoirty Products.SQLAuthority ProductsI have no intention to make mo...
Simple Talk, July 24, 2008
Some reasons for the slow-running of database applications aren't obvious. Occasionally, even the profiler won't tell you enough to remedy a problem, especially when a SQL Statement is being forced to...
Journey to SQL Authority with Pinal Dave, July 24, 2008
Just a day ago, I was wondering how many active transaction are currently in my database. I found following DMV very useful - very simple and to the point.Following SQL will return currently active tr...
ASP.NET Announcements, July 24, 2008
Normal
0
false
false
false
EN-US
X-NONE
X-NONE
...
Journey to SQL Authority with Pinal Dave, July 24, 2008
Just a day ago, I was wondering how many active transaction are currently in my database. I found following DMV very useful - very simple and to the point.Following SQL will return currently active tr...
Guy Barrettes WebLog, July 23, 2008
The problemYou have SQL Servers for each of your environments (development, test, pre-prod, production) and in each one, the table names are different. In fact, its not the table names that are ...
Journey to SQL Authority with Pinal Dave, July 23, 2008
SQL Server log data is very important for any DBA to troubleshoot SQL Server related problems. In SQL Server 2000 there was no facility to check System and Application log, however in SQL Server 2005 ...
Journey to SQL Authority with Pinal Dave, July 22, 2008
If SQL Server is running slow and operations are throwing errors due to lack of memory, it is necessary to look into memory issue. If SQL Server is restarted all the cache memory is automatically clea...
Simple Talk, July 21, 2008
Retrieving a build script from a backup, or synchronising a database schema with the version in a backup is a time-consuming chore. Well, it is'nt now, if you use SQL Compare 7. SQL Compare 7 now allo...
Journey to SQL Authority with Pinal Dave, July 21, 2008
Ahmedabad SQL Server User Group is just 2 months old chapter but it is getting extremely popular among enthusiastic IT professionals. I have joined this group and suggest all the developers of Ahmedab...
Journey to SQL Authority with Pinal Dave, July 20, 2008
Just two day ago, I wrote small note about SQL SERVER - Introduction to Service Broker.Yesterday I wrote article where Service Broker throws error due to it is using same port as other application SQL...
Journey to SQL Authority with Pinal Dave, July 19, 2008
If you face following error the solution of this is very simple.Error : 9692 The _MSG protocol transport cannot listen on port because it is in use by another process.Above error comes up with Service...
Federal Developer Weblog, July 18, 2008
In this screencast, I show you how to draw a polygon on a Virtual Earth map and save it using ASP.NET AJAX, Windows Communication Foundation (WCF), LINQ to SQL, and the new geography data type in SQL ...
Federal Developer Weblog, July 18, 2008
In this screencast, I build off of the concepts shown in my previous screencast and show you how to render a polygon on a Virtual Earth map using REST, Windows Communication Foundation (WCF), LINQ to ...
Journey to SQL Authority with Pinal Dave, July 18, 2008
It has been long time since I have updated my personal book mark list. I have just refreshed it. You are all welcome to checkout my personally picked articles.SQLAuthority Best ArticlesSQLAuthority Fa...
Journey to SQL Authority with Pinal Dave, July 18, 2008
Service Broker is message queuing for SQL Server. It is used for sending emails and through Database Mails. You can read about SQL SERVER - Difference Between Database Mail and SQLMail here. Service B...
the telerik blogs, July 17, 2008
As I mentioned in one of my previous posts with RadGrid for ASP.NET AJAX Q2 2008 you can access the grid sort and filter expressions on the client.
While filter expressions toString() method will crea...
InfoWorld: Web services, July 17, 2008
Katmai, the code name for Microsoft's imminent SQL Server 2008 release, comes from an Alaskan territory know for volcanoes, which may not be the best symbol for a database. So far, however, Katmai has...
Journey to SQL Authority with Pinal Dave, July 17, 2008
I will be attending Ahmedabad SQL Server Usergroup Meeting on July 19, 2008. I will be taking session about “SQL Server Best Practices“. I invite all of the SQL enthusiastic to stop by User Group Meet...
Journey to SQL Authority with Pinal Dave, July 16, 2008
eaders are very important to me. Without their active participation this site would not be the community helping web site. I encourage readers participation and request that you help other users with ...
4GuysFromRolla.com Headlines, July 16, 2008
Last week's article, Using a Dynamic IN Clause, showed how to display detail records
for a set of user-selected master records. This entailed creating a User Defined Function
(UDF) in the database t...
DevX: .NET Feed, July 15, 2008
Learn how to use Visual Studio.NET to debug SQL Server stored procedures....
Federal Developer Weblog, July 15, 2008
I've been having some issues getting my VPC updated to SQL Server 2008 RC0 and Visual Studio 2008 SP1 Beta so I can record a couple screencasts on using Virtual Earth with SQL Server 2008. I swe...
Joe Brinkman, July 14, 2008
Had a few requests for more details on how Im auto packaging and developing the Help. So here it is.
xmlversion="1.0"encoding="utf-8"?>
ProjectDefaultTargets="Build"xmlns="http://schemas.micros...
Joe Brinkman, July 14, 2008
I have been rewriting the Help Module using Test Driven Development Techniques. This means that I write a unit test or 4 for each piece of functionality. The test results look like this:
I have been ...
Journey to SQL Authority with Pinal Dave, July 14, 2008
Previously I wrote about SQL SERVER - 2008 - Introduction to SPARSE Columns. Let us understand the concept of SPARSE column in more detail. I suggest you read the first part before continuing reading ...
K. Scott Allen, July 14, 2008
I recently had some time on airplanes to read through Bitter EJB, POJOs in Action, and Better, Faster, Lighter Java. All three books were good, but the last one was my favorite, and was recommen...
Journey to SQL Authority with Pinal Dave, July 13, 2008
It is very good to know our server and its feature which are available for configurations. SQL Server 2008/2005/2000 always have many feature which can be enabled or disabled. One should atleast know ...
Journey to SQL Authority with Pinal Dave, July 12, 2008
Just a day ago, I noticed ’sysadmin’ user in SQL Server 2008. While looking more into it, I found that it has same account rights as ’sa’ account. ’sysadmin’ is actually replacement for legacy ’sa’ ac...
DevX: .NET Feed, July 11, 2008
ASP.NET 3.5 and LINQ provide the greatest amount of functionality yet for building data-aware web applications. Even if you prefer to write stored procedures, you can still leverage some of LINQ to SQ...
Microsoft Certified Professional Magazine Online | News, July 10, 2008
Redmond divulges tidbits of SQL Server 2008 release information at this week's Worldwide Partner Conference....
FTPOnline ASP.NET Channel, July 10, 2008
After some speculation that the final release of SQL Server 2008 may slip yet another quarter, Microsoft said its next-generation database is on pace to ship in the third quarter....
Journey to SQL Authority with Pinal Dave, July 10, 2008
I have been writing recently about how SQL Server 2008 is better in terms of Data Stage and Backup Management. I have received very good replies from many users and have requested to write more about ...
the telerik blogs, July 10, 2008
Very often you need to use RadDatePicker inside a grid or list component and if you have lots of records the standard approach is not the best choice. Example: <telerik:RadGrid ID="RadGri...
Jeffrey Palermo, July 9, 2008
It's no secret that we at Headspring Systems use NHibernate for data access in the custom software systems we deploy. I, personally, have been using NHibernate since 2005 when version 0.8 was cu...
Jeffrey Palermo, July 9, 2008
It's no secret that we at Headspring Systems use NHibernate for data access in the custom software systems we deploy. I, personally, have been using NHibernate since 2005 when version 0.8 was cu...
Journey to SQL Authority with Pinal Dave, July 9, 2008
Sometimes things just go very convenient and we wish that how come it was not available in earlier versions.Let us see two features here. If it was SQL Server earlier versions we might have to write m...
ASPAlliance.com - The #1 ASP.NET Community, July 9, 2008
In this article, Liam examines the implementation of the Repository pattern with the help of a LINQ to SQL application using C#. The article starts with a brief overview of the pattern and delves deep...
4GuysFromRolla.com Headlines, July 9, 2008
The master/detail report pattern is used to display information in two database tables that share a one-to-many relationship. Typically the user is shown
a list of the master records and can pick one...
Steven Smith, July 9, 2008
Finally have a few minutes to play with Velocity, Microsoft's new distributed cache offering that's currently in CTP1 status (since a month ago at TechEd Developers in Orlando). Read the officia...
K. Scott Allen, July 9, 2008
In the BI space Ive seen a lot of SQL queries succumb to complexity. A data extraction query adds some joins, then some filters, then some nested SELET statements, and it becomes an unhealthy mess in ...
Steven Smith, July 8, 2008
It's still quite painful to try and test code that relies on ASP.NET Caching. Now, I love caching. Ask anybody. But testing around it can pretty much suck. The biggest source o...
ASPAlliance.com - The #1 ASP.NET Community, July 8, 2008
Many times beginning Crystal Reports authors overlook the powerful feature of cross tabs, in this article we discuss the basics of creating and formatting cross tabulations in Crystal Reports 2008....
JohnPapa.net, July 8, 2008
Tuesday evening I will be presenting at the Miramar .NET User Group in Miramar Florida, sponsored by INETA. The topic will be the Entity Framework, one which I am always excited to talk about! If you ...
Journey to SQL Authority with Pinal Dave, July 8, 2008
It is very simple to find out the space used by any table in database.USE AdventureWorks;GOEXEC sp_spaceused ‘Sales.Customer’;GOReference : Pinal Dave (http://www.SQLAuthority.com)...
Journey to SQL Authority with Pinal Dave, July 6, 2008
In my previous article SQL SERVER - 2008 - Introduction to New Feature of Backup Compression I wrote about Row Compression and I have received many request to write in detail about Row Compression. I ...
Journey to SQL Authority with Pinal Dave, July 5, 2008
In recent user group meeting in my city Ahmedabad, I have found that not every user knows difference between these two features of SQL Server. I do not blame any user for not knowing difference betwee...
kbAlertz.com :: ASP.NET 1.1, July 4, 2008
954838 ... The user account must have the db_owner permission to store information about the ASP.NET session state in the SQL Server databaseThis RSS feed provided by kbAlerz.com.Visit kbAlertz.com to...
Simple Talk, July 4, 2008
Simple-Talk's Geek of the Week is Dr Richard Hipp. His code is probably running on your PC, and running completely reliably, for he almost single-handedly wrote SQLite, the most widely deployed SQL Da...
Journey to SQL Authority with Pinal Dave, July 4, 2008
I received following email yesterday from Satnam Singh- Computer Programmer from Bangalore.“Dear Pinal,Congratulations for being MVP. You truely deserved it.I wonder why have you never written newly i...