SQL Server Agent Job Monitoring for Last Execution
In this article we continue our series of using PowerShell to monitor SQL Server by collecting the last run information for SQL Server Agent Jobs.
2020-08-12
SQL Server
SQL Server Bulk Insert for Multiple CSV Files from a Single Folder
Check out this article to see how to quickly import into SQL Server many files with the same structure using T-SQL.
2020-08-11
How to Expand a Range of Dates into Rows using a SQL Server Numbers Table
In this article we look at different T-SQL code examples that can help you build a range of date rows based on a starting and ending date.
2020-07-28
Using SQL Server Query Store & Plan Guides to Fix Problem Queries
This webinar will cover how to use SQL Server plan guides and the query store to fix problematic queries and ways to improve query performance.
2020-07-14
Setting up Management Studio for remote SQL Server
Learn how to configure SQL Server and Windows to allow others to connect to an instance remotely.
2020-01-06
137,715 reads
Update only Year, Month or Day in a SQL Server Date
In this tip we look at how to change specific parts of a date such as the Year, Month or Day for data stored in a SQL Server table.
2019-12-17
A Big Week for the Data Platform
Steve highlights a few items from a busy Microsoft and SQL Server news week.
2019-11-09
236 reads
Getting Started with SQL Server on Google Cloud Platform
Learn how you can create a SQL Server instance in the Google Cloud Platform.
2019-09-26
3,924 reads
2019-09-14
307 reads
Technology Flows Downstream
The technologies that we see in other data platform products sometimes flow to SQL Server.
2019-06-20
260 reads
Blogs
A New Chapter: Why I Made the Move from Dayforce to ESO
By gbargsley
A New Chapter: Why I Made the Move from Dayforce to ESO Over the...
Lean Six Sigma – Brief
By Vinay Thakur
When you have a project or system, it has to be optimized, tuned, and...
T-SQL Tuesday #200: Bad Query signals
NO AI was used to generate this content. Grammarly was used to check and...
Forums
Reading Parquet using openrowset
Hi, We are looking out to read parquet file directly from on premise shared...
Impact of Single-Threaded PVS Cleanup on ADR in SQL Server 2019
We want to enable ADR on our SQL Server 2019 instances. I’ve heard that...
Forward Deployed Engineers
Comments posted to this topic are about the item Forward Deployed Engineers
Question of the Day
DBCC CHECKDB Limits II
I have a SQL Server 2025 database that I want to check for corruption every night. One of the things we do is disable indexes used for ETL loads during the weekend and re-enable them on Monday morning. If we run DBCC over the weekend, are our disabled indexes checked for consistency?
See possible answers