Sheldon Hull

https://github.com/sheldonhull

Blog Post

Dataedo - First Look

Diagraming and Documentation
Previously, I've written up on database diagramming for visualization of database structures. Check that out for more detailed...

2017-08-07

717 reads

Blog Post

Dataedo - First Look

update 2019-02-22
Image links broken. Since their product is continually improving, I'm going to just link to their product here instead so you can review their latest demo content there....

2017-08-07

1 reads

Blog Post

InfluxDB and Annotations

This post assumes you've already setup InfluxDB and have Grafana running.
Inserting annotations Annotations are not a special type of resource, instead it's just another metric that you query with...

2017-08-07

31 reads

Blogs

A New Word: the Wends

By

the wends– n. the frustration that you’re not enjoying an experience as much as...

7 Best Online Advanced SQL Training Courses to Learn in 2024 and Beyond

By

The world runs on data, and SQL is the key to unlocking its secrets....

Manually Updating Redgate Monitor/SQL Monitor Patch Info

By

This post looks at updating the patch information for SQL Monitor/Redgate Monitor without using...

Read the latest Blogs

Forums

There's No Free Lunch with Open-source Software

By Ryan Booz

Comments posted to this topic are about the item There's No Free Lunch with...

Permissions required for SSIS

By ramana3327

To manage ssis project development’s & deployment from visual studio is SSISadmin role is...

Upgrading SSRS 2016 to SSRS 2019 in place

By koln

Server A has SSRS 2016 on it and I would now like to upgrade...

Visit the forum

Question of the Day

Default Objects in Clones

On SQL Server 2022, I do this:

USE model
GO
CREATE TABLE dbo.DBALog
(logdate DATETIME2(3), logmsg VARCHAR(2000))
GO
I then create a new database:
CREATE DATABASE INVENTORY
GO
I install a new database application in here with multiple tables, views, etc. I do not run any queries. I then decide to run this code:
DBCC CLONEDATABASE(INVENTORY, Inventory_clone);
GO
What happens?

See possible answers