Window Functions in SQL Server
With SQL Server 2012, we are soon to enjoy a full range of Window Functions. They are going to make for some much simpler SQL queries, as Fabiano Amorim ably demonstrates here.
2011-11-14
4,521 reads
SQL Server 2012
New Spatial Features in SQL Server Code-Named 'Denali'
SQL Server 2008 introduced spatial data support into the database server. This paper describes and discusses the new spatial features in SQL Server Code-Named “Denali” CTP1 and CTP3 that augment existing SQL Server 2008 and SQL Server 2008 R2 spatial functionality.
2011-11-03
2,943 reads
Help Make SQL Server “Denali” The Best Release Yet!
A blog from Dan Jones of Microsoft asks you to test the next release of SQL Server, in CTP3 now, and send your feedback to Microsoft to ensure that the product is well tested.
2011-08-24
2,006 reads
Tool to help you analyze SQLDIAG and PSSDIAG output
SQLDIAG or PSSDIAG are excellent tools used to collect and analyze data in order to identify possible performance root causes. The issue is that the output produced by such utilities is sometimes convoluted, hard to read and hard to understand. In this tip, I will show you a tool that you can use to read and analyze the data collected by these tools.
2009-12-17
2,873 reads
Blogs
Removing a PowerShell Array Element–#SQLNewBlogger
By Steve Jones
I saw an article on this and realized I had no idea how to...
PostgreSQL Backup Failure
In this blog post I wrote a tip about fixing the PostgreSQL backup failure...
Dynamic Data Masking – SQL Server
By Tim Radney
Use Dynamic Data Masking to protect your data The post Dynamic Data Masking – SQL...
Forums
Case statement to insert a new line in query output??
Hi I need to insert a new line of my output when a condition...
Database Mail to work on Azure VM
Trying to get Database mail working sending via outlook.office365.com or smtp.office365.com port 587 using ...
Ask SSC