You are working on a database development project, and you need to obtain the records before/after an INSERT, DELETE, UPGRADE or MERGE Statement to present it to the user...
2020-01-09 (first published: 2020-01-03)
1,072 reads
This is also posted to the ISACA Journal blog, Practically Speaking: As new technologies are developed, we have to stay up to date with them. More so than almost...
2020-01-08 (first published: 2020-01-02)
230 reads
Working with Microsoft, we determined that there is no BGP community for Azure’s Application Insights. As a result, I’ve created a feedback request for Microsoft to consider doing just...
2020-01-08 (first published: 2019-12-30)
117 reads
This is by no means a complete list but more of a personal list of features I have seen not setup or just missed out when looking at Azure...
2020-01-08
55 reads
Every once in awhile when I’m recording a Pluralsight course, I’ll take a photo of my desk to let people see the behind the scenes of the process. Well,...
2020-01-08
6 reads
At Data Céilí 2020 we want to be as green as possible and one idea we’ve had is to run a Green Track that will host remote sessions from...
2020-01-08
13 reads
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. When you install Windows, by default, the execution...
2020-01-08
145 reads
In August last year I posted about a command line parser problem I ran into with AzCopy, which I eventually resolved by writing a batch file and escaping a...
2020-01-08
31 reads
As a follow-up to my last blog, Azure Synapse Analytics & Power BI performance, I wanted to focus on concurrency when using these two products. A common question I...
2020-01-07 (first published: 2019-12-27)
783 reads
Code Camp will be March 28th, 2020 at Seminole State College. The fifteenth consecutive year! They are definitely interested in developer/end user SQL content and would like at least...
2020-01-07
40 reads
By HeyMo0sh
As someone who’s worked with data for over 20 years and with many cloud...
By HeyMo0sh
2025 belongs to the AI startups. If you peek into the tech headlines, you’ll...
By Vinay Thakur
it has been a year since i have not written much on the blog...
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