Tag Archives: visual studio 2010 tutorial video

Roots of SQL Server Data Tools

Thumbnail for 580Microsoft has long supported application database development with features built into Visual Studio, ranging from support for data access to the ability to create a connection to a database and manipulate database objects and data in simple ways. Various add-ons over the years have expanded those basic abilities, but even developers were constantly having to bounce between Visual Studio and either Enterprise Manager (in earlier versions of SQL Server) or Management Studio (in more recent versions, including SQL Server 2012) to perform data-related tasks, such as to create database tables, set security features, or execute stored procedures. Neither Visual Studio nor the SQL Server tools fully supported database development.

Then several years ago, Microsoft released its first version of the Team System Edition of Visual Studio 2008. This was a huge package of group software collaboration tools, including a long overdue successor to its Visual Source Safe source code control product. Over time, Team System spawned Architecture, Testing, and Development editions. But for a long time, one piece was missing: a database edition.

Microsoft soon rectified that, and released the product code named Data Dude. Officially, it is Visual Studio 2008 Team System Database Edition. Definitely a case where the code name was way cooler than the official name!

Data Dude, er, Database Edition, was a set of tools for managing the full database development lifecycle. Software developers were intimately familiar with the process, since it mirrors the code, build, deploy, rinse, repeat cycle common in software development. (And it can handle agile development methodologies as well.) Database administrators had to get used to some things, but could most certainly be part of the process.

Microsoft had several important high-level goals for the product:

  • Provide integrated change management, just like source control systems. This lets you go back in time to earlier versions of the database project and also provides controlled access to the project components to various developers for collaborative, simultaneous development.
  •  Manage database projects by allowing you to monitor progress and perform code reviews.
  •  Find and understand differences between versions. This way you can easily find the differences that cause problems in order to resolve them quickly.
  •  Make changes and see their effectiveness, without necessarily needing to build an entire project.
  • Support isolated development environments, so that each developer can work on their part of the project and test the changes before checking them in and distributing them to the rest of the team.
  • Test solutions to validate the design and code. You can use Team System’s support for unit tests to make sure that the design, code, and data doesn’t introduce any breaking changes.
  • Simplify deployment, of both the entire database and changes. This supports a variety of deployment scenarios during development and after the database goes into production, including finding the changes made to a test version of the database relative to a production version of the database.
  • Facilitate collaborative development of databases, so that team
    members can work together productively.

Database Edition was a huge step forward to make the process of creating database projects similar to creating application projects, particularly with its collaboration tools, support for source control, and test integration. But even with this step, things just weren’t as deeply integrated as they could be, in three primary ways:

Developer Edition wasn’t fully integrated with the database server. It enabled developers to perform more database-specific actions than earlier tools, but you still had to pop over to Management Studio too often.

  • Database developers had one tool to create database objects, and another tool—the Business Intelligence Development Studio
  • (BIDS)—for BI projects, adding a significant third tool to the mix in addition to Visual Studio and Management Studio.
  • Developer Edition made many simple things very easy, but once you went past simple stuff things got very hard. This is a rather subjectiv assessment, we realize, but there just seemed to be too many work arounds for what should have been easy.

The Database Edition was a great set of tools, particularly relative to what came before it. But with SQL Server 2012, Microsoft introduced what has so far proven to be the best set of tools yet, truly integrating database development tools into Visual Studio 2010 and 2012.

ldn-expertdkielyThis post is an excerpt from the online courseware for our SQL Server 2012: Advanced SQL CLR course written by expert Don Kiely. 

Don Kiely is a featured instructor on many of our SQL Server and Visual Studio courses. He is a nationally recognized author, instructor and consultant who travels the country sharing his expertise in SQL Server and security.

Advancements in Online Training Can Make Anyone a Programmer

application security is over the heads of it pros_800856775_large

There was a time in the not-too-distant past where computer programmers were viewed as an elite, mysterious bunch. The general public and non-IT workers knew nothing about coding, beyond the fact that it was complicated stuff. In other words, a relatively small group of individuals had a kind of monopoly on coding competencies.

But things are changing.

Thanks to the Internet and advancements in training technology, online courses are democratizing coding and programming. Now someone with even a casual interest can take a handful of online courses and become proficient relatively quickly.

In fact, New York City Michael Bloomberg’s 2012 New Year’s resolution was to learn how to code. If that isn’t inspiring, what is?

LearnNowOnline is leading the coding training revolution. So whether it’s video tutorials for C#, C# .NET courses, or a Visual Studio 2010 tutorial video, we can make your dream of becoming an amateur or professional programmer a reality.


var s=’hubspotutk’,r,c=((r=new RegExp(‘(^|; )’+s+’=([^;]*)’).exec(document.cookie))?r[2]:”),w=window;w[s]=w[s]||c,
hsjs.type = “text/javascript”;hsjs.async = true;
hsjs.src = “//cta-service-cms2.hubspot.com/cs/loader.js?pg=c6aa8857-3e7e-4761-a672-02016ac3851d&pid=153597&hsutk=” + encodeURIComponent(c);
setTimeout(function() {try{el.style.visibility=”visible”;}catch(err){}}, 2500);


Become a Tech Master in Record Time

Having someone tell you how to do something verbally is not always effective. Think of all the times you have attempted to fix an appliance or repair something while talking with support staff over the phone. It can be incredibly frustrating. Learning anything is much easier when you can physically interact with it while watching someone else also work with the tool or concept. This is especially true when it comes to learning how to use computer-related applications.

The internet has made it easier than ever to enjoy an experiential learning environment. With an online C# video course, a Visual Studio 2010 tutorial video, or an online MVC 3 tutorial, you can increase your programming and networking knowledge in a focused, hands-on way. It makes it easier than ever to increase your knowledge base. By watching someone work with the programs while interacting with them at the same time, the amount of time between your basic knowledge of a program and full mastery will be shortened considerably.


var s=’hubspotutk’,r,c=((r=new RegExp(‘(^|; )’+s+’=([^;]*)’).exec(document.cookie))?r[2]:(function(){var c=’0123456789abcdef’,s=[],i=0;for(i=0;i<32;i++)s[i]=c[Math.floor(Math.random()*0x10)];return s.join(”);})()),w=window;w[s]=w[s]||c,
hsjs.type = “text/javascript”;hsjs.async = true;
hsjs.src = “//cta-service-cms2.hubspot.com/cs/loader.js?pg=c6aa8857-3e7e-4761-a672-02016ac3851d&pid=153597&hsutk=” + encodeURIComponent(c);
setTimeout(function() {try{el.style.visibility=”visible”;}catch(err){}}, 2500);


Start Learning!

Tutorial Videos Help Beginners And Pros Learn More

Learning how to use any new development tool like Visual Studio 2010 can be challenging, and learning a programming language like C# can be as difficult as learning the written word of another culture. Too often, trying to learn by reading through dry, boring manuals and tutorials can just make things more confusing. Especially if you’re unfamiliar with some of the technical terms being used, trying to learn development tools and programming languages with text-only tutorials can seem impossibly daunting.

If you’re brand new to C# or Visual Studio 2010, sometimes the best way to begin learning is with a video tutorial. For the uninitiated, a visual studio 2010 tutorial video is often a great way to jump-start the learning process. Not only will you gain all of the useful information of a text tutorial, you’ll be presented with easy-to-follow visual steps so you can be certain you’re on the right track.

Video tutorials are also great resources for learning programming languages as well. There are a number of video tutorials for C# as well as html5 tutorials that can help programmers of all skill levels learn new and needed skills. And not only can you find tutorials on specific subjects, but also entire C# video courses to help you learn new skills and brush up on old ones.

Whether you’re just starting to learn about Visual Studio 2010 or programming languages like C#, or if you’re a seasoned pro, video tutorials can often times be the best and most useful way to learn new skills.


alt=”” src=”http://track.hubspot.com/__ptq.gif?a=153597&k=14&bu=http://blogs.learnnowonline.com/blog/&r=http://blogs.learnnowonline.com/blog/bid/228410/Tutorial-Videos-Help-Beginners-And-Pros-Learn-More&bvt=rss” />