Awesome new features in SQL Server 2011 “Denali”: IIF and CHOOSE functions
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
607 reads
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
607 reads
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,926 reads
I was studying SQL Azure parameters some time ago and found out that there are no materials which tell you...
2011-07-29
1,757 reads
Keeping your SQL objects’ naming rules during furious development is hard. New levels of information are added continuously, entities are...
2011-07-28
2,722 reads
SELECT COUNT(*) is most common method (and exact) how to find out how many records is in table. There is...
2011-07-26
6,366 reads
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
481 reads
See a short and dirty example how to use temporary table in user defined function (UDF).
2011-07-21
16,015 reads
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,379 reads
I am desperately trying to finalize this add-in and it is very very close. I was performing another testing on...
2011-07-17
535 reads
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
659 reads
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers