SQL Server Crossword #3 – Solution
Here’s the solution to SQL Server Crossword #3.
I hope you enjoyed it. Let me know if you would like me...
2011-03-27
1,013 reads
John Sansom
SQL Server Crossword #3
To mark my 30th Birthday today, as promised here’s a SQL Server Crossword for you to enjoy. You can find the previous...
2011-03-23
1,554 reads
SQL Server Crossword #3
To mark my 30th Birthday today, as promised here’s a SQL Server Crossword for you to enjoy. You can find the previous...
2011-03-21
1,400 reads
How to Raise Your Game by Doing Nothing
What if I told you that you could become a more effective Database Administrator by doing nothing?
That’s right, in this...
2011-03-08
479 reads
How to Get a Head Start on Performance Tuning
The problem with performance tuning is that it is commonly considered as secondary to the task at hand rather than...
2011-03-01
711 reads
5 Things Every DBA Should NOT Do
Earlier in the month I shared with you 10 Things That Every DBA Should Do and so it only seems natural...
2011-03-01
5,946 reads
5 Things Every DBA Should NOT Do
Earlier in the month I shared with you 10 Things That Every DBA Should Do and so it only seems natural...
2011-02-22
3,600 reads
London UK SQL Server User Group – It’s Back!
"We're back with a Bang!"
In case you missed it, being tucked away amongst all the other UK SQL Server User...
2011-02-21
638 reads
The DBA Ultimate Fitness Workout Plan
If you plan to stay on top of your DBA game then you have to workout regularly.
Those of you that...
2011-02-15
718 reads
10 Things Every DBA Should Do
Recently I spoke about how The Best Database Administrators Automate Everything, as well as Document Everything and this got me...
2011-02-08
2,273 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