T-SQL HOST_ID and HOST_NAME
HOST_ID and HOST_NAME
Included in T-SQL for SQL Server is a functions that returns the workstation information that executes a SQL...
2015-04-20
3,531 reads
Derek Wilson
SQL Server 2014 Deprecated Features
SQL Server 2014 Deprecated Features – Database Engine
Everyone looks at the new features when trying to determine when to upgrade from...
2015-03-19
2,054 reads
SQL Saturday #408 Houston – June 13th 2015
Call for speakers is now open for SQL Saturday #408 in Houston, TX. If you are interested in presenting please...
2015-03-13
902 reads
Azure Data Factory
What is the Azure Data Factory?
The Azure Data Factory is a managed service for data storage and processing. It allows...
2015-03-10
1,402 reads
T-SQL EXCEPT and INTERSECT
T-SQL EXCEPT and INTERSECT
Both T-SQL EXCEPT and INTERSECT are set based operators that combine multiple query results back in the same...
2015-03-03 (first published: 2015-02-23)
9,038 reads
T-SQL UNION Set Operator
T-SQL UNION
Set operators allow you to combine data from two or more queries and return the results in a single...
2015-02-13 (first published: 2015-02-04)
8,678 reads
SSRS Farm to Scale-Out Performance
SSRS Farm Overview
Building a SSRS farm will require Enterprise or Business Intelligence editions of SQL Server for versions 2012 and...
2015-01-26
1,373 reads
T-SQL Random Numbers using RAND() for Test Data
T-SQL Random Numbers using RAND()
SQL Server includes the T-SQL RAND() function to create a random value between 0 and 1...
2015-01-12
1,391 reads
T-SQL COALESCE Example
T-SQL COALESCE
SQL Server T-SQL coalesce simplifies the use of a case statement to find the first non-null value of your...
2014-12-30 (first published: 2014-12-26)
9,020 reads
ROW_NUMBER SQL Server
Row_Number SQL Server
SQL Server includes several Ranking Functions that can be called in T-SQL. One of these is the Row_Number()...
2014-12-22 (first published: 2014-12-16)
8,855 reads
Blogs
Car Update September 2026
By Steve Jones
Software is hard. While I love our Lucid Gravity, I realize that they are...
Microsoft Tools for Making Data AI-Ready
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
Local Models Using GPUs with Ollama
By Steve Jones
Can you use your GPUs when running a local model under Ollama? You can,...
Forums
Absolute and Relative References
Comments posted to this topic are about the item Absolute and Relative References
Moving Beyond the Reboot: Finding the Culprit Behind Memory Pressure
Comments posted to this topic are about the item Moving Beyond the Reboot: Finding...
Reserved Words I
Comments posted to this topic are about the item Reserved Words I