Additional Articles

Windows Containers and Docker

by Additional Articles

SimpleTalk

Windows Containers

Windows Server 2016 features support for containers. These are not Linux-based, but containers that run on Windows and run Windows on the inside. These conform to the Open Container Initiative (OCI). They allow you to run applications insulated from the rest of the system, within portable containers that include everything an application needs to be fully functional. As they did with Linux, containers will change the nature of the software supply chain for Windows users.

2016-08-19

6,766 reads

Why Not Just Create Statistics?

by Additional Articles

Brent Ozar Blog

statistics (data)

Erik Darling looks at why you should be more interested in up to date statistics, and also why statistics outside of indexes aren’t really the most helpful thing.

2016-08-18

4,899 reads

Simple T-SQL Code Comparison With PowerShell

by Additional Articles

MSSQLTips.com

PowerShell

Tim Smith shows how you can use PowerShell to automate a simple comparison of objects such as stored procedures, views, and fucntions.

2016-08-17

3,933 reads

Crossing the Site Domain with JavaScript

by Additional Articles

SimpleTalk

ASP.NET

Browsers try to prevent a range of malicious attacks by preventing content being accessed by a web page from a different domain to the one that the page was fetched from. If you have a legitimate need to do this, it is a bad idea to disable this method of defence: Instead, there are more legitimate and safer ways of performing cross-domain JavaScript calls such as JSONP or Cross-Origin Resource Sharing, as Dino explains.

2016-08-16

2,961 reads

Paying Attention to Estimates

by Additional Articles

SQLPerformance.com

Migration

Aaron Bertrand follows up on a recent post about DATEFROMPARTS() with a deeper look into the estimates and potential mitigation techniques.

2016-08-15

3,092 reads

SQL Server Stored Procedure to Compress Non Partitioned Tables

by Additional Articles

MSSQLTips.com

Compression

My SQL Server database has some very big tables that can be compressed. The tables are simple, non-partitioned tables and I want a quick tool to compress them. I

2016-08-12

2,979 reads

SSIS in SSDT: The Basics

by Additional Articles

SimpleTalk

Integration Services (SSIS)

SQL Server Integration Services (SSIS) is a fast and reliable way of importing and exporting data, but it can be tricky to learn, initially. Rob Sheldon provides a beginner's guide to get you started with using SSIS with Visual Studio and SQL Server Data Tools (SSDT).

2016-08-11

6,766 reads

Stretch Database in SQL Server 2016 RTM

by Additional Articles

SQLPerformance.com

Stretch Database

Tim Radney of SQLskills shows how the Stretch Database feature has evolved from its early CTP beginnings to the RTM version released earlier this month.

2016-08-10

2,545 reads

Steps to change the server name for a SQL Server machine

by Additional Articles

MSSQLTips.com

In this tip Jugal Shah looks at the steps within SQL Server you need to follow if you change the physical server name for a standalone SQL Server.

2016-08-09

4,870 reads

Database Lifecycle Management: Deployment and Release

by Additional Articles

SimpleTalk

deployment

So often, the unexpected delays in delivering database code are more likely to happen after the developers initiate the release process. The necessary checks and tests can turn up surprises: The handover process can expose deficiencies. With good teamwork, planning and forethought, though, the process can be made almost painless.

2016-08-05

4,063 reads

All authors

Additional Articles

Windows Containers and Docker

Why Not Just Create Statistics?

Simple T-SQL Code Comparison With PowerShell

Crossing the Site Domain with JavaScript

Paying Attention to Estimates

SQL Server Stored Procedure to Compress Non Partitioned Tables

SSIS in SSDT: The Basics

Stretch Database in SQL Server 2016 RTM

Steps to change the server name for a SQL Server machine

Database Lifecycle Management: Deployment and Release

Blogs

“We love to debate minutiae”

Advice I Like: Knots

Shifting Mindsets: Why FinOps is Essential for Cloud Efficiency

Forums

how to write this query?

Windows logins for users migrated from DomainA to DomainB

Multiple Deployment Processes

Question of the Day

Upgrading Admin Queries