Sun Invests, IBM Invests, MS ??
The other major database vendors have been making investments by purchasing database related companies, but what has Microsoft done?
2008-04-16
257 reads
Editorials
Behind the Curtain
Commentary on the database related news of the past week. SQL Server 2008 Certification, deep inside SQL Server and the Library of Congress.
2008-04-14
98 reads
Bloated
What is going on with all this production data? Steve Jones talks about the need to manage data growth and is it really worth the resources.
2008-04-14
212 reads
Historical Dollars
Tracking your salary over time might be a fun, or not so fun, endeavor for a DBA. However should anyone else know what your trend is? Steve Jones asks the question this week.
2008-04-11
132 reads
The Social Mesh
Steve Jones talks about some research from Dr. Cross, a professor from his alma mater, into social networks and how work gets done in a company.
2008-04-10
76 reads
The Feature Debate
Is SQL Server keeping up with MySQL or is it the other way around. Steve Jones comments on a few of the differences in the platforms.
2008-04-09
128 reads
Securing Data
It's important that you do more than just implement perimeter security with firewalls. Steve Jones talks about how we can better secure our systems.
2008-04-08
533 reads
No XP, but Look Forward To 7
A look back at the news of the past week including Windows 7, SSD performance, April Fools, and consistency in SQL Server.
2008-04-07
512 reads
The Cost of Support
Microsoft is not planning on releasing Service Pack 3, but what is the best model for supporting software? Steve Jones gives a few thoughts.
2008-04-07
96 reads
2008-04-04
127 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