-
Processing Large Datasets Using C# and SQL Server Table Data Types
By:
Rod Paddock
Last updated: Friday, May 28, 2021
Published in: CODE Magazine: 2017 - January/February
If you’ve got large datasets, you don’t want to slow the system down every time you save them to your SQL Server database. Rod shows you an uncomplicated way to keep your records zipping along.
-
SQL Server Reporting Services: Eight Power Tips
By:
Kevin Goff
Last updated: Wednesday, June 23, 2021
Published in: CODE Magazine: 2016 - May/June
SQL Server’s Reporting Services is still the best workhorse for getting data to your users. Kevin tells you how to take advantage of some of its more subtle points.
-
Baker's Dozen--Business Intelligence Developers
By:
Last updated: Monday, December 27, 2021
Published in: CODE Magazine: 2014 - March/April
If you want to be a great SQL Server developer, you’ll want to pay attention to these 13 key points. Kevin Goff covers both best practices and common pitfalls of Business Intelligence.
-
The Baker’s Dozen: 13 Differences Between Analysis Services OLAP and Tabular
By:
Last updated: Monday, May 23, 2022
Published in: CODE Magazine: 2013 - July/August
For over a decade, many Microsoft database developers have used SQL Server Analysis Services (SSAS) OLAP to create database cubes for advanced business analytics. SSAS OLAP offers many powerful features, although some developers view the learning curve of OLAP (and its supporting language, MDX) as very steep.
-
Building a CODE Framework Service and Consuming It on an iPhone Application
By:
Milton Abe
Last updated: Tuesday, May 31, 2022
Published in: VFP Conversion Papers, CODE Magazine: 2013 - May/June
In this article, you will create a CODE Framework RESTful service and an iPhone application from scratch. For the client side, you will utilize XCode (yes, you’ll need a Mac!), which uses Objective-C as the primary language. This article won’t teach you the language; you need to know the basics of Objective-C. Even if you don’t know anything about it but want to code right away, read the article “Building a Twitter Search Client on iOS,” by Ben Scherman, available for all CODE readers in the Xiine application for Windows, Android, and iPhone. For the database, you’ll use any instance of SQL Server 2008. The service will be written in C#, using the latest version of CODE Framework, available on http://codeframework.codeplex.com, where you will find not only the download link, but also a lot of useful information.
-
The Baker’s Dozen Doubleheader: 26 Productivity Tips for Optimizing SQL Server Queries (Part 2 of 2)
By:
Last updated: Tuesday, February 19, 2019
Published in: CODE Magazine: 2012 - November/December
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: 13 Miscellaneous SQL Server Tips
By:
Last updated: Tuesday, February 19, 2019
Published in: CODE Magazine: 2012 - January/February
To use a music analogy, many installments of “The Baker’s Dozen” have been like “concept albums,” where most or all of the tips work towards a big picture. Then there are times where I present a series of random tips that are largely standalone and don’t form a pattern. In this article, I’m going to present 13 random tips for SQL Server and T-SQL programming.
-
The Baker’s Dozen: 13 Transact SQL Programming Tips
By:
Last updated: Wednesday, August 31, 2022
Published in: CODE Magazine: 2011 - November/December
Even with all the new features in the Microsoft SQL Server Business Intelligence (BI), sometimes the only way to accomplish a task is with good old fashioned T-SQL code. (Fortunately, “code” is the acronym for this great magazine!) In this latest installment of The Baker’s Dozen, I’ll present 13 T-SQL programming tips that could help you accomplish different database tasks.
-
The Baker’s Dozen: 13 Power Tips for Using SQL Server Reporting Services 2008 R2
By:
Last updated: Tuesday, February 19, 2019
Published in: CODE Magazine: 2011 - July/August
With each new version of SQL Server Reporting Services, Microsoft continues to offer new functionality for reporting. SQL Server 2008 R2, released to manufacturing in mid-2010, represents Microsoft’s fourth major release of Reporting Services in the last 10 years. This fourth release focuses on map generation and various business intelligence/data visualization features. In this article, I’ll demonstrate 13 significant features in SSRS.
-
Using Configurations to Manage SQL Server Extended Properties
By:
John Petersen
Last updated: Wednesday, August 31, 2022
Published in: CODE Magazine: 2011 - May/June
Before you start hard coding parts of your project to work with metadata in SQL Server, make sure that the functionality you want isn’t already part of the product.
-
The Baker’s Dozen: 13 Productivity Tips for Building OLAP Databases with Microsoft SQL Server 2008 Analysis Services
By:
Last updated: Tuesday, February 19, 2019
Published in: CODE Magazine: 2011 - March/April
rewarding experience of writing and speaking is taking a seemingly complex topic and making it more understandable and accessible. In this article, I’ll show how to create and use OLAP databases and cubes using SQL Server Analysis Services 2008 (SSAS 2008). The benefits of OLAP are significant, even monumental - but like most technologies, reaping the benefits means considerable research and effort into leveraging the tools. In the case of OLAP databases, developers need to learn the differences between OLAP databases and relational databases, and how to use the tools that SSAS provides. In this article, I’ll walk through how to create an OLAP database and how to use the tools in Analysis Services to enhance the OLAP database. By the end, you’ll see why businesses and other organizations see the value of OLAP databases. I’ll also briefly cover some of the plans Microsoft has announced for the next generation of OLAP tools.
-
Building Line-of-Business RIA in Silverlight Using Microsoft SQL Server 2008 Reporting Services
Last updated: Saturday, January 18, 2020
Published in: CODE Magazine: 2011 - January/February
While the development community has accepted the inevitable future of Line-of-Business RIAs and indispensable role of Silverlight in their creation, many of them have started looking for ways to use Microsoft SQL Server Reporting Services in Silverlight applications. It is logical: Reporting Services is reasonably capable and the most-used reporting engine on the market. Millions of developers are Reporting Services professionals and of course they would like to continue using the tool in their RIAs as well.
-
ASP.NET MVC and the ADO.NET Entity Framework
By:
Morgridge, Dane
Last updated: Wednesday, August 31, 2022
Published in: CODE Magazine: 2010 - September/October
Both ASP.NET MVC and the ADO.NET Entity Framework are both very popular topics right now in the developer community.Having spoken at various user group meeting and code camps it is very obvious to me what topics a lot of developers are interested in. I see that sessions about ASP.NET MVC or the Entity Framework are always packed with developers eager for more information. The focus of this article is the Entity Framework, but in the context of an ASP.NET MVC application. As such, I am assuming at least basic understanding of ASP.NET MVC but little-to-none with Entity Framework.
-
Incorporating ASP.NET MVC and SQL Server Reporting Services, Part 1
By:
Last updated: Wednesday, August 31, 2022
Published in: CODE Magazine: 2010 - September/October
Your ASP.NET MVC application needs reports. What do you do? In this article, I will demonstrate how simple it is to weave SQL Server Reporting Services (SSRS) into your ASP.NET MVC Applications.Your ASP.NET MVC application needs reports. What do you do? In this article, I will demonstrate how simple it is to weave SQL Server Reporting Services (SSRS) into your ASP.NET MVC Applications.Your ASP.NET MVC application needs reports. What do you do? In this article, I will demonstrate how simple it is to weave SQL Server Reporting Services (SSRS) into your ASP.NET MVC Applications.Your ASP.NET MVC application needs reports. What do you do? In this article, I will demonstrate how simple it is to weave SQL Server Reporting Services (SSRS) into your ASP.NET MVC Applications.
-
The Baker’s Dozen: 13 More Examples of Functionality in SQL Server 2008 Integration Services
By:
Last updated: Tuesday, February 19, 2019
Published in: CODE Magazine: 2010 - September/October
In the last Baker’s Dozen article, I demonstrated 13 SSIS packages to show what Integration Services can do. This article picks up where the last one left off. I’ll show some capabilities in SSIS, such as handling irregular input files, extracting database changes, implementing package configurations, and leveraging the advanced lookup features in SSIS 2008.
-
The Baker’s Dozen: 13 Examples of Functionality in SQL Server 2008 Integration Services
By:
Last updated: Tuesday, February 19, 2019
Published in: CODE Magazine: 2010 - July/August
A skilled database developer might find it difficult to accept that other tools can increase productivity. When Microsoft released SQL Server 2005 Integration Services (SSIS 2005), I did not think that any tool could possibly make me more productive than the C# and T-SQL code I was writing by hand. After some reconsideration (and subtle persuasion from peers), I discovered that SSIS 2005 contained many features that indeed reduced my development time - WITHOUT sacrificing flexibility. Microsoft added new functionality in SSIS 2008 to make a strong product even better. In this article, I’ll present 13 different examples that demonstrate the power of Integration Services.
-
Developing Database Agnostic Applications with Entity Framework
Last updated: Wednesday, August 31, 2022
Published in: CODE Magazine: 2010 - March/April
Microsoft released Entity Framework, an ORM (Object Relational Mapping) tool, in 2008.Entity Framework gives developers the ability to be abstracted from the underlying relational database management system and allows them to talk to a database using familiar LINQ-based syntax.
-
Handling Business-Related Date Tasks in T-SQL
By:
Last updated: Wednesday, August 31, 2022
Published in: CODE Magazine: 2010 - March/April
How many times have you found yourself in need of knowing what the next or previous business date is?What about the dates when a particular quarter begins and ends? Have you had to handle the thorny issue of daylight savings time (DST); when does DST begin and end for this or another year in the US, UK or some other region? And finally, once you have determined you have a need to calculate these various date values, where do you host that logic? This article answers those questions.
-
Using the Amazon Web Service SDK for .NET
By:
Last updated: Wednesday, August 31, 2022
Published in: CODE Magazine: 2010 - March/April
The richest set of cloud computing services comes from a little e-commerce company known as Amazon.com. Developers can access the Amazon Web Services (AWS) platform using numerous tools including the .NET platform.Amazon.com is a major player in the cloud computing space and has numerous services available to developers. In late 2009, Amazon released the AWS SDK for .NET. This article will demonstrate using the AWS SDK to create a custom backup service using the Amazon Simple Storage Service (S3).
-
SQL Server 2008: Two Winning Features
By:
Talmage, Ron
Last updated: Friday, February 22, 2019
Published in: CODE Magazine: 2009 - September/October
SQL Server 2008 has been out for more than a year, and perhaps an overview and assessment is due. From a database administrator’s point of view, what features are standing the test of time?
-
SQL Server Reporting Services Hits its Stride
By:
Litwin, Paul
Last updated: Wednesday, August 31, 2022
Published in: CODE Magazine: 2009 - September/October
We’ve all heard that version 3 of a Microsoft product is when that product really hits its stride.And while I’m not sure of the truth of that software urban legend, I do have to say that Microsoft, with the release of SQL Server 2008 Reporting Services (which happens to be its 3rd major version), has released a gem of a reporting solution that is sure to please users of prior versions and bring more converts into the Reporting Services fold. The newest version of SQL Server Reporting Services is faster, can handle larger reports, supports a wider variety of browsers, and is more flexible thanks to the new Tablix data region, support for rich text content, and Microsoft Word as an output format.
-
The Baker’s Dozen: 13 Miscellaneous C#, SQL, and Business Intelligence Development Tips
By:
Last updated: Wednesday, August 31, 2022
Published in: CODE Magazine: 2009 - January/February
No, the title isn’t a misprint-this installment of the Baker’s Dozen will visit both sides of the planet. These days, many .NET user group meetings focus on database and business intelligence topics as well as hardcore .NET content. Over the last several months, I’ve spent roughly half my time modifying my own development framework for WCF. The result is some basic but functional factory classes I’d like to share. The other half of the time, I’ve been looking at different capabilities in the SQL Server 2005 and 2008 Business Intelligence stack, and solving requirements that BI developers often face. So rather than pick one side and make the other side wait two months, I decided to combine the two.
-
Ask the Doc Detective
By:
Doc Detective
Last updated: Wednesday, February 20, 2019
Published in: CODE Magazine: 2008 - November/December
Nov/Dec 08 Doc Detective column
-
The Baker’s Dozen: 13 Tips for SQL Server 2008 and SSRS 2008
By:
Last updated: Wednesday, August 31, 2022
Published in: CODE Magazine: 2008 - July/August
A major software release either contains a substantial number of enhancements, or a small number of substantial enhancements.The last two releases of SQL Server remind me of the two types of Christmas: SQL 2005 was like receiving a large number of presents, and SQL Server 2008 is like receiving a smaller number of big gifts. Those of you who asked Santa for the ability to INSERT/UPDATE/DELETE in one SQL statement, or to specify multiple GROUP BY statements in a single SQL query, you will be very happy. If you wanted a hierarchical data type, you will be ecstatic. SQL Server 2008 also includes a new and completely re-written version of SQL Server Reporting Services (SSRS)-complete with a new interface, new charting features, and (get ready to applaud) no more reliance on Internet Information Services (IIS). So while the temperatures are getting warmer, it’s Christmas Day here at the Baker’s Dozen, and we’re about to unwrap thirteen major SQL Server/SSRS 2008 gifts from Microsoft.
-
Introducing the Microsoft Sync Framework: Next Generation Synchronization Framework
By:
Khosravy, Moe
Last updated: Tuesday, February 19, 2019
Published in: CODE Focus Magazine: 2007 - Vol. 4 - Issue 3 - Data Programability
The Microsoft® Sync Framework is the new framework and runtime for adding synchronization, roaming, and offline capabilities to applications. It supports peer-to-peer scenarios, works with devices and services, and is agnostic of data types, stores, and protocols. In this article, I’ll cover the high-level vision for the platform as well as the enabled scenarios made possible by the framework for developers, ISVs, and OEMs.
-
LINQ to Relational Data: Who’s Who?
By:
Flasko, Elisa
Last updated: Tuesday, February 19, 2019
Published in: CODE Focus Magazine: 2007 - Vol. 4 - Issue 3 - Data Programability
With the combined launch of Visual Studio 2008, SQL Server 2008, and Windows Server 2008, Microsoft is introducing five implementations of .NET Language Integrated Query (LINQ).Of these five implementations, two specifically target access to relational databases: LINQ to SQL and LINQ to Entities.
-
Programming SQL Server 2008
Last updated: Wednesday, February 20, 2019
Published in: CODE Focus Magazine: 2007 - Vol. 4 - Issue 3 - Data Programability
SQL Server Katmai, now officially announced as SQL Server 2008, introduces a significant amount of new and improved functionality, including enhanced data types and greater programming flexibility for database application developers.
-
The Data Dude Meets Team Build
By:
Drapers, Gert
Last updated: Wednesday, February 20, 2019
Published in: CODE Focus Magazine: 2007 - Vol. 4 - Issue 3 - Data Programability
“Integrate the data tier developer in to the core development life cycle and process.”That is one of the main objectives of Visual Studio Team Edition for Database Professionals, also known under its project name “Data Dude”. Bringing the data tier developer into Visual Studio is the first step in enabling closer integration between the application and data tier developer. Having both environments leverage the same Team Foundation Build (Team Build) system enables daily and automatic integration of changes into the build process, enforcing closer integration and shorter feedback cycles between the two originally disjoint disciplines.
-
Use SQL CLR 2.0-Advancing CLR Integration in SQL Server 2008
By:
Blakeley, José,
Kleinerman, Christian
Last updated: Tuesday, February 19, 2019
Published in: CODE Focus Magazine: 2007 - Vol. 4 - Issue 3 - Data Programability
The integration of the .NET Common Language Runtime (CLR) inside SQL Server 2005 (SQL CLR 1.0) enabled database programmers to write business logic in the form of functions, stored procedures, triggers, data types, and aggregates using modern .NET programming languages.This article presents the advances to the CLR integration introduced in SQL Server 2008, which significantly enhances the kinds of applications supported by SQL Server.
-
What’s New in SQL Server 2008?
Last updated: Tuesday, February 19, 2019
Published in: CODE Focus Magazine: 2007 - Vol. 4 - Issue 3 - Data Programability
SQL Server 2008 is scheduled for release in 2008 and promises to deliver an array of new and exciting benefits to both developers and IT Pros alike.
-
The Baker’s Dozen: A 13-Step Crash Course for Using LINQ
By:
Last updated: Wednesday, August 31, 2022
Published in: CODE Magazine: 2007 - July/August
How many software tasks DON’T involve reading through data? Answer: very few. Developers work all the time with database data, XML data, DataSets, collections, lists, and arrays-all with different syntax and functionality for each one. Developers who write T-SQL code often covet set-based language statements when they work against other types of data. Additionally, developers who have coded against strongly-typed custom collections wish they could write SQL database queries with IntelliSense. Language Integrated Query (LINQ), a set of extensions to the .NET Framework for the next version of Visual Studio codename “Orcas”, brings the promise of integrated and uniform query capabilities to increase developer productivity when working with different types of data. While LINQ is a large topic worthy of books, this edition of The Baker’s Dozen will provide a crash course to learn what’s under the LINQ hood.
- Home
Articles filed in category 'SQL Server 2008'