SQL ConstantCare® Population Report: Spring 2024
The short story: SQL Server 2019 appears poised to swallow the SQL Server market altogether, hahaha.
The short story: SQL Server 2019 appears poised to swallow the SQL Server market altogether, hahaha.
Today Steve asks about your view of Managed Instance. He has found many people like the offering quite a bit.
Learn how Daniel Calbimonte is using the AI in Bing to have some fun, write some code, and get help.
Learn about creating stored procedures in the SQL Server tempdb database and why you might want to create temporary stored procedures.
Two days of Data, Beer and Bratwurst. What did it bring me, find out by reading this photo-rich article.
Steve has had a good time sharing knowledge with others at events. He gives you a few thoughts on why you might join him at a future event.
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.
Learn how to use the OneLake Explorer and Data Wrangler extension in VS Code to empower users to work with data in Microsoft Fabric.
Steve has a few thoughts on invisible downtime, a term he had never heard until recently.
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?
In the data-driven landscape of 2024, advanced SQL isn't just a nice-to-have, it's a...
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...
hello, i am trying to find where SSRS edition and product key information...
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...
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