SHUTDOWN SQL Server
Recently a friend by the name of Chris Bell (blog | twitter) wrote about an easy way to disrupt SQL Server....
2018-12-20 (first published: 2018-12-03)
3,587 reads
SQL RNNR
SHUTDOWN SQL Server
I explore the question of if it is possible to reboot the server from within SQL Server or even simply shut down the entire server. Well, you can certainly...
2018-12-03
9 reads
My Book Contributions
It’s a Wonderful Life
One of the really super cool things about the SQL community is the frequent opportunity one could...
2018-11-30
260 reads
My Book Contributions
One of the really super cool things about the SQL community is the frequent opportunity one could have to get involved.
One of my favorite methods of getting involved is...
2018-11-30
2 reads
Data Professionals at Work Book
Working as a Data Professional
An old friend Malathi Mahadevan (b | t) asked me one day if I would be interested...
2018-11-29
246 reads
Data Professionals at Work Book
Not only will you encounter some interesting stories, but I believe you will also encounter some interesting insight into some of the contributors for this book: Data Professionals at...
2018-11-29
5 reads
How to be an MVP Book
How to be an MVP in LIFE
One of the fun things about being involved in the community is the opportunity...
2018-11-28
293 reads
How to be an MVP Book
When it comes to characteristics of an MVP, the two groups (geek and jock) are no longer at the opposite ends of the spectrum. Rather, they are very similar...
2018-11-28
5 reads
Auditing when Database Files Change
As a Database Administrator, something that should be part of your database audit is monitoring the growth of files. That...
2018-11-27
497 reads
Auditing when Database Files Change
As a Database Administrator, something that should be part of your database audit is monitoring the growth of files. That means tracking when the log file grows and tracking...
2018-11-27
10 reads
Blogs
Deployment Pipelines in Fabric – What Are They?
By HeyMo0sh
In the realm of software development and content creation, the deployment pipeline serves as...
TempDB Internals – What’s New (SQL Server 2016 to 2022)
By Vinay Thakur
I wrote about TempDB Internals and understand that Tempdb plays very important role on...
Forums
A Quick Restore
Comments posted to this topic are about the item A Quick Restore
Guarding Against SQL Injection at the Database Layer (SQL Server)
Comments posted to this topic are about the item Guarding Against SQL Injection at...
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
Question of the Day
A Quick Restore
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