Don’t Change Anything
Being responsible for data integrity as well as the cleaning of data can be a problem for an organization. Steve Jones reminds us today that we should be careful about changing the data we work with.
2010-04-07
139 reads
Editorial
Can We Skip the Marketing?
Steve Jones has a message for the speakers and presenters from Microsoft today.
2010-04-13 (first published: 2010-04-06)
179 reads
Answering to the Business
As data professionals, or IT workers, we often have a lot of insight into how much our services cost and the options that are available. But many times the rest of the company does not. Steve Jones thinks we could be more transparent, and possibly help them to be more efficient.
2010-04-05
91 reads
Down Tools Week
Sometimes it's important for a developer or DBA to be given the opportunity to 'shake up their brain'. What falls out is almost always worth having.
2010-04-05
286 reads
2010-04-02
71 reads
No More NULL
A change in the support for NULL values has Steve Jones commenting on the implications.
2010-04-01
757 reads
ORM Mapping
A guest editorial from Phil Factor that discusses ORMs and how they ca be used, or mis-used, in our applications.
2010-03-31
399 reads
Why Be an MCP?
With Steve Jones on vacation, we reprint on of his more popular editorials from the past. This was originally published on Feb 14, 2005.
2010-03-30
210 reads
Space in the Clouds
Spatial support is coming to SQL Azure soon, and Steve Jones thinks about how the service could improve this support.
2010-03-29
63 reads
Open Source is Not a Career Path
A reprint from the early days of SQLServerCentral as Steve is on vacation. Here is Steve Jones' Open Source Musings from February 3, 2005.
2020-06-22 (first published: 2010-03-29)
285 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