Monday, October 15, 2012

Pluralsight for MSDN Subscribers Worldwide

Back in June, Pluralsight announced special training benefits (Videos) for MSDN Subscribers. This was only for US MSDN subscribers.

Microsoft and Pluralsight were receiving feedback and comments from MSDN subscribers from other countries and now they have expanded the benefits to MSDN subscribers world wide.

So hurry up and get benefited by December 11, 2012 using your MSDN Subscriber ID. You can view this by logging on to your MSDN Site.

Courses that are included:

  • Agile Team Practices with Scrum
  • ALM for Developers with Visual Studio 2012
  • ALM with Team Foundation Server 2010
  • ALM with TFS 2012 Fundamentals
  • Building Windows 8 Metro Apps with C# and XAML
  • Building Windows 8 Metro Apps with C++ and XAML
  • C# Fundamentals - Part 1
  • C++ Fundamentals
  • Continuous Integration
  • Developing for Windows 7
  • Intellitrace
  • Introduction to .NET Debugging using Visual Studio 2010
  • Introduction to Building Windows 8 Applications
  • Introduction to Microsoft Fakes
  • Introduction to Visual Studio 2010 - Part 1
  • Introduction to Visual Studio 2010 - Part 2
  • Introduction to Visual Studio 2012 - Part 1
  • Introduction to Windows 7 Development
  • Kanban Fundamentals
  • Solution Modeling with UML in Visual Studio 2010
  • Test First Development - Part 1
  • Test First Development - Part 2
  • Web Application Performance and Scalability Testing
  • Windows Azure Diagnostics
  • Windows Phone 7 Basics

Monday, September 03, 2012

Database Cannot be opened because it is version 706. This server supports version 661 and earlier

When I tried attaching a mdf file using SQL SERVER 2008 R2 I got the following error:

"Attach Database failed for Server "XXXXXX"

Database cannot be opened because it is version 706. This server supports version 661 and earlier

Solution

This is because the database I was trying to attach is SQL Server 2012. The only way to resolve this is to Generate Script from SQL Server 2012 then run it in SQL Server 2008 R2. This needs to be done for data too.

Thursday, July 19, 2012

Find all dependent objects in oracle

Yesterday I had a scenario where I need to find the objects that are dependent on a particular table in Oracle 10g. My friend Peter happily offered me the following code.
select *
from dba_dependencies dep
where dep.referenced_owner = 'TABLE_OWNER_NAME'
and dep.referenced_name = 'TABLE_NAME'
order by owner, name;

Monday, July 16, 2012

The report server cannot decrypt the symmetric key that is used to access sensitive or encrypted data in a report server database

You will need to reset your encryption keys. To do that: 1.Open Reporting Services Configuration Manager and select 'Encryption keys' tab 2.Click 'Delete' in 'Delete Encrypted Keys' section: 3.You will need to reset all connection strings and db credentials for all your data sources

How to use crow feet notation in data modeling in Enterprise Architect

1.Right-click data-diagram and select properties (you can do it in the working area directly or through browsing the Project Browser).
2.Navigate to the Connectors tab.
3.On the right side you'll see a small section labeled "Connector Notation", there you select "Information Engineering"

Citing Sources: [http://stackoverflow.com/questions/6690495/using-crows-feet-notation-in-data-modelling-in-enterprise-architect]:

Tuesday, March 06, 2012

Icons used in Fiddler

What's the circular stop icon in fiddler denotes?

The default text coloring of the Session entries derives from the HTTP Status (red for errors, yellow for authentication demands), traffic type (CONNECT appears in grey), or response type (CSS in purple, HTML in blue; script in green, images in grey).

Icons and descriptions - http://docs.telerik.com/fiddler/knowledgebase/uiguide

Using PATINDEX in SQL Server

Returns the starting position of the first occurrence of a pattern in a specified expression, or zeros if the pattern is not found, on all valid text and character data types.

e.g. SELECT PATINDEX('%:%','22:30') will return 3 as the colon appears in that position.

Quite handy to figure out whether a pattern appears in the expression or not.

'The specified default EntityContainer name '' could not be found in the mapping and metadata information

This error normally occurs if the names for the CSDL, SSDL and MSL which is part of the Entity Framework mapping is correct in the App.config file.

Monday, February 20, 2012

Single row result set is specified but no rows were returned

If you try to execute a SQL query in SSIS with the resultset as 'single row' and if your query doesn't return any records then you will get this error.

Solution

IF NOT EXISTS (Query Here)
SELECT ''
ELSE
Query Here

Saturday, February 18, 2012

How to configure SQL SERVER to accept remote connections?

STEP 1: Enabling TCP/IP

First we must tell SQL Server to listen on TCP/IP, to do this
perform the following steps:

1. Launch the SQL Server Configuration Manager from the "Microsoft SQL
Server 2008 R2 > Configuration Tools" Program menu
2. Click on the "Protocols for your SQL instance"
3. Right click on "TCP/IP" in the list of Protocols and choose, "Enable"

STEP 2: SQL Browser Service

Next, we have to determine if we want the SQL Browser service to be running or not. The benefit of having this service run is that users connecting remotely do not have to specify the port in the connection string.

STEP 3: Firewall..?

At this point you should be able to remotely connect. If you still
can't chances are you have a firewall configured on the computer where SQL
Server is running.

Make sure to add the port number you used for tcp/ip connection added to the exceptions list. The default port for SQL Server is 1433 unless you changed it to listen on another port

If you chose to use the SQL Browser service, you must also add
sqlbrowser service executable to the exceptions list as it listens on udp
port 1434.

Could not locate file 'FIelD' for database db in sys.database_files. The file either does not exist, or was dropped.

If you get the above error while truncating the transaction logs then either you haven't selected the proper database to run the script for truncating the logs or you haven't provided the correct logical log file name for the database.

Truncating Transaction Logs in SQL SERVER

Truncating transacation logs!!! Normally you need to find why your transactional logs are growing. The major reason would be that your transaction logs are not getting backed up.

First thing is to check your database recovery model and if you have it as 'FULL' and you deal with too many transactions within the day then start backing up your transaction logs otherwise change your recovery model to 'SIMPLE' (not suitable for databases dealing with large transactions)

Before you change the recovery model you need to truncate your logs.

USE [DatabaseName]
GO

ALTER DATABASE [DatabaseName] SET RECOVERY SIMPLE
GO

DBCC ShrinkFile('[Database log file Logical name]',100)
GO

Note: For Data Warehouse Databases, it is recommended to use 'SIMPLE' recovery model