Selecting from hierarchies like Managers and Employees
Chuck Hoffman shows a technique using sets for selecting records from hierarchies such as Manager / Employee structures.
New Built-in Conversion Functions in SQL Server 2012
SQL Server 2012 introduces three new built-in conversion functions: PARSE, TRY_ PARSE, and TRY_CONVERT. These functions were introduced to be more familiar to users of expression languages. They perform a subset of the functionality of the pre-existing conversion functions. This article will introduce these three new functions and their usage.
20 tips on converting MySQL views to MS SQL
This article gives 20 tips how to modify MySQL views to make it compatible with Microsoft SQL Server.
New FileTable Feature in SQL Server 2012
The FileTable feature of SQL Server 2012 is an enhancement to the FILESTREAM feature which was introduced in SQL Server 2008. In this tip we will take a look at how to use FileTable feature of SQL Server 2012.
Being Responsible for Code
How responsible should developers be for their code? Facebook has an interesting way of looking at their engineers' performance.
Manage your environment with CMS
How to setup and use Central Management Server to manage a disperse environment.
When Will You Upgrade to SQL Server 2012?
Having noticed a very low rate of migration to the latest version of SQL Server, Brad McGehee asks - when will you upgrade to 2012?
Creating Chart Reports in SSRS SQL Server 2008 R2
SQL Server Reporting Services provides several ways to analyze data; one of them is creating Chart reports. Arshad Ali demonstrates how to create, modifying and beautifying the chart report quickly and easily.
Run SQL Server Scripts using C#
In this article I will run a SQL Server script to backup a database using C# in visual studio. For this purpose, I am going to use the sqlcmd.
Microsoft SQL Server AlwaysOn Solutions Guide for High Availability and Disaster Recovery
This white paper discusses how to reduce planned and unplanned downtime, maximize application availability, and provide data protection using SQL Server 2012 AlwaysOn high availability and disaster recovery solutions.
Blogs
PlanTrace Now Supports PostgreSQL
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
A New Word: the Kinder Surprise
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
VPN + SQL Server Connections: Why Long-Working Setups Suddenly Fail with Msg 10054 and “Connection Broken”
By Tim Radney
Over the past few weeks, I’ve been contacted by multiple customers experiencing the same...
Forums
There's Too Much to Learn
Comments posted to this topic are about the item There's Too Much to Learn
How to Calculate Distance Between Coordinates in SQL Server
Comments posted to this topic are about the item How to Calculate Distance Between...
SSoL Support on the OS
Comments posted to this topic are about the item SSoL Support on the OS
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers