Webcast Tomorrow: Understanding Indexes and Index Fragmentation
In this webcast, we’ll examine how to look at your indexes, how to understand them and how to apply them. We’ll look into fragmentation and how you can determine whether an index needs to be rebuilt. We’ll look at the options you have available to you for maintaining your indexes as well.
> Register Now
> Dec 11 2007 at 12:00pm Noon Pacific
Featured Article(s)
Understanding Microsoft BizTalk Server (Part I)
BizTalk Server is an integration product offering from Microsoft that helps to develop, deploy and manage business processes that are integrated and also XML based web services. It helps the developers to integrate applications without excessive coding. It supports SOA (Service Oriented Architecture) and aims to create business processes that combine separate applications coherently. Two important aspects of BizTalk Server are, connecting applications within a single integration that is commonly called as Enterprise Application Integration (EAI), and, connecting applications in different organizations that are referred to as business-to-business (B2B) integration. BizTalk Server supports open web protocols and hence it can be extensively used across the Internet. According to Microsoft, "Microsoft BizTalk Server is a business process management server that enables companies to automate and optimize business processes. Building on Microsoft Windows Server System and the Microsoft .NET Framework, Microsoft BizTalk Server delivers an integrated, interoperable, extensible, and security-enhanced e-business solution that enables companies to connect information, systems, people, and processes."
Thanks To Our Sponsors
We’ve worked with some great companies this year! We really appreciate their support and help in bringing you SSWUG. Over the next few days I’ll be bringing you a list of the different sponsors, big and small. Take a moment and check it out – there are some outstanding products here!
90 Degree Software – Next Generation Reporting for Microsoft
/n software – Software Components for Communications, Security & e-Business
Acronis – Compute With Confidence
Acunetix – Web Vulnerability Scanner
Altova – XML, Data Management, UML & Web Services Tools
ApexSql – Tools for SQL Developers and DBAs
Feedback on Whether You’re Interested in Version 1.000
Stephen writes: "Is it a version issue or something else, as in a jump from 2000 to 2005.
I am not sure that business will jump on the change of a db and it’s HUGE cost associated with those changes, just because it’s available.
Buying new hardware for it, OS on that server cluster as well as the cost of the db licenses. Now we factor in the man hours to “play” with the new version and then the planning on what to take advantage of. How much developer time will be needed to bring in column encryption into use within our current application? Now Testing and QA as well as deployment. All of that eats up the budget from the accountants POV, or NO you can’t hire more staff.
At the company I am working at we are just bringing in SQL 2005 into a production usage in 2008. Not for fear of it, just inability to “jump” to it. Believe me when we say that the project plan(s) for 2007-2008-2009 doesn’t lend much time to check out the new stuff.
We are as a development team taking in the VS2005, .NET 3.0 and VS2008 changes on the bleeding edge though. You see you can try the change and see if it’s easier to go with it. Your scale of change, test, and new value is far less with Development tools then from a DB."
Charley’s feedback from the Government sector: "As a government agency, we are now midyear on our 2008 Budget.
As such, I have to budget June-June which seems to be outside MS’s release schedule. Sql 2008 is in my 2009 budget, which builds in a much needed shakeout period for the live server. I won’t be able to install until 3rd Quarter 2008.
A six month shakeout period has always seemed good for any software release. Sadly, Vista hasn’t even hit SP1 after 1 year of waiting. So much for the 6 month shakeout theory…"
Send in your feedback here – do you use version 1.000 of a product, or are you in the "wait for the first service pack" camp?
Featured White Paper(s)
Optimizing your SQL Server Infrastructure: Good Ideas, Bad Ideas
In the first chapter of the eBook SQL Server Infrastructure Optimization, “Traditional Challenges and Their Impact,” the auth… (read more)
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)
Developing Rich Internet Applications with NXJ Developer
Companies today have external and internal pressures that are placing ever increasing demands on IT and ISV/VAR organizations… (read more)