Incorrect syntax near “GO”

PROBLEM:
SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Incorrect syntax near 'GO'. at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()

SOLUTION:
1. Put the “GO” command on a new line, separate from the other statement
2. .SqlDataProvider file wasn't encoded in UTF-8 properly. Do save-as, then save file type with encoding UTF-8
3. Check issues with '+' and '-' signs in CREATE PROCEDURE scripts
4. Put an EOF char after the last “GO”

If you find this solution useful, you are welcome to press one of the ads in this page.. Thanks!

Shrink my database?

PROBLEM:
Why do I need to shrink my database?

SOLUTION:
Consider the following information when you plan to shrink a database:

1. A shrink operation is most effective after an operation that creates lots of unused space, such as a truncate table or a drop table operation. 
2. Most databases require some free space to be available for regular day-to-day operations. If you shrink a database repeatedly and notice that the database size grows again, this indicates that the space that was shrunk is required for regular operations. In these cases, repeatedly shrinking the database is a wasted operation. 
3. A shrink operation does not preserve the fragmentation state of indexes in the database, and generally increases fragmentation to a degree. This is another reason not to repeatedly shrink the database. 
4. Unless you have a specific requirement, do not set the AUTO_SHRINK database option to ON.

If you find this solution useful, you are welcome to press one of the ads in this page.. Thanks!

Team Foundation services are not available. Fatal error while initializing web service

PROBLEM:
You get the following errors using Visual Studio Team Explorer when trying to connect TFS

• TF31001: Team Foundation cannot retrieve the list of team projects from Team Foundation Server servername. The Team Foundation Server returned the following error: Team Foundation services are not available from the server. 
• TF30059: Fatal error while initializing web service. 

SOLUTION:
Check if your TFS database and IIS services are OK (up and running..)

If you find this solution useful, you are welcome to press one of the ads in this page.. Thanks!

SCRUM Wedding

PROBLEM:
You plan a wedding

SOLUTION:
You can use the following instruction guide
http://gregoryheller.com/blog/2010-12/video-scrum-wedding-planning-ignite-talk

If you find this solution useful, you are welcome to press one of the ads in this page.. Thanks!

Design anti-patterns

PROBLEM:
What is considered to be bad code?

SOLUTION:
It’s always good to know what is considered to be good. At the same time in order to find out where you are now it’s required to know what is considered to be bad code or development style. There is a big list of anti-patterns which are related to software development. Full list of anti-patterns can be found here:

http://en.wikipedia.org/wiki/Anti-pattern

List of most interesting anti-patterns is copied and pasted below. I believe articles below can be interesting for developers of any level (juniors and seniors). If you know patterns and anti-patterns it’s easy to evaluate if you are doing something wrong or you are on the right way.

Project management anti-patterns

• Death march: Everyone knows that the project is going to be a disaster,  except the CEO - so the truth is hidden to prevent immediate cancellation of the project - (although the CEO often knows and does it anyway to maximise profit). However, the truth remains hidden and the project is artificially kept alive until the Day Zero finally comes ("Big Bang"). Alternative definition: Employees are pressured to work late nights and weekends on a project with an unreasonable deadline. 
• Groupthink: During groupthink, members of the group avoid promoting viewpoints outside the comfort zone of consensus thinking 
• Smoke and mirrors: Demonstrating how unimplemented functions will appear 
• Software bloat: Allowing successive versions of a system to demand ever more resources 
• Waterfall model: An older method of software development that inadequately deals with unanticipated change

Analysis anti-patterns

• Bystander apathy: When a requirement or design decision is wrong, but the people who notice this do nothing because it affects a larger number of people

Software design anti-patterns

• Abstraction inversion: Not exposing implemented functionality required by users, so that they re-implement it using higher level functions 
• Ambiguous viewpoint: Presenting a model (usually Object-oriented analysis and design (OOAD)) without specifying its viewpoint 
• Big ball of mud: A system with no recognizable structure 
• Database-as-IPC: Using a database as the message queue for routine interprocess communication where a much more lightweight mechanism would be suitable 
• Gold plating: Continuing to work on a task or project well past the point at which extra effort is adding value 
• Inner-platform effect: A system so customizable as to become a poor replica of the software development platform 
• Input kludge: Failing to specify and implement the handling of possibly invalid input 
• Interface bloat: Making an interface so powerful that it is extremely difficult to implement 
• Magic pushbutton: Coding implementation logic directly within interface code, without using abstraction
• Race hazard: Failing to see the consequence of different orders of events 
• Stovepipe system: A barely maintainable assemblage of ill-related components

Object-oriented design anti-patterns

• Anemic Domain Model: The use of domain model without any business logic. The domain model's objects cannot guarantee their correctness at any moment, because their validation and mutation logic is placed somewhere outside (most likely in multiple places). 
• BaseBean: Inheriting functionality from a utility class rather than delegating to it 
• Call super: Requiring subclasses to call a superclass's overridden method 
• Circle-ellipse problem: Subtyping variable-types on the basis of value-subtypes 
• Circular dependency: Introducing unnecessary direct or indirect mutual dependencies between objects or software modules 
• Constant interface: Using interfaces to define constants 
• God object: Concentrating too many functions in a single part of the design (class) 
• Object cesspool: Reusing objects whose state does not conform to the (possibly implicit) contract for re-use 
• Object orgy: Failing to properly encapsulate objects permitting unrestricted access to their internals 
• Poltergeists: Objects whose sole purpose is to pass information to another object 
• Sequential coupling: A class that requires its methods to be called in a particular order 
• Yo-yo problem: A structure (e.g., of inheritance) that is hard to understand due to excessive fragmentation

Programming anti-patterns

• Accidental complexity: Introducing unnecessary complexity into a solution 
• Action at a distance: Unexpected interaction between widely separated parts of a system 
• Blind faith: Lack of checking of (a) the correctness of a bug fix or (b) the result of a subroutine 
• Boat anchor: Retaining a part of a system that no longer has any use 
• Busy spin: Consuming CPU while waiting for something to happen, usually by repeated checking instead of messaging 
• Caching failure: Forgetting to reset an error flag when an error has been corrected 
• Cargo cult programming: Using patterns and methods without understanding why 
• Coding by exception: Adding new code to handle each special case as it is recognized 
• Error hiding: Catching an error message before it can be shown to the user and either showing nothing or showing a meaningless message 
• Hard code: Embedding assumptions about the environment of a system in its implementation 
• Lava flow: Retaining undesirable (redundant or low-quality) code because removing it is too expensive or has unpredictable consequences[5][6]
• Loop-switch sequence: Encoding a set of sequential steps using a switch within a loop statement 
• Magic numbers: Including unexplained numbers in algorithms 
• Magic strings: Including literal strings in code, for comparisons, as event types etc. 
• Soft code: Storing business logic in configuration files rather than source code[7]
• Spaghetti code: Programs whose structure is barely comprehensible, especially because of misuse of code structures

Methodological anti-patterns

• Copy and paste programming: Copying (and modifying) existing code rather than creating generic solutions 
• Golden hammer: Assuming that a favorite solution is universally applicable (See: Silver Bullet) 
• Improbability factor: Assuming that it is improbable that a known error will occur 
• Not Invented Here (NIH) syndrome: The tendency towards reinventing the wheel (Failing to adopt an existing, adequate solution) 
• Premature optimization: Coding early-on for perceived efficiency, sacrificing good design, maintainability, and sometimes even real-world efficiency 
• Programming by permutation (or "programming by accident"): Trying to approach a solution by successively modifying the code to see if it works 
• Reinventing the wheel: Failing to adopt an existing, adequate solution 
• Reinventing the square wheel: Failing to adopt an existing solution and instead adopting a custom solution which performs much worse than the existing one 
• Silver bullet: Assuming that a favorite technical solution can solve a larger process or problem 
• Tester Driven Development: Software projects in which new requirements are specified in bug reports

If you find this solution useful, you are welcome to press one of the ads in this page.. Thanks!

6 Phases of a big project

1. Enthusiasm,
2. Disillusionment,
3. Panic and hysteria,
4. Search for the guilty,
5. Punishment of the innocent, and
6. Praise and honor for the nonparticipants.

http://en.wikipedia.org/wiki/Six_phases_of_a_big_project

If you find this solution useful, you are welcome to press one of the ads in this page.. Thanks!

How to use SQL Server profiler for basic profiling?

PROBLEM:

How to use SQL Server profiler for basic profiling?

SOLUTION:

To access Profiler, you must be the administrator or have permission to connect to a specific instance of SQL Server and have granted permissions to execute profiler stored procedures.

Open SQL Server profiler. If the following window not open, choose the "New Trace" button.

Use the "Standard (default)" template and go to the "Event Selection" Tab

In the event selection tab choose only

• "RPC:Completed"
• "SQL:BatchCompleted"

Press the run button

Now you can start to traces and analyze your queries or applications..

For more information, visit here

If you find this solution useful, you are welcome to press one of the ads in this page.. Thanks!