Last week, Microsoft released SQL Server 2012. With this release comes an update to SQL Server Management Studio (SSMS). Here is a quick glance of some of the new features…
New Font and New Color Scheme
If you take a look at the new SQL Server 2012 Management Studio, you will immediately notice the new color scheme and that it looks just like Visual Studio 2010! That’s because it’s not built on the Visual Studio 2010 Shell. We will also notice that the default font is now ‘Consolas’.
Multi Monitor Support
SQL Server Management Studio now supports multiple monitors, just like Visual Studio 2010. You can drag each window to another monitor. This also means that each monitor can appear outside of the SSMS shell.
Now there are lots of code snippets are available and you can that code snippets via right Click Query window-> Insert snippets like following.
Once you click Insert snippets it will open lots of built in snippets and create syntax for you directly.
You can also manage the Code Snippets from the Tools –> Code Snippets Manager… menu
Now you can zoom the query editor window. There is a dropdown given in left bottom corner of the window and you can zoom the query editor windows as you need like following.
SQL Server 2008 added IntelliSense support. In SQL Server 2012, this only gets better and faster. It seems much more responsive, similar to what we see in Visual Studio 2010 IntelliSense.
A New Activity Monitor Window
Additional features in SQL Server Management Studio:
On March 6, 2012, Microsoft released the first official release of the “SQL Server Data Tools” (SSDT) to the web. Even though this release accompanies SQL Server 2012 RTM, you can use SSDT against SQL Server 2005 or later, including SQL Azure. So download it now! and get started developing and deploying your SQL Server databases using SQL Server Data Tools.
“SQL Server Data Tools (SSDT) is a free database development environment for SQL Server which is hosted inside the Visual Studio shell. Even though SSDT will first ship as part of SQL Server 2012, it supports all existing SQL Server versions starting with SQL Server 2005, including SQL Azure. This means you can use it today to author, debug and deploy your database schemas targeting SQL Server 2005 SQL Server 2008, SQL Server 2008 R2, SQL Server 2012 and SQL Azure.
SSDT builds upon the declarative database development foundations established by Visual Studio database projects, as such it provides a rich set of database schema authoring and deployment capabilities which is fully integrated in to the Visual Studio development environment.”
You can also download SSDT from the Web Platform Installer. Navigate to Products on the top and then to Database on the left side. SQL Server Data Tools will be in the list near the bottom. This is a free tool and will integrate into your VS2010 IDE.
The following are great blogs about SQL Server Data Tools:
You can read more about the new features in SQL Server 2012 here:
SQL Server 2012 Express Edition
For those of you looking to download the Express edition, you can do so from this URL: http://www.microsoft.com/sqlserver/en/us/editions/2012-editions/express.aspx
Microsoft released Microsoft Flight on February 29, 2012 as a free game, with additional purchasable downloadable content for items such as additional planes and locations.
The sky’s the limit! Experience the thrill and wonder of flight with Microsoft Flight. Now anyone can enjoy the fun, freedom and adventure of flight. Feel the power at your fingertips as you take to the skies and launch into thrilling missions and exciting challenges over the free-to-play Big Island of Hawaii. Take off today and fly into the ever-expanding world of Microsoft Flight.
This free download gives you the opportunity to explore the skies over the beautiful Big Island of Hawaii in the state-of-the-art Icon A5 or the classic Boeing Stearman.
- Direct X Version: DirectX 9.0c Shader Model 3.0
- Memory: 2.0 GB
- Operating System: Windows® XP with Service Pack 3
- Processor: Dual Core 2.0 GHz or higher
- Graphics: 256 MB (DirectX 9.0c Shader Model 3.0 compatible)
- Hard Disk Space: 773 MB
START FLYING NOW… IT ONLY TAKES A FEW MINUTES TO GET IN THE AIR!
GAMERTAG NOT REQUIRED TO DOWNLOAD AND PLAY THE FREE VERSION.
The free version includes everything you need to take-off and fly around the Big Island of Hawaii including the following:
- Play Online or Offline
- Includes the Icon A5
- Hidden Aerocaches
Hello WordPress. I’ve moved my blog over to WordPress from Spaces. I must say, I’m really impressed with what WordPress has to offer.
Look for more blog posts coming soon.
I can’t believe this, but Blue Mountain has closed it’s ski operations this season due to the unusual weather conditions were having.
“Ontario’s largest ski resort has laid off 1,300 workers after closing down its ski operations in the middle of the winter season for the first time in the resort’s 65-year history.” – Toronto Star http://www.thestar.com/News/article/168295
This sucks as I wanted to get out and ride my board before heading to Banff to ski the Big 3.
I think there is hope of skiing in Quebec at Mt. Tremblant. Jonathan…hook us up!!!