Powershell Add-Member: IsLogBackupAllowed ?
In my previous post, I shared some of the issues I had when attempting to get Add-Member to work with...
2012-07-05
1,504 reads
SQL SERVER:How Can I Get Notification Alert When Fail Over Happened ?
It was long time I was searching for simple solution to get notification alert in my inbox when ever fail...
2012-07-16 (first published: 2012-07-05)
5,074 reads
MDX ‘Is’ Operator
I recently encountered a business scenario involving calculated members in a cube that I thought is worth sharing.
We have a...
2012-07-04
827 reads
View SQL Server information using Transact-SQL script
Recently one of our clients requested information about their SQL Server infrastructure which we manage. In order to complete this...
2012-07-13 (first published: 2012-07-04)
9,067 reads
Lost in Translation – Deprecated System Tables – syscomments
This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective...
2012-07-04
1,016 reads
Fourth of July Bloopers
Here you go. The raw ones.
It’s a holiday, and usually I’m spending time with the family and enjoying the...
2012-07-04
1,112 reads
Lost in Translation – Deprecated System Tables – syscolumns
This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective...
2012-07-13 (first published: 2012-07-04)
2,687 reads
SQL SERVER : The Scene Behind NOLOCK
I have heard many time people talking about the NOLOCK hint. Some of them says it improves the performance and...
2012-07-12 (first published: 2012-07-04)
6,763 reads
Service Broker Adventures: Stucked Queue Monitors
This week I'm in London helping a client with its large scale Service Broker deployment,
mainly troubleshooting some strange problems with...
2012-07-10 (first published: 2012-07-03)
4,305 reads
Useful new DMV’s in SQL Server 2008 R2 SP1 and SQL Server 2012
Introduction
Microsoft SQL Server 2008 R2 and SP1 and SQL Server 2012 has a new set of DMVs that includes sys.dm_server_memory_dumps,...
2012-07-03
5,414 reads
Blogs
When Your Microsoft Fabric Capacity Runs Out: Optimize, Scale Up, Scale Out, or Isolate?
By James Serra
Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform....
Accessing the Data API Builder MCP Server from VS Code
By Steve Jones
I recently started playing with the MCP Server for SQL Server, which is a...
From DBA or Data Engineer to AI Engineer: A Realistic Path
If you spend your days tuning queries, managing pipelines, or keeping a production database...
Forums
Two queries work until compared with EXCEPT statement
I've got multiple databases on 2 SQL 2019 CU32 servers , all using the...
STRING_AGG DISTINCT
Has anyone written a wrapper function (or similar) around STRING_AGG() to allow the retrieval...
In-place OS upgrade or migration to new OS?
Putting this here as we're currently on SQL Server 2019 installed on Windows Server...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers