TechNet Guru Awards – September 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 September results are…

3

TechNet Guru Awards – August 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 August results are…

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

SQL Server 2012 Discovery Report – Determining what SQL Server Components are Installed

How can I determine which SQL Server features and versions are on my computer?   This continues to be one of the more frequently asked questions on the MSDN Forums and is important for many reasons, including patching, security, compatibility with other applications, network compliance, and even troubleshooting failed installs.  Over the years, I’ve pointed many people…

4

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…

13