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,681 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
500 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
703 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
568 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
453 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,197 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
640 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
975 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
444 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
503 reads
Blogs
Unused Indexes in SQL Server: Find them, vet them, and drop them safely
Unused Indexes in SQL Server: Find them, vet them, and drop them safely Indexes are...
T-SQL Tuesday #191 Round Up
By Steve Jones
I hosted this month, late as it turns out, but we still had a...
Come See Me at the PASS Data Community Summit
By Brian Kelley
I'm speaking on Quantum Computing at the PASS Data Community Summit. It's scheduled for...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
Managing unused indexes
While doing some housekeeping activity on several old but large production databases, I come...
Cloud Performance Considerations
How important to SQL Server is the speed of the SSD and network latency?...
Question of the Day
Striped Backup File Limits
In SQL Server 2022, how many backup files can I have in a striped backup?
See possible answers