31 Days of SSIS – Generating Row Numbers (23/31)
31 Days of SSIS
It’s Sunday afternoon and a good time to be putting up post twenty-three for the 31 Days...
2011-01-28
2,863 reads
StrateSQL
31 Days of SSIS – Small Package, Big Win (26/31)
Welcome to day twenty-sixth post of the 31 Days of SSIS. We’re getting near the end now. If you have...
2011-01-27
903 reads
31 Days of SSIS – Data Flow Expressions (22/31)
31 Days of SSIS
Today, we continue on with the 31 Days of SSIS blog series. Yesterday’s post was on the...
2011-01-27
2,042 reads
31 Days of SSIS – One Package, Unlimited Tables (25/31)
31 Days of SSIS
One day at a time and we have reached the twenty-fifth post in the 31 Days of...
2011-01-26
1,705 reads
Presenting on #SSIS to EDMPASS Today
Will you be in Edmonton today? How about near a computer connected to the inter-tubes? If so, you might be...
2011-01-26
784 reads
31 Days of SSIS – One Package, Unlimited Databases (24/31)
31 Days of SSIS
Another day, another blog post all about SSIS in my continuing journey through 31 Days of SSIS. ...
2011-01-25
1,410 reads
PASSMN January Meeting Today
Minnesota SQL Server User Group (PASSMN) will be meeting today. Come down and learn about SQL Server with Kalen Delaney...
2011-01-25
506 reads
Time To Get Your #SQLRally Vote On! – Part 2
Now it’s week three of voting for the upcoming SQLRally. This week, we are voting for the Enterprise Database Administration...
2011-01-25
588 reads
31 Days of SSIS – SQL Server Configuration (18/31)
31 Days of SSIS
The last post in the 31 Days of SSIS talked about the use of environmental variables. As...
2011-01-25
1,469 reads
31 Days of SSIS – Generating Row Numbers (23/31)
31 Days of SSIS
It’s Sunday afternoon and a good time to be putting up post twenty-three for the 31 Days...
2011-01-24
2,490 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