SQL Server 2016 announced as SQL Server 2005 support nears its end

For those of you still using SQL Server 2005, Microsoft will completely end support on April 12th 2016. You can head over here to check out upgrade guidelines, download migration tools, and read more ...
dbta

Dynamic Data Masking and Row-Level Security Features on the Way in SQL Server 2016

SQL Server 2016, the next major release of Microsoft’s flagship database and analytics platform (which is available as a Community Technology Preview [CTP] as of this writing), includes exciting ...
InfoQ

Accelerate SQL Server Performance With SafePeak’s Dynamic Database Caching

Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with content, and download exclusive resources. Vivek Yadav, an engineering manager from ...
Houston Chronicle

How to Build a Query String in T-SQL

Dynamic SQL lets you create a query string based off of user input. SQL Server allows you to create dynamic SQL statements. The statements use a SQL string varchar data type, then you execute the ...
ZDNet

Improve dynamic SQL performance with binds

Developers often dismiss dynamic SQL used in PL/SQL programs for two reasons. One reason is that it's riskier because the SQL statements aren't parsed until runtime, so it's more difficult to catch ...
TechRepublic

SQL Server 2022: Here’s what you need to know

SQL Server 2022: Here’s what you need to know Your email has been sent Three decades on, SQL Server is still a database workhorse that powers both an internal line of business applications and ...