The CLR
Some very interesting responses to my CLR editorial today including some good details that I haven't seen elsewhere. I'm still...
2008-05-13
911 reads
Blog Posts
Visiting Boston This Week
I get busy and usually forget to post when I'm out and about, but for once I've remembered. I'll be...
2008-05-11
455 reads
Possible interview questions for Intern/Junior DBA or Developer
I wrote these questions thinking about what some basic t-sql statements that I would want to see if I were...
2008-05-10
3,818 reads
A View Variable
I saw that Erland Sommerskag posted a Connect item that asked for a "View Variable" to be added to the...
2008-05-09
1,259 reads
A little fun with SSIS Expression Language
The SSIS expression language is a powerful yet enigmatic entity. Once you get used to its syntax - which is part...
2008-05-08
4,872 reads
Follow Up Notes on SQLSaturday #3
Our most recent SQLSaturday went well, but there is always room for improvement. Here are my notes from this event:
The...
2008-05-08
392 reads
Kindle Research - Procs and Cons with the Sony Reader
After the editorial on the Kindle, which got quite a few responses, I've continued to look around and research things....
2008-05-08
960 reads
ACM, 5 Year Anniversary, and Customer Service
Time moves by and I was surprised to get a coffee mug in the mail from ACM (Association for Computing Machinery)...
2008-05-07
483 reads
Thoughts on SQL Saturday in Jacksonville
I was able this Saturday to head down to Jacksonville and speak at the SQL Saturday there. There were a...
2008-05-07
725 reads
One More SQL Feature Wish
It would be handy to have a checkbox/SET option/something that would tell SQL not to cache plans run in a...
2008-05-06
413 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