Guide for Setting up Telegraf to Monitor InfluxDB
Problem
If you been reading this series you are used to looking at Windows and SQL Server but who knows what...
2018-04-30
205 reads
Blog Posts
Security: Create and view Audit Logs
It is important to have a secure environment, enforcing the least privilege principle in your servers and databases, but this...
2018-04-30
5,387 reads
Shiny Tech Syndrome
This is the name I give to anyone who, whilst learning a new technology, suddenly thinks it’s the best thing...
2018-04-30
365 reads
SQL Server Removing Outliers With Standard Deviation
When running aggregations for reporting in some situations outliers can throw out the numbers.
For example lets say we have a...
2018-04-30
372 reads
Export data from Cosmos DB to SQL Server
Cosmos DB is Microsoft’s latest NoSQL database offering low latency, high scalability and geo-distribution to any Azure region. Read Microsoft...
2018-04-29
2,605 reads
Introduction to Azure Cosmos DB
What is Azure Cosmos DB?
Cosmos DB started as an internal project – “Project Florence” – at Microsoft in 2010. It is a...
2018-04-29
401 reads
SQL Server Minimum Memory Setting
There is almost never a reason to set this setting unless you’re running other apps on the same server as...
2018-04-29
1,078 reads
SQL Server Advanced Aggregations Part 2 ROLLUP and CUBE
This post is part 2 of a 3 part series…
Part 1 Grouping SetsPart 2 ROLLUP and CUBEPart 3 GROUPING and...
2018-04-28
99 reads
Backup VisualSVN using PowerShell
Quick and easy backup for VisualSVN. Wraps the svnadmin.exe and performs a hotcopy of all repositories in the $source_path, dumping them to the $backup_path [crayon-5c98d5a77e81c224584330/]
2018-04-27
56 reads
How to get alerted anytime SQL Service is restarted?
You may and should have monitoring in place to monitor state of your servers, services, jobs, critical and not critical...
2018-04-27
786 reads
Blogs
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Forums
Lots of FKs
Comments posted to this topic are about the item Lots of FKs
Real-time On-prem SQL Server Data in Excel – Over the Internet
Comments posted to this topic are about the item Real-time On-prem SQL Server Data...
Can You Let Go of Determinism
Comments posted to this topic are about the item Can You Let Go of...
Question of the Day
Lots of FKs
In SQL Server 2025, what are the most outgoing and incoming FK references a table can have?
See possible answers