Allow SQL Server Agent jobs management for non sysadmins
I don’t know about your experience when it comes to SQL Server Agent jobs but often I receive requests to grant permission so that clients can handle their jobs...
2019-08-13
12 reads
Cláudio Silva
dbatools v1.0? It’s available – Check it out!
Dear reader, before continue please open a PowerShell console and run the following command: If you are doing this on the date of this blog post, you have just...
2019-06-19
61 reads
dbatools v1.0? It's available - Check it out!
Dear reader, before continue please open a PowerShell console and run the following command:
Install-Module -Name dbatools If you are doing this on the date of this blog post, you...
2019-06-19
2 reads
“Ups…I have deleted some data. Can you put it back?” – dbatools for the rescue
Few days ago I received a request to restore a dozen of tables because someone have deleted more data than it was supposed. I immediately thought about dbatools for...
2019-06-04 (first published: 2019-05-17)
1,234 reads
'Ups...I have deleted some data. Can you put it back?' - dbatools for the rescue
Few days ago I received a request to restore a dozen of tables because someone have deleted more data than it was supposed. I immediately thought about dbatools for...
2019-05-17
2 reads
Scripting SQL Server objects with dbatools – Beyond default options
Probably you had the need to script out some objects from a SQL Server instance/database and this is quite easy. You just need to right click on the object...
2019-05-29 (first published: 2019-05-15)
2,136 reads
Access is denied – Using DTCPing utility between two Windows Server 2016
Few days ago a client requested the configuration of MSDTC (Microsoft Distributed Transaction Coordinator). NOTE: If you want to know more about it here is a nice FAQ from...
2019-05-21 (first published: 2019-05-10)
5,192 reads
SSMS GUI not working? Try to use T-SQL!
One of the good things, when we have new clients, is that sometimes they have needs that you never heard before. This does not necessarily mean that they are...
2019-04-11 (first published: 2019-03-29)
1,143 reads
SQL Server Operations Studio and VSCode: The wrong default datetimeoffset format
This post is to answer the question: “You are used to seeing in the format of yyyy-MM-dd right?” that I...
2018-09-12
424 reads
Triggers: The hidden logic that will strike back – TSQL Tuesday #106
This month’s T-SQL Tuesday is brought by Steve Jones (b | t) and he wants to know if triggers causes headaches...
2018-09-11
245 reads
Blogs
Monday Monitor Tips: AI Query Analysis
By Steve Jones
AI is everywhere. It’s in the news, it’s being added to every product, management...
AI: Blog a Day – Day 8: RAG – Retrieval Augmented Generation
By Vinay Thakur
RAG — Retrieval Augmented Generation. we have covered so far — embeddings, vectors, vector...
AI: Blog a Day – Day 7: Vector and Vector Databases
By Vinay Thakur
Continuing from Day 6 we learned Embeddings, Semantic Search and Checks, on Day 7...
Forums
I'm thinking about submitting some articles
I've written some documentation on using different Markdown types of files on GitHub. It's...
Not Just an Upgrade
Comments posted to this topic are about the item Not Just an Upgrade
Restoring On Top I
Comments posted to this topic are about the item Restoring On Top I
Question of the Day
Restoring On Top I
I am doing development work on a database and want to keep a backup so I can reset my database. I make some changes and want to restore over top of my changes. When I run this code, what happens?
USE Master BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO USE DNRTest GO CREATE TABLE MyTest(myid INT) GO USE master RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACESee possible answers