PASSMN January Meeting This Week
Don’t forget – if you are in Minnesota this week the Minnesota SQL Server User Group (PASSMN) will be meeting on...
2011-01-23
528 reads
StrateSQL
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-22
2,330 reads
31 Days of SSIS – Controlling Your Flow In The Control Flow (21/31)
Remember, what I said last Friday? I’m going do it, again. Which means, I’m taking the day off. There will...
2011-01-21
924 reads
31 Days of SSIS – Environmental Variable(17/31)
31 Days of SSIS
It’s time to go back to discussing the environment when it comes to SSIS packages. For the...
2011-01-21
2,830 reads
31 Days of SSIS – DTSConfig Configuration (19/31)
31 Days of SSIS
The last two posts in the 31 Days of SSIS talked about the use of environmental variables...
2011-01-20
1,256 reads
31 Days of SSIS – No More Procedures (20/31)
Time to shift off of configurations and environments and talk more about SSIS packages and best practices. If you haven’t...
2011-01-20
1,832 reads
Now Let’s Vote for 24 Hours of PASS
Yesterday, I wanted you to vote for some SQLRally sessions, mine included. Today, let’s vote for the sessions for the...
2011-01-20
617 reads
XQuery for the Non-Expert – @Variable Use
Talk to the Experts
In a previous post, I discussed the exist() method as part of the XQuery for the Non-Expert...
2011-01-20
2,997 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-19
2,206 reads
Time To Get Your #SQLRally Vote On!
It’s week two of voting for the upcoming SQLRally. This week, we are voting for the Database & Application Development sessions...
2011-01-19
453 reads
Blogs
Don’t Miss Out – SQL Server 2025 Unleashed Training Starts Next Monday!
Next Monday, Marchg 9, 2026, my one-day live online training SQL Server 2025 Unleashed:...
What is ALM in Fabric?
By HeyMo0sh
As someone who’s worked with data for over 20 years and with many cloud...
The Most Successful Startups in 2025 — And What They Have in Common
By HeyMo0sh
2025 belongs to the AI startups. If you peek into the tech headlines, you’ll...
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