Tampa IT Camp 2011 Lessons Learned Part 1
On Saturday, March 19th 2011 we held the first ever Saturday “code camp” style event for the IT Pro (Sys...
2011-03-30
1,744 reads
Blog Posts
The DBAs Guide to Expectation Management
Your customers expectations are their primary measure of your success. How well are you managing them?
You’re reading The DBAs Guide...
2011-03-30
2,121 reads
#SQLSat67… it’s mystery is only exceeded by it’s power.
We’ve seen a few summaries come through by now, so I’m going to throw mine into the mix. To recap...
2011-03-29
677 reads
Brent Ozar Blitz at SQL Server Connections
The first session of the day for me was Brent Ozars Blitz talk on how to quickly get information on...
2011-03-29
1,860 reads
Brian Kelley talking Windows Internals for SQL Pros at DevConnections
I have known Brian for nearly as long as i have been running SQLServerCentral. He has been the guy that...
2011-03-29
1,694 reads
2011-03-29
1,569 reads
Do You Solution?
Do you ever find yourself working on different scripts at once? Maybe you are working on something that tests certain...
2011-03-29
910 reads
Do You Solution?
Do you ever find yourself working on different scripts at once? Maybe you are working on something that tests certain functionality in SQL Server, you have some presentation scripts...
2011-03-29
4 reads
Extended Events at SQL Server Connections with Jonathan Kehayias
I was very interested to hear Jonathan Kehayias’ session on extended events. I know this is one of the areas...
2011-03-29
1,903 reads
How To Really Listen
One of the most undervalued skills that an individual can possess is the ability to listen. Are you really hearing...
2011-03-29
1,625 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