A High Level Comparison Between Oracle and SQL Server - Part II
Part II or the Oracle / SQL Server comparison dives deeper into databases by exploring the architectural differences.
2010-03-26
4,935 reads
Articles
Inserting into an XML document
I was reading through the latest XML Workshop article that I have from Jacob Sebastian. It’s a fantastic series for...
2010-03-26
1,476 reads
Run an SSIS Package Under a Different Account
In this article, learn how to use the SQL Server agent proxy to run an SSIS Package under whatever account you choose.
2010-03-25
58,770 reads
A High Level Comparison Between Oracle and SQL Server
Part I of the Oracle / SQL Server comparison looks at the various editions of each database and their structure.
2010-03-25
6,514 reads
Left outer join vs NOT EXISTS
And to wrap up the miniseries on IN, EXISTS and JOIN, a look at NOT EXISTS and LEFT OUTER JOIN...
2010-03-25
5,209 reads
A little restriction that prevent changing tables in SQL Server 2008
In SQL Server 2008, by default, the option to prevent tables changes is "on". We can have some issues and...
2010-03-24
4,013 reads
SQL Saturday #29 - Birmingham
A free one day training event from SQL Saturday and the Birmingham SQL Server groups. Come join us if you are in the area.
2010-03-24 (first published: 2010-02-18)
3,212 reads
SQL Server - Introduction to Business Intelligence Development Studio
In his latest article, Marcin Policht demonstrates a variety of tools that can be employed to execute SQL Server Integration Services packages, focusing in particular on the method leveraging functionality available within the Business Intelligence Development Studio.
2010-03-24
3,539 reads
Expanding The Scope of Bridge Tables
Timothy Claason continues talking about database design in a new article. This one talks about expanding the functionality that Bridge Tables provide in your schema.
2010-03-23
8,221 reads
Microsoft SQL Server 2008 Integration Services Problem-Design-Solution - Sample Chapter
Learning about practical Integration Services is an important part of the well rounded DBA for the future. Read a sample chapter from this new book.
2010-03-23
2,314 reads
Blogs
The Book of Redgate: Spread across the world
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
Merry Christmas
By John
Today is Christmas and while I do not expect anybody to actual be reading...
Self-Hosting a Photo Server the Whole Family Can Use
By Bert Wagner
Until recently, my family's 90,000+ photos have been hidden away in the depths of...
Forums
SQL Server 2025 Backup Compression Algorithm
Comments posted to this topic are about the item SQL Server 2025 Backup Compression...
The Large Encoded Value
Comments posted to this topic are about the item The Large Encoded Value
The Side Job
Comments posted to this topic are about the item The Side Job
Question of the Day
The Large Encoded Value
I want to use the new BASE64_ENCODE() function in SQL Server 2025, but return a string that isn't large type. What is the longest varbinary string I can pass in and still get a varchar(8000) returned?
See possible answers