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.
2017-02-01
5,732 reads
Learn how you can easily load data from a file that isn't duplicated, discarding those rows that are.
2017-01-31
4,443 reads
Aaron Bertrand starts digging deeper into the performance of string concatenation methods STRING_AGG and FOR XML PATH.
2017-01-31
3,209 reads
We will teach how to create a new SQL Azure Data Warehouse using Powershell
2017-01-30
1,652 reads
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...
2017-01-30
3,197 reads
What's this, a conditional WHERE clause that doesn't use dynamic SQL?
2017-01-27 (first published: 2013-04-18)
39,600 reads
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.
2017-01-27
6,538 reads
How to article on changing passwords for linked servers via TSQL and SSMS.
2017-01-26
16,682 reads
The SQL Server model database is one of the core system databases, but it seem to get less attention in terms of importance. This post from Simon Liew will demonstrate the havoc the model database can cause when database integrity checks exclude the model database and corruption goes undetected.
2017-01-26
4,940 reads
In this article, we will learn how to use Visual Studio to query Azure SQL Data Warehouse tables and how to create a new table.
2017-01-25
2,750 reads
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
BCA Finance Tangerang Layanan Mobil Telpon/WA:085188120691 Scientia Garden, Jl. Gading Serpong Boulevard No.1 Blok...
BCA KCU HARAPAN INDAH Telpon/WA:085188120691 Jl. Sentra Niaga Jl. Harapan Indah Boulevard Kav. CP2...
BCA MULTI FINANCE CAB SUNTER Telpon/WA:085188120691 Ruko Danau Sunter Utara, BLK. a 36D Jl....
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers