Parallel Execution in SSIS 2008 and later version
SQL Server Integration Services (SSIS) execution is sequential by default. SQL Server Integration Services (SSIS) does allow parallel execution. Now...
2012-09-29
986 reads
Blog Posts
Check List for SQL Server Connectivity Issue !
SQL Server connectivity is the most common issue & below mention errors is also common at time of connectivity issue.
Error :
A...
2012-09-28
1,485 reads
I voted in the PASS Election - you should too!
If you are a member of PASS you have probably already received an email that looks like this:
--
From: <hq@sqlpass.org>
Date: Fri,...
2012-09-28
1,679 reads
Reblog – September 21 to September 27
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2012-09-28
1,463 reads
SQL Server: Part 2 : Approaching Database Server Performance Issues
In the Part 1, we have seen how quickly we can check the runnable task and I/O pending task on...
2012-09-28 (first published: 2012-09-21)
3,782 reads
Time to Vote-PASS Board of Directors
It’s that time of year where we get to vote for the three best candidates to serve a two year...
2012-09-28
1,511 reads
Use Powershell to Manage Idera SQL Diagnostic Manager
Idera SQL Diagnostic Manager (or as I call it "SQLdm") is a great monitoring and performance tuning tool that I...
2012-09-28
2,738 reads
Yet Another Facebook Page - Living For SQL Server
I have created facebook page named "Living For SQL Serever" couple of days back.
https://www.facebook.com/LivingForSqlServer
Inviting our community friends to like this...
2012-09-28
1,798 reads
An Introduction to SQL Server
There are still seats left on the Learning Tree course – An Introduction to SQL Server event that I will be...
2012-09-27
808 reads
Cannot assign a default value to a local variable !
You will hit this error Cannot assign a default value to a local variable in case you are running SQL 2005/below,and you try...
2012-09-27
2,925 reads
Blogs
Don’t Miss Out – SQL Server 2025 Unleashed Training Starts Next Monday!
Next Monday, March 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