(Pinal Dave) This article shows how to use ApexSQL Complete, a free SQL Server intellisense add-in. You can download ApexSQL Complete, and play along through the article.
Other News
Using the New Compatibility Mode
(Troy Coleman) In May when I posted a summary of new DB2 11 features, I mentioned that the latest release allows applications with SQL or XML to be run in compatibility mode. Since this is an important feature that will help customers much more quickly migrate to DB2 11, I’ll provide some detail.
Failover with the MySQL Utilities: Part 2 – mysqlfailover
(Stephane Combaudon) In the previous post of this series we saw how you could use mysqlrpladmin to perform manual failover/switchover when GTID replication is enabled in MySQL 5.6. Now we will review mysqlfailover (version 1.4.3), another tool from the MySQL Utilities that can be used for automatic
An example of a user-defined aggregate function
(Flavio Casetta) May be user-defined aggregate functions are not among the most frequent hits in the life on a PL/SQL or APEX developer, but today I wanted to find an elegant solution for a problem submitted by a customer without reinventing the wheel:
How to Use an Android Layout Mockup Utility that Generates Usable XML and Java
(B. Clay Shannon) In the olden days of Eclipse, creating the GUI/View part of a Java app was/is unconscionably difficult. Along came Droidio (AKA “Android Studio”) that makes creating an Android layout much easier.
Step-by-Step Guide to Using Generic ADO.NET
(Peter Shaw) Those of you who know what lies behind frameworks such as ‘Entity Framework’ and ‘N-Hibernate’ will undoubtedly be going ‘Why’? For those of you who don’t, well… stay tuned, this might get just a little bit interesting.
Questions about SQL Server Data Types You were Too Shy to Ask
(Robert Sheldon) Although SQL Data Types seem to cause a lot of grief for database developers and can be tricky in their use, we seem to be expected to know all about them, and so it is embarrassing to ask questions about them in forums.
How do you get someone in another department to do something you need
How Do You Get Someone in Another Department to do Something You Need Hello, this is Laura Lee Rose. I am a speaker and author. My background is in time and project management. I help busy professionals and entrepreneurs create effective systems so that they can comfortably delegate to others, be more profitable and have time to enjoy life even...
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
Full Text Search
(Jagmeet Chaudhary) This is the first post in a two part series which I am planning to write on full text search .In this post I will give a brief introduction on full text search and explain how to configure it in SQL Server 2012.
Basics of MDX
MDX is a language that enables to query multidimensional databases similar to the way SQL is used to query relational databases.