Find SQL Server Installation Date for all Instances with 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
Articles
Read Excel File in SQL Server with OPENROWSET or OPENDATASOURCE
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.
2019-10-17
Find SQL Server Stored Procedure Create, Modified, Last Execution Date and Code
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
Using a Surrogate vs Natural Key
A common debate in table architecture is whether to use a natural or surrogate key. In this article, I discuss some of the advantages to each method.
2019-10-15
13,086 reads
Database Tools and Extensions for Visual Studio 2019
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
A User-Defined Function returns more rows
The Problem Recently, while working with one of my clients, I came across a script in which I had to introduce a scalar User-Defined Function in the SELECT statement. The SELECT used to return around 750K records. However, after introducing the UDF, the row count significantly increased to 826K. There were no other changes made […]
2019-10-14
5,166 reads
Building Machine Learning Models to Solve Practical Problems
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
Capturing the business value of Compliant Database DevOps
You’ve probably heard of Compliant Database DevOps, but to take it from buzzword to boardroom relies on demonstrating value across your business. IT leaders must think more broadly than cost savings and ROI calculations when investing in scaling DevOps across database teams.
Our latest whitepaper explains how to lay the foundations for a successful DevOps implementation, and how to track success against global metrics that demonstrate your team’s impact across the business.
2019-10-14
Moving beyond principal components analysis
Principal components analysis is a standard, but usually terrible, technique for visualising complex data. We're using network diagrams to solve this problem.
2019-10-11 (first published: 2017-09-19)
2,607 reads
Find SQL Server Installation Date for all Instances with 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
Blogs
T-SQL Tuesday #202 Invitation: That One SQL Server Outage You’ll Never Forget
I am excited to host T-SQL Tuesday for the first time. I want to...
A Daily Report from Claude
By Steve Jones
Redgate had some Claude training recently, which I went through as my knowledge has...
A New Word: Gnossienne
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
Forums
Measuring Productivity
Comments posted to this topic are about the item Measuring Productivity
Importing Excel files into SQL Server using DuckDB and Python
Comments posted to this topic are about the item Importing Excel files into SQL...
Tracking All the Queries
Comments posted to this topic are about the item Tracking All the Queries
Question of the Day
Tracking All the Queries
I have 3 instances of a brand new long running query that are executing on a SQL Server 2025 instance. Query store is enabled. One of the queries is killed by the administrator, one is cancelled by the user. The other runs to completion. How many rows are in Query Store for this query?
See possible answers