Find SQL Server Installation Date for all Instances with PowerShell

• by Additional Articles

• MSSQLTips.com

• PowerShell

In this tip we look at a PowerShell script you can use to gather information about the installation date for all of your SQL Servers.

2019-10-18

Read Excel File in SQL Server with OPENROWSET or OPENDATASOURCE

• by Additional Articles

• SQLServerCentral

• Excel
• OPENROWSET

In this tip we look at how to read an Excel file from within SQL Server using OpenRowSet and OpenDataSource along with the possible errors you may encounter and how to fix these issues.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

2019-10-17

Find SQL Server Stored Procedure Create, Modified, Last Execution Date and Code

• by Additional Articles

• MSSQLTips.com

• Stored Procedures

In this tip we look at different scripts you can use to find when a SQL Server stored procedure was created, modified, last executed and to also return the code for the stored procedure.

2019-10-16

Database Tools and Extensions for Visual Studio 2019

• by Additional Articles

• Database Journal

• visual studio

In this article, you will explore tools and extensions that can be used with Visual Studio 2019 to improve your database experience irrespective of what database you use.

2019-10-15

Building Machine Learning Models to Solve Practical Problems

• by Additional Articles

• SimpleTalk

• Data Science

Machine learning is a skill that many data professionals are learning as they plan their careers over the next five to ten years. In this article, Supriya Pande gives an overview of machine learning and walks through a practical example.

2019-10-14

Find SQL Server Installation Date for all Instances with PowerShell

• by Additional Articles

• MSSQLTips.com

• PowerShell

In this tip we look at a PowerShell script you can use to gather information about the installation date for all of your SQL Servers.

2019-10-11

Foreign Keys and Multi-Table Inserts in Oracle

• by Additional Articles

• Database Journal

• Oracle

Referential constraints ensure data integrity, but in at least one case can cause occasional problems. Read on to see what can happen and why it can occur...

2019-10-11

Free Solution Brief – Dedicated Database Environments for Dev, Test and CI

• by Additional Articles

• Redgate

• SQL Provision

Developers and testers can be blocked from having a local, private database to work in because of disk space, refresh times, and data privacy. Download this free solution brief to learn how SQL Provision removes these blockers and enables production-like data to be delivered at speed.

2019-10-11

Handling Tricky Data Migrations during State-based Database Deployments

• by Additional Articles

• Redgate

• SQL Change Automation

This article demonstrates how to use a 'state' approach to database source control, when the nature of the database changes cause you to hit difficulties with migrating existing data. These difficulties happen when the differences are such that it is impossible for any automated script to make the changes whilst preserving existing data.

2019-10-10

SQL Server Management Studio is as Relevant as Ever

• by Additional Articles

• SimpleTalk

• Management Studio (SSMS)

In this Simple Talk editorial Kendra Little discusses how SSMS is as relevant as ever.

2019-10-10