Connecting to DB2 AS\400 with SSIS
We have a lot of projects in our organizations that require us to work with database systems other than SQL...
2010-02-20
4,504 reads
Blog Posts
Don’t Miss our Upcoming Webinar Series in February and March
More awesome happenings from Pragmatic Works, Wrox, and SQLServerCentral.com. Check out our Upcoming Webinar Series next week. They are free,...
2010-02-20
252 reads
Free SQL Server Webinar Series
Are you new to SQL Server?Do you want to learn about its many features and capabilities? If so, please join...
2010-02-20
775 reads
I’m Speaking at the SSWUG VConference in April
Hey All ! I wanted to let you know I will be speaking at the SSWUG Virtual Conference this Spring. This...
2010-02-20
211 reads
Important SSAS Dimension Properties
When configuring a SSAS Dimension, there are many important properties to pay attention to. This blog will give you a...
2010-02-20
442 reads
Improve your SSMS Interaction
Ever wanted to liven up your life some with some color in your day to day DBA duties. There are...
2010-02-20
252 reads
Keynote Speaker!
Actually it’s not as big a deal as it sounds, but still a little exciting. I was asked to be...
2010-02-20
684 reads
LastPeriods and PeriodstoDate
There are several ways for calculating “To-Date” calculations the longer way. These normally include a more granular level of control...
2010-02-20
600 reads
MDX Time Calculation Shortcuts
There are lots of ways to calculate time comparisons in MDX, but there are some great shortcuts. The functions WTD,...
2010-02-20
290 reads
Modifying SQL in a Lookup Transform
Oftentimes you need to make a more advanced join that the default LookUp Transform will allow. The challenge is when...
2010-02-20
351 reads
Blogs
The Book of Redgate: Do the Right Things
By Steve Jones
I do believe that Redgate has been very customer focused since it’s inception. I’ve...
How to Connect to SQL Server When Nothing Else Works – DAC
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
Get a Range of Sequence Values: #SQLNewBlogger
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
Forums
Warning: Could not open global shared memory to communicate with performance DLL
Hi everyone I am getting below warning when I run SSIS: Warning: 0x80049304 at...
Let's Talk Community Events!
Comments posted to this topic are about the item Let's Talk Community Events!
that one limitation in replication
Hi as shown below a replication target requires a primary key. if we want...
Question of the Day
Detecting Deadlocks
By default, how often is the SQL Server Database Engine checking for deadlocks?
See possible answers