HOW WE CAN GET WHO IS CONNECTED TO DATABASE?
Some time we need to know that who is using database as of now or who all are connected to...
2015-10-07
571 reads
Some time we need to know that who is using database as of now or who all are connected to...
2015-10-07
571 reads
In this post we’re going discuss how to implement load testing of your storage subsystem with DiskSpd. We’re going to...
2015-10-07 (first published: 2015-09-29)
7,721 reads
I will be speaking this weekend at SQL Saturday #445 - Raleigh, NC. If you are in the area, please come...
2015-10-07
482 reads
Caution must be exercised when mixing Transparent Data Encryption (TDE) and Availability Groups to ensure databases don't end up in...
2015-10-07
670 reads
It’s entirely possible that you’ve heard us talk about our supercharged, free backup and index maintenance solutions on Twitter, or on...
2015-10-07
663 reads
What’s my share? Calculating percent share of the total is a common need. Let’s see how to calculate this in Power BI...
2015-10-06 (first published: 2015-09-29)
24,925 reads
PowerShell can pack a pretty big punch when dealing with Extended Events. Using PowerShell as one of your Extended Events Management Tools, there could be a bit of a...
2015-10-06
4 reads
So far in this series I have introduced a couple of tools that are suitable for helping with the management...
2015-10-06
621 reads
October 4th of this month was my seven year anniversary as an employee of Pragmatic Works. Things have changed a...
2015-10-06
558 reads
Are you a Social DBA?
No I don’t mean that you are a DBA and attend a myriad of merry mixers,...
2015-10-06 (first published: 2015-09-28)
2,492 reads
Next Monday, March 9, 2026, my one-day live online training SQL Server 2025 Unleashed:...
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...
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