Latest Video Programs

SSWUGtv: Should you separate your personal and professional values?

SSWUGtv: Should you separate your personal and professional values?

SSWUGtv: The Precedent of Sony   SSWUGtv: SQL Server Versions and Migrations   SSWUGtv: Data Driven Decision Making.  

From the Editor's Desk...

The Software First Setup  -  Many software projects, specifically BI solutions fail because companies acquire tools as part of a software license package with not idea of what problems need to be solved.

Application Architecture Pains  -  As we continue to create new application architectures strengths and weaknesses emerge. Enterprise architectures can become cumbersome. SOA micro-architectures can be brittle. Where are we to go?

Vectors vs SQL  -  Many functions performed in vector based languages such as R may be performed using traditional SQL, or implemented with custom functions in SQL Server. Whick should you use?

Skill Enhancement Goals  -  Any professional software developer must continually enhance their skills and knowledge for how to write software. Have you set any goals for yourself?

Intercepting Entity Framework Database Calls  -  Entity Framework 6 provides new capabilities allowing you to intercept database execution.

Memory vs. Intellisense  -  Before the powerful intellisense engines made our code writing much more simple we had to memorize a lot of syntax. Is there value in the memorization today?

Overriding the Optimizer  -  Do you know something about the characteristics of the data in your database that the built in optimizer does not? If so, SQL Server provides you with overriding capabilities causing SQL Server to behave as you require.

Canned Application Indexes and Maintenance  -  Canned Applications require index maintenance just as much as updated statistics. If you don't have the skills or the time to address these issues, Maurice shares an open systems tool that can do it for you.

Canned Database Mangement  -  When you deploy a canned application using SQL Server as the database component, the database may require attention from time to time in order to keep it performing optimally.

Community Content - News, Articles, How-To Information and More from Around the World