The fifth article in the SQL Server Analysis Services Tabular Model has been released on SQLServerCentral.com. Please start at the beginning article before reading this one in order to...
2019-02-03
39 reads
I previously wrote about measuring wait statistics. This matters a lot, because you can track historically what wait statistics are...
2019-02-02
369 reads
I previously spent some time troubleshooting this issue at one client, and then having encountered it twice more this year, I figured I'd include it in a blog post....
2019-02-01
6,215 reads
When I first joined the programming team at my previous job in an aerospace company, the first observation I made...
2019-02-01 (first published: 2019-01-18)
2,102 reads
One of the ways that you can more easily perform database development tasks is with SQL Change Automation (SCA). This...
2019-02-01 (first published: 2019-01-22)
2,047 reads
Gday,
I’ve been playing with Azure notebooks lately and have found them invaluable as
A teaching aidA test sandboxI’ve been using Python...
2019-01-31
1,100 reads
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2019-01-31 (first published: 2019-01-16)
3,757 reads
It depends on where you’re looking and how many statements are in the stored procedure.
Let’s take a look at some...
2019-01-31
525 reads
When you build a brand new shiny SQL Server, you want to get a lot of memory so your queries...
2019-01-31 (first published: 2019-01-18)
2,926 reads
Azure offers a lot of value-added services included with the price of what you pay . One of the things really,...
2019-01-30
280 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