| Category: SQL Server 2012 | | |
7 Articles
found and displayed in this view.
- Microsoft® SQL Server® 2012 Step by Step - Chapter 1
Magazine/Issue: Online CoDe Magazine, Book Excerpts
Release Date: Monday, May 06, 2013
Quick ID: 1305083
By Patrick LeBlanc, Publisher: Microsoft Press, Released: January 2013, http://shop.oreilly.com/product/0790145338273.do?sortby=publicationDate
- The Absolute Beginner’s Guide to Windows Azure SQL Database
Magazine/Issue: CoDe Magazine, 2013 May/Jun
Release Date: Saturday, April 06, 2013
Quick ID: 1305041
In virtually every CODE article I’ve written since 2004, the proverbial 99% of the content has been based on things I’ve done in production. Well, every technical person has to “go back to school” at some point,-and my return to school has been in the last month as I finally took a look at SQL Azure. This article represents my findings as I recently finished “kindergarten” and am now ready for the trials of first grade!
- The Baker’s Dozen: 13 Tips for Basics of Data Warehousing and Dimensional Modeling
Magazine/Issue: CoDe Magazine, 2013 Mar/Apr
Release Date: Wednesday, February 06, 2013
Quick ID: 1304071
Imagine you’re working for a company that has accumulated a tremendous amount of transaction data. The business users want to perform all sorts of analysis, monitoring and analytics on the data. Some OLTP developers might reply with, “Just create views or stored procedures to query all the data the way the users want.” Many companies initially take that approach - however, just like certain technologies and system hardware configurations don’t scale well, certain methodologies don’t scale well either. Fortunately, this is where data warehousing and dimensional modeling can help. In this article, I’ll provide some basic information for developers on the basics of data warehousing and dimensional modeling - information that might help you if you want to provide even more value for your company.
- The Baker’s Dozen: 13 Steps for Building a SQL Server Analysis Services 2012 Tabular Model
Magazine/Issue: CoDe Magazine, 2013 Jan/Feb
Release Date: Monday, December 10, 2012
Quick ID: 1301071
For several years, database developers have created analytic (OLAP) databases using tools such as Microsoft SQL Server Analysis Services. SSAS includes the MDX programming language for retrieving data and writing custom expressions. These tools remain very powerful for creating analytic applications. However, some view the tools in SSAS/MDX as difficult to learn. In SQL Server Analysis Services 2012, Microsoft has created a second model (known as the tabular model) for creating analytic databases. The new model brings the promise of simplified features and (in some cases) even better performance than traditional OLAP. In this article, I’ll provide an overview for this new model and will walk through a basic example of creating an SSAS 2012 tabular model database.
- The Baker’s Dozen Doubleheader: 26 Productivity Tips for Optimizing SQL Server Queries (Part 2 of 2)
Magazine/Issue: CoDe Magazine, 2012 Nov/Dec
Release Date: Thursday, October 04, 2012
Quick ID: 1211061
In part two of this series on optimizing SQL Server queries I’m going to continue with some T-SQL scenarios that pit one approach versus another. I’ll also look at what SQL developers can do to optimize certain data access scenarios. I’ll also compare approaches with temporary tables versus table variables, and stored procedures versus views.
- The Baker’s Dozen Doubleheader: 26 new Features in SQL Server Integration Services 2012 (Part 2 of 2)
Magazine/Issue: CoDe Magazine, 2012 May/Jun
Release Date: Thursday, April 19, 2012
Quick ID: 1206021
The new release of SQL Server's Integration Services has many exciting new features
- The Baker’s Dozen Doubleheader: 26 New Features in SQL Server 2012 (Part 1 of 2)
Magazine/Issue: CoDe Magazine, 2012 Mar/Apr
Release Date: Saturday, February 18, 2012
Quick ID: 1203051
When I was a kid, I loved baseball. I lived it 24/7. In the summertime, happiness meant a pickup game during the day and a Phillies doubleheader at night. I’m still a kid at heart and I still love baseball - and I also love SQL Server. And right now, happiness means seeing all the cool new features in SQL Server 2012. There are so many of them that I can’t list them in a single article. So, I’m penning a two-part Baker’s Dozen. The first part of this “twin-bill” (yes, expect a few baseball analogies!) will be 13 new T-SQL and database engine features in SQL Server 2012. The “night-cap” in the next issue will be 13 new features in SQL Server Integration Services and the new Business Intelligence Semantic Model.
|  | |  |  |
 |
|
 |
“Lightning Fast”
– Redmond Mag |
|
“Covers all data
sources” – eWeek |
|
|
 |
|
|
 |
|
| • |
25+ fielded & full-text search options |
|
|
| • |
dtSearch’s own document filters highlight hits in popular file types |
|
|
| • |
Web Spider supports static & dynamic data |
|
|
| • |
APIs for .NET, Java, C++, SQL, etc. |
|
|
| • |
Win / Linux (64-bit & 32-bit) |
|
|
| www.dtSearch.com |
|
|
|
|
|
|
|