The Age of Software
Does the age of software matter? Steve Jones talks about this after there was a decision for the SQL 11 tools not to support Windows XP.
2011-06-23
262 reads
Editorial
More Regulation Coming?
With no end to company hack attacks in sight, will we get new regulation instead?
2015-06-16 (first published: 2011-06-22)
204 reads
Excel in the Clouds
Today Steve Jones talks about a new use for cloud computing with Excel to analyze large sets of data.
2011-06-21
159 reads
Archiving
It seems that archival isn't on the mind of most designers when they first build a database, which is OK, but DBAs ought to be building skills to implement this if the data size grows large.
2011-06-20
737 reads
Patch Week
This week Steve Jones notes there were quite a few patches from Microsoft for a variety of products. No SQL Server specific security patches, but that doesn't mean that DBAs shouldn't be patching systems.
2011-06-20
135 reads
Multiple Failures
This Friday Steve Jones has a disaster recovery poll. When you have a true disaster, often there are multiple things that go wrong and cause a cascading failure. Is this common, let us know what your experience is this Friday.
2011-06-17
105 reads
Phrases that Resonate
Today we have a guest editorial from Andy Warren. Are there particular phrases that you use in technology that resonate with you and have particular meanings? Andy shares a few of his favorites.
2011-06-16
152 reads
Understanding Security
It is important for data professionals to understand security, but it's also important for end users that must handle data. However we have a lot of work to do to make that easier since Steve Jones thinks many IT pros struggle with this concept.
2011-06-15
281 reads
Etiquette
As technology has rapidly advanced our communications, we have not necessarily learned to deal with the implications and challenges of this anywhere, anytime communication reach. Steve Jones reminds us that etiquette matters, even when we are designing systems.
2011-06-14
217 reads
Cloud Outages
It seems that we regularly hear about outages from various cloud services. Steve Jones comments that we are likely to have this happen more and more, but it's shouldn't happen at a rate greater than in house IT services.
2011-06-13
152 reads
Blogs
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...
AI: Blog a Day – Day 2: Generative AI, Multimodal Systems, and Agent AI
By Vinay Thakur
continuing from Day 1 where we covered the history of AI and GPT family,...
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