SQL Injection - The Revenge
As yet more personal details are spilled by preventable security lapses, what's
2015-11-02
280 reads
Editorials
2015-10-30
328 reads
Leave Developers Alone
Interruptions are the enemy of productivity for creative people, like software developers. Steve Jones talks today about the need for quiet time.
2015-10-29 (first published: 2011-07-25)
523 reads
Masking Data
As DBAs we go to great lengths to ensure the security of our production data. But what happens when it moves off of a production server?
2015-10-28 (first published: 2008-03-07)
1,316 reads
From Great Idea to End Result
IT is too slow. That was a quote that inspired this piece from Steve Jones that talks about the need for IT to be more flexible and agile in their efforts. That includes the data professional in their modeling.
2015-10-27 (first published: 2011-05-24)
261 reads
The Hot Jobs
This week Steve looks at the hot jobs that are going to have pay increases in the coming year.
2015-10-26
263 reads
Positive or Negative
Today Steve Jones wonders if the way you choose to design a database says something about you.
2015-10-23
188 reads
The Dangers of Travel
As data professionals, we might carry lots of information with us that relates to our organization. Will we get caught up in government issues as we cross borders?
2015-10-22
203 reads
An Out of Date CAP
The CAP Theorem talks about the properties of distributed systems, and how you can really only have two of them in any system.
2015-10-21
107 reads
On Learning from Experience and Misfortune
Phil Factor on learning from mistakes. Preferably other people's.
2015-10-19
137 reads
Blogs
How to Parameterize Fabric Linked Services in Azure Data Factory for Azure Devops Deployment
Quite the title, so let me set the stage first. You have an Azure...
Deployment Pipelines in Fabric – What Are They?
By HeyMo0sh
In the realm of software development and content creation, the deployment pipeline serves as...
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