My SQLSat54 Experience
In case you hadn’t heard SQLSaturday #54 was Oct 23 in Salt Lake City. It was a dreary opening to...
2010-10-25
1,113 reads
SQL RNNR
A Haunting TSQL Tuesday Tale
Time for the ghouls and goblins to come out of the woodwork once again for another tale of deception and...
2010-10-12
1,424 reads
A Haunting TSQL Tuesday Tale
If you truncate a table, you cannot undo the action like you can with a delete. What is the difference between the two methods to remove data from a...
2010-10-12
2 reads
October 2010 TSQL Tuesday Reminder
Holy Cow, another month has flown by without much of a hint. We now have upon us another TSQL Tuesday....
2010-10-07
638 reads
It’s Implied
This has been on my radar now for a little over a week. I ran across a request in the...
2010-10-05
743 reads
The Year of the Phantom
It is amazing how fast time moves the older (and slower) we as humans get. Looking back on time, it...
2010-10-03
624 reads
Red Pyramid
After having read the Percy Jackson series of books, I wanted to read a few more books by Rick Riordan....
2010-10-02
467 reads
SQLSat 54
Wow, I have really been kinda slow in the blog department for a couple of weeks now. I have a...
2010-10-01
582 reads
TSQL Tuesday Indexes and Blobs
Woohoo – chugga chugga chugga chugga – woo woo. The train is pulling into town once again for another installment in the...
2010-09-15
1,743 reads
September TSQL Tuesday
It is hard to believe that time is flying like it is. Already it has been a month since I...
2010-09-08
523 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