SQL Database Overview
Learn about what a SQL database is, what is stored in a database and how to interact with a database.
2022-06-17
Database Administration
2022-05-23
432 reads
2022-01-12
349 reads
2022-01-05
597 reads
Challenging Trends
Steve notes the changes in the world might affect how to view and use data in our work.
2022-01-05
253 reads
Data Cleanup
Steve wishes we could do some data cleanup and archival every year. Or even more often.
2022-01-03
311 reads
2021-12-06
376 reads
Building blocks of Extended Events data collection
Extended Events have been part of SQL Server since 2008. In this article, Ed Pollack explains the building blocks of Extended Events data collection.
2021-10-04
Improving performance with instant file initialization
Instant file initialization can speed up database creation, file growth, and restores. Greg Larsen explains how to configure it and how it works.
2021-08-18
SQL Server and hyperconvergence
To be efficient and save money, many organizations are looking at hyperconverged infrastructures for SQL Server. In this article, Robert Sheldon explains what to consider for SQL Server and hyperconvergence.
2021-07-09
Blogs
How to find free space in Azure PosgreSQL
I wanted to figure out how big (or approximately how big) my dump file...
T-SQL Tuesday #180: Good enough is perfect Roundup
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
Using SQL Compare with Read-only Access
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
Forums
Announcing SQL Server 2025
Comments posted to this topic are about the item Announcing SQL Server 2025
Running Steve's Code
Comments posted to this topic are about the item Running Steve's Code
New SQL Server 2022 Functions
Comments posted to this topic are about the item New SQL Server 2022 Functions
Question of the Day
Running Steve's Code
Can you run this code in any of your SQL Server 2019 databases without error?
CREATE OR ALTER PROCEDURE [dbo].[StevesAmazingProc]
AS
SELECT Consumer_ID ,
Trend_Category ,
Bit_Trace
FROM NewWorldDB.dbo.MarketTrend;
GO See possible answers