Webcast Today: SQL Server Best Practices
Having worked with databases for some time now, I felt it important to get some best practices documented. This presentation will touch on the simple things that we often take for granted while using our favorite database systems. From naming conventions, to cursors,to temporary, derived and variable tables, to the use of dynamic sql. We’ll touch on a great many different ideas and hopefully further cement your own best practices, making you a more exceptional DBA or Database Developer. Presented by: TJay Belt
> Register Now
> Live date: 10/14/2009 at 12:00 Pacific
Featured Article(s)
Tips for using ASP.NET with SQL Server 2005 (Part 1)
Here you can find some useful tips to use ASP.NET with SQL Server 2005.
Virtual Workshop: TOMORROW
SQL Server 911: What You Really Need to Know About SQL Server Backup, Restore and Having a Recoverable System.
Chris Shaw will be presenting a multi-hour virtual workshop, complete with Q&A, option-by-option explanations and full demonstrations of each feature and option. You’ll even learn about what to do if a restore fails – what options do you have? Chris put together this workshop as a way to make sure you had all the information you needed when it comes to setting up your systems. Don’t miss this great workshop – take a look at the outline at the site and then be sure to get registered. The workshop is tomorrow, straight to your desktop.
[Register Here] or [Check Out the Course Outline Here]
Hold Your Own Virtual Events – It’s Easier Than You Think!
Find out how – we’re holding a free event!
You’re aware of the online offerings we provide at SSWUG; what is your company doing virtually to reach customers and prospects? Let your marketing, sales or events teams know about the free Virtual Event University. Image is everything; ensure that you’re portrayed using next generation technology.
Business Intelligence and Business Insight
Trace writes with some thoughts on the differences between Insight and Intelligence in the BI world –
"It is interesting that this is being asked. Since BI either way has been with us since the beginning of business. But in today’s world I do look at each as being separate. A one is the cart, Business Isight, the other the horse, Business Intelligence.
Business Intelligence, I believe is the work horse– it is the development of a tool set that delivers data to a company in a meaningful manner that aids in the understanding of their business, leading the way to Business Insight.
The tool set generally starts from the ground up – business process flows, business interactions, gathering data, building a foundational (central) data warehouse, building marts or cubes, metadata layers and other means of exposing data in interpretive and meaningful ways and then presenting said data in purposeful, actionable ways for the company to gather insight into their business.
Once the empire of data is built, it is constantly tuned and re-tooled to maximize the information delivered to continually feed the business for new insights.
Business Insight on the other hand, is data being intrepreted in a meaningful way for a company to have insight into their business and make informed decisions based upon their data, err insights."
Want to Stay Up To Speed with SQL Server?
Oct 21, 22, 23 – SSWUG.ORG Virtual Conference [Register Here]
75+ sessions, expert speakers, time is running out to register.
Oct 26, 27, 28 – Smart Database Design Class with Paul Nielson
In-person, hands-on class about best practices, approaches and more. Seats VERY limited. (West Coast – Tucson, AZ)
[More information here] [Register Here]
Featured White Paper(s)
Managing Complex Database Changes
Development can be a volatile endeavor – especially when sites or applications are database dependent and subject to a high d… (read more)