This month’s T-SQL Tuesday invitation comes from Tracy Boggiano and she’s asking us to write about our experiences with Query Store. I thought about what I should write, I’m...
2020-03-17 (first published: 2020-03-10)
339 reads
The full message when connecting to your Azure SQL Database is: Reason: An instance-specific error occurred while establishing a connection to SQL Server. The public data endpoint on this...
2020-03-16
386 reads
Wouldn’t it be great to just quickly and easily take a look at your system to see if you had any queries that ran for a long time, but,...
2020-03-16 (first published: 2020-03-09)
563 reads
By default, the vSphere vCenter deployment contains a virtual appliance where the VMware management and orchestration platform, vCenter, resides and runs from. The default performance metric statistics collection interval...
2020-03-16 (first published: 2020-03-09)
276 reads
I’ve not done much BI work in my career, other than simple aggregates in reports. I’ve wanted to tackle projects, but I’ve rarely had a chance to spend time...
2020-03-16
218 reads
There are many ways to share the dashboards, reports, and datasets that you create in Power BI. Below I’ll compare all such options (there are twelve!). First make sure...
2020-03-16
88 reads
We’ve cancelled our upcoming Meetups in April and May due the loss of our venue (due to corona virus worries) though we would have probably cancelled them anyway. Our...
2020-03-16
7 reads
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the essential knowledge you need to know about performance...
2020-03-16
3 reads
Building CI/CD process for Azure Data Factory is not quite straightforward. Furthermore, there are a few different methods of doing that. Before we begin doing that, we must set...
2020-03-14
17 reads
Building CI/CD process for Azure Data Factory is not quite straightforward. Furthermore, there are a few different methods of doing that. Before we begin doing that, we must set...
2020-03-14
6 reads
By Vinay Thakur
I wrote about TempDB Internals and understand that Tempdb plays very important role on...
By Vinay Thakur
continuing from Day 1 where we covered the history of AI and GPT family,...
Comments posted to this topic are about the item A Quick Restore
Comments posted to this topic are about the item Guarding Against SQL Injection at...
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
While doing some testing of an application, I wanted to reset my environment after doing some testing with this code:
USE DNRTest BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO /* Bunch of stuff tested here */RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance. See possible answers