SQL Lunch - Oracle-CDC for SQL Server Integration Services
We have been working hard trying to get speakers to complete the year for our SQL Lunch schedule. I am...
2009-09-10
702 reads
Blog Posts
Updating Existing Data with SSIS
I see a lot of questions on the forums about updating existing data in SSIS. When the update is dynamic...
2009-09-10
22,360 reads
What happened to that email?
This question:
Created script to send mails using sp_send_dbmail- working like a charm.
Now searching for a way to get...
2009-09-10
937 reads
Be Careful of Facebook
Even the President thinks so! In his talk yesterday, he warned kids about Facebook, and being careful what they should...
2009-09-09
1,056 reads
Books You Should Own
Have you ever wondered where to go to get good information that will help you in your day to day...
2009-09-09
453 reads
Great Post on Clearing all data from your Data Warehouse
Hey there Gang !
Most of you probably know Jamie Thompson has move his blog over to SQLBlog.com. This is worth noting...
2009-09-09
418 reads
Some 24 Hours of PASS Sessions Can Now be Viewed Online
If you missed out on some of the 24 free, live sessions that made up the 24 Hours of PASS,...
2009-09-09
493 reads
Speaking at Space Coast User Group
I have the privilege of presenting, Dive into the Default Trace, at the Space Coast User Group, tomorrow evening (Sept....
2009-09-09
305 reads
Spools in Execution Plans
I got the question the other day, when are you likely to see a spool in an execution plan? Easy,...
2009-09-09
2,788 reads
SQL Server 7.0 – Transaction Log Not Backing Up
I have not worked with SQL Server 7.0 in a loooong time. So when I received a call from a...
2009-09-09
2,007 reads
Blogs
Did You Really Name That Default?
By alevyinroc
Ten years (and a couple jobs) ago, I wrote about naming default constraints to...
Monday Monitor Tips: A New Analysis Page
By Steve Jones
We have multiple teams (8) working on Redgate Monitor. Some work on the Standard...
Case Studies: Real-World Success Stories of FinOps Implementation
By HeyMo0sh
Learning any kind of theory is easy, but adapting FinOps and watching it rescue...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
The Problem Isn't Always Your Query or Schema... Sometimes It's Hidden Assumptions
Comments posted to this topic are about the item The Problem Isn't Always Your...
Identity Defaults
Comments posted to this topic are about the item Identity Defaults
Question of the Day
Identity Defaults
What happens when I run this code?
CREATE TABLE dbo.IdentityTest
(
id int IDENTITY(10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
See possible answers