SQL Server Management Studio Recovery, Reporting, Key Combinations and Efficiency Tips
Serget Gigoyan is back with another set of 5 common SSMS tips.
Dynamic Pivot, Passing Temp Table Variables to Dynamic SQL
This example demonstrates how to perform a pivot using dynamic headers based on the row values of a table. The article also shows how to pass a temp table variable to a Dynamic SQL call.
Developing Metadata Design Patterns in BIML
You may have already experienced ETL Hell, where you have a large number of similar of SSIS tasks, and a small change, such as an alteration to the network topology, means that they all need to be altered with the correct connection details. Perhaps you should consider creating design patterns for all the standard components of integration tasks in BIML, and generating the SSIS packages from these? Amarendra walks you through the process.
The Second Best Job
Redgate is hiring someone to manage Simple Talk, a job just like the one Steve has with SQLServerCentral.
Ingest data from a web page into SQL Server 2017 using R
Siddharth Mehta shows that R libraries can be used from T-SQL to ingest data from the web into SQL Server.
Performance Myths : Oversizing string columns
Aaron Bertrand shows a quick demo that illustrates why you should be very careful about oversizing varchar / nvarchar columns.
Azure DWH part 13: Load data using Data Platform Studio
In this article we will load data from a SQL Server on-premises to Azure SQL Data Warehouse
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...
Crash-Consistent Snapshot Cloning - Hyper-V Edition
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
Forums
The New Wave of Security Threats
Comments posted to this topic are about the item The New Wave of Security...
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...
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers