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
608 reads
SQL Treeo
The Good, the Bad and the Ugly SQL Cursor types
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,933 reads
SQL Azure – simple description, part I.
I was studying SQL Azure parameters some time ago and found out that there are no materials which tell you...
2011-07-29
1,761 reads
T-SQL refactoring
Keeping your SQL objects’ naming rules during furious development is hard. New levels of information are added continuously, entities are...
2011-07-28
2,728 reads
Fastest row counting method
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
Partial name matching in SQL Server 2011 “Denali”
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
Article: How to use temporary table in function
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
487 reads
Custom folders SSMS Add-In slightly delayed
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
SQL Injection is still actual :)
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
Tracking table changes seamlessly with Change Data Capture (CDC)
I am going to describe quite forgotten feature in SQL Server 2008. It is Change Data Capture (CDC) – powerful feature...
2011-07-15
2,421 reads
Blogs
How to find free space in Azure PosgreSQL
I wanted to figure out how big (or approximately how big) my dump file...
T-SQL Tuesday #180: Good enough is perfect Roundup
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
Using SQL Compare with Read-only Access
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
Forums
Announcing SQL Server 2025
Comments posted to this topic are about the item Announcing SQL Server 2025
Running Steve's Code
Comments posted to this topic are about the item Running Steve's Code
New SQL Server 2022 Functions
Comments posted to this topic are about the item New SQL Server 2022 Functions
Question of the Day
Running Steve's Code
Can you run this code in any of your SQL Server 2019 databases without error?
CREATE OR ALTER PROCEDURE [dbo].[StevesAmazingProc]
AS
SELECT Consumer_ID ,
Trend_Category ,
Bit_Trace
FROM NewWorldDB.dbo.MarketTrend;
GO See possible answers