All the headlines and interesting SQL Server information that we've collected over the past week, and sometimes even a few repeats if we think they fit. These headlines are gathered throughout the week and are posted in real time at the website. Check there for information throughout the week or enjoy this weekly summary of the SQL Server world.
EDITORIAL - THE COWBOY WAY
Technology in sports and Windows outselling Linux.
http://www.sqlservercentral.com/links/370396/9576
TECH NEWS : THE LIGHTER SIDE
APPLE TO ALLOW MAC OS X SERVER VIRTUALIZATION - Apple Inc. has relaxed the licensing of its server software and will now allow users to run it in virtual machines, a sign that the company may focus more attention on the business market, said one of the companies developing virtualization software for the Mac....
http://www.sqlservercentral.com/links/370396/9577
SEAGATE TO REPAY CUSTOMERS OVER INACCURATE GB DEFINITION - Seagate Technology has agreed to settle a lawsuit by offering customers who purchased a hard drive from the company during the last six years a cash refund or free backup and recovery software....
http://www.sqlservercentral.com/links/370396/9450
TECH NEWS : SECURITY
TWO CHARGED WITH HACKING PEOPLESOFT TO FIX GRADES - Two California men are facing 20 years in prison on charges they hacked into a California state university's PeopleSoft system to change their grades....
http://www.sqlservercentral.com/links/370396/9578
TECH NEWS : DATA MINING/WAREHOUSING
IBM, SPSS PARTNER TO EMBED ANALYTICS IN DATA WAREHOUSES - Embedded approach supports real-time analysis and parallels move by SAS and Teradata....
http://www.sqlservercentral.com/links/370396/9464
TECH NEWS
TERABYTE STORAGE FOR CELL PHONES - A new type of memory technology could lead to thumb drives or digital-camera memory cards that store a terabyte of information--more than most hard drives hold today. The first examples of the new technology, which could also slash energy consumption by more than 99 percent, could be on the market within 18 months....
http://www.sqlservercentral.com/links/370396/9465
TECH NEWS : THE LIGHTER SIDE
A CARBON-FREE, STACKABLE RENTAL CAR - The Smart Cities group at the MIT Media Lab is working on two low-cost electric vehicles that it hopes will revolutionize mass transit and help alleviate pollution. Next week, the group will unveil a prototype of its foldable electric scooter at the EICMA Motorcycle Show, in Milan. A prototype for the team's foldable electric car, called the City Car, is slated to follow next year....
http://www.sqlservercentral.com/links/370396/9466
PRELUDE TO A ROBOT RACE - This week, robotic cars overran the desert town of Victorville, CA. Thirty-five autonomous vehicles, capable of piloting themselves without any human aid, came to compete in the Urban Challenge, a robot race sponsored by the U.S. Defense Advanced Research Projects Agency (DARPA). The robots' goal is to autonomously--and safely--navigate city streets, avoid obstacles in the roads, merge with traffic, park in a crowded lot, and perform other tasks on the roads of the former George Air Force Base....
http://www.sqlservercentral.com/links/370396/9467
TECH NEWS
IBM TO RECYCLE SILICON WAFERS FOR SOLAR CELLS - IBM is probably best known for its enterprise-class servers and related systems software, but the company is obviously a pretty big player in the chip industry with its various Power and PowerPC chips. IBM's techies in Burlington, Vermont, where IBM still makes a lot of chips, have been scratching their heads about what to do with defective silicon wafers, which are the inevitable result of any chip-making process, and have come up with a novel idea: recycle them for use in solar cells....
http://www.sqlservercentral.com/links/370396/9468
TECH NEWS : SECURITY
HARTFORD FINANCIAL MISPLACES BACK-UP TAPES WITH PERSONAL DATA ON POLICY HOLDERS - The personal data of some 237,000 policy holders at Hartford Financial Services Group Inc. -- stored on back-up tapes that were misplaced -- may have been compromised, the company said....
http://www.sqlservercentral.com/links/370396/9469
TECH NEWS
PARACCEL TARGETS MIDMARKET WITH NEW DATABASE - ParAccel, a new company based in San Diego, this week released a database for midsize companies that combines a number of BI-oriented features at a low price point....
http://www.sqlservercentral.com/links/370396/9579
TECH NEWS : DISASTER RECOVERY
NETEX, F5 FACE UP TO DR REALITY - NetEx yesterday unveiled an upgrade for its WAN optimization solution, which it claims can push data replication speeds through the roof in the event of an emergency. This followed EMC's recent announcement that it would resell F5's WANJet Appliance in conjunction with its SRDF replication software....
http://www.sqlservercentral.com/links/370396/9580
TECH NEWS
LINUX LOSING MARKET SHARE TO WINDOWS SERVER - Experts say that migrations from Unix to Linux have slowed down because all the low-hanging fruit has now been picked. ...
http://www.sqlservercentral.com/links/370396/9472
RESEARCHER: HANDHELD SUPERCOMPUTERS ONLY 10-15 YEARS AWAY - A Scottish engineer has figured out how to tame microscopic wires, making it easier to build smaller microprocessors, which will eventually lead to smaller supercomputers....
http://www.sqlservercentral.com/links/370396/9473
TECH NEWS : SECURITY
AS ATTACKS ON DATA RISE, CORPORATE TEAMWORK FAILS - As the TJX Companies data leakage incident seeped its way further toward becoming the Exxon Valdez of corporate information spills this week, researchers reinforced the notion that businesses continue to make a mess of electronic data security because they fail to foster adequate internal communication....
http://www.sqlservercentral.com/links/370396/9581
TECH NEWS
THE TRUTH ABOUT PC POWER CONSUMPTION - Tom's Hardware was one of the first publications to not only criticize ridiculously high heat dissipation, but also excessive power consumption where it's totally unnecessary. AMD and Intel have been in the news for years because their products either weren't efficient enough, or because of the advances they both made in reducing their power requirements. Measuring minimum (idle) and maximum power requirements of components, or of the overall system at the plug, is a good way to determine whether or not a device is thrifty....
http://www.sqlservercentral.com/links/370396/9475
TRAVELERS LEAVE CELL PHONES BEHIND - Travelers want to go green and stay clean in the next year—and they don't want cell phones disturbing their peace, according to an annual survey of travel trends....
http://www.sqlservercentral.com/links/370396/9476
DBAS WANT TO MAKE DATABASE MIGRATIONS EASIER - Analysts and IT pros said vendors need to provide customers with more tools to ease the database migration process. ...
http://www.sqlservercentral.com/links/370396/9477
LEOPARD, THE NEW DESKTOP OS PREDATOR, ARRIVES - Apple's OS X 10.5 "Leopard" emerges from its den today, Oct. 26. Macs fan are, of course, ready to embrace the latest Mac OS, but what's really new in this version?...
http://www.sqlservercentral.com/links/370396/9478
TECH NEWS : THE LIGHTER SIDE
12 TOOLS I WANT - Here’s what we know: Consumer-level gadgets and add-ons will continue to play an ever bigger role in how our users do their jobs. We know this, too: With only a few exceptions, gadget makers couldn’t innovate to save their skins. They happily clone whatever happens to be selling at the moment....
http://www.sqlservercentral.com/links/370396/9582
SURVEY: COMPUTERWORLD'S TOP 10 GREEN-IT COMPANIES - If you think you're green, participate....
http://www.sqlservercentral.com/links/370396/9583
TECH NEWS
MYSQL TO GET INJECTION OF GOOGLE CODE - MySQL has laid out its software road map through 2009, including some code contributed by Google and security improvements that are due in MySQL 7.0....
http://www.sqlservercentral.com/links/370396/9584
SQL SERVER NEWS : WEBCASTS
WEBCAST: BUILDING ADAPTIVE APPLICATIONS WITH SQL SERVER DATA MINING - Thursday, November 08, 2007
1:00 PM Pacific Time
There are many interesting and well-known uses of data mining for business analysis. However, for the application developer, data mining can also be useful for building adaptive, "intelligent" applications. In this webcast, we demonstrate how to build a simple application with Microsoft SQL Server Data Mining that collects data about usage as it goes along, and then uses that data to offer smart defaults—a truly adaptive application....
http://www.sqlservercentral.com/links/370396/9585
MICROSOFT NEWS
BILL CLINTON DROPS IN AT MICROSOFT TO SAY THANKS - The former president visited Microsoft's Redmond campus to express thanks for the company's support of a pair of outreach programs ...
http://www.sqlservercentral.com/links/370396/9586
MICROSOFT SEPARATES SHAREPOINT SERVICES FROM WINDOWS SERVER; DEVELOPERS SHRUG - Developers shrugged off Microsoft’s decision this week to revert to a separate download deliverable of Windows Sharepoint Services...
http://www.sqlservercentral.com/links/370396/9484
GOOD TIMES ROLL FOR MICROSOFT FINANCIALLY - Would somebody please remind Microsoft what year it is? The software giant hauled in the cash like it was 1999 during its most recent quarter, growing revenues by nearly 30 percent to nearly $14 billion, and increasing earnings per share by more than 25 percent, thereby beating Wall Street estimates and sending its stock climbing close to a six-year high....
http://www.sqlservercentral.com/links/370396/9485
MICROSOFT UNVEILS NEW 'OSLO' APPROACH TO SOA - Microsoft yesterday unveiled "Oslo," the codename of a new group of products and technologies for creating service-oriented architectures (SOAs). Oslo won't introduce any new products, but rather refers to new releases of existing products, including BizTalk Server, the .NET Framework, and its Visual Studio development tools....
http://www.sqlservercentral.com/links/370396/9486
DALLAS COWBOYS BUILT FOR MORE THAN THE GRIDIRON - With Super Bowl XXX the last big win in the Dallas Cowboy's history—and Super Bowl XL11 looming on the horizon early in 2008—one of the most prolific dynasties in NFL history is not only rebuilding its team, it's rebuilding its IT systems....
http://www.sqlservercentral.com/links/370396/9447
MICROSOFT DEAL VALUES FACEBOOK AT $15B - It's hard to determine what's more surprising about Microsoft Corp.'s investment in Facebook Inc. -- the appraisal that valued a 3 1/2-year-old Internet hangout at $15 billion or the rare snub of online search leader Google Inc....
http://www.sqlservercentral.com/links/370396/9487
MICROSOFT 1Q PROFIT BEATS STREET - After Microsoft Corp. executives laid out plans in July to win at Web search, online advertising, Web-based software and video games, analysts wondered if the world's largest software maker had too many balls in the air....
http://www.sqlservercentral.com/links/370396/9488
MICROSOFT EXEC: DESKTOP APPLICATION SOFTWARE IS NOT DEAD - A top Microsoft executive defended desktop application software, the source of the company's revenue for three decades, arguing on Tuesday that even services-based companies such as Google still need it....
http://www.sqlservercentral.com/links/370396/9587
MOBILE IS KEY TO MICROSOFT STRATEGY, BALLMER SAYS - Mobile phones play an important role in Microsoft's software-plus-services vision, CEO Steve Ballmer said Tuesday....
http://www.sqlservercentral.com/links/370396/9588
HARDWARE NEWS
INTEL QUIETLY RELEASES 'MONTVALE' ITANIUM KICKERS - It is hard to say why, but the launch of the "Montvale" Itanium 9100 kickers to the current dual-core "Montecito" Itanium 9000 processors could go down as the least enthusiastic launch that Intel has ever done for a microprocessor. I mean, Montvale did not even, according to Intel's PR department, rate its own set of foils, even though it can boost performance for customers by as much as 19 percent compared to the Montecito chips....
http://www.sqlservercentral.com/links/370396/9491
REVIEW: SEAGATE'S WHOPPER OF A DRIVE -- THE 1TB BARRACUDA - Should you buy this Seagate drive? Certainly! The odds are excellent that Windows will never again tell you that you're running low on hard disk space, and that alone might be worth the price of admission....
http://www.sqlservercentral.com/links/370396/9492
INTEL'S MONTVALE ITANIUM CHIP ARRIVES - Chipmaker launches line of Itanium processors for high-end computing servers, touts three new features....
http://www.sqlservercentral.com/links/370396/9493
SWITCH MAKER INTRODUCES A 'DATA CENTER FABRIC' ARCHITECTURE - Brocade Communication Systems Inc. today announced that it is developing what it calls a Data Center Fabric architecture, a product strategy built around optimized server and storage virtualization, application services and policy-based automation that will materialize over the next six months with new products in five categories....
http://www.sqlservercentral.com/links/370396/9589
SAMSUNG MANUFACTURING LEAP TO MAKE CHEAPER, FASTER MEMORY CHIPS - Samsung Electronics has developed a chip-manufacturing technique able to significantly increase the amount of music, pictures, videos, and other data people can store in future iPods, iPhones, and other devices....
http://www.sqlservercentral.com/links/370396/9590
BLOGS : PERFORMANCE POINT
PERFORMANCEPOINT MONITORING DATA SOURCE CONNECTION PROBLEMS - Now that the PPS user groups are live on TechNet I have already seen several posts about data source connection issues. This was similar to posts in the BSM newsgroup on the same topic. I have been meaning to post about this for a while. Now is as good a time as any....
http://www.sqlservercentral.com/links/370396/9496
BLOGS : SQL SERVER 2005
ONLINE REINDEX = ON - For the past several editions, SQL Books On-Line (BOL) has helpfully included a script to rebuild or defragment (since 2000) an index. Being Microsoft, this script is NOT located under the reindex or defragmentation topic, it is included in the fragmentation analysis section. For SQL 2000, this is DBCC SHOWCONTIG. For SQL 2005, they rewrote it to use the new system views and stashed it under sys.dm_db_physical_stats....
http://www.sqlservercentral.com/links/370396/9497
BLOGS : T-SQL
SPLITTING A SINGLE DATATABLE INTO PARENT/CHILD DATATABLES FOR HIERARCHICAL PROCESSING - In ASP.NET, we often would like to output "grouped" data on our web pages, like this:...
http://www.sqlservercentral.com/links/370396/9498
WHY SQL SERVER 2005 DOESN'T PERMIT NON-ANSI STYLE OUTER JOINS - As of SQL Server 2005, any database in 90 compatibility mode (settable by sp_dbcmptlevel) cannot support non-ANSI OUTER JOINs. Sometimes these types of joins are called old style joins. An example of such a non-ANSI OUTER JOIN is the following:...
http://www.sqlservercentral.com/links/370396/9499
BLOGS : PERFORMANCE AND TUNING
BEST AND WORST CHECKPOINT PERFORMANCE - The best documentation on the I/O behavior of SQL Server checkpoints is found in SQL Server 2000 I/O Basics by Bob Dorr. In particular, you should read the following carefully:...
http://www.sqlservercentral.com/links/370396/9500
BLOGS : SECURITY
SQL SERVER UNDOCUMENTED PASSWORD HASHING BUILTINS: PWDCOMPARE AND PWDENCRYPT - First, I must say that I don't know why these exist in an undocumented form. They have been around for a long time and a search on their names gets me back pages of hits. Being undocumented means that their actual implementation may change slightly from one version of SQL Server to another, mainly because the password hash format could change - and it has changed for the last three major versions of SQL Server....
http://www.sqlservercentral.com/links/370396/9501
BLOGS : SOFTWARE DEVELOPMENT
WHAT DOES "WRITING GOOD SOFTWARE" MEAN? GOOD FOR WHO? - I’ve mentioned before on this blog a little about how we write software here at Microsoft. I think it’s great that we are allowed to talk about it – in fact, we’re encouraged to be open about it. That’s very different from many other software firms I’ve dealt with. Along with describing how we write software, I thought I would share a very simple philosophy I have on the process. I’m not talking about Agile, or any of the dozens of other methodologies, since those normally deal with the mechanics of the coding process. I’m staying a bit more broad than that, with a bit less detail. For me, the process to writing good software has three attributes:...
http://www.sqlservercentral.com/links/370396/9502
BLOGS : SQL SERVER 2005
INDEXES FROM EVERY ANGLE: WHAT INDEXES ARE NECESSARY WHEN USING SWITCH PARTITION? - This is a quick answer to a question I was sent today by someone who'd read Kimberly's partitioning whitepaper - Partitioned Tables and Indexes in SQL Server 2005 - and is implementing a "sliding-window" scenario. (This is a mechanism to allow fast insertion and deletion of significant portions of data into/from a partitioned production table. Insertion is done by taking a table and making it a new partition of the production table - called switching-in. Deletion is done by removing a partition from the production table and making it into a stand-alone table - called switching-out.)...
http://www.sqlservercentral.com/links/370396/9503
BLOGS : DATABASE DESIGN, THEORY AND DEVELOPMENT
SPARSE TABLES, SPARSE COLUMNS, AND XML - I've been talking with folks for (it seems like) a long time about modeling sparse attributes in a relational database. Seems like I run into a new design where there's a need for sparse attributes every few weeks. If you remember the "hardware store" example (where each new sales item may have unqiue properties), that's just the tip of the iceburg. Basically, your choices boil down to: Sparse Columns (new column for each new attribute), Sparse Tables (new table for each new set of related attributes, if they are related), Entity-Attribute-Value (the "traditional" design, often eshewed because of scalability concerns), and XML (attributes model that sparse attributes, elements model the common attributes)....
http://www.sqlservercentral.com/links/370396/9504
BLOGS : DMO/SMO/POWERSHELL
POWERSHELL AND SQL SERVER'S 2008 SMO - THE REPRISE - In the last few years, I've done a few talks at various conferences on the integration of SMO (SQL Server Management Objects) and Powershell. My friend and co-author of the SQL Server 2005 books, Dan Sullivan, got me into using Powershell and SMO and has written quite a number of excellent blog entries and articles about it. Because SMO is just another loadable .NET library, they're a perfect fit. For TechEd US, I even wrote a simple powershell provider that makes SQL Server look at a file system (NavigationCmdletProvider through the database objects), and showed the code....
http://www.sqlservercentral.com/links/370396/9505
BLOGS : INTEGRATION SERVICES
TRANSFERING A COUPLE OF TABLES AT A TIME - I missed some of the comments to my post about creating your own Transfer SQL Objects Task with a script task, so I thought I'd post the answer here incase people miss my answer....
http://www.sqlservercentral.com/links/370396/9506
BLOGS : ANALYSIS SERVICES / BI
PROGRAMMING FOR WHOLESALE SURVEILLANCE AND DATA MINING - AT&T has done the research: They use high-tech data-mining algorithms to scan through the huge daily logs of every call made on the AT&T network; then they use sophisticated algorithms to analyze the connections between phone numbers...
http://www.sqlservercentral.com/links/370396/9507
BLOGS : LINQ
TWO APPROACHES TO A LINQ SOLUTION STRUCTURE - I’m in the process of writing a small windows application with a very straightforward architecture, for which the only twist is the need to be able to plug in different data providers according to how it is used. This means it must be able to handle SQL 2005, other database servers, XML files, flat files, and any other data source that I choose during the life of the application....
http://www.sqlservercentral.com/links/370396/9508
LOVING LINQ - I have to say, I love how easy it is to do SQL-like expressions over collections of objects with LINQ......
http://www.sqlservercentral.com/links/370396/9509
BLOGS : T-SQL
COMMON TABLE EXPRESSIONS, REVERSED - There was an interesting question left on my last post entitled Hierarchies WITH Common Table Expressions. Basically in this post I showed a couple of ways that you can use SQL Server 2005’s new “Common Table Expressions” (the “WITH” SQL statement) to retrieve a subset of a hierarchy of data....
http://www.sqlservercentral.com/links/370396/9510
BLOGS : SQL SERVER 2005
WHEN IS TOO MUCH SUCCESS A BAD THING? - I was talking to a customer the other day who had an interesting problem: Successful backups. Specifically, their problem had to do with the success messages that SQL backup puts in the SQL errorlog and the system event log....
http://www.sqlservercentral.com/links/370396/9511
BLOGS : CAREER
BECOMING A DBA, PART I - A recent thread on SQLServerCentral.com had an individual what it took to be a successful DBA. Couple that with a RunAs Radio podcast with SQL Server MVP Brad McGehee on Being a Better DBA and that raises the question, "What does it take to become a DBA?"...
http://www.sqlservercentral.com/links/370396/9512
BECOMING A DBA, PART I - A recent thread on SQLServerCentral.com had an individual what it took to be a successful DBA. Couple that with a RunAs Radio podcast with SQL Server MVP Brad McGehee on Being a Better DBA and that raises the question, "What does it take to become a DBA?"...
http://www.sqlservercentral.com/links/370396/9512
BLOGS : T-SQL
SQL SERVER: LISTING ALL THE DATABASE ROLES FOR A GIVEN DATABASE USER - SQL Server 2005 introduces Common Table Expressions (CTEs), which are great for recursive queries. Previously, in order to do recursion, we'd have to resort to a temporary table or a like type of structure. Therefore, if we have hierarchical lookups, CTEs are a great construct to use to navigate the hierarchy....
http://www.sqlservercentral.com/links/370396/9513
BLOGS : SECURITY
TOOL: KEEPASS PASSWORD SAFE PASSWORD MANAGER/VAULT - Some time ago I was looking for a password vault and came across some recommendations for KeePass. KeePass is open source and free. It's a nice password manager and some of the features I like are:...
http://www.sqlservercentral.com/links/370396/9514
BLOGS : T-SQL
CONDITIONAL INSERT/UPDATE RACE CONDITION - I often see conditional INSERT/UPDATE code like:...
http://www.sqlservercentral.com/links/370396/9515
DATE ONLY AND TIME ONLY DATA TYPES IN SQL SERVER 2005 (WITHOUT THE CLR) - In this post, I showed a simple way to create simple but useful Date and Time user-defined data types in SQL Server 2000. Here's how to do it in SQL Server 2005, without the need for CLR types or anything fancy....
http://www.sqlservercentral.com/links/370396/9516
BLOGS : SQL SERVER 2005
LOGIN EVENTS INCLUDE POOLED CONNECTIONS - Every now and then I stumble across something and say "I know I knew this before!" In Profiler, the Audit Login event includes regular logins and connection pooling reuse. If you run a trace and see a large number of logins you'll need to include the EventSubClass column to determine if they are pooled connections....
http://www.sqlservercentral.com/links/370396/9517
BLOGS : DATABASE DESIGN, THEORY AND DEVELOPMENT
DATABASE PARALLELISM CHOICES GREATLY IMPACT SCALABILITY - Large databases require the use of parallel computing resources to get good performance. There are several fundamentally different parallel architectures in use today; in this post, Dave DeWitt, Mike Stonebraker, and I review three approaches and reflect on the pros and cons of each....
http://www.sqlservercentral.com/links/370396/9518
BLOGS : SQL CLR
CONSUMING EVENT NOTIFICATIONS FROM CLR - A question was asked on the newsgroups: how can a C# program be notified when the schema of a table was modified (i.e. a column was added)? The short answer is to use Event Notifications, see
http://www.sqlservercentral.com/links/370396/9591
But an example would help J. First thing, we need to set up a queue and service that will receive the notifications:...
http://www.sqlservercentral.com/links/370396/9519
BLOGS : SERVICE BROKER / SOA
REUSING CONVERSATIONS - One of the most common deployed patterns of using Service Broker is what I would call ‘data push’, when Service Broker conversations are used to send data one way only (from initiator to target). In this pattern the target never sends any message back to the initiator...
http://www.sqlservercentral.com/links/370396/9520
RECYCLING CONVERSATIONS - In my previous post Reusing Conversations I promised I’ll follow up with a solution to the question about how to end the conversations that are reused for the data-push scenario (logging, auditing, ETL for DW etc)....
http://www.sqlservercentral.com/links/370396/9521
DYNAMIC ROUTING SERVICE - So how does one deploy Service Broker services in a large enterprise? Hundreds of services that change location every now and then (just enough to create a major outage exactly at the wrong moment!), and each database requiring a route to any service it wishes to interact with. Creating hundreds and thousands of routes and maintaining them as each new service is deployed, is retired or is moved is a difficult task and obviously prone to operational mistakes, pretty much a disaster waiting to happen...
http://www.sqlservercentral.com/links/370396/9522
BLOGS : DATABASE DESIGN, THEORY AND DEVELOPMENT
IN OR OUT? - I've been stalling, trying not to say too much about spatial until it's actually available. The code has all been in for some time now, but its been waiting for its release vehicle: the next CTP. Hopefully it should be in your hands in a few weeks....
http://www.sqlservercentral.com/links/370396/9523
COP DATABASES - COP (Column Oriented Processing) databases seem to have been making something of a comeback recently. You may be wondering what a COP database is; the best short summary is from the OLAP Report's glossary:...
http://www.sqlservercentral.com/links/370396/9524
BLOGS : SQL SERVER 2005
SUCCESSFUL BACKUP MESSAGES NO MORE... - How many times have you asked for a way to turn off the behavior in SQL Server that logs successful backup messages to the SQL Server Logs and to the Windows Application Event Logs? If you are like most DBA’s probably a lot. I have been asking for this feature for ages. I have sent email to SQLWish, filed on LadyBug and most recently on Connect with never any positive feedback. Well the other day I happened to be on campus in Redmond and was talking to Kevin Farlee...
http://www.sqlservercentral.com/links/370396/9525
BLOGS : ANALYSIS SERVICES / BI
COBOL THE ORIGINAL BI? - My dad, Gordon, was in BI before me, it had a different name but it was definitely BI. I remember him telling me that in 1964 he had this English Electric mainframe with 2k RAM that took up the whole building and it didn't have a divide function. He was working on statistics for the Ministry of Works and needed to compute standard deviation which not only uses division but also square roots....
http://www.sqlservercentral.com/links/370396/9526
BLOGS : SQL SERVER 2005
MSDN, ISOS, AND SQL SERVER HOTFIXES - Ok, this may be a bit off-topic, but I'm getting really annoyed that so many products are being offered only as ISO images. Why is it that I can set up a virtual machine or boot camp operating system running Vista without any problems, but in order to install SQL Server Developer Edition (if I don't have the DVD handy, of course, which is often the case when I am on traveling), I need to find some third party ISO utility. I used to be able to use WinImage (free), but for some reason, Microsoft changed the file format so that it can no longer extract anything beyond the root folder. :-(...
http://www.sqlservercentral.com/links/370396/9527
INSTALLING SQL SERVER MANAGEMENT STUDIO WHEN YOU ALREADY HAVE MANAGEMENT STUDIO EXPRESS INSTALLED!!! - Argh, I just beat my head against a wall trying to do this for the last couple hours:(. After a bit of web searching, I finally found this. So if you try to run the SQL Server 2005 installer to install the full version of SQL Server Management Studio (SSMS), you will inevitably get an "Edition Version Conflict" message. However, the installer sends you on a wild goose chase because it just tells you to uninstall "express tools."...
http://www.sqlservercentral.com/links/370396/9528
BLOGS : SQL SERVER COMPACT EDITION
TROUBLESHOOTING: CAN’T LOAD SQLCE DLL - SQL Server CE/Comapct uses Windows API LoadLibrary (PlatformBuilder or WinCE or Win32) to load the DLLs. When LoadLibrary fails to load any SQL CE dll, we throw the error “Can’t load sqlce dll”. Now, let’s discuss more on why LoadLibrary can fail. ...
http://www.sqlservercentral.com/links/370396/9529
BLOGS : T-SQL
GEEK CITY: POOR (WO)MAN'S LOAD TESTING - Last July, I posted about a way to run a batch multiple times when you use GO as the batch separator. I usually take advantage of this technique when I am loading test data into a table....
http://www.sqlservercentral.com/links/370396/9530
BLOGS : SOFTWARE DEVELOPMENT
COMMENDABLE TRANSPARENCY FROM THE VISUAL STUDIO TEAM - I spend a fair bit of time on this blog negatively criticising the various product teams within Microsoft when they do something that I think is worthy of that criticsm. Hence, its only fair that I criticise positvely as well. This blog entry is one such critique....
http://www.sqlservercentral.com/links/370396/9531
BLOGS : SQL SERVER 2005
FUZZY BACKUPS AND RESTORE DATABASE WITH STOPAT - So what’s a “fuzzy backup” and how does it relate to STOPAT?...
http://www.sqlservercentral.com/links/370396/9532
BLOGS : SECURITY
BASIC SQL SERVER SECURITY CONCEPTS: SIDS, ORPHANED USERS, AND LOGINLESS USERS - I am grouping here two topics (orphaned users and loginless users) that are actually very different, but I have often seen confusion between them, so I am covering them together in an attempt to dispel that confusion....
http://www.sqlservercentral.com/links/370396/9533
BLOGS : REPORTING SERVICES
ENSURING UP TO DATE RESULTS THROUGH URL ACCESS - A pretty common pattern that I see exporting of reports through URL Access using a simple hyperlink. The hyperlink usually looks something like this:...
http://www.sqlservercentral.com/links/370396/9534
BLOGS : HIGH AVAILABILITY/DISASTER RECOVERY
SEARCH ENGINE Q&A #8: HOW CAN DEFRAGGING AN INDEX BREAK SYNCHRONOUS MIRRORING? AND WHAT HAPPENS? - ustomer has a maintenance plan that involves running regular ALTER INDEX ... REORGANIZE on a 100GB clustered index to remove fragmentation. Three weeks ago they added database mirroring, with the database setup for synchronous mirroring. Every so often, they see the state of the mirror change from SYNCHRONIZED to SYNCHRONIZING and then a bit later back to SYNCHRONIZED. What's going on?...
http://www.sqlservercentral.com/links/370396/9535
BLOGS : DATABASE DESIGN, THEORY AND DEVELOPMENT
JUST HOW LONG SHOULD YOU MAKE CHARACTER FIELDS? WHAT'S THE LONGEST WORD? - Ok - this post is a little strange and fun. I was thinking about word length and how it relates to designing software/schemas to support multiple-languages. How far do you have to go in your research to figure out the maximum string length to support? So I started digging about and found some interesting things about words. Here are some examples....
http://www.sqlservercentral.com/links/370396/9536
DEBUNKING A COUPLE OF MYTHS AROUND FULL DATABASE BACKUPS - I've been involved in a few conversations today that have highlighted some big misconceptions about how backups work. I'd like to use this blog post to debunk them. I checked everything I say here with my friend Steve Schmidt, the developer on the Storage Engine team responsible for BACKUP/RESTORE for the last ten years....
http://www.sqlservercentral.com/links/370396/9537
BLOGS : T-SQL
DO YOU WANT TO LAUGH OR CRY? - I don't know if I should laugh or cry after looking at this code. This could not have been written by a human right?...
http://www.sqlservercentral.com/links/370396/9538
BLOGS : ANALYSIS SERVICES / BI
MAX AS A SEMI-ADDITIVE AGGREGATION OVER TIME - I got sent this question recently, but when I tried to reply the senders email address bounced, so I am posting the question and answer here. Q: "I have a problem with aggregate function in cube measure....
http://www.sqlservercentral.com/links/370396/9539
BLOGS : T-SQL
RECURSIVE CTES - One of the most important uses of CTEs is to write recursive queries. In fact, CTEs provide the only means to write recursive queries. As I noted last week, there are several excellent CTE examples, including recursive CTE examples, in Books Online. I'll once again start with the examples from Books Online. To run these examples, you'll need to install the Adventure Works Cycles OLTP sample database....
http://www.sqlservercentral.com/links/370396/9540
BLOGS : EVENTS
SQLBITS PODCAST - While at SQLBits, Dave McMahon of the Next Generation User Group recorded a podcast with various people there, including me. It's now available to download here:...
http://www.sqlservercentral.com/links/370396/9541
BLOGS : SQL SERVER 2008 (KATMAI)
SPATIAL DATA, A NICHE OR A TOOL FOR THE MASSES? - I'll have to admit it, when I first saw that SQL Server 2008 was adding spatial data support, I thought of it as a niche. The province of geographers, cartographers, and maybe a few others. Complex, involving a lot of higher mathematics, each province having their own geographic encoding, and so on... And that level exists, to me it's the production of spatial reference data. When I think of spatial reference data, I think of map data you'd buy from ESRI and data posted by government agencies. Or made available by utilities, so you don't hit a power cable while digging in your garden. As opposed to spatial line of business data....
http://www.sqlservercentral.com/links/370396/9542
BLOGS : DATABASE DESIGN, THEORY AND DEVELOPMENT
MASTER DATA MANAGEMENT 101: STANDARDIZE UNITS OF MEASURE - There's quite a bit of hoopla about MDM lately, mostly due to awareness. While "Lacks needed data" was cited as the number 1 problem (with 21 votes) in data warehouses in the recent IBM Data Warehousing Satisfaction Survey (2007), "Insufficient or inadequate master data" made a decent showing at second with 17 votes (see Table 3)....
http://www.sqlservercentral.com/links/370396/9543
BLOGS : T-SQL
USE CAUTION WITH EXPLICIT TRANSACTIONS IN STORED PROCEDURES - Explicit transactions are often used within stored procedures to guarantee all-or-nothing data integrity. However, a little known fact is that a query timeout will leave the transaction open unless non-default session settings and/or special exception handling are used. I’ll describe how to protect your application from problems following timeouts and other unexpected errors....
http://www.sqlservercentral.com/links/370396/9544
SQL SERVER: THE ONE AND ONLY LOCALE INSENSITIVE DATE FORMAT - Until recently i've been sure that there are 2 date formats that are completly locale insensitive....
http://www.sqlservercentral.com/links/370396/9545
BLOGS : DATABASE DESIGN, THEORY AND DEVELOPMENT
CPU TRENDS, LIKE DISK TRENDS, WILL FAVOR ADOPTION OF COLUMN STORES - In a recent post, we discussed how mass storage technology trends favor the use of a column-store architecture in database systems designed primarily for processing decision support queries. In this post, Sam Madden and I reflect on why CPU trends may have a similar influence on database design choice....
http://www.sqlservercentral.com/links/370396/9546
BLOGS : INTEGRATION SERVICES
EXPORTING MULTI-RECORD FORMATED FLAT FILE WITH SSIS - I recently had to come up with an easy way to create a multi record formatted file as a destination from and SSIS package. While I found a number of helpful tips on how to read from such a file I did not find anything on how to create such a file. I decided to see if I could do this utilizing standard SSIS objects with as little code as possible. I will walk you through the process utilizing the Adventure Works database as a source ( The sample database can be found at codeplex:...
http://www.sqlservercentral.com/links/370396/9547
PASSING A VALUES BACK FROM A CHILD PACKAGE TO A PARENT PACKAGE IN SSIS - This is an example of something similar to what I saw Allan Mitchell execute in an SSIS package about a year ago. I didn't think much of it until a few days ago when I needed to pass a bunch of data from a child package back to the calling parent package. This example passes a record set from a child package to the parent package where the parent package loops through object. This example uses the Adventure Works database to push data from sys.tables table into a record set in the child package then push this information into a Object in the Parent Package....
http://www.sqlservercentral.com/links/370396/9548
LOOPING THROUGH ISERIES DB2 DATA IN SSIS (DB2 FOR THE AS400) - This should be a pretty short post. I came across a pretty interesting behavior using the Native OLE DB\Microsoft OLE DB Provider for DB2 when its configured to connect to a iSeries DB instance. (This is the driver provided by MS in an add on pack to SQL Server 2005 sometime earlier this year) When you try to loop through a record set of data in a for each loop the package will failure with an error of wrong data type for data types that should match....
http://www.sqlservercentral.com/links/370396/9549
ISERIES TIMESTAMPS TO SQLSERVER USING SSIS - Here is a simple enough problem, the IBM iSeries (AS400) allows for a date range that starts at a lower value then SQL Server can handle, but one that SSIS can handle. This can cause a slight issue when trying to import data from an iSeries into a SQL Server. This can be handled by a derived column transformation checking the source column for a TimeStamp value less than 1753-01-01, then replacing it with 1753-01-01, or null or whatever other value you desire. Another simple solution is to place this value into a char or varchar on SQL Server buy you may have this problem when you go to query this field later....
http://www.sqlservercentral.com/links/370396/9550
SSIS: LIMITATIONS OF CUSTOM LOG PROVIDERS - Ever heard of custom log providers? They are a mechanism within SSIS by which we can write our own log providers in .Net rather than us those that are provided out of the box. Just recently I had cause to look into building a custom log provider as I was investigating whether it was feasible to replace my technique for custom logging using event handlers with such a custom log provider. Unfortunately I came across a rather large limitation of custom log providers, let me explain....
http://www.sqlservercentral.com/links/370396/9551
BLOGS : SQL SERVER 2005
BUG IN SSMS? - Check out this strange little ocurrence I just came across in SQL Server Management Studio (SSMS). It thinks a table is in my database when actually it isn't. Check out the screen shot below taken from my attempt to build a database diagram:...
http://www.sqlservercentral.com/links/370396/9552
BLOGS : SQL SERVER 2008 (KATMAI)
FILESTREAM DATA TYPE : SQL SERVER 2008 - I am loving the enthusiasm that people have for SQL Server 2008. Everyday I come across many questions on SQL Server 2008, this shows that people are curious and I am pretty sure that people are regularly reading and learning SQL Server 2008 to know more about it and how it can help to improve their present working environment. SQL Server 2008 CTP5 is awaited and it would be out for us very soon. There are lots of new features introduced in CTP5 and I think it will keep me busy writing and keep you busy reading....
http://www.sqlservercentral.com/links/370396/9553
BLOGS : ANALYSIS SERVICES / BI
DATA MINING FROM CASINOS TO COUNTERTERRORISM... - I guess DHS has figured out that bad guys are bad guys and existing expertise and technology probably will translate from fraud prevention to terrorism prevention....
http://www.sqlservercentral.com/links/370396/9554
USING BYATTRIBUTE OR BYTABLE PROCESSING GROUP PROPERTY WITH ANALYSIS SERVICES 2005 - As noted within the Analysis Services 2005 Performance Guide, there are some niche situations where setting the Processing Group property to ByTable provides more optimal processing than the default value of ByAttribute....
http://www.sqlservercentral.com/links/370396/9555
SSAS SMALL/BIG QUERY INTERACTION - Default SSAS behavior can sometimes result in small queries being slowed down by concurrently running big queries....
http://www.sqlservercentral.com/links/370396/9556
BLOGS : DATABASE DESIGN, THEORY AND DEVELOPMENT
THE PERILS OF CASE-INSENSITIVE DATA (AND OUR LIFE IN TANGENT-LAND) - OK, have you ever been working on one thing...that led you to another (and another and another) and then you seem to have lost hours? OK, I know. That's our life [in the computer industry and I'm sure others!] - putting out fires and chasing strange behaviors that we eventually call "gremlins" when we really can't figure them out (especially when they don't repro). And, I know that we all want to be incredibly prepared but, sometimes bugs happen. And, sometimes bugs lead to serious problems possibly even data corruption/loss (which I've seen) and NO, I'm not directly relating this to anything about SQL Server....
http://www.sqlservercentral.com/links/370396/9557
THE PERILS OF CASE-INSENSITIVE DATA (AND OUR LIFE IN TANGENT-LAND) - OK, have you ever been working on one thing...that led you to another (and another and another) and then you seem to have lost hours? OK, I know. That's our life [in the computer industry and I'm sure others!] - putting out fires and chasing strange behaviors that we eventually call "gremlins" when we really can't figure them out (especially when they don't repro). And, I know that we all want to be incredibly prepared but, sometimes bugs happen. And, sometimes bugs lead to serious problems possibly even data corruption/loss (which I've seen) and NO, I'm not directly relating this to anything about SQL Server....
http://www.sqlservercentral.com/links/370396/9557
BLOGS : T-SQL
SQL SERVER 2008 OFFERS PARTITION-LEVEL LOCK ESCALATION *EXCELLENT*, BUT... - OK, let me start by saying that I absolutely love when a feature improves in granularity options. Better granularity in locks means that contention is reduced and concurrency improved. And even though the overhead to manage smaller locks (and typically more of them) is usually higher - the improved concurrency benefits often significantly outweight the costs. Additionally, design is often simplified as more granular locks typically means you don't have to work as hard to minimize contention. ...
http://www.sqlservercentral.com/links/370396/9558
SQL SERVER 2008 OFFERS PARTITION-LEVEL LOCK ESCALATION *EXCELLENT*, BUT... - OK, let me start by saying that I absolutely love when a feature improves in granularity options. Better granularity in locks means that contention is reduced and concurrency improved. And even though the overhead to manage smaller locks (and typically more of them) is usually higher - the improved concurrency benefits often significantly outweight the costs. Additionally, design is often simplified as more granular locks typically means you don't have to work as hard to minimize contention. ...
http://www.sqlservercentral.com/links/370396/9558
FOLLOW ON POST TO "THE PERILS OF CASE-INSENSITIVE DATA (AND OUR LIFE IN TANGENT-LAND)" - OK, so thought I'd do a follow up to the post I did a couple of days ago titled: The perils of case-insensitive data (and our life in tangent-land). The reason I'd like to followup on it is that I received some excellent comments and I want to make sure that you're all aware of the tips/tricks and recommendations that there were (some of you may not have returned to see all of the comments)....
http://www.sqlservercentral.com/links/370396/9559
FOLLOW ON POST TO "THE PERILS OF CASE-INSENSITIVE DATA (AND OUR LIFE IN TANGENT-LAND)" - OK, so thought I'd do a follow up to the post I did a couple of days ago titled: The perils of case-insensitive data (and our life in tangent-land). The reason I'd like to followup on it is that I received some excellent comments and I want to make sure that you're all aware of the tips/tricks and recommendations that there were (some of you may not have returned to see all of the comments)....
http://www.sqlservercentral.com/links/370396/9559
BLOGS : SQL SERVER 2008 (KATMAI)
SQL SERVER 2005 AND 2008 - COMPRESSION - OK, I still have a way to go in learning about data compression in SQL Server 2008 but one thing that I do know is that nothing is free. So, the trade-off will be performance (i.e. CPU) v. space. And, that's not really a new trade-off wrt to compression. Sometimes that trade-off has other benefits that still minimize the overall cost (for example, backup compression compresses in-memory and before it goes to disk... this actually makes the overall backup process faster because the actual backup written to disk is smaller)....
http://www.sqlservercentral.com/links/370396/9560
BLOGS : SOFTWARE DEVELOPMENT
STILL ON THE FENCE? LET ME SAVE YOU SOME MONEY - Microsoft offers some pretty cool ways to get support, training and our products. I know a lot of you fence sitters wait for a deal to come along before you plop down your hard earned cash. I don't blame you one bit. I like to pinch my pennies, too....
http://www.sqlservercentral.com/links/370396/9561
BLOGS : SECURITY
GET PERMISSIONS OF MY USERNAME / USERLOGIN ON SERVER / DATABASE - Few days ago, I was invited to one of the largest database company. I was asked to review database schema and propose changes to it. There was special username or userlogic was created for me, so I can review their database. I was very much interested to know what kind of permissions I was assigned per server level and database level. I did not feel like asking there Sr. DBA the question about permissions....
http://www.sqlservercentral.com/links/370396/9562
BLOGS : ANALYSIS SERVICES / BI
NEW TIME SERIES FEATURES FOR SQL SERVER 2008 - The time series algorithm has had some major changes for SQL Server 2008. We've ramped up the algorithm and added prediction against new data. While the new data prediction is just as cool as the algorithm changes, I'll have to save that for later - this post I'll just tell you about the algorithm....
http://www.sqlservercentral.com/links/370396/9563
BLOGS : DATABASE DESIGN, THEORY AND DEVELOPMENT
INDEXES FROM EVERY ANGLE: USING CROSS APPLY WITH SYS.DM_DB_INDEX_PHYSICAL_STATS - Two of the cool features in SQL Server 2005 are CROSS APPLY and DMVs (Dynamic Management Views). Now, far be it for me to get my hands dirty explaining developer stuff like CROSS APPLY :-) but I was having a discussion with Colin Leversuch-Roberts in the UK about the composability limitations of the sys.dm_db_index_physical_stats DMV....
http://www.sqlservercentral.com/links/370396/9564
BLOGS : SQL SERVER 2005
YOU CAN'T HANDLE THE TRUTH - I received an email from a colleague the other day. He was having some issues with a job running in SQL Agent. Essentially, the code inside one of the steps would raise an error, and the step would immediately end. Now, we all know that there are limited options for any job step (Quit Reporting Success, Quit Reporting Failure, or Go To Step X, as my friend so nicely summarized). Sadly, what was really needed in this case was an option to "Continue Running Step Until Cursor Ends", or something like that. You can read more about it here....
http://www.sqlservercentral.com/links/370396/9565
BLOGS : CAREER
WILL MDX GO MAINSTREAM? - I always look out for Mark Whitehorn's articles in the Register, if only because I'm tickled to see any mention of MDX on the front page of the UK's foremost IT news site. Here's his latest:
http://www.sqlservercentral.com/links/370396/9592...
http://www.sqlservercentral.com/links/370396/9566
BLOGS : ANALYSIS SERVICES / BI
WHY DOES AS QUERY MY ROLAP DIMENSION? OR, ANOTHER GOOD REASON TO USE UNIQUE NAMES - One of my particular hobby horses is always using full unique names when writing MDX, rather than just referring to the name of the member. Consider the following query in Adventure Works:...
http://www.sqlservercentral.com/links/370396/9567
BLOGS : CAREER
WHITHER THE JOY? - It seems sometimes that the “joy’ of a particular vocation fades. No, I’m not in one of those places today, but I have been from time to time. You’ve probably been there yourself – when the job you have just isn’t as much fun as it once was.
This can happen for a lot of reasons. One is time – personally, I’ve been working with technology since 1979. Like most geeks of my time, I was a big sci-fi fan, so robots, electronics and computers were just part of the landscape....
http://www.sqlservercentral.com/links/370396/9568
BLOGS : LINQ
USING LINQ TO SQL AND EDM WITH SQL SERVER 2008 - I've been trying out LINQ for SQL and the Entity Data Model (EDM) latest betas with some "non-traditional" data sources. Namely SQL Server 2008 (CTP4) and SQL Server Compact Edition 3.5. I'll cover using SQL Server 2008 CTP in this blog entry, and using SQLCE 3.5 in the next one....
http://www.sqlservercentral.com/links/370396/9569
USING LINQ TO SQL AND EDM WITH SQL SERVER 2008 - I've been trying out LINQ for SQL and the Entity Data Model (EDM) latest betas with some "non-traditional" data sources. Namely SQL Server 2008 (CTP4) and SQL Server Compact Edition 3.5. I'll cover using SQL Server 2008 CTP in this blog entry, and using SQLCE 3.5 in the next one....
http://www.sqlservercentral.com/links/370396/9569
BLOGS : HARDWARE
ZFS & HARD DRIVE DEFECTS - The most recent ACM Queue Magazine (Vol 5 #6, Sep/Oct 2007) had two really interesting articles. The first was about the ZFS file system and was framed as an interview it with the two inventors, both from Sun. I'd seen it mentioned a few times via blog and took the opportunity to learn more. It was interesting to hear that they built the file system to expect hardware errors, to never require a disk check, that they think storage really should be a pool that you can just add (much like a SAN, but at the file system level)....
http://www.sqlservercentral.com/links/370396/9570
BLOGS : T-SQL
IF EXISTS (SELECT 1...) VS IF EXISTS (SELECT * ...) - xists is a well known way to improve performance because it returns as soon as it matches a single row - at that point it knows the condition is true and there is no need to continue.During a recent www.opass.org meeting guest speaker Bill Graziano mentioned that he uses if exists (select 1) instead of if exists (select *) as a performance optimization. Discussion revealed that this was based on a conversation with a MS person at some point, but Bill didn't have online URL to support it....
http://www.sqlservercentral.com/links/370396/9571
REQUIRING COLUMNS OVER 900 BYTES TO BE UNIQUE - Had a friend call me recently to ask about how to do this, had an nvarchar(2000) column that needed to be unique values. If you've ever tried this you'll know that SQL will let you do - with a warning! All works fine if your column initially has less than 900 bytes for any row but the first time you try to update to 901 bytes - bam! Now I know many of you will be shaking your head about the idea of an index that big anyway and I don't disagree. At the same time it was just a business problem to solve and he was hoping that there would be a quick way to do without a lot of changes. In other words, having the column be unique was important but it was far less important how it ended up that way....
http://www.sqlservercentral.com/links/370396/9572
BLOGS : PERFORMANCE POINT
PERFORMANCE POINT SERVER 2007 PERFORMANCE - f you call your flagship business intelligence product Performance Point then it might be a good idea to make sure it performs! ...
http://www.sqlservercentral.com/links/370396/9573
BLOGS : T-SQL
THE PROBLEM WITH JOINS - I recently came up against a pretty big problem with outer joins on SQL Server, and thought I'd talk about it a bit. First let me give you a little background on the problem.
<Begin Background>
It's common in data warehousing and datamarts to "band" data. By "banding" I'm referring to the practice of assigning identifiers to ranges of values, like dollar amounts. As a simple example, you might classify your sales dollar amounts into four categories like the ones represented in this sample AmountRange table:...
http://www.sqlservercentral.com/links/370396/9574
"EXACT NUMERICS" RE-VISITED - Wow, seems like I have a lot to write about today. I just noticed a blog by SQL Server guru Hugo Kornelis about the difference between "exact" and "approximate" numeric data types. This is a topic that seems to pop up on the radar regularly on the SQL Server newsgroups, and Hugo attempts to dispel the myth of "exact" data types. I appreciate Hugo's opinion on the matter, but I do disagree with some of his points and conclusions, as I'll try to explain below. For those who aren't familiar with the differences between "exact" and "approximate" data types, here's the short version:...
http://www.sqlservercentral.com/links/370396/9575
ADMINISTRATIVE
To be removed from this list, send a blank email to leavedd(*)sqlservercentral.com. Many people have issues with sending plain text emails or their from address is slightly different than their reply to address. If you have any problems leaving the list, please contact webmaster(*)databasedaily.com
Note: This is not the SQLServerCentral.com daily newsletter list. If you want to be removed from that list, you can change your profile or follow the instructions on that list.
This transmission is ©2000, 2007 Simple Talk Publishing. All rights reserved.
If you have any issues or problems, you may contact us at: Simple Talk Publishing, Red Gate Software, Cambridge, CB40WS, United Kingdom / Fax: 904-282-7845
Received on Sat Nov 03 2007 - 23:53:04 EDT