Converting Rows to Columns (PIVOT) and Columns to Rows (UNPIVOT) in SQL Server
Learn how to convert row values into column values (PIVOT) and column values into row values (UNPIVOT) in SQL Server.
How do you use change scripts for your database deployments?
Redgate is researching how people deploy their database changes. This is a very quick survey, and there's an opportunity to sign up for a research call in exchange for a $50 Amazon voucher.
Cellular Automation – SQL Server CPU, IO and Hekaton Stress Testing
This article shows how you can use SQL Server spatial methods, mathematical rules and oscillating patterns to benchmark CPU, IO and Hekaton performance.
Five Minute Refactoring
The debate over how to change code or solve a problem can create arguments that last for years. Steve Jones notes the idea of limiting debates to five minutes is interesting.
The Challenges of Space
CSS Engineers at Microsoft are reporting more space issues with database systems. Steve Jones has a few comments.
Powershell day-to-day Admin tasks: WMI, CIM and PSWA
WMI (Windows Management Instrumentation) is the basic way of querying and changing basic information about any windows server, including SQL Server or Exchange Server. It provides a logical structure and representation of systems and services that are hosted on the server and is essential for anyone who is keen to automate routine monitoring and administration work via PowerShell, especially where many servers are involved in the task.
Stored Procedures and SQL Injection
Why do stored procedures help with security? In this piece, MVP Brian Kelley explains why SQL Injection and information gathering are hampered with stored procedures.
Managing Test Data as a Database CI Component - Part 2
Tim Hidalgo goes through some practical demos to show you how you can automatically keep your testing environments up to date, and ship more robust databases.
Add Styles to Your Reporting Services Reports
Reporting Services provides a robust reporting platform that rivals many other products. New author Adam Aspin stars a series on how you can dress up your reports and maintain good development practices.
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 Kapuk Muara Telp:cs.(0821)8171955
Whatsapp:08218171955 Jl. Duta Harapan Indah Jl. Kapuk Muara Raya No.33 Blok K.32, Kapuk Muara,...
BCA KCP Kapuk Muara Tlp (+62 821°3111°179
Jl. Duta Harapan Indah Jl. Kapuk Muara Raya No.33 Blok K.32, Kapuk Muara, Kecamatan...
BCA KCP Maranatha No.Tlp.083179431643
Jl. Prof. Drg Jl. Prof. drg. Soeria Soemantri No.33, Sukawarna, Sukajadi, Bandung City, West...
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