The Nature of the Database-Driven Developer
Bear with me as I wax philosophical for two sentences. Our societies are becoming more polarized with each passing day. ...
2010-06-03
680 reads
Blog Posts
Catch Performance Issues Early!
I have posted this before elsewhere. However, due to the frequency in which I come across this, I feel it’s...
2010-06-03
593 reads
Daily SQL Server 2008 new Feature – Day 15
Every day for the next couple of weeks, I aim to highlight one of SQL Server 2008’s new features, simply...
2010-06-03
402 reads
Drive Space
I found a cool series of scripts from Jeremiah Peschka on getting disk space from SQL Server. They’re useful queries,...
2010-06-03
1,980 reads
List of indexes and Parallel queries
Today while being on forum found this information so though to blog for future reference. thanx Uri Dimant for sharing...
2010-06-03
458 reads
Notes about Server SSDs
Note: This isn’t a recommendation or endorsement, just notes from some research I’ve done. Please contact your vendor before making...
2010-06-03
549 reads
One more Fix Database Role in SQL Server
Fixed Database Rols are: db_ddladmin, db_owner, db_accessadmin, db_securityadmin, db_backupoperator, db_datawriter, db_datareader, db_denydatawriter, db_denydatareader + one more that is dbm_monitor.
This is...
2010-06-03
1,696 reads
Performance Tuning Series
To kick off this blog, I am going to start with a topic that is hot on the mind of...
2010-06-03
753 reads
Sins of a Recursive CTE?
On June 1, 2010, Steve Gray had an article, Sins of SQL: The Time Table, published on sqlservercentral.com. I’m not...
2010-06-03
2,588 reads
Slides from SQL Server Auditing Class
Here are the slides from the SQL Server Auditing Class held on June 2, 2010.
Hour 1 - Attacking SQL Server
Hour 2...
2010-06-03
1,017 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