In-Memory OLTP: Part 1 – Introduction
In-Memory OLTP is getting a lot of (rightly deserved imho) hype at the moment. But what does it entail exactly?...
2015-04-10 (first published: 2015-04-06)
848 reads
Blog Posts
On PowerShell
I use PowerShell a lot and I write about using it to solve problems quite frequently. The fact that I...
2015-04-10
678 reads
On PowerShell
I use PowerShell a lot and I write about using it to solve problems quite frequently. The fact that I...
2015-04-10
416 reads
Why I Want to Have Coffee With You
Yesterday I read an article entitled “Why I Don’t Want to Have Coffee With You”, in which the author writes...
2015-04-10 (first published: 2015-03-31)
7,892 reads
April Blogging Challenge 2 – Primary Key in CREATE TABLE
The April Blogger Challenge is from Ed Leighton-Dick and aimed at new bloggers, but anyone is welcome. I’m trying to...
2015-04-09
1,124 reads
Delete unused SQL Agent jobs from instance
I recently worked on a project where the client requested to “remove all of the unused jobs” that had been...
2015-04-09 (first published: 2015-04-01)
8,510 reads
Detaching a Database – File Security Gotcha
I’ll admit it, there are times where detaching a database is the best way to get something accomplished, but it...
2015-04-09
680 reads
Journey to Becoming a Consultant – Webinar Wrap up
Today I presented a new session on the various paths to becoming a consultant to the PASSProfessional Development Virtual Chapter....
2015-04-09
576 reads
Learn about SQL Server 2014 Performance Improvements
On May 11th I will deliver a precon about SQL Server 2014 Performance Improvements at the SQLDay Poland conference in...
2015-04-09
984 reads
Live Microsoft Event - Power BI Dashboard in a Day - Baton Rouge
Join BRSSUG Founder and Microsoft TSP Patrick Leblanc to learn how to use Microsoft’s self-service Business Intelligence platform, Power BI. In...
2015-04-09
701 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