Using Pester with dbatools Test-DbaLastBackup
In previous posts I have shown how to use Test-DbaLastBackup from dbatools and how you can make use of the...
2017-04-11 (first published: 2017-03-25)
1,663 reads
Blog Posts
Why Volunteer at SQLBits ?
WARNING – Contains Orange and light-hearted photos
I have returned home from SQLBits 2017 The Disco Edition. I am exhausted, my...
2017-04-11
553 reads
Will Technology Eliminate Your Tech Job?
This post is a response to this month's T-SQL Tuesday prompt. T-SQL Tuesday was created by Adam Machanic and is a way for SQL users to share ideas about...
2017-04-11
15 reads
Export SQL User Permissions to T-SQL script using PowerShell and dbatools
There are times when DBA’s are required to export database user permissions to a file. This may be for a...
2017-04-10
2,370 reads
Gethyn Ellis:My SQL Server You Tube Channel
Its been an interesting weekend at gethynellis.com I have been attempting to put together a SQL Server YouTubechannel. I’m planning...
2017-04-10
320 reads
Microsoft Business Intelligence Materials from Discussion at Jacksonville University
Today I had the wonderful pleasure for leading a discussion regarding the products, services, and tools Microsoft provides in the...
2017-04-10
332 reads
Microsoft Business Intelligence Materials from Discussion at Jacksonville University
Today I had the wonderful pleasure for leading a discussion regarding the products, services, and tools Microsoft provides in the...
2017-04-10
107 reads
Missing index with create statements
Missing index :- Scripts will help you to get all the missing index and prepare script for new index.
/*
Description:- This Query...
2017-04-10
661 reads
Monday Coffee 2017-04-10
So SQLBits is over and I have to say that I really enjoyed attending on the Saturday, hopefully next year...
2017-04-10
299 reads
Monday Coffee 2017-04-10
So SQLBits is over and I have to say that I really enjoyed attending on the Saturday, hopefully next year...
2017-04-10
176 reads
Blogs
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
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....
Forums
The New World Of AI Robots
Comments posted to this topic are about the item The New World Of AI...
Logic question in a WHERE clause using IIF?
Thanks in advance, I'm trying to avoid using IIF for performance reasons, but the...
Execute as failure
Security has long been a problem for me. Every time I think I understand...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers