Tags » SQL

SQL SERVER - System procedures to know SQL Server Version

There are several ways to know the version of SQL Server. But did you know that there are two system procedures through which you can know the version? 102 more words

SQL Authority

Highest Demand Programming Languages in March 2015

A question that I hear frequently is: “Which programming language (or languages) should I learn? Usually the person asking is a student and what they really mean is, “What programming language will get me a job?!” My usual answer is that it’s more important to focus on learning concepts (like: inheritance, composition, polymorphism, data structures, design patterns, etc.) because these are pretty much the same regardless of language. 433 more words


Wrong SQL Collation

When installing SCCM 2012 R2 you might see this error:

Required SQL Server Collation

Configuration Manager requires that you configure your SQL Server instance and Configuration Manager site database (if already present) to use the SQL_Latin1_General_CP1_CI_AS collation, unless you are using a Chinese operating system and require GB18030 support.  For information about changing your SQL Server instance and database collations, see… 30 more words


Get ConfigMgr Versions

Just a quick blog to share a little SQL query that shows what version of ConfigMgr is being used at each site in you hierarchy. 183 more words


Super Scaling The SQL Server 2014 Parallel Insert: Part 4, Bulk Extent Allocation

In this post I will look at the parallel insert in whole and in particular the affect that bulk extent allocation can have.

Here are the key takeaway points from the series so far: 999 more words


How to Find Bind Variable Values for SQL Currently Executed by Oracle Server, by Zahar Hilkevich

Finding currently executed SQL is fairly trivial – all we need to know is SID of the current session which can be found in v$session dynamic performance view. 149 more words


Recursive CTE

To build a list of anything, you can use a recursive CTE query

The example below shows how to build a list of dates, 7 days apart, between 2 dates… 41 more words