SQL Server Temporary Stored Procedures
Learn about creating stored procedures in the SQL Server tempdb database and why you might want to create temporary stored procedures.
2024-05-27
Articles
Manage Elastic jobs in Azure using Azure Elastic Jobs Manager
Microsoft Azure offers Azure Elastic Job agent as a managed service, enabling efficient scheduling of T-SQL workloads on Azure SQL Databases. Learn how to configure the service in this article.
2024-05-24
686 reads
Takeaways from Data Grillen 2024
Two days of Data, Beer and Bratwurst. What did it bring me, find out by reading this photo-rich article.
2024-05-24
382 reads
How to Build Metadata Driven Pipelines in Microsoft Fabric
Over the past years, “traditional” ETL development has morphed into data engineering, which has a more disciplined software engineering approach. One of the benefits of having a more code-based approach in data pipelines is that it has become easier to build metadata driven pipelines.
2024-05-24
Empowering Lakehouse Users – Data Engineering with Fabric
Learn how to use the OneLake Explorer and Data Wrangler extension in VS Code to empower users to work with data in Microsoft Fabric.
2024-05-22
1,218 reads
Troubleshoot SQL Server Always On Availability Groups with SQL LogScout
We experienced several unplanned outages and failovers on our SQL Server Always On Availability Groups. We want to know the root cause to prevent them from happening in the future. How do we identify the root causes of unplanned Availability Group outages and failovers?
2024-05-22
SQL Server 2022 Build List
This is a list of the builds for SQL Server 2022. There are other build lists available here. A list of all the builds that I can find and install on my Build VM. If you find a build not listed here, please let the webmaster know (webmaster at sqlservercentral.com). All builds are listed in reverse […]
2024-05-21 (first published: 2022-09-01)
2,749 reads
How Big Data Supports Gen AI
This article includes an overview of how big data and Artificial Intelligence (AI) models work together.
2024-05-20
716 reads
Recursive CTEs: Transforming and Analyzing Data in PostgreSQL, Part 3
The first two articles in this series demonstrated how PostgreSQL is a capable tool for ELT – taking raw input and transforming it into usable data for querying and analyzing. We used sample data from the Advent of Code 2023 to demonstrate some of the ELT techniques in PostgreSQL.
2024-05-20
Managing SQL Agent in Azure Data Studio
This article continues my series on ADS and examines the SQL Agent extension.
2024-05-17
1,112 reads
Blogs
Export Extended Event Results to CSV or Table
This is something that I’ve seen pop up a couple of times on various...
Introduction to OpenAI and LLMs – Part 2
By James Serra
My previous blog post on this topic was Introduction to OpenAI and LLMs, the...
Large System Databases on SQL Server
This one is an oldie in my blog drafts, but a goodie! So, I...
Forums
Parse Double Quoted comma separated data with comma
I've used this function before and I'm sorry I do not recall it's origination. ...
What is re-enabling Ole Automation Procedures?
Hello experts, I'm trying to disable (0) Ole Automation Procedures via sp_configure. But each...
Database Engine Tuning Advisor in Azure
Hello, all We have several performance issues, which I think could be mitigated by...
Question of the Day
Logon Trigger Messages
I created this trigger in SQL Server 2022:
CREATE TRIGGER checksteve ON ALL SERVER FOR LOGON AS BEGIN IF ORIGINAL_LOGIN()= N'ARISTOTLE\Steve' PRINT 'Steve logged in' END; GOWhere can I view "Steve logged in"? See possible answers