2024-06-14
200 reads
2024-06-14
200 reads
2024-06-14 (first published: 2018-12-20)
10,260 reads
Recently I’ve been looking at archiving some data at SQL Saturday, possibly querying it, and perhaps building a data warehouse of sorts. The modern view of data warehousing seems...
2024-06-14 (first published: 2024-05-20)
229 reads
2024-06-12
378 reads
2024-06-07
319 reads
Steve sees that poor database design is the reality of the world and we have to work around that.
2024-06-07
123 reads
This month is a great topic to me. I think growing and improving your career is a skill that most of us could improve, especially in our younger years....
2024-06-07 (first published: 2024-05-14)
564 reads
2024-06-05
392 reads
What is an AI LLM useful for? Steve thinks a first draft is not a bad way to look at your AI results.
2024-06-05
77 reads
Microsoft is no longer supporting some uses for DBCC CLONEDATABASE. Read a few of Steve's thoughts on the change.
2024-06-03
81 reads
A couple of weeks ago, a developer came to me and wanted to know...
By SQLPals
Database Property LastGoodCheckDbTime to Get the Last Successful DBCC CHECKDB on a Database As one...
When you develop data pipelines in Microsoft Fabric (the Azure Data Factory equivalent in...
Comments posted to this topic are about the item Baseball Everywhere
I am working on a small test script on SQL server 2022 using python...
Upgrade to SQL2019 from 2012 Query is taking time, Need Query Optimization steps and...
I want to use the ADD SENSITIVITY CLASSIFICATION DDL to mark some columns in my SQL Server 2022 database as PII. Can I use this code?
ADD SENSITIVITY CLASSIFICATION TO dbo.sales.price, dbo.sales.discount WITH ( LABEL = 'Highly Confidential', INFORMATION_TYPE = 'Financial', RANK = 'INTERNAL ONLY' );See possible answers