MidnightDBA: We do a lot
We do a lot of things. It’s difficult to explain all the things we do to people. So I made...
2011-03-28
611 reads
Jen McCown
SQL Math: Whole Numbers, Real Numbers
It’s been a long time since grade school math, and for some the details have become kinda fuzzy. I’m no...
2011-03-28
1,876 reads
An Analogy is like a Tree….
For years, I’ve been trying to express how everything ties into everything else. A big part of understanding any given...
2011-03-25
490 reads
Maaaaaagic Tables!!!
I had an interview earlier this week. An interview for a SQL developer position. It went fine. But. Question number X...
2011-03-24
2,379 reads
Not Cool Enough for Firefox
I’m pretty consistently behind the curve on most things. It took three years for me to get into The Office...
2011-03-22
878 reads
Filmed: DBAs@Midnight Episode 2.30
Friday night (as per usual) we filmed a new episode of our 2 1/2 year old webshow, DBAs@Midnight in front...
2011-03-19
848 reads
Women in Technology SQL Lunch!
Attend SQL Lunch...the power of my sweater compels you...
This week on Friday, March 17 we’re having a free panel talk,...
2011-03-17
662 reads
24 Hours of PASS Spring 2011 Code Sins
Here is all the things related to the most awesome Code Sins session I gave at 24 Hours of PASS Spring...
2011-03-15
673 reads
SQL University – Teach Your Children Well
“If you had a daughter, would you really encourage her to get into IT?” … “Yes, if she loved it.”
- My...
2011-03-10
971 reads
T-SQL Tuesday #016: Aggregates and Windowing Functions and Ranking! Yum!
Let’s get this out of the way right now: I am SO going to take advantage of this T-SQL Tuesday...
2011-03-08
894 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