How to understand NoSQL Databases
Today we have a guest editorial from Phil Factor that looks at NoSQL databases.
2013-07-29
543 reads
Editorials
Some Relevant PowerShell Books
Phil Factor leafs through a few of his PowerShell books in his library, and considers which are his favorites
2013-07-29
147 reads
Data Farming
Another spy story involving data that's not true, and perhaps not plausible, but it makes Steve Jones think about data shadows.
2013-07-25 (first published: 2008-10-13)
256 reads
Moving to the Heartland
With companies like Microsoft and Google building data centers in small towns, Steve Jones has some comments about how this might affect IT jobs.
2013-07-24 (first published: 2008-10-16)
227 reads
The Agile Cult
Lots of developers have embraced Agile development, and Steve Jones thinks it's a good way to build software. However, it's not necessarily as easy as you might think.
2013-07-23 (first published: 2008-09-23)
374 reads
What Counts for a DBA: Baselines
It is very difficult to pinpoint what ails a server, just by looking at a single snapshot of the data, or to spot retrospectively what caused the problem by examining aggregated data for the server, collected over many months. The answer? Baselines.
2013-07-22
540 reads
DR Failovers
We don't often predict for disasters, which is good since we rarely have extensive plans for dealing with them. If we do, do we actually test our plans, or test the systems under full load?
2013-07-19
127 reads
Password Ninjas
How do you keep track of passwords? A few experts out there share some of their techniques and Steve Jones adds his thoughts.
2013-07-18
295 reads
Data Philanthropy
The idea of giving back to the world some of your success has been something many successful businesses have done forever. Steve Jones thinks they should consider giving more than physical resources, but also give data.
2013-07-17
89 reads
Hack Resistant?
Can we make a hack resistant database? A vendor claims this, but Steve Jones thinks it's not really a good claim to make and that we ought to make it our job to secure databases.
2013-07-16
180 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