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
206 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,411 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
368 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
374 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,609 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
404 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,083 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
101 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
61 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
797 reads
Blogs
5 Starter Projects for Your AI and Data Engineering Portfolio
Reading tutorials is fine. Shipping something is better. If you are trying to break...
The Book of Redgate: Taking Breaks
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Forums
Pro SQL Server Internals
Comments posted to this topic are about the item Pro SQL Server Internals
SQL ART: Who's Blocking Who? Visualising SQL Server Blocking With Spatial Geometry
Comments posted to this topic are about the item SQL ART: Who's Blocking Who?...
Running SQLCMD II
Comments posted to this topic are about the item Running SQLCMD II
Question of the Day
Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers