Pinal Dave Helps Me Fix My Performance Tuning Problems
Be sure to check out this week’s video on YouTube.
This week I was fortunate enough to film a video in...
2018-07-24
316 reads
Pinal Dave Helps Me Fix My Performance Tuning Problems
Watch this week's video on YouTube
This week I was fortunate enough to film a video in collaboration with Pinal Dave, the SQL Authority himself. Pinal is creative, hilarious, and...
2018-07-24
7 reads
Pinal Dave Helps Me Fix My Performance Tuning Problems
Watch this week's video on YouTube
This week I was fortunate enough to film a video in collaboration with Pinal Dave, the SQL Authority himself. Pinal is creative, hilarious, and...
2018-07-24
8 reads
AlwaysOn Dashboard uses System Policies
The AlwaysOn Dashboard is an excellent tool in SQL Server Management Studio that allows you to monitor Replica status, Availability...
2018-07-24
667 reads
Power BI Monthly Digest – July 2018
This month I continued my series with my friend Manuel Quintana [Blog | Twitter] as we guide you through some of...
2018-07-23
878 reads
Database Fundamentals #18: The SELECT Statement
In my previous Database Fundamentals post, I showed you how to use the Query Designer to build a query. That...
2018-07-23
825 reads
Zero Width Characters
Another bit of miscellany, this one shows how you can use zero width characters to tag/fingerprint data. Reminds me of...
2018-07-23
552 reads
PsPing your Azure SQL Server
PsPing tool is part of the sysinternals PsTools download found – ( https://docs.microsoft.com/en-us/sysinternals/downloads/psping) This is the tool of choice when wanting to...
2018-07-23
665 reads
Off on Holiday
Another break for me. This might actually be the first year I use all my vacation allowance.
In any case, I’m...
2018-07-23
843 reads
Processes can dramatically improve your work until they don’t.
As always with something like this, I like to start with a definition so we are all starting in the...
2018-07-23
176 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