Using Super Keys to Enforce Database Constraints
Example of Using Super Keys to Enforce Database Constraints, instead of procedural code
2017-08-07
2,420 reads
Articles
SQL Server Management Studio Recovery, Reporting, Key Combinations and Efficiency Tips
Serget Gigoyan is back with another set of 5 common SSMS tips.
2017-08-07
4,928 reads
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.
2017-08-04 (first published: 2015-10-22)
13,239 reads
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.
2017-08-04
6,028 reads
2017-08-03
15,866 reads
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.
2017-08-03
5,113 reads
Performance Myths : Oversizing string columns
Aaron Bertrand shows a quick demo that illustrates why you should be very careful about oversizing varchar / nvarchar columns.
2017-08-02
8,420 reads
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
2017-08-01
780 reads
How to Generate a Restore Script
There are multiple ways to accomplish a database restore. But if you wanted to restore a database from a script how might you accomplish that task quickly and accurately?
2017-08-01
4,704 reads
Simple Talk is hiring a full-time editor
Have experience editing and writing technical content? Redgate is currently hiring for their educational publishing site, Simple Talk. They're open to accepting remote workers, so if you're interested, there's no excuse not to go ahead and apply!
2017-08-01 (first published: 2017-07-28)
4,722 reads
Blogs
Five Ways Redshift Serverless Quietly Eats Your Budget
It is Friday, the queries are running, and nobody is watching the bill. That...
A Career of Memories
By Steve Jones
Annabel retired from Redgate Software this week. Across most of my career at Redgate,...
Rethinking Index Maintenance: Why avg_fragmentation_in_percent Is Outdated and What You Should Do Instead
By Tim Radney
As a SQL Server DBA with years of experience tuning production environments, I’ve seen...
Forums
Midjourney, Healthcare?
Comments posted to this topic are about the item Midjourney, Healthcare?
Changes, Happiness, and a Few Tears
Comments posted to this topic are about the item Changes, Happiness, and a Few...
BCP on Linux
Comments posted to this topic are about the item BCP on Linux
Question of the Day
BCP on Linux
When running bcp on Linux, what is the field terminator?
See possible answers