LAST_VALUE() Analytic Function–SQL Server 2012
Earlier, i discussed FIRST_VALUE() function. FIRST_VALUE() returns the first value from an ordered set of records. Similarly LAST_VALUE() returns the last...
2012-02-07
2,708 reads
Blog Posts
List failed SQL server Jobs with Powershell
This post explains how to list failed SQL Server Jobs , on multiple SQL Server Instances and output the results to...
2012-02-07 (first published: 2012-02-06)
2,311 reads
Opt In/Out of Personalized Microsoft Ads
Nice to have the option, you can opt-out (default is in) of having personalized ads. I turned it off, the...
2012-02-07
824 reads
PIPE CLIP – (| CLIP)
The main focus of this blog is to write about SQL Server related stuff – but now and then in the...
2012-02-07
797 reads
S3OLV – Get your Merge On
We are rapidly closing in on the February meeting for S3OLV. You might remember reading about the upcoming meeting here.
We...
2012-02-07
643 reads
S3OLV – Get your Merge On
We are rapidly closing in on the February meeting for S3OLV. You might remember reading about the upcoming meeting here. We are looking to have an excellent meeting this...
2012-02-07
9 reads
Send email from Powershell with attachment
This post describes how to call to add an email attachment using Powershell.
In an earlier post - SQL Server – Send email...
2012-02-07
8,264 reads
Simple XML exist performance enhancement
I came across this really simple best practice from BOL for the xml method exist which when used will give...
2012-02-07
1,274 reads
SQL Saturday Jacksonville and Precon with Kevin Kline
I’m so excited to tell you about SQL Saturday 130 in Jacksonville coming April 28th. This is the 5th year...
2012-02-07
1,048 reads
SQLBits9
SQLBits9 – “Query across the Mersey” was held in the majestic Adelphi hotel. This was my first SQLBits experience and was...
2012-02-07
994 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
BIT_COUNT() V
Comments posted to this topic are about the item BIT_COUNT() V
How We Reduced SQL Server Infrastructure Costs by 33% on AWS: Lessons From a Database Operations Manager
Comments posted to this topic are about the item How We Reduced SQL Server...
An Eventual Consistency Scam
Comments posted to this topic are about the item An Eventual Consistency Scam
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers