Other News

Community

IT Budget Planning for Big Data

(Lockwood Lyon) Big data software, hardware, application suites, business analytics solutions … suddenly, it seems, IT enterprises are deluged with vendor offerings that solve problems it didn’t know it had. Competitors are gathering data to determine customer needs, define new product categories,

Editorials

User Defined Table Type

User Defined Table Types have been in SQL Server since 2008. They are mostly used to pass sets of data into a stored procedure. You create the user defined table type first in a database. Then you can populate the type from your client application or another SQL Server object. That table, defined as your own table type, may then […]

Editorials

Sequences

Have you found an opportunity to use Sequences in SQL Server Yet? Sequences can be very powerful when implementing a type/subtype database pattern. Using a type/Subtype pattern you may have a number of tables that have similar characteristics. For example, you could have a number of different tables representing a person. You could have people tables like Employee, Sales Representative, […]