SQL Treeo

SQL Server 2011 “Denali” introduces two new features for flow control which may help you to keep your T-SQL cleaner than...

2011-08-02

627 reads

The Good, the Bad and the Ugly SQL Cursor types

by Danny Riebeek

SQL Treeo

T-SQL cursors are generally bad approach and are often misused. In today’s world of correlated subqueries, CTE’s, recursive CTE’s, ranking...

2011-07-30

1,946 reads

SQL Azure – simple description, part I.

by Danny Riebeek

SQL Treeo

I was studying SQL Azure parameters some time ago and found out that there are no materials which tell you...

2011-07-29

1,769 reads

T-SQL refactoring

by Danny Riebeek

SQL Treeo

Keeping your SQL objects’ naming rules during furious development is hard. New levels of information are added continuously, entities are...

2011-07-28

2,735 reads

Fastest row counting method

by Danny Riebeek

SQL Treeo

SELECT COUNT(*) is most common method (and exact) how to find out how many records is in table. There is...

2011-07-26

6,375 reads

Partial name matching in SQL Server 2011 “Denali”

by Danny Riebeek

SQL Treeo

While playing with SQL Server 2011 “Denali”, I’ve accidentally found out that it has slightly enhanced intellisense in SSMS. There...

2011-07-21

1,389 reads

Article: How to use temporary table in function

by Danny Riebeek

SQL Treeo

Steve Jones from voiceofthedba.com, editor on SQLServerCentral.com gave me an opportunity to publish humble article about workaround solution for using...

2011-07-21

505 reads

Custom folders SSMS Add-In slightly delayed

by Danny Riebeek

SQL Treeo

I am desperately trying to finalize this add-in and it is very very close. I was performing another testing on...

2011-07-17

540 reads

SQL Injection is still actual :)

by Danny Riebeek

SQL Treeo

Here are two samples showing that SQL Injection is still here and dangerous !!!

source:xkcd.com

This use case is especially insidious

2011-07-16

668 reads

Tracking table changes seamlessly with Change Data Capture (CDC)

by Danny Riebeek

SQL Treeo

I am going to describe quite forgotten feature in SQL Server 2008. It is Change Data Capture (CDC) – powerful feature...

2011-07-15

2,552 reads

SQL Treeo

Awesome new features in SQL Server 2011 “Denali”: IIF and CHOOSE functions

The Good, the Bad and the Ugly SQL Cursor types

SQL Azure – simple description, part I.

T-SQL refactoring

Fastest row counting method

Partial name matching in SQL Server 2011 “Denali”

Article: How to use temporary table in function

Custom folders SSMS Add-In slightly delayed

SQL Injection is still actual :)

Tracking table changes seamlessly with Change Data Capture (CDC)

Blogs

Where Is My SQL Agent? Running Scheduled Jobs Against Azure SQL Database

AgentDBA vs Critical SQL Server

Finally Cleaning Up Dropbox: Moving Almost a TB to Google Drive with rclone

Forums

Alamat kontak resmi BCA KCP Tebet Telp:0818751777

Stan Phone Number Australia +61-1800868603 Quick Help Guide

BCA KCP Pasar Minggu Center | Tlp/Wa:0817866887

Question of the Day

Detecting Characters