The Database Development Stage
Phil Factor distills the basic tasks of the database development stage and explains how SQL Compare can help tackle them.
Why Organizations Need to Pay Attention to Cloud Security
As organisations move to cloud platforms like Azure and AWS, understanding security is more important than ever. In this article, Vasanth Makam explains what companies need to know to make sure their data is secure.
Lock Scenarios Using sys.dm_tran_locks
Learn about the impact of locking and blocking in sessions through some demonstrations of different types of actions.
The Benefits and Detractions of Remote
Working from home during the pandemic is likely to change many things, and Steve discusses a few today.
Getting Started with Automatic Database Branch Switching
Alexander Diab demonstrates how a team of developers can work on and test features in different branches of a SQL Server database development project, while their local development database automatically remains 'synchronized' with the current branch in version control.
Group By in SQL Sever with CUBE, ROLLUP and GROUPING SETS Examples
In this article we look at different examples of how to use GROUP BY with your SQL Server queries and the different results you get with the various options.
Stairway to SSAS Tabular Level 10: Multiple Dates in Fact Table
In this level of the stairway, learn about multiple dates in fact table
Getting Started with Data Masker for SQL Server: I Want to Mask A Database
Grant Fritchey explains what's involved in masking a SQL Server database. It can seem a daunting task, but it all becomes a lot more logical if you start from a plan, based on agreed data classifications, and then use a tool like Data Masker to implement the masking, and track progress.
Right-Sizing Row Mode Query Memory Requirements
When the optimizer doesn’t estimate the correct amount of memory for a query, either memory is wasted that could be used for other processes or some operations will spill to disk. Microsoft has added Memory Grant Feedback to help overcome this issue. In this article, Greg Larsen explains what you need to know about this new feature.
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