The Growth of Storage
This week Steve Jones asks you to predict the future of hardware. When will we have laptops that rival the specs of today's large SQL Server servers.
2013-01-18
116 reads
Editorial
Serious Security
The password issue has Steve Jones concerned. So many of us that use computing devices don't do a good job of securing our information.
2013-01-17
131 reads
Message Queues in Software
Steve Jones talks about Service Broker and messaging and how these techniques can help you build a more robust application.
2013-01-16
271 reads
Cramming for Interviews
Today Steve Jones talks about the questions people ask on the Internet about interviews. Are they ok? Should you cram for an interview this way?
2013-01-15
341 reads
The Java Danger
This week a vulnerability in Java has prompted a large scale notice to the general public.
2013-01-14
164 reads
Global Insecurities
The various security scans of 2012 reported lots of potential problems in companies. Why don't vendors make it easier for us to install and configure their software securely?
2013-01-14
79 reads
The Auditing Poll
Is auditing in use in your applications? Steve Jones wants to know as he thinks it will be more important in the future for most software.
2013-01-11
111 reads
A Patch Disaster
What would happen if the wrong patches were applied to your database server? The results could be a huge problem. Steve Jones reminds you to be careful with mass patches.
2013-01-10
145 reads
2017-03-27 (first published: 2013-01-09)
437 reads
Statistical Protection
Statistical databases contain lots of information that can be used in a variety of ways, but it can also be abused. Steve Jones talks about some of the problems and potential solutions.
2013-01-08
113 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