Wish you were here?
As it gets easier to attend events virtually, it's worth considering what the literal, financial value is of physical attendance.
2011-05-16
70 reads
Editorials
Dropping a Row
How important is it that your server record all changes to every row? Probably very important and that is one of the foundations on which RDBMS platforms are built. Steve Jones talks about this being a difference with some NoSQL systems, and why it might not be acceptable to most businesses.
2011-05-10
192 reads
Tiered Storage
Storage costs are constantly rising, especially for databases as we gather more and more data. However not all of our data is necessarily the same priority or requires the same hardware. Steve Jones talks about the benefits you might get if you can tier your storage.
2011-05-09
215 reads
The Titanic Cloud
The outage at Amazon's Web Services recently affected a lot of different companies. However not everyone was affected. The reach of the cloud and the competition for attention means that while we have to learn to expect failures, they are not necessarily evenly distributed.
2011-05-05
169 reads
Cascading Human Error
The recent Amazon AWS outage was blamed on human error. Steve Jones notes that the more interconnected our systems are, the more likely that a human error might cause cascades between the systems.
2011-05-03
283 reads
100% Microsoft?
This week Brad McGehee asks if your company is a 100% Microsoft software shop or if you are allowed to use third party software with your SQL Server.
2011-05-02
205 reads
The Intelligence Cloud
More cloud talk today as the Air Force is building a new intelligence sharing system in the cloud? Why the cloud? Is the cloud really better?
2011-05-02
239 reads
Temporary Indexes
Temporary indexes can speed up processes that run periodically in your applications. This Friday Steve Jones asks how many of you use temporary indexes and how you do so.
2011-04-29
564 reads
When To Hire a DBA
When should you hire a DBA? Always, of course! Actually Steve Jones doesn't have an answer, but he does talk about why a DBA can help you.
2011-04-28
295 reads
Showing Its Age
Computer Systems are aging and as companies try to save money by extending their lifetimes, are we going to see more issues?
2011-04-27
174 reads
Blogs
Friday Basics: the CIA Triad
By Brian Kelley
In information security (INFOSEC), there several foundational concepts and principles. One of the ones...
A New Word: the standard blues
By Steve Jones
the standard blues– n. the dispiriting awareness that the twists and turns of your...
How Redgate Flyway Can Boost Your DevOps Journey
By Chris Yates
A brief introduction to the tool and its advantages for database migrations DevOps is...
Forums
client_app_name is empty in Extended Events output but present in sp_who2
I'm tracing activity on one database and would like to include the client_app_name in...
How to compare data in customer table with other customers to find related cust
select Custno, Addr1, City, Res_Phone, Bus_Phone, Fax_Phone, Marine_Phone, Pager_Phone, Other_Phone, email1, email2 from customer...
process records in loop
I'm only processing 50,000 records not everything from the Table where there are 250,00...
Question of the Day
The Marked Transaction
I want to mark a transaction in the log as a recovery point. How do I do this in my code if I use the transaction, myTran?
See possible answers