Database Management & Programming News, Articles & Tutorials for Database Administrators
Getting Started with Azure SQL Data Warehouse - Part 5 05/22/2017
In part 5 of this series covering Azure SQL Data Warehouse, Arshad Ali covers performance optimization and the different aspects that impact performance.
Database as a Service: Outlook Cloudy 05/15/2017
For most companies, IT-related hardware and software maintenance is costly, time-consuming and requires hiring and retaining a support staff of operating system and database management system specialists. Delegating these responsibilities to an outside firm allows a new application to be developed and implemented more quickly. However, there are issues with delegating database support to an outside service. In this article, we will concentrate on how these environments scale with application growth, especially if the data and services are stored in the cloud.
Oracle B-Tree Index On A BLOB 05/11/2017
Interestingly, you can create a B-tree index on a BLOB column; read on to see how to do it and just how useful, or not, it might be.
Implement a Secure WordPress Search 05/08/2017
Rolling your own search is especially advantageous for WordPress sites that include a lot of custom post types. Rob Gravelle shows you how to build a query that searches by post_title and taxonomy metadata.
Setting Variables in Calling T-SQL Code While Using sp_executesql 05/04/2017
In this tip, Greg Larsen shows you how to set variables in your calling T-SQL code when using sp_execute sql.
Where is my SQL Server Configuration Manager? 05/04/2017
If you are running Windows 8 and above, you might have found out that you can’t find SQL Server Configuration Manager in the list of installed applications. Read on to learn how to locate it.