Geeks With Blogs
Catherine Russell Architect, President of "Women In Information Technology" Group June 2010 Entries
5 Stored Procedures Optimization Tips
5 Stored Procedures Optimization Tips 1. Use stored procedures instead of heavy-duty queries. This can reduce network traffic as your client will send to the server only the stored procedure name (perhaps with some parameters) instead of all the text from a large heavy-duty query. Stored procedures can be used to enhance security as well. For example, you can give the users permission to execute the stored procedure to work with restricted sets of columns and data. 2. Call stored procedures using ......

Posted On Friday, June 25, 2010 1:21 PM

In what scale of companies do you prefer to work: big or small?
In what scale of companies do you prefer to work: big or small? What is your experience? What are the advantages and disadvantages? It really depends on your personal preferences. Big Company advantages: 1) Resume bragging rights 2) Excellent training opportunities 3) Established processes and procedures 4) Established profit sharing/bonus schemes 5) Established corporate culture 6) Usually Big companies have more resources Big Company disadvantages: 1) Too many processes to follow 2) Promotion can ......

Posted On Thursday, June 24, 2010 4:00 PM

What's the difference between datasets and the entity framework?
It seems like typed datasets provide the same type of object layout as the entity framework. What's the difference and why should I use one or the other? We'll start at the fundamental difference: DataSets give you a basic in-memory database that you can query and fill from a data source such as a database. Queries against datasets are executed against in-memory data. Entity Framework gives you a translation layer that translates LINQ queries to your database's SQL dialect. Queries against the EF ......

Posted On Wednesday, June 23, 2010 12:25 PM

log4net - is an essential tool in every developer's arsenal.
Technorati Tags: asp.net Logging is an essential tool in every developer's arsenal. It helps the developer to identify problems faster by showing the state of an application at any given point. It is important after deployment, when admins have are the logs that are generated by your application. So it is absolutely necessary to be equipped with a logging framework which is easy to set up, easy to use, and extensible. For logging service my choice is log4net from Apache Software Foundation. It is ......

Posted On Wednesday, June 23, 2010 6:07 AM

Why GoToMyPC is a better solution than a traditional VPN
In contrast to a VPN (virtual private network), GoToMyPC enables Information Systems management with a way to provide secure remote pc access to corporate computing resources without security loss, poor performance issues and extra management resources. A VPN (with there special hardware, software and config requirements) can be extrememely time-consuming and very expensive to implement. In contrast, GoToMyPC Pro is a completely Web-based solution that small organizations can implement in just minutes ......

Posted On Tuesday, June 22, 2010 10:50 AM

Have you considered working for Microsoft in the IT organization?
Microsoft’s IT organization is hosting a Webinar for female technology professionals! Microsoft’s IT organization is hosting a Webinar on Thursday, June 24th at 11:30 AM PDT for female technology professionals interested in meeting some of the dynamic women who work in IT at Microsoft. Four different women from across the organization will share with you their stories and highlight why they have chosen Microsoft’s IT organization as a great place to grow and nurture their careers. This event will ......

Posted On Wednesday, June 16, 2010 1:11 PM

Rollback in Oracle and SQL Server
I have an Oracle background. It was interesting to see how rollback handled in Oracle and SQL Server. There is no begin trans in Oracle. What oracle does is it will store the data in a temporary area called the rollback segments. Untill your issue the commit command the records will be kept there. You can even rollback your update statement by issuing the rollback command. When you issue the commit command the records in the rollback segments are written to the redo log files. The same logic for ......

Posted On Tuesday, June 15, 2010 1:45 AM

2 min video about the SQL_Compare
It is nice to start blogging again! I am working on new project in a small company now. We do not have a full time database admin. I have to cover multiple roles: getting requirements, writing docs and creating diagrams, designing app, writing code, testing and DBA role. I am not a DBA. But, I have to do day to day database changes: adding new new columns and tables. Check out 2 min video about the SQL_Compare. This tool saves time by automatically comparing and synchronizing database schemas; eliminate ......

Posted On Monday, June 14, 2010 11:07 PM

Free LINQPad is a great way to learn LINQ!
LINQPad is a great way to learn LINQ: it comes loaded with 500 examples from the book, C# 4.0 in a Nutshell. There's no better way to experience the coolness of LINQ and functional programming. LINQPad is more than just a LINQ tool: it's an ergonomic C#/VB scratchpad that instantly executes any C#/VB expression, statement block or program with rich output formatting – the ultimate in dynamic development. Put an end to those hundreds of Visual Studio Console projects cluttering your source folder! ......

Posted On Friday, June 11, 2010 1:48 AM

FILESTREAM in SQL Server 2008 R2
Much data is unstructured, such as text documents, images, and videos. This unstructured data is often stored outside the database, separate from its structured data. This separation can cause data management complexities. Or, if the data is associated with structured storage, the file streaming capabilities and performance can be limited. FILESTREAM integrates the SQL Server Database Engine with an NTFS file system by storing varbinary(max) binary large object (BLOB) data as files on the file system. ......

Posted On Thursday, June 10, 2010 9:50 AM

Free Webinar: Filling the Gap in SharePoint Records Management
Webinar: Filling the Gap in SharePoint Records Management Find out how you can solve your challenges with conceptClassifier for SharePoint and leverage SharePoint 2007 and 2010 in this free one hour webinar. This informative webinar will focus on records management in SharePoint and how Concept Searching’s award winning conceptClassifier for SharePoint automatically generates conceptual and descriptor metadata from documents, automatically changes the Content Type, and automatically declares records. ......

Posted On Thursday, June 10, 2010 9:46 AM

According to new research by economics experts, companies that have women in senior management roles make more money

An interesting research:
According to new research by economics experts, companies that have women in senior management roles make more money.

To check the article go to:
http://blogs.techrepublic.com.com/career/?p=1004

Posted On Wednesday, June 9, 2010 1:44 PM

Introducing Microsoft SQL Server 2008 R2
I was thrilled to find a free ebook: Introducing Microsoft SQL Server 2008 R2,by Ross Mistry and Stacia Misner The purpose in Introducing Microsoft SQL Server 2008 R2 is to point out both the new and the improved in the latest version of SQL Server. Great info and they are sharing it for free. Feel free to follow the authors and ask quesitons on Twitter. @RossMistry @StaciaMisner Here is the link to the book: http://blogs.msdn.com/b/mic... ......

Posted On Wednesday, June 9, 2010 1:32 PM

Copyright © CatherineRussell | Powered by: GeeksWithBlogs.net