2014-11-07
80 reads
Editorials
2014-11-06
112 reads
2014-11-04
96 reads
A Fundamental Security Mistake
Steve Jones thinks Microsoft is making a fundamental security mistake in the way they build features for the various editions of SQL Server. Read today's editorial and see if you agree.
2014-11-03 (first published: 2009-12-21)
429 reads
Normalizing Performance
Determining the best performance value you can get for your effort is not as straightforward as you might think.
2014-11-03
209 reads
The Geek Costume
This Friday Steve Jones has another fun poll. A question on the geek costume that might excite you the most.
2014-10-31
175 reads
Stuck in a Rut
What do people do when their job doesn't require a lot of technical skills? Steve Jones has a few thoughts.
2014-10-29
168 reads
Triple Digits
Salaries for data professionals have risen quite a bit, according to the latest salary survey. That's good for those of us working with SQL Server.
2014-10-28
235 reads
Managers: who needs them?
Managers, look away now. Patrick Index wants to get something off his chest...
2014-10-27
326 reads
When is 8000 too small?
Over the years the page size in SQL Server has changed, growing larger to fit larger data sets. However not all functions have been modified to work with larger page sizes. Or even exceed them. Steve Jones wonders if it's time to increase the page size.
2014-10-23 (first published: 2010-02-11)
393 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