TechNet Guru Awards – December 2013

The TechNet Guru Awards celebrate the technical articles on TechNet, contributed from valued wiki authors like YOU! Each month, the contributions are scored by a panel of judges (5 per category, 2-3 in each are MS experts), and the winners of each category are showered with love and attention from all corners of TechNet.   The December results are…

1

TechNet Guru Awards – November 2013

The TechNet Guru Awards celebrate the technical articles on TechNet, contributed from valued wiki authors like YOU! Each month, the contributions are scored by a panel of judges (5 per category, 2-3 in each are MS experts), and the winners of each category are showered with love and attention from all corners of TechNet.   The November results are…

0

TechNet Guru Awards – October 2013

I’m a bit behind on posting the TechNet Guru award winners for the past few months, so I’m catching up today.  These awards represent many hours of contribution from each of the contributors, not just the winners, and the community benefits greatly from these articles.  Thanks again to all who participate each month and I…

0

EOMONTH() Equivalent in SQL Server 2008 R2 and below

  SQL Server 2012 introduced several new system functions pertaining to the date and time data types.  In my opinion, I’ve found the EOMONTH(), “end of month”, function to be one of the most useful.  The EOMONTH() function returns the final day of the calendar month, thus greatly simplifying a common calculation, taking into account…

10

TechNet Guru Competition – Show off your SQL Server skills!

  Over the past few months, I’ve had the opportunity to help judge a great new online competition on TechNet Wiki spanning many Microsoft technologies and including several SQL Server categories.  The contest requirements are very basic and contribute to the overall SQL Server community by increasing the amount of user contributed content on TechNet…

1

SSMA for Oracle – Error: No columns were returned from the database for table ‘Foo’

  Error:  SQL Server Migration Assistant for Oracle fails to load columns with error “Loading columns for table or view ‘Table_Name_1’ failed.”   Solution:  Connect to the Oracle instance using the OLE DB provider instead of the default .NET Oracle Client provider.   On a recent client project, we were tasked with upgrading a very…

2

Language Translation in SQL Server using Bing Translator APIs & SQL CLR

Language Translation within SQL Server using Microsoft Translator public APIs and CLR Stored Procedures / Functions   Does SQL Server have a built-in way to translate my text data from English to Spanish, German to French, Italian to Russian?  The answer is no, SQL Server does not have this functionality built-in, but it is indeed possible to build by…

14

Bulk Database Migration from On-Premise SQL Server to SQL Azure – Step 1: Bulk .bacpac Export

I recently had a task to perform a bulk migration of hundreds of databases to Windows Azure SQL Database (formerly known as SQL Azure) from an instance of SQL Server 2012.  If you need to migrate a very small number of databases, the easiest way is likely through the SSMS export Data-Tier Application wizard.  You can…

4

Creating Complex Test Databases – Generating One Table for each of the 2,397 supported Collations

As a follow up to my series on complex test databases, this article will cover one of the more interesting test databases that I recently created.    Goal:  Create a database that includes one table for each supported collation.  Each table contains a single column with the various column level collations supported by SQL Server 2012 (nearly…

0

TSQL – Solve it YOUR Way – Finding a Person’s Current Age Based on Birth Date

Introduction: As part of the blog series TSQL – Solve it YOUR Way, today’s topic will cover a question asked recently in the T-SQL MSDN forums where the solution, at first, seems extremely obvious.  However, as solutions were proposed and flaws were discovered with the proposals, the interesting nature of the problem was revealed.  As is the theme…

12