Example of Using Super Keys to Enforce Database Constraints, instead of procedural code  Read more...

Serget Gigoyan is back with another set of 5 common SSMS tips.  Read more...

Phil Factor's a 'tethered goat' database taught in the value of database intrusion detection and of "defense in depth".  Read more...

Different people respond to different types of learning techniques. Maybe a puzzle is the way that you learn.  Read more...

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.  Read more...

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.  Read more...

Finally a fuzzy search that finds all sorts of misspellings and missing parts.  Read more...

Siddharth Mehta shows that R libraries can be used from T-SQL to ingest data from the web into SQL Server.  Read more...

Redgate is hiring someone to manage Simple Talk, a job just like the one Steve has with SQLServerCentral.  Read more...

SQL Monitor’s dev team has made huge improvements to the product over the last year. In the first half of 2017 alone, they released reporting capabilities, support for collecting metrics from VMWare hosts, significant improvements to performance and scalability, improved configurability of alerts, as well as dozens of smaller enhancements. Since we’re about half way through 2017, it’s time to talk about the plans for the rest of the year.  Read more...

This level of the stairway details the creation of a relational database, as well as filling in some of the history of the relational database model.  Read more...

Three SQL Server MVPs (Jonathan Kehayias, Ted Krueger and Gail Shaw) provide fascinating insight into the most common SQL Server problems, why they occur, and how they can be diagnosed using tools such as Performance Monitor, Dynamic Management Views and server-side tracing. The focus is on practical solutions for removing root causes of these problems, rather than "papering over the cracks".  Read more...

GE is training lots of its staff in data science.  Read more...

Aaron Bertrand shows a quick demo that illustrates why you should be very careful about oversizing varchar / nvarchar columns.  Read more...

It's not easy to keep track of software licenses in a large organization.  Read more...

In this article we will load data from a SQL Server on-premises to Azure SQL Data Warehouse  Read more...

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?  Read more...

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!  Read more...

Steve Jones worries about the coding being done in today's vehicles.  Read more...

Discover how to integrate features of Visual Studio and the SSIS Catalog for an efficient development and deployment environment.  Read more...