SQL Server 2008 T-SQL Enhancements Part - IV
In the fourth installment that looks at T-SQL changes for SQL Server 2008, Ashad Ali examines how the Filestream data type works.
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.
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...
Burnout
What happens when you burnout? Would you recognize when it happens? A guest editorial from Andy Warren talks about some of the signs and what you can do.
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.
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.
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...
Injecting Your Own Bias
Steve Jones talks about the controversy surrounding the PASS Survey and future Summit announcements. And about how we, as data professionals, might subtly bias clients.
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...
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.
Blogs
T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes?
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
Understanding Fabric MCP
By James Serra
Model Context Protocol, or MCP, is one of those technical ideas that sounds more...
AWS RDS Aurora - our first approach
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
Forums
BCA KCP Senayan City Telpn/wa (08218171891)
Mall Senayan City Unit 6-09A, Jl. Asia Afrika Lot 19, Daerah Khusus Ibukota Jakarta...
BCA KCU DARMO TLP/WA 083800209966
PPCR+MQ6, Jl. Raya Darmo No.5, Keputran, Kec. Tegalsari, Surabaya, Jawa Timur 60265
BCA KCP Golden Trade Center Telpon/wa:0821°8168°291
BCA KCP Golden Trade Center Telpon/wa:0821°8168°291.Jl. Glugur Jl. Gatot Subroto No.11-12, Petisah Tengah, Kec....
Question of the Day
May the Fourth Be With You Fun
In honor of May the fourth and Star Wars (may the force be with you), finish this quote:
"Do, or do not. ..."See possible answers