SQL Server 2008 R2 Books OnLine - available now...
SQL Server 2008 R2 is released on April 21st, 2010 and in parallel with this new release, now is available...
2010-04-26
2,933 reads
Speaking at Auckland, New Zealand SQL Users Group
On Tuesday Morning at 2:00 am EST time I will be speaking at the Auckland SQLUsers Group. This will be...
2010-04-25
545 reads
Need Data from a Mac: TransMac for Reading HFS Volumes a Lifesaver
Recently I was handed over a HFS volume to read from my colleague who uses his Macbook exclusively. We had...
2010-04-25
1,041 reads
A DMV a Day – Day 25
The DMV for Day 25 is sys.dm_os_memory_cache_counters, which is described by BOL as:
Returns a snapshot of the health of a...
2010-04-25
1,700 reads
Reporting Services 2008 R2 Report Parts
Reporting Services 2008 R2 has many new great features that I’ve written about lately (Data Bars and Indicators). Today I...
2010-04-24
1,337 reads
A DMV a Day – Day 24
The DMV for Day 24 is sys.dm_exec_requests, which is described by BOL as:
Returns information about each request that is executing...
2010-04-24
974 reads
Besides Being a DBA, Do You Also Happen to be an Exchange Administrator?
I know a lot of DBAs fall into the category of part-time DBAs, because they work in small IT shops...
2010-04-23
552 reads
SQL Server 2008 R2 Road Show Recap
This past week I had the opportunity to speak at three SQL Server R2 Launch events.I spoke in three cities...
2010-04-23
403 reads
Looking forward to Optimize for Ad hoc Workloads in Sql Server 2008
Looking forward to Optimize for Ad hoc Workloads in Sql Server 2008
One of the features of SQL Server 2008 that...
2010-04-23
3,254 reads
Increasing deadlocks with NoLock
One of my personal pet issues is with inappropriate use of the NOLOCK hint (and read uncommitted) . Don't get me...
2010-04-23
760 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 BCA KCU Gading Serpong Tlp:08218154374
Hub Via Wa:628218154374 Alamat Summarecon Serpong, Perumahan Gading Serpong, Jl. Gading Serpong Boulevard Cluster...
Alamat BCA KCU Tangerang City Telp:08218154374
Hub Via Wa:628218154374 Alamat Komp. Tangerang City Ruko Skandinavia Blok H 6-8 & 18-20,...
Alamat Kantor BCA KCU Serang Telp:08218154374
Hub Via Wa:628218154374 Alamat Jl. Pangeran Diponegoro No.14, Kotabaru, Kec. Serang, Kota Serang, 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