More Time to Certify
You have more time to earn that MCSA, MCSE, or MCSD, thanks to Microsoft and the pandemic.
You have more time to earn that MCSA, MCSE, or MCSD, thanks to Microsoft and the pandemic.
Delve behind the scenes and learn about the catalog used to manage Azure Data Lakes.
Delve behind the scenes and learn about the catalog used to manage Azure Data Lakes.
In SQL cursors serve as a pointer that enables application programming language to deal with query results one row at a time. This article quickly explores the concept behind and show how to declare cursors, open, retrieve data from them, and then close them
Problem Many of us are already aware of the loopin...
Fourty-six percent of the State of Database DevOps survey respondents advised they are performing some form of deployment automation. This figure has risen year on year as the conversation of DevOps in Database development continues, and the benefits become more apparent. If you are interested in more insight, you can download a copy of the 2020 State of Database DevOps report here.
Download now
Despite some humorous examples of deployments gone wrong, failures are not funny. William Brewer explains why staging is so important and how it can help avoid the types of disasters he recalls in this article.
A morning checklist is a good thing, but an automated one is better.
In this time of crisis, it's up to each of us to make a difference in some way.
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