SQLSaturday #49 Planning Update
Planning for SQLSaturday #49 – Orlando is on-going and going well especially since we have a good head start. We have...
2010-05-27
480 reads
Blog Posts
The SSIS Data Flow is Like... an Automotive Assembly Line
When I describe (or rather, attempt to describe) technical subjects to people that aren't familiar with them, I tend to...
2010-05-27
465 reads
When did SQL Server start and how long is the downtime window?
This is an old topic, and there have been quite a few blogs (and following comments) that illustrate how to...
2010-05-27
3,728 reads
Connecting to DB2 using SSIS
To start, first download and install the Microsoft OLE DB Provider for DB2. Click here to download. After it is...
2010-05-26
21,822 reads
Kalen Delaney Speaking In Denver on June 9, 2010
Well-known SQL Server MVP and author Kalen Delaney (blog) will be speaking about SQL Server Plan Cache and Recompilation on...
2010-05-26
945 reads
Reporting Services – Building the first report
One of my goals this year was to spend some time learning Reporting Services. Not necessarily do the 10,000 hours...
2010-05-26
2,121 reads
Does The Job Matter To You?
Last week I wrote an editorial for SQLServerCentral titled Does The Job Matter To You?, asking how much the type...
2010-05-25
556 reads
Quick Audits of Schema Changes
I saw someone post a question recently about tracking down who deleted a stored procedure. I suggested the default trace,...
2010-05-25
959 reads
Space Used
At long last I am bringing the next installment in this mini-series. You can find the rest of the articles...
2010-05-25
1,430 reads
SQL Saturday #35 Notes and Observations
First of all, I want to congratulate all the volunteers that made this happen. It was a very well organized...
2010-05-25
1,175 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
Jabatan Imigresen Certified Translators: Trusted Support for Official Documents
When preparing documents for immigration in Malaysia, accuracy and compliance are essential. Working with...
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