It is the data, in particular, that sets Database Lifecycle Management apart from the mainstream of application delivery. Data entities, and the way that organisations understand and deal with them, have their own lifespan. If we neglect the management of data, we risk disaster for the organisations that use it. If we take data management seriously, databases become a lot easier.
We all have different levels of skills, and it's not always because we don't try. Sometimes it's a question of timing.
Learn how you can easily load data from a file that isn't duplicated, discarding those rows that are.
Aaron Bertrand starts digging deeper into the performance of string concatenation methods STRING_AGG and FOR XML PATH.
We will teach how to create a new SQL Azure Data Warehouse using Powershell
Database Lifecycle Management (DLM) aims to provide a roadmap of what is required, and when, to deliver and maintain effective databases that can respond quickly to business change. How...
What's this, a conditional WHERE clause that doesn't use dynamic SQL?
Because it is important with maintaining Virtual Machine environments to be able to repeat routine tasks completely accurately, Windows PowerShell has grown in importance for the job. Now you can manage the Hyper-V environment via PowerShell without needing to use the Hyper-V Manager console. It opens up many opportunities for automation.
How to article on changing passwords for linked servers via TSQL and SSMS.
By Steve Jones
While wandering around the documentation looking for some Question of the Day topics, I...
By Arun Sirpal
Third part in my Ai series with databases. When building AI solutions within the...
By Steve Jones
This month we have a very interesting invitation from Koen Verbeeck. He has hosted...
Please I am hoping for some feedback Specifications: Windows Server 2022 SQL Server 2022...
Comments posted to this topic are about the item How Do the Experts Become...
Comments posted to this topic are about the item Stairway to Reliable Database Deployments...
As of June 2026, what is the best version of TLS to use with SQL Server?
See possible answers