Category: Development

DesignDevelopment

Custom Chrome Window Glyphs

If your looking to create a custom chrome window in Winform or WPF, you should take a look at the ‘Marlett’ font that is available on your system.

This font contains the actual glyphs used in Windows for the Minimize, Maximize, Restore and Close buttons.

Using this font makes it really easy to reuse these glyphs in a custom chrome window, instead of custom images that is typically used.

To get started, assign your buttons the Marlett font.

Next, assign the text value for each of the buttons the following…

  • Close button, use the text r (lowercase R)
  • Minimize button, use 0 (zero)
  • Maximize button, use 1 (one)
  • Restore button, use 2 (two)

You can take a look at the Marlett font in the Windows Character Map or here for more details.

Here is an example of what the Windows buttons would look like using this font…

DatabaseDevelopment

First Look at SQL Server 2012 Management Studio

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’.

image

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.

Code Snippets

Now there are lots of code snippets are available and you can that code snippets via right Click Query window-> Insert snippets like following.

image

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

image

Zoom Functionality

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.

image

Improved IntelliSense

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.

image

A New Activity Monitor Window

image_thumb[3]

Additional features in SQL Server Management Studio:
http://msdn.microsoft.com/en-us/library/ms174219(v=sql.110).aspx

DatabaseDevelopment

SQL Server Data Tools Released

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.

clip_image002

clip_image002[5]

Resources

The following are great blogs about SQL Server Data Tools:

DatabaseDevelopment

SQL Server 2012 RTM now available on MSDN/TechNet

SQLServer2012You can now download all of the latest RTM editions of SQL Server 2012 if you have a currently active MSDN Subscription.

http://msdn.microsoft.com/subscriptions

You can read more about the new features in SQL Server 2012 here:
http://www.microsoft.com/sqlserver/en/us/get-sql-server/try-it.aspx

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