Managing SQL Server containers using Docker SDK for Python - Part 1

• by Carlos Robles

• SQLServerCentral

• Containers
• Docker
• Python

There are multiple ways to interact with the Docke...

Upgrading Your OS

• by Steve Jones

• SQLServerCentral

• Microsoft
• Windows

Windows 7 support is ending, but Microsoft doesn't have a good plan for home users. Steve notes that the OS upgrade treadmill ought to come to an end soon.

How to Copy a Table in SQL Server to Another Database

• by Additional Articles

• MSSQLTips.com

• Table

Learn about options to copy a table from one SQL Server database to another including Linked Servers, PowerShell, Integration Services, backup and restore along with the associated performance metrics and completion time.

NOSQL and RDBMSs

• by David Poole

• SQLServerCentral.com

• Editorial

NOSQL and RDBMS are evolving and absorbing ideas from each other. Is this necessarily a good thing? Perhaps we should think again

Stairway to DAX and Power BI - Level 11: Function / Iterator Function Pairs: The DAX Concatenate() and ConcatenateX() Functions

• by Bill Pearson

• SQLServerCentral.com

Continuing his examination of the evolving DAX “Function / Iterator Pairs,” Business Intelligence Architect, Analysis Services Maestro, Microsoft Data Platform MVP and author Bill Pearson introduces the DAX Concatenate() and ConcatenateX() functions, discussing the syntax, uses and operation of each. He then provides hands-on exposure to Concatenate() and ConcatenateX(), in joining two text strings into a single text string, and in returning the concatenation of an expression evaluated for each row in a table, respectively.

Free eBook: SQL Server Execution Plans, Third Edition

• by Press Release

• Redgate

• Execution Plans

If a query is performing poorly, and you can't understand why, then that query's execution plan will tell you not only what data set is coming back, but also what SQL Server did, and in what order, to get that data. It will reveal how the data was retrieved, and from which tables and indexes, what types of joins were used, at what point filtering, sorting and aggregation occurred, and a whole lot more. These details will often highlight the likely source of any problem.

SQL Server Common Table Expression vs Temp Table

• by Additional Articles

• MSSQLTips.com

• Common Table Expressions (CTE)
• Temporal Tables

In this tip we look at how to use Common Table Expressions CTE in SQL Server including the syntax, use cases, using more than 1 CTE at the same time and recursive CTEs with a parameter.

Are We Suckers?

• by Steve Jones

• SQLServerCentral.com

• Editorial

This week Steve Jones wonders if we work too much. Do we give more to our employers than they give to us?

Slower is Faster

• by MVDBA

• SQLServerCentral

• DevOps and Continuous Delivery (CI/CD)

How changing developer practices might slow you do...

SQL in the City Summits Down Under

• by Press Release

• Redgate

• event

Redgate are inviting senior data professionals to attend one of the upcoming SQL in the City Summit events taking place in June. If you’re interested in learning how your business can benefit from implementing Compliant Database DevOps this event is for you. Find out who’s presenting and register for a Summit near you today.