(Lockwood Lyon) Big data applications are now fairly commonplace in large organizations. They typically begin as part of an information technology (IT) project that will extract, store and analyze large amounts of existing data in order to reduce costs, predict customer buying patterns, speed produc
Other News
JavaScript Arabic Alert Message
(arkaysahu) This is a tip where developers find an easy way to show up JavaScript Alert Messages having Arabic Text. While developing a web site which supports multiple language, many times, it is a requirement to show Alerts having Arabic text.
SQL Server Integration Services XML Configurations Tips and Tricks
(Dattatrey Sindol) Package Configurations are a very powerful feature of SQL Server Integration Services (SSIS). They enable us to handle various things dynamically at run-time. In this tip, we will take a look at few Tips and Tricks on SSIS XML Package Configurations.
Silverlight Lifecycle
As I have been watching the startup of new projects using the Dot Net stack it looks like Silverlight is being replaced with MVC or MVVM based on HTML5 capabilities. I’m not saying one is better or worse, or even making capability comparisons. Moreover, Silverlight has more capabilities in older browsers in those situations where installing a client tool is […]
SQL Server 2014: Stored Procedures
SQL Server 2014: Stored Procedures Author: Basit A. Farooq Introduction A stored procedure is a named, precompiled collection of SQL statements, variables, and control-of-flow statements. You can create stored procedures that accept input parameters and return values and status information. Typical uses for stored procedures include automating repetitive tasks, ensuring tasks are performed consistently, enhancing application and user access security...
This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Register
Already a member? Log in here
DB2 and Transparent LDAP in DB2 DPF – Misleading error SQL30082N
(Pavan Kristipati) In this blog post, I will quickly cover my recent experience in troubleshooting a DB2/LDAP authentication problem in a DB2 DPF database.
Implement Large, Fast, Updatable Tables for Responsive Real-Time Reporting
(Don Mackenzie) Satisfying the needs of business users is an ongoing challenge for system designers. This article builds on the October MSDN Magazine print article, “Use Updatable Tables for Responsive Real-Time Reporting,” that describes a combination of table partitioning and columnstore indexing
SQL SERVER – SSMS: Index Usage Statistics, Physical Statistics & User Statistics
(Pinal Dave) When I used to be in the consulting business, the most request session or topics always revolved around Performance Tuning. And whenever I talk to folks around what they want to get covered, they often get to a point of when and how to create efficient indexes in my database.
Enable Ionic Intellisense support in Visual Studio 2013
(Shailendra Chauhan) Visual studio provides you intellisense support for various programming languages and scripts. It helps a lot while programming with Visual Studio IDE.
GROUP BY fixed
(Arjen Lentz) Friend and former colleague Roland Bouwman has written an excellent update on the GROUP BY implementation in MySQL.