Documenting SQL Server Access – Who Can Do What? - Syndication – WaterOx Consulting
When is the last time you audited who has SQL Server access? No really? When did you last do this?...
2016-02-22 (first published: 2016-02-17)
1,688 reads
Chris
What’s Going On? A review of 2015 and forecast for 2016 - Syndication – WaterOx Consulting
It’s been quiet… Too quiet Yes, yes it has. Things have been quiet here as of late. Posts and podcasts...
2016-01-06
508 reads
What Alerts Us About The SQL Agent? - Syndication – WaterOx Consulting
The SQL Agent is our friend! Setting up SQL Server Agent to automate jobs and alerts is a great idea....
2015-12-16
710 reads
SQL F.A.D. – Trace flag 834 and columnstore indexes - Syndication – WaterOx Consulting
Trace flags can be good Are special codes we, the DBA, can use to change the way the SQL Server...
2015-12-10
572 reads
020 – A Foolish Decision - Syndication – WaterOx Consulting
Making Foolish Decisions In WOxPod!, episode # 020– “A Foolish Decision” I announce a foolish decision I recently made, and how...
2015-10-16
456 reads
Get Hyper-V Host To Talk To Guest VM’s With This Simple Trick - Syndication – WaterOx Consulting
The Assumption I assume you already have a Hyper-V basic configuration on your system, be it a laptop, server or...
2015-10-16 (first published: 2015-10-07)
1,201 reads
019 – 24 HOP Questions Answered - Syndication – WaterOx Consulting
24 HOP Questions Answered In WOxPod!, episode # 019 – “24 HOP Questions Answered” I answer those questions that I wasn’t able...
2015-10-02
645 reads
SQL Server’s TIMESTAMP Is Not What You May Think It Is. - Syndication – WaterOx Consulting
TIMESTAMP vs. DATETIME: What’s the diff? The TIMESTAMP data type in SQL Server is not what you may think it...
2015-09-23
979 reads
The Poor Man’s SQL Backup Encryption - Syndication – WaterOx Consulting
Well, that was interesting While playing around with demos to use in my newer session, Hacking Exposé Too (See it...
2015-09-09
449 reads
018 – Learn Like A Pro! - Syndication – WaterOx Consulting
Learn Like A Pro In WOxPod!, episode # 018 – “Learn Like...
The post 018 – Learn Like A Pro! appeared first on WaterOx...
2015-09-04
507 reads
Blogs
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Upgrading SQL Server Containers on the Laptop
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
Forums
Increase Deadlock Detection
Comments posted to this topic are about the item Increase Deadlock Detection
Having Issue deploying a report to an on prem server from PowerBI desktop
Using PowerBI Version1.25.9508.3237(January 2026). Installed Microsoft Power BI Desktop (Optimized for Power BI Report...
SQL 2019 instance with AG, across 2 Windows 2016 OS servers - OSin-place upgrade
Hi all Can I get some perspective from the community please on performing in-place...
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers