Listing members of a group in SQL Server.
In SQL we are used to the GROUP BY and the type of result it produces. In real life, we...
2010-10-11
1,570 reads
SSMS Tip – Tab Groups
A few months ago as I came across tab groups in SSMS and once I found them I was very...
2010-10-11
1,099 reads
Return Values from XP_CMDSHELL
Let’s be clear: I don’t recommend the use of xp_cmdshell as a general tool. It ought to be used when...
2010-10-11
17,417 reads
Getting ready for the third “Industrial Revolution”: Database 2010-2015
I searched the internet for “connect and forget”. Wonderbox.net offer is described as a...
2010-10-10
26 reads
Getting ready for the third “Industrial Revolution”: Database 2010-2015
I searched the internet for “connect and forget”. Wonderbox.net offer is described as a “revolutionary computer server”… I think of wonderbox as a “computing appliance”, but Wikipedia limits the...
2010-10-10
14 reads
Time Saver – Presentation Preparation
Presenting is a huge fear for many and it is no different for me. I have been presenting at SQL...
2010-10-10
591 reads
Project Phoenix
Project PhoenixSometime people need a hand up – an opportunity to rise from the ashes. Over the last couple of years...
2010-10-09
897 reads
What are Physical Sockets, Physical Cores, and Logical Cores and Why Does it matter?
I witnessed a confused conversation on Twitter today where someone was talking about how he uses the terms sockets and...
2010-10-09
12,727 reads
Issues With Calculating Current Age Using DateDiff (Rounding?)
Recently I inherited a set of SSIS packages that did a pretty simple calculation for age.It used the following expression,...
2010-10-09
1,387 reads
SSRS - Join Function
Often when designing a Reporting Services with parameters you
may be required to display those parameter values on your report.This is...
2010-10-08
4,199 reads
Blogs
Narrow Task Decomposition in AI Pipeline Agents
A nightly load into sales_fact fails. Ask an orchestrating agent to break down the...
Car Update: August 2026
By Steve Jones
It’s been some time since I provided a car update, so I decided to...
Microsoft Fabric OneLake Shortcuts: When to Use Them and When Not To
By James Serra
An architecture scenario Imagine separate Sales, Finance, Shared Data, and Executive Analytics workspaces. Sales...
Forums
Alamat Kantor BCA KCU Bintaro Telp:08217555651
Hub Via Wa:628217555651 Alamat: Bintaro Jaya Blok A-5 No.12 & 15, Sektor 7, Pd....
Alamat Kantor BCA KCU Alam Sutera Tlp:08217555651
Hub Via Wa:628217555651 Alamat: Perumahan Alam Sutera, Jl. Alam Sutera Boulevard No.10A, Pakulonan, Kec....
Alamat Kantor BCA KCU Tangerang Telp:08217555651
Hub Via Wa:628217555651 Alamat: Jl. Kisamaun No.57, RT.001/RW.006, Sukasari, Kec. Tangerang, Kota Tangerang, Banten...
Question of the Day
Backing Up a DMK
In SQL Server 2025, I have a database with a Database Masker Key (DMK). I want to back up this key and keep a copy offline. When do I have to open this key before running the backup?
See possible answers