SQL Confessions
I had a brainstorm of an idea for a group of articles on my blog a couple of weeks ago...
2010-12-13
508 reads
SQL RNNR
SQL Confessions
I had a brainstorm of an idea for a group of articles on my blog a couple of weeks ago and am finally getting around to putting it together....
2010-12-13
4 reads
Bundle of Joy
After baking for 9 months, our bouncing baby girl has finally arrived. She arrived Thursday Dec 2, 2010 at 8:28...
2010-12-09
620 reads
Bundle of Joy
After baking for 9 months, our bouncing baby girl has finally arrived. She arrived Thursday Dec 2, 2010 at 8:28 AM (PST). There were no complications and the delivery...
2010-12-09
3 reads
December 2010 SSSOLV Reminder
Here is a quick reminder and a repost of the announcement from last week.
This month we will be broadcasting the...
2010-12-08
848 reads
December 2010 SSSOLV Reminder
Here is a quick reminder and a repost of the announcement from last week. This month we will be broadcasting the meeting once again. This month the technology bug...
2010-12-08
4 reads
December 2010 S3OLV Meeting
It is amazing how the months just seem to fly by these days. I probably say that every month. It...
2010-12-01
545 reads
December 2010 S3OLV Meeting
It is amazing how the months just seem to fly by these days. I probably say that every month. It seems appropriate though. This month we will be broadcasting...
2010-12-01
2 reads
Drumroll Please…
Defensive Db Programming Chapter 10
After dragging this review on for months now, it is finally time to bring this bad...
2010-11-29
1,382 reads
Drumroll Please…
Defensive Db Programming Chapter 10 After dragging this review on for months now, it is finally time to bring this bad boy home and wrap it up. I have...
2010-11-29
6 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