Searching for Plans
Would you want a query optimizer that searches for the best plan for your code? Steve Jones thinks this might not be a bad idea.
2015-05-15 (first published: 2010-09-13)
283 reads
Editorial
Instrumentation
This Friday Steve Jones is looking for the instrumentation or monitoring that you build into your applications.
2010-09-10
181 reads
Enjoy Your Job
A reminder today that there are people that enjoy their jobs. Steve Jones reminds us that we should take jobs based on that criteria.
2010-09-09
255 reads
Developer Deployment Frustrations
SQL Server should work to make it easy for developers to work with it, and include versions like Express in their applications.
2016-10-11 (first published: 2010-09-08)
362 reads
Talking To You Makes Me Smarter
There's a lot of value in the interactions that professionals have with each other. A guest editorial from Andy Warren talks about the benefits of meeting new people.
2010-09-07
138 reads
Please don’t Tweet this, but…
Brad worries that with the advent and growth of social media, has come an increasing concern that today's private conversation may turn into tomorrow's world-wide Tweet.
2010-09-06
173 reads
Labor Day 2010
It's Labor Day in the US, and a day off for Steve, so enjoy this set of bloopers from his podcast.
2010-09-06
62 reads
2010-09-03
98 reads
Check Twice, Update Once
An update to the Microsoft Best Practices Analyzer tool intrigues Steve Jones as it seems to have been enhanced to better help DBAs manage SQL Server.
2010-09-02
151 reads
Where Are the Programmers?
Today Steve Jones has a little fun with titles in technology, and what we might start to call ourselves instead of DBAs.
2010-09-01
250 reads
Blogs
T-SQL Tuesday #192: What career risks have you taken?
By James Serra
I’m honored to be hosting T-SQL Tuesday — edition #192. For those who may...
AI: Blog a Day – Day 3: LLM Models – Open Source vs Closed Source
By Vinay Thakur
Continuing from Day 2 , we learned introduction on Generative AI and Agentic AI,...
How to Parameterize Fabric Linked Services in Azure Data Factory for Azure Devops Deployment
Quite the title, so let me set the stage first. You have an Azure...
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