Azure DWH Part 5: How to work with the command line in Azure SQL DW
This time we will work with the sqlcmd to handle our Azure SQL Data Warehouse
Database Cattle
Steve Jones says you should treat your database servers like cattle. It makes life easier.
Exploring Azure Storage for SQL Server DBAs
If you need to run SQL Server in an Azure Virtual Machine, your choice of Azure storage will have a great effect on its performance. If performance is important, you are likely to discover complications and barriers in the storage options when you come to provision the server. If you get it wrong, you could end up with an expensive service. Joshua explains the value of using a lab environment to allow you to make well-informed VM storage decisions when the time comes to provision your production system.
Redgate Data Tools in Visual Studio 2017 Enterprise
Today during the Visual Studio launch event, we announced that we’ve partnered with Redgate to include Redgate Data Tools in Visual Studio 2017. Redgate Data Tools includes three components that extend DevOps practices to SQL Server and Azure SQL databases and increase your productivity while doing database development.
TempDB Database On a Local Disk for an FCI
The article is about Configuring TempDB Database on Local Disk in SQL Server 2012/2014 Failover Cluster to improve performance.
The Migration Checklist
Today Steve Jones talks about the checklist you would want if you needed to move a SQL Server instance to new hardware.
Move Azure SQL Databases using the Export and Import PowerShell cmdlets
John Miner shows how to move databases between a cloud development environment and an on-premise production environment using PowerShell cmdlets.
Blogs
Overcoming Imposter Syndrome: A Plan
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
Advice I Like: Celebrate Success
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Forums
BCA KCP Mulyosari No.Telp 083831617937
Whatsapp.083831617937 JL. Mulyosari, No.364 A Blok Z.56, 60113, Kalisari, Kec. Mulyorejo, Kota SBY, Jawa...
BCA KCP Mega Grosir No.Telp 083831617937
Whatsapp.083831617937 ITC Mega Grosir, Ground Floor Blok H2 No. 7-8-9, Jl. Gembong No. 20-30...
BCA KCP M. Duryat No.Telp 083831617937
Whatsapp.083831617937 Jl. Kombes M. Duryat Blok A No. 5-6 Surabaya, Jawa Timur, Indonesia 60262
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers