Only as Good as Your Auditor
Today we have a guest editorial from Andy Warren that talks about auditing your organization.
Understanding Graphical Execution Plans - Part 1: Explaining the Plan
Understanding execution plans is a good basic skill for all DBA's and SQL developers. Darren White gives us an overview of what execution plans are in SQL Server and how they are used.
TroubleShooting SQL Server Memory Consumption
Satnam Singh walks through the steps he took to troubleshoot a recent issue with memory consumption on a staging server.
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.
Blogs
PlanTrace Now Supports PostgreSQL
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
A New Word: the Kinder Surprise
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
Crash-Consistent Snapshot Cloning - Hyper-V Edition
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
Forums
Alamat Kantor BCA KCU PONDOK INDAH Tlp/WA.(+62 821°3111°179
Tlp/WA.(+62 821°3111°179 Wisma BCA Pd. Indah, Jl. Metro Pondok Indah No.10, RT.3/RW.17, Pd. Pinang,...
BCA KCU THAMRIN Tlpn/wa0853.7373-7551
Tlpn/wa0853.7373-7551 Menara BCA, Grand Indonesia, Jl. M.H. Thamrin No.1, Menteng, Kec. Menteng, Kota Jakarta...
BCA KCP Gatot Subroto Tlp/WA.(+62 821°3111°179
Tlp/WA.(+62 821°3111°179 Centennial Tower, Jl. Gatot Subroto No.Kav 24-25 lantai GF unit C, Karet...
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers