PAC Community Ambassador – SQL Sentry
Last week Aaron Bertrand (b|t) published a post regarding five new PAC Community Ambassadors for SentryOne. I am privileged and...
2017-07-17
334 reads
Blog Posts
Security Basics: The Principle of Least Privilege
Whenever I’m asked about creating a security model for an application or database, I tell folks to follow the Principle...
2017-07-17 (first published: 2017-06-30)
2,956 reads
SSMS Tip #1: Annotations and Map Mode for Vertical Scroll Bar
SQL Server Management Studio (SSMS) for SQL Server 2016 added some interesting enhancements for the vertical scroll bar: Map Mode...
2017-07-17
665 reads
Updating a SharePoint List Item With Flow When You Don’t Have The ID
I recently worked on a project that used Flow to update a SharePoint list each time an item was updated...
2017-07-17
554 reads
When not to use Management Reporter
Management Reporter is easy to use to create Management Reports and it does not require a developer to do it....
2017-07-16
443 reads
Building Always On Availability Groups - Part 1
Introduction
By David Postlethwaite
Ensuring that your databases can survive a major outage such as a server failure and can continue to...
2017-07-14 (first published: 2017-07-03)
2,194 reads
Friday Reading 2017-07-14
Fun week, and what a Lions final test last weekend. Still can’t believe it!
Here’s what I’ve been reading…
STOPAT And Date...
2017-07-14
292 reads
Toolbox - Where Did All My Space Go?
This is the first in a new series of blogs I am going to create talking about useful tools (mostly...
2017-07-14 (first published: 2017-07-03)
2,179 reads
Capture Important Parameters of the SQL Server Replication
Whenever there is a business requirement to add a new article to an existing publication, you want to know how...
2017-07-13 (first published: 2017-07-03)
1,701 reads
My Evening With SQL Tool Service
Hello!
I’ve been writing a PowerShell Module that will handle deploying SQL Server Agent Jobs by using the Agent namespace in...
2017-07-13
243 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