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
611 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
611 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,934 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,763 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,730 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
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
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
490 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
664 reads
I am going to describe quite forgotten feature in SQL Server 2008. It is Change Data Capture (CDC) – powerful feature...
2011-07-15
2,468 reads
So, you want to get your SQL skills razor-sharp without dropping any cash? You're...
By Steve Jones
Here are the slides from my talk today at the Redgate NYC Devour Hour:...
By Steve Jones
If you have any doubt about being able to carry a load in one...
Hi everyone I have a SP that just failed. Format of SP is: Select...
Comments posted to this topic are about the item Analyzing Tempdb Spills and Usage...
Comments posted to this topic are about the item Creating a new API in...
If I run "dab init" to create a new API over a database, what parameters are required?
See possible answers