Developer, speaker, blogger – how did all of this happen?
It’s been exactly two years today, that I stood on an international “stage” as a speaker for the first time,...
2018-05-11 (first published: 2018-05-03)
1,848 reads
SQL Server Dedicated Admin Connection and Why You NEED It!
DAC or Dedicated Admin Connection is one of those things you don’t know you need until it’s too late.
What is...
2018-05-02
80 reads
Day 2: Introduction to MySQL
Story of MySQL is very interesting and involved emotions in it. This is my understanding and my though on Journey...
2018-05-02
308 reads
Digitally Signing a Stored Procedure To Allow It To Run With Elevated Permissions
Have you ever had the need to give elevated permissions via a stored procedure above that what the user calling...
2018-05-14 (first published: 2018-05-02)
2,421 reads
Dates and Times in SQL Server: What about TIMESTAMP?
It occurred to me that we haven’t covered the TIMESTAMP data type in this series about dates and times. TIMESTAMP...
2018-05-02
272 reads
Azure SQL Data Warehouse Gen2 announced
Monday was announced the general availability of the Compute Optimized Gen2 tier of Azure SQL Data Warehouse. With this performance optimized tier, Microsoft...
2018-05-02
191 reads
Azure SQL Data Warehouse Gen2 announced
Monday was announced the general availability of the Compute Optimized Gen2 tier of Azure SQL Data Warehouse. With this performance optimized tier, Microsoft...
2018-05-02
523 reads
Power BI Custom Visuals Class (Module 101 – Tachometer)
In this module you will learn how to use the Tachometer. The Tachometer for communicating performance against a goal.
Module 101...
2018-05-08 (first published: 2018-05-02)
2,246 reads
Connect to Power BI Report Server with SSMS
Sometimes you want to connect to a report server instance using Management Studio, for example to create a new security...
2018-05-11 (first published: 2018-05-02)
4,140 reads
SQL Homework – May 2018 – Create a database
I’ve really got to make a plan here at some point. So far I’ve been just putting down things as...
2018-05-02
259 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