Don’t Miss Out on an Opportunity to Connect
There are people in our lives that we want to connect with, so why don't we?
2016-05-09
100 reads
Editorial
The Information Schema and Cross-RDBMS Working
A look at the ODBC standard and how valuable it has been, unlike the Information Schema implementations.
2016-05-09
69 reads
What’s in a name?
When a business does not have an agreed set of definitions for their every day terms slow burning chaos ensues.
2016-05-04
105 reads
What Does a DBA Do?
Today we have a guest editorial from Andy Warren as Steve is away. Andy tries to define what a DBA really does in a way that might make sense to others.
2016-05-03
322 reads
2020-06-05 (first published: 2016-04-29)
215 reads
2020-08-14 (first published: 2016-04-28)
205 reads
Cloud First
SQL Server 2016 is the first cloud first version of SQL Server being released as the on-premise product.
2016-04-27
205 reads
2016-04-26
120 reads
A nice whistle and flute
Phil Factor recounts the most important lesson of his early IT career: try not to burst into giggles when you get to look at the client's IT system.
2016-04-25
121 reads
2016-04-25
102 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