Memory/Storage Technology Hierarchy and SQL Server
Glenn Berry discusses the ever-changing landscape of memory/storage technology, and how it relates to SQL Server workloads on Windows servers.
Basic Data Manipulation for Relational Data in R
In this post I will attempt to explore simple commands to manipulate data pulled in from a SQL database into R.
Where Do You Run Your R Scripts?
Executing R scripts can be a heavy load. Today Steve Jones wonders if SQL Server is the best place to execute these.
Getting started with Query Store feature in SQL Server 2016 – Part 3
Arshad Ali demonstrates how you can analyze the data collected by Query Store either with T-SQL scripting or with the graphical user interface in SSMS.
One Million
The number one million has special meaning to many people. And it's a heck of a metric to achieve in a measurement on a database system.
PowerShell Just Enough Administration
A major difficulty for a System Administrator who wishes to provide access for auditors, Helpdesk staff, developers and other IT people is that adminstrator roles give users more access than they need. It is too easy to make mistakes, or to make more changes than those that were signed-off. With JEA, it is possible to create role-based access control (RBAC) endpoints that define precisely what actions you’ll let your users carry out without needing a elevated, privileged administrator credentials, and which log and report all operations.
Automatically upload SQL Server Database Backups to Azure with Integration Services
Daniel Calbimonte shows how the Feature pack in SQL Server Integration Services can connect to Azure to automatically copy your SQL Server database backups.
Developing Redgate’s SQL Toolbelt
Take a look behind the scenes to learn more about Redgate’s development challenges, what role the SQL Toolbelt plays, and which releases are coming up.
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 Kapasan No.Telp 083831617937
Whatsapp.083831617937 Jl. Kapasan 155, RT.007/RW.09, Kapasan, Kec. Simokerto, Kota SBY, Jawa Timur Surabaya, Jawa...
BCA KCP Jembatan Merah Plaza No.Telp 083831617937
Whatsapp.083831617937 Ruko Jembatan Merah Plaza Blok A No. 36-37, 38-39 Surabaya, Jawa Timur, Indonesia...
BCA KCP Jagalan No.Telp 083831617937
Whatsapp.083831617937 Jl. Jagalan No. 117 B, Peneleh, Kec. Genteng, Kota SBY, Jawa Timur Surabaya,...
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