alevyinroc


Blog Post

Spring 2024 Speaking Engagements

I will be presenting Answering the Auditor’s Call with Automation at two upcoming events, one virtual and one in-person.
DBA Fundamentals Virtual User Group Tuesday, April 9 2024 at Noon...

2024-04-03 (first published: )

116 reads

Blog Post

Just Buy the Keyboard

The holidays have passed and it’s a new year. You probably have a gift card or two and haven’t decided how to use it yet. Allow me to help:
Buy...

2024-01-30

24 reads

Blog Post

On Session Evaluations

As PASS Summit approaches this week, I’m re-reviewing my evaluations from SQL Saturday Boston and I’d like to give feedback about feedback.
Why Feedback? Both speakers and event organizers depend...

2023-11-12

5 reads

Blog Post

Summit 2023 Is Nearly Here!

All week, my phone has been reminding me (via photo memories) of the amazing experience I had at PASS Summit 2017. This can mean only one thing - PASS...

2023-11-10 (first published: )

104 reads

Blog Post

SQL Saturday Boston 2023 Recap

First Things First Thank you to everyone who attended my session “Answering the Automator’s Call with Automation.” My slide deck and demo code are now available on my Github.....

2023-10-16 (first published: )

56 reads

Blog Post

Seeking Home Network Happiness

TL;DR: My home firewall/router is slow, please help me pick out a new one.
After replacing my firewall/router/WiFi access point one too many times, I’m ready to get off the...

2022-12-27

100 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