Why SQL Server 2005 Doesn't Permit Non-ANSI Style OUTER JOINs
As of SQL Server 2005, any database in 90 compatibility mode (settable by sp_dbcmptlevel) cannot support non-ANSI OUTER JOINs. Sometimes...
2007-11-01
2,174 reads
Blog Posts
Nominations INETA North America Board of Directors
Picked this up from the local Net group here in Orlando. INETA is actually pretty helpful when it comes to...
2007-10-31
1,415 reads
SQLSaturday Finally Has a Logo
Sometimes its the little things that seem to take forever! We've had a text only logo up for a while,...
2007-10-31
1,442 reads
Tool: KeePass Password Safe password manager/vault
Some time ago I was looking for a password vault and came across some recommendations for KeePass. KeePass is open...
2007-10-31
2,603 reads
If Exists (Select 1...) vs If Exists (select * ...)
If exists is a well known way to improve performance because it returns as soon as it matches a single...
2007-10-30
1,960 reads
SQL Server: Listing all the database roles for a given database user
SQL Server 2005 introduces Common Table Expressions (CTEs), which are great for recursive queries. Previously, in order to do recursion,...
2007-10-30
2,569 reads
Becoming a DBA, Part I
A recent thread on SQLServerCentral.com had an individual what it took to be a successful DBA. Couple that with a...
2007-10-29
1,675 reads
How Much Pizza and Soda for a User Group Meeting (Why You Should RSVP)?
After a few meetings of oPASS this year the numbers I use are 2 slices of pizza and 2 drinks...
2007-10-29
1,450 reads
Structuring the Blog Better
For a variety reasons, including personal/family concerns and workload, I've not been able to write as often as I'd like....
2007-10-28
1,466 reads
Alpha Version of SQLPing3 Command Line Available
Noted SQL Server security expert, Chip Andrews, has released an alpha version of a command-line version of SQLPing3. You can...
2007-10-25
2,308 reads
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
adira finance bogor tajur,Telpon/wa 0822-7774-3331
Jl. Raya Tajur No.112, RT.01/RW.06, Pakuan, Kec. Bogor Sel., Kota Bogor, Jawa Barat 16134
BCA KCP BANYUMANIK TLP/WA 083800209966
Ruko Srondol Square, Jl. Setia Budi No.147 Blok 5 & 6, Srondol Kulon, Kec....
Adira Bekasi 5 Mobil Cikarang,Telpon/wa 0822-7774-3331
Komplek Ruko Cikarang Square, Jl. Raya Cikarang - Cibarusah No.B12, Pasirsari, Cikarang Sel., Kabupaten...
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