Dell
Dell & VMware Deliver the Enterprise Hybrid Cloud
SQL Server
 Our new SQL 2012 just released. I get asked all the time why should I upgrade to the latest. There are 100's of reasons with this one, I tried to pick the best 10.
Multi-subnet failover clusters: A SQL Server multi-subnet failover cluster is a configuration where each failover cluster...Apr. 22, 2012 11:00 AM EDT Reads: 1,016 |
 This book is a really great beginners guide for core SQL Server 2012, and it also does a great job of introducing new features introduced in SQL Server 2012. What I mean by core is that topics like Master Data Services and Data Quality Services are not introduced. That is not a bad thi...Apr. 1, 2012 02:00 PM EDT Reads: 967 |
 SQL Server integration Services (SSIS) is the de-facto standard for data migration and ETL (Extract, Transform and Load) operations in the Microsoft BI suite of technologies. Nevertheless, SQL Stored Procedures are still the preferred choice in some of the applications for carrying out...Feb. 22, 2012 11:02 AM EST Reads: 1,505 |
 The metadata structure of Microsoft SQL database is divided into numerous allocation units, such as, IAM (Index Allocation Map) pages, GAM (Global Allocation Map) pages, SGAM (Shared Global Allocation Map), or PFS (Page Free Space) pages. Corruption in any of the above pages primarily ...Dec. 29, 2009 04:00 AM EST Reads: 1,859 |
 The Windows Azure Platform training kit was updated with new SQL Azure content in the August release of the Windows Azure Platform Training Kit. Many of the existing labs and presentations were also updated, in line with recent developments of the platform.
The kit now includes:
Hand...Aug. 20, 2009 05:00 AM EDT Reads: 2,660 |
 Change Data Capture is the most recent important change in the way the ETL Process is perceived for a dynamic business environment. In a generic sense CDC may be understood as, "What did change since the last time I looked it up?" In an image recognition situation this may mean what ha...Aug. 5, 2009 01:15 PM EDT Reads: 3,269 |
 I recently installed Visual Studio 2010 Beta on my Notebook computer with Vista Home Premium. SQLServer Express 2008 that comes with VS2010 Installation has only two tools.It has only Import and Export Data (32bit) SQL Server Configuration Manager You could download t... Jul. 20, 2009 03:45 PM EDT Reads: 3,348 |
 Over the past year, I've been discussing some of the various technologies found inside SQL Server 2005. Three of these technologies are CLR integration, HTTP endpoints, and Service Broker. (Articles on these topics were published, respectively, in the November 2005, March 2006, and Nov...Mar. 14, 2007 10:00 AM EDT Reads: 10,608 Replies: 1 |
 In today's complex and demanding environments, it is quite common for users to be able to submit requests faster than those requests can be processed. In some situations, this is because the system has an enormous number of users. In other situations, it is because the requests take a ...Nov. 17, 2006 02:00 PM EST Reads: 34,168 Replies: 1 |
 A number of years ago, I worked for a company that was developing internal applications with SQL Server 2000. We didn't have any real database administrators. I was given that responsibility, but I was really a developer, one of many in fact. The problem with this arrangement was that ...Jul. 29, 2006 11:00 AM EDT Reads: 17,728 |
 SQL Server 2005 has many new and improved features. So many, in fact, that it would be very difficult to cover them all thoroughly. Therefore, I've been concentrating on those features that I feel will have the most impact on developers. Because of this, I want to present two more new ...Apr. 13, 2006 11:00 AM EDT Reads: 20,692 Replies: 4 |
 These days, applications built around a service-oriented architecture (SOA) are all the rage. Complex systems can be written as a collection of services that communicate with each other through standard protocols. When implemented properly, these systems can become immensely flexible, ...Mar. 14, 2006 10:00 AM EST Reads: 23,680 |
 Sequential numbers. Sooner or later, you'll find a process that requires you to generate a series of sequential numbers. As a matter of fact, most database engines provide at least one method of producing such numbers. Microsoft Access, for example, has AutoNumber columns, while SQL Se...Feb. 19, 2006 03:45 PM EST Reads: 27,228 Replies: 2 |
 Do you love XML? Have you been using XML with SQL Server? Many people have, starting way back when with SQL Server 7.0. Back then, there was no support for XML in the database, so we had to write external programs to convert the relational data into an XML format. This was time-consumi...Jan. 19, 2006 02:15 PM EST Reads: 29,780 Replies: 3 |
 Have you ever heard the expression 'I want it so bad that I can taste it?' Well, that's the way I feel about SQL Server 2005. I've been looking forward to the official release for quite some time. When people ask me why, I usually say 'SELECT TOP X.' In addition to generating some funn...Dec. 23, 2005 01:45 PM EST Reads: 32,096 Replies: 1 |
 For most of this year, I've been giving presentations and teaching classes on various aspects of Visual Studio 2005 and SQL Server 2005. In my consulting role, I've been constantly presented with problems that, while definitely solvable with current tools, simply screamed for the new p...Nov. 27, 2005 03:15 PM EST Reads: 19,111 |
A new version of SQL Server 2005, codenamed Yukon, is to be launched at a gala event at the Moscone Center in San Francisco today. SQL Server 2005 features significant enhancements in Enterprise Data management, Developer Productivity and Business Intelligence. First benchmarks for SQL... Nov. 7, 2005 11:15 AM EST Reads: 16,658 Replies: 1 |
Unless you have been living under a rock, then you know that November 7 is the biggest day in 2005 so far as Microsoft developers are concerned. Tomorrow, October 7, exactly one month in advance of that day, Jerry Dixon of .NET Developer's Journal is featuring SQL Server 2005 in a SYS-... Oct. 6, 2005 04:45 AM EDT Reads: 13,221 |
.NET Developer's Journal Editorial Board member Tim Huckaby writes: 'Microsoft's Paul Flessner gave his keynote entitled 'Getting Ready for Connected Systems' at Tech·Ed 2005 here in Orlando, Florida this morning. The huge announcement of the day was that SQL Server 2005, Visual Studio... Jun. 7, 2005 11:00 AM EDT Reads: 15,424 |
