New SQLonCall Show Live Now
Basic Security Practices – Learn about mistakes commonly made when working with security and SQL Server. Lost consumer data, encryption, hacker attacks and much more – find out where to start looking and what to consider.
Featured Article(s)
Troubleshooting SQL Server 2005 Snapshot Replication
In this article, Alexander Chigrik explains some problems that you can have when you work with SQL Server 2005 snapshot replication. He also tells how you can resolve these problems.
Get Your Reports Out… Right!
You’ve built the perfect reports for your users. Now you have to get the information to them in the form they want it. Could be Excel, PDF, Word, whatever. How do you get the same report to different people, when they want it, in the format they want it? Simple. SQL-RD will take care of it for you. Truly set it and forget it, SQL-RD will take care of distributing the reports and making sure the format is right, the right people are getting it and much more. Scheduling, distribution, automation….you can even tie report generation to specific events, creating reports in response to data elements change, automatically. Get more information here.
Webcast TODAY
Infrastructure Optimization for Mission-Critical SQL Server
For SQL Server, the difference between an optimized infrastructure and a disjointed one is the difference between spending nights and weekends reacting to changes in your IT requirements versus being in control of your IT environment and a proactive strategic partner with your business units. When it comes to maintenance and management requirements, capacity changes and service availability, IT organizations can realize tremendous gains by uniting and optimizing the infrastructure components they already own.
> Register Now
> Today, October 10, 2007 at 12:00pm Noon Pacific
The Challenge of New Systems
One of the things that I’ve come to realize about this whole idea of new systems (columnar databases, object-oriented databases and the like) is that the exact same terms mean different things to different people. I was surprised by this – I thought since the terms were pretty new that they wouldn’t have really had time to have assumptive or modified definitions.
To me, what I was referring to with the whole columnar databases thing is the physical storage-level database approach. This all but requires a different database engine, not something you can actually do within a non-columnar database environment. I was surprised in the recent discussions by all of the people writing in with their "different database technologies" that are implemented on top of SQL Server. Not instead of, but inside of…
Now, I realize that relying on a new database environment for some or all of your database needs is a scary thing, that you have to start asking the serious questions of the potential providers of those new systems, but… it would seem to me (perhaps ignorantly) that implementing a new "layer" to abstract your new approach – all on top of SQL Server, is counter-productive. Your approach would have to be SO much more efficient, SO much faster… is it really worth it?
Inquiring minds want to know. I realize that sometimes it just won’t work "as-is." In those cases, sure. But in a tuning type situation, where is the cross-over point where it makes sense and how do you measure that?
Featured White Paper(s)
Requirements for a Secure Database
This paper outlines the key business requirements most often identified as being essential for the deployment of databases co… (read more)
The Top 5 Challenges of Migrating Lotus Notes Applications
Meeting the challenges of any Lotus Notes replacement initiative is a difficult and time consuming project that requires care… (read more)
Improving reliability and efficiency of the Database Change Management
Any Database Administrator or developer that has had to or deals with database schema changes realizes that establishing and … (read more)
Proactive Monitoring & Event Management Solutions for Oracle, MS SQL Server, Sybase & DB2 UDB
This whitepaper discusses DBA demands for database availability and the challenges to maintain uninterrupted 24/7 systems wit… (read more)