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
606 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
606 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,929 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,759 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,723 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
484 reads
See a short and dirty example how to use temporary table in user defined function (UDF).
2011-07-21
20,697 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
661 reads
By Brian Kelley
When I look at a system and think about its security model, the first...
On Wednesday May 15th 2024 I will give a free webinar on MSSQLTips.com about...
By Will Assaf
I recently reviewed, worked on, and added a similar example to the DATETIMEOFFSET Microsoft...
Hello folks, I would very grateful if someone could assist me with this problem....
Can anyone recommend an Azure SQL Managed Instance book? I'm looking for information about...
hi we run 2019 std but i'm testing this on 2016. following some old...
I run this command in SQL Server 2022. What is the extension of the backup file?
BACKUP DATABASE HerdofTwo TO DISK = 'HerdOfTwo_20240501'See possible answers