|
|
Tip: Please be sure to add newsletter@sswug.org when configuring your email filters.
SQL Server BI Marketplace - Headed for Consolidation (and stagnation?)
Featured Article(s)
Using Oracle 11g Invisible Indexes
This article describes how to use Oracle 11g's new invisible indexes to prevent the accidental use of an index by a production system.
We've Found Your SQL Assistant
Just imaging having a good friend check your SQL code, help as you type, show you statement syntax and the like. This, versus having to remember or lookup syntax, guess at usage, try, then edit, then try, then re-edit your code. If you're not using an Assistant, you're not where you could be in terms of getting things done with your TSQL, your Oracle, your DB2 or other major database of choice. Take a look at SQL Assistant - it provides auto-completion, code assistance and many more context-sensitive tools that really help you make the most of your time with your databases. Get more information here.
Do You See "BI" As Consolidating?
I saw this article about a Gartner bit about BI and their opinion that the overall BI marketplace won't be continuing to grow at double-digit rates. Specifically, they're saying that the available tools and software companies providing them will be consolidating, as will tools into the software itself. So, this suggests that the tools you look to third-party vendors for today will consolidate and be part of the SQL Server "engine" as a native capability. The same would presumably hold true for the other major database players.
I'm not sure this is a good thing. This is one area where I think we need some pretty sustained innovation and evolution. It seems like we have the whole "query this data and drop it into Excel" thing covered, but really learning data element importance and helping non-technical people be able to make sense of masses of data - I just don't think this nut is cracked yet. There are some nice tools out there, some really great mining tools, but it makes your eyes hurt sometimes just setting them up with real data.
I'd like to see some true innovators come up with better ways to have intelligent information pulled from these huge sources of data we all have. I haven't the *slightest* idea how that should be done - but if we can figure that out, we'd suddenly get so much more out of our databases in terms of company intelligence, decision support and overall management information flow.
I, for one, hope the industry doesn't consolidate, that we get more players with serious offerings that really decide to compete, rather than "well, they have it, so I guess we better" type features. That's what I think anyway.
Too bad no one is asking. :)
Featured White Paper(s)
Development, Change management, Code and Project deployment: Processes and Automation in SQL Server Environments
This white paper explores best practices and common approaches to managing the lifecycle of database projects in SQL Server e... (read more)
The Keys to Recoverability, from ESG
ESG Analyst, Lauren Whitehouse, discusses Double-Take Software’s concept of “recoverability” – which involves layers of prote... (read more)
See you online!
Stephen Wynkoop,
Founder
Microsoft SQL Server MVP
swynk@sswug.org
|
|
Featured/New Products For Your Review
The following products are in the Product Directory, and may help in your use of your database engine. Take a look when you get
a minute.
* Idera -
Tools for Data Management: SQL defrag manager
* Idera -
Tools for Data Management: SQLpermissions
* Acronis -
Compute with Confidence
Find out about these and other products in the Product Directory.
|
Today's Articles
Note: 'Guest' articles below will be available for seven days to registered guests.
SQL Server Topics
Developer Topics
Oracle Topics
XML Topics
DB2 Topics
SSWUG.ORG Sponsors, Special Offers
| |
Thank you to our sponsors!
Special Member Offers
See the special member offers page for more information
Pay them a visit and let them know you heard about them on SSWUG.ORG!
|
SSWUG.ORG Free Software
| |
Software Free to use courtesy of SSWUG.ORG
- The Digipede Network - Free Developer Edition - The Digipede Network is a grid computing solution that delivers dramatically improved application performance for Windows applications. It includes t...
- SQL Server Finder - Who remembers connection details months after an install? Yet, how many times do you need this information later on? Quickly get information required ...
- DataLinks for MS Access Only - DataLinks for Access only query tool allows business and IT users to quickly and easily access their Access databases. Writes SQL, easiest UI on the m...
- SQL job manager - “Every SQL Server DBA will tell you that they wish they had a quick and easy way to check and manage their SQL Server jobs,” said Rick Pleczko, Presid...
- SQLsafe Freeware Edition - High performance SQL Server Backup & Recovery – 50% Faster than Native Backup Idera SQLsafe Freeware Edition is a free SQL Server database backup and...
- The Jing Project - The concept of Jing is the always-ready program that instantly captures and shares images and video…from your computer to anywhere. It’s something we...
- Free SQL Server Performance Dashboard - Idera Free SQL Check SQLcheck is an easy-to-use performance dashboard for SQL Server. Running as a handy and secure screensaver or on-demand, SQLchec...
- Free SQL Server Permissions Transfer - Idera SQLpermissions Save time and reduce errors when setting up SQL Server logins & permissions. SQLpermissions will generate customizable T-SQL sc...
Free Software Offers
See the free software page for more information
|
Help Needed!
| |
Some of your fellow members need some help - and we'll be sure to include your questions here as well. We'll see that you get answers!
Forum: SQL Server: SQL Server 2005Forum: SQL Server: Development
When you post questions to the boards, they're included here in the newsletter. In addition,
the message board system can email you when answers to your questions have been posted. Ask away!
|
Summaries
| Using Oracle 11g Invisible Indexes
| |  This article describes how to use Oracle 11g's new invisible indexes to prevent the accidental use of an index by a productio... [more]
[Click Here to Read More...] [TOP] |
Microsoft SQL Server 2008 - Change Data Capture – Part I
| | (Muthusamy Anantha Kumar) One of the new features in Microsoft SQL Server 2008 is the ability to track changes on a table. Yo... [more]
[Click Here to Read More...] [TOP] |
SQL Server 2005 - Backup, Integrity Check and Index Optimization
| | (Ola Hallengren) I have made a solution for backup, integrity check and index optimization in SQL Server 2005. The solution i... [more]
[Click Here to Read More...] [TOP] |
New Best Practices Whitepaper published: 'Database Mirroring and Log Shipping Working Together'
| | (Sanjay Mishra) Log shipping and database mirroring can work together to provide solutions for high availability and disaster... [more]
[Click Here to Read More...] [TOP] |
Table Data Partitioning in SQL Server 2005
| | In this blog post, we will cover a working example on data partitioning feature in SQL Server 2005. In subsequent posts, we w... [more]
[Click Here to Read More...] [TOP] |
Working with LINQ in Visual Studio 2008
| | (Tony Patton) Last week, I introduced the basics about the .NET Language-Integrated Query (LINQ) technology. Now I’ll cover h... [more]
[Click Here to Read More...] [TOP] |
Onchanged Event for Composite User Controls
| | (Michael Livshitz) In a previous article we discussed some ways to create composite user controls with OnChanged events. Our ... [more]
[Click Here to Read More...] [TOP] |
Changing The Background Color of a TabControl's Tab
| | (Ged Mead) I've noticed a couple of questions in the VB.NET forums recently where someone wants to change the BackColor of th... [more]
[Click Here to Read More...] [TOP] |
Creating Composite Controls
| | (Bipin Joshi) So far in this series you developed controls by emitting raw HTML markup. As you will agree with me this can be... [more]
[Click Here to Read More...] [TOP] |
Introduction To Linguistic Indexes - Part II
| | (Richard Foote) As previously discussed, Linguistic Indexes can potentially be useful with case-insensitive searches and sort... [more]
[Click Here to Read More...] [TOP] |
11g SQL Performance Analyzer Rocks!
| | (Tyler Muth) There are a lot of myths and rules of thumb floating around about Oracle tuning:
--Should I partition this ta... [more]
[Click Here to Read More...] [TOP] |
Get namespaces from an XML Document with XPathDocument and LINQ to XML
| | (Scott Hanselman) A fellow emailed me earlier asking how to get the namespaces from an XML document, but he was having troubl... [more]
[Click Here to Read More...] [TOP] |
The Mystery of Removing XML DOM Nodes
| | (Dave Johnson) I was reviewing some code today and came across something that seemed very strange. There is a method we use f... [more]
[Click Here to Read More...] [TOP] |
Create dynamic Firefox user interfaces
| | (Adam Pilkington) When you create browser-based applications that display XML data feeds, you often need to code the data-ret... [more]
[Click Here to Read More...] [TOP] |
Aggressive DB2 Disaster Recovery
| | (Robert Catterall) Back in the mid-1990s, when I was on the DB2 for z/OS National Technical support team at IBM's Dallas Syst... [more]
[Click Here to Read More...] [TOP] |
Q+A: Locking
| | (Craig Mullins) I get questions e-mailed to me all the time. Although I try to read and answer them all, sometimes I don't. I... [more]
[Click Here to Read More...] [TOP] |
15 best practices for pureXML performance in DB2
| | (Matthias Nicola) DB2 9 introduces pureXML support, which means that XML data is stored and queried in its inherent hierarchi... [more]
[Click Here to Read More...] [TOP] |
|
Guest Articles [Top]
The article listings denoted as GUEST are random archive articles. Those articles are always available to dues-paying members, but are also available to guest newsletter subscribers for a period of 7 days from the release of this newsletter. Each newsletter features a new set of archive articles for each of the topics.
It's our hope that when you see the quality and range of articles in the archives, you'll see what a great value your SSWUG dues-paying membership really is.
Click Here to Activate Membership Today - it only takes a minute.
[ SQL Server ]
[ Oracle ]
[ DB2 ]
[ Open Source ]
[ XML ]
[ Developer ]
[ Join/Upgrade ]
[ Webcasts ]
[ Podcasts ]
[ Newsletter Archive ]
[ RSS/Feeds ]
[ About ]
[ Advertise ]
[ Contact ]
[ Privacy ]
[ Terms of Service ]
[ Link to SSWUG ]
[ List Server Archives ]
[ Recent Orig. Content ]
(c) 1997-2008, Bits on the Wire, Inc.
Some names and products covered by SSWUG are the registered trademarks of their respective owners.
The SQL Server Worldwide User's Group
8987 E. Tanque Verde #309-269
Tucson, AZ 85749 USA
|
