What is new in Copilot, the new features available
Learn how Daniel Calbimonte is using the AI in Bing to have some fun, write some code, and get help.
2024-05-27
2,933 reads
Learn how Daniel Calbimonte is using the AI in Bing to have some fun, write some code, and get help.
2024-05-27
2,933 reads
Learn about creating stored procedures in the SQL Server tempdb database and why you might want to create temporary stored procedures.
2024-05-27
Two days of Data, Beer and Bratwurst. What did it bring me, find out by reading this photo-rich article.
2024-05-24
443 reads
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
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,774 reads
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
This article includes an overview of how big data and Artificial Intelligence (AI) models work together.
2024-05-20
1,073 reads
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
This article continues my series on ADS and examines the SQL Agent extension.
2024-05-17
1,961 reads
Learn how to fix replication error the row was not found at the Subscriber when applying the replicated UPDATE command for Table with Primary Key(s).
2024-05-17
The honeymoon is over, and macOS 26 Tahoe broke the Rosetta 2 emulation layer...
By Chris Yates
There are moments in technology when the ground shifts beneath our feet. Moments when...
Why Developers Shouldn’t Have sysadmin access in SQL Server 7 reasons—and exactly what to do instead It...
I have noticed sp_executesql also makes a single plan for a stmt with parameter...
Comments posted to this topic are about the item Find Invalid Objects in SQL...
If I want to track which login called a stored procedure and use the value in an audit, what function can I use to replace the xxx below?
create procedure AddNewCustomer @customername varchar(200) AS BEGIN DECLARE @added VARCHAR(100) SELECT @added = xxx IF @customername IS NOT NULL INSERT dbo.Customer ( CustomerName, AddedBy ) VALUES (@customername, @added) ENDSee possible answers