Warning Handling in dbatools Automation Tasks
So I’ve been using dbatools for automated restore tasks and came across a SQL Server Agent job that I wrote that was reporting success but the job was actually...
2017-09-12
6 reads
Blog Posts
Warning Handling in dbatools Automation Tasks
So I’ve been using dbatools for automated restore tasks and came across a SQL Server Agent job that I wrote...
2017-09-12
385 reads
#TSQL2sDay Long Story Short: Avoid -Scope User
For T-SQL Tuesday #94 the topic is databases and PowerShell. Rob Sewell asks us: What are you going to automate today? I’m going to automate some thing in SSRS...
2017-09-11
10 reads
#TSQL2sDay Long Story Short: Avoid -Scope User
For T-SQL Tuesday #94 the topic is databases and PowerShell. Rob Sewell asks us: What are you going to automate...
2017-09-11
338 reads
#TSQL2sDay Long Story Short: Avoid -Scope User
For T-SQL Tuesday #94 the topic is databases and PowerShell. Rob Sewell asks us: What are you going to automate today? I’m going to automate some thing in SSRS...
2017-09-11
9 reads
#TSQL2sDay Long Story Short: Avoid -Scope User
For T-SQL Tuesday #94 the topic is databases and PowerShell. Rob Sewell asks us: What are you going to automate today? I’m going to automate some thing in SSRS...
2017-09-11
19 reads
Create an empty table from a SELECT statement but without the IDENTITY.
A while back I did a post about creating an empty table using a SELECT statement. Basically doing something like...
2017-09-11 (first published: 2017-08-28)
3,090 reads
Data Channel Interview - 08 - Leila Etaati on Machine Learning using Microsoft BI
Dear All,
Very happy to share the 8th interview of #DataChannel. Dr. Leila Etaati MVP, MCT from New Zealand discusses...
2017-09-11 (first published: 2017-08-28)
1,633 reads
How to Capture Database(s) usage stats using sp_spaceused and PowerShell
The objective of this article is to look at the possible ways of capturing database usage trends using the most...
2017-09-11
397 reads
How to run the Availability Group Traffic on a different NIC
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...
2017-09-11
426 reads
Blogs
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
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...
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