Articles filed in category 'SQL Server':
-
A SQL Programming Puzzle: You Never Stop Learning
Kevin learns the hard way how to estimate a process’ duration and he uses a clever bit of code to figure it out.
http://codemag.com/article/1801051/A-SQL-Programming-Puzzle-You-Never-Stop-Learning
-
ADO.NET Best Practices - Part II
ADO.NET has a strong and powerful disconnected model.It allows programmers to build a web of in-memory objects and relate contents coming from different tables and even from different data sources. When inter-related tables are involved with the proc...
http://codemag.com/article/0401061/ADO.NET-Best-Practices---Part-II
-
Ask the Doc Detective
Nov/Dec 08 Doc Detective column
-
Azure Skyline: Azure’s SQL Database—SQL Server in the Cloud
Mike explores Azure SQL Database and what it has the potential to do for large and small businesses.
http://codemag.com/article/1603071/Azure-Skyline-Azure’s-SQL-Database—SQL-Server-in-the-Cloud
-
Baker's Dozen--Business Intelligence Developers
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.
http://codemag.com/article/1403031/Baker's-Dozen--Business-Intelligence-Developers
-
Better Extract/Transform/Load (ETL) Practices in Data Warehousing (Continued)
Kevin shows us how to solve tangles in SQL Server, and in this article, he looks at some questions that have come up since his last article on ETL practices in Data Warehousing.
-
Building a CODE Framework Service and Consuming It on an iPhone Application
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 ...
-
Building a Stored Procedure Generator
Creating basic data access stored procedures is time consuming and boring work. Relieve the tedium by writing code that writes these stored procedures for you.
http://codemag.com/article/0509041/Building-a-Stored-Procedure-Generator
-
Building Data Access Components in C#
With the functionality provided by the .NET runtime, building data access components with C# (pronounced "c-sharp") is not difficult.In this article, we discuss how to access data stored in a SQL Server database. We will then review the steps necess...
http://codemag.com/article/0101021/Building-Data-Access-Components-in-C#
-
Building WCF Services for Deployment in Transiently Connected Networks
Distributed applications are now prolific in the enterprise and more and more users are relying on network connectivity both on site and on the go so they can remain productive anywhere and at any time. Since network connectivity cannot always be gua...
-
C# 3.0 Syntax Additions-Design Guidelines
C# 3.0 includes a few syntactical additions to the language. For the most part, Microsoft added these language additions to support Language Integrated Query (LINQ). These features include (but are not limited to) lambda expressions, extensions metho...
http://codemag.com/article/0801061/C#-3.0-Syntax-Additions-Design-Guidelines
-
Caching with SQL Server Compact and the Microsoft Sync Framework for ADO.NET
With Sync Services for ADO.NET, developers can easily optimize their online experience by caching data locally within the easy-to-deploy SQL Server Compact embedded database engine.In this article I’ll cover how Sync Services for ADO.NET was designed...
-
Chapter 3: Enterprise Data Management
SQL Server2005 Distilled Need to get your arms around Microsoft SQL Server 2005 fast, without getting buried in the details? Need to make fundamental decisions about deploying, using, or administering Microsoft’s latest enterprise database? Need...
http://codemag.com/article/070043/Chapter-3-Enterprise-Data-Management
-
Creating Custom Data Extensions for SQL Server 2000 Reporting Services
In early 2004, Microsoft released a new set of extensions to SQL Server 2000 called SQL Server 2000 Reporting Services.SQL Server Reporting Services provides a comprehensive platform for creating, managing, securing, scheduling, and outputting data f...
-
Creating User-Defined Data Types in Yukon
The next version of SQL Server (code name Yukon) has extensive support of the Common Language Runtime (CLR).Previous versions of SQL Server (2000 and earlier) had a mechanism for creating custom data types. These data types were nothing more than ali...
http://codemag.com/article/0303052/Creating-User-Defined-Data-Types-in-Yukon
-
Data Access Options in Visual Studio 2008
With Visual Studio 2008 and .NET 3.5, developer’s data access options have increased substantially. In addition to using ADO.NET to create DataReaders or DataSets, Microsoft has added LINQ to SQL and Entity Framework as well as ADO.NET Data Services,...
http://codemag.com/article/0809091/Data-Access-Options-in-Visual-Studio-2008
-
Designing for Database Movability
Eventually SQL Server databases in a production environment must move from one server to another. It’s important to plan for eventual database moves when architecting a database solution.Designers and developers often overlook the eventuality that a ...
http://codemag.com/article/070023/Designing-for-Database-Movability
-
Developing Database Agnostic Applications with Entity Framework
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...
http://codemag.com/article/1003101/Developing-Database-Agnostic-Applications-with-Entity-Framework
-
Enterprise Reporting with Excel
When it comes to analysis and reporting, managers love Excel. Just give them the raw data and they have a field day. For enterprise-level reporting, however, you want everybody to have the same data and the same interpretation of that data. With some...
http://codemag.com/article/0701051/Enterprise-Reporting-with-Excel
-
Great Reasons to Ring In 2005!
Wow, another year has gone by, and as you read this, you are probably returning to the office after a few more or less relaxing holiday time spent with friends and family and a New Year's celebration. Interesting things have happened in our industry ...
http://codemag.com/article/050013/Great-Reasons-to-Ring-In-2005!
-
Handling Business-Related Date Tasks in T-SQL
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...
http://codemag.com/article/1003081/Handling-Business-Related-Date-Tasks-in-T-SQL
-
Handling SQL Server Errors in Nested Procedures
Basic error handling in SQL Server's programming language, Transact-SQL, is straightforward.But when you nest calls to stored procedures, and the procedures have SQL transactions, error handling becomes much more complex. In this article I'll show yo...
http://codemag.com/article/0305111/Handling-SQL-Server-Errors-in-Nested-Procedures
-
Heard on .NET Rocks! Andy Leonard on Unit Testing Your Database
May/June 2008 .NET Rocks! column
http://codemag.com/article/0805111/Heard-on-.NET-Rocks!--Andy-Leonard-on-Unit-Testing-Your-Database
-
Heard on .NET Rocks!: Kimberly Tripp on SQL Server 2005 SP1 and More
Heard on .NET Rocks!: Kimberly Tripp on SQL Server 2005 SP1 and More
-
Heard on .NET Rocks!: Paul Randal on SQL Server 2005 Performance and Recovery
May/June .Net Rocks Column
-
How Developers Can Avoid Transact-SQL Cursors
Ron Talmage discusses how developers can avaiod Transact-SQL Cursors
http://codemag.com/article/060113/How-Developers-Can-Avoid-Transact-SQL-Cursors
-
Ink And The Database
Unless your battery is really, really good, you’ll eventually want to store your Ink.In some situations, simple file storage or XML serialization is sufficient for your needs, but in the majority of business applications, you’ll want to move Ink into...
-
Integrating .NET Code and SQL Server Reporting Services
SQL Server Reporting Services versions 2000 and 2005 (SSRS) has many powerful features. SSRS has a well-designed data access engine, a great set of layout tools, and an excellent expression system for creating complex formulas. While the expression s...
http://codemag.com/article/0701061/Integrating-.NET-Code-and-SQL-Server-Reporting-Services
-
Introducing ADO.NET Entity Framework
The challenge of bringing data from efficient storage engines such as SQL Server into object-oriented programming models is hardly a new one. Most developers address this challenge by writing complex data access code to move data between their applic...
http://codemag.com/article/0711051/Introducing-ADO.NET-Entity-Framework
-
Introducing the Microsoft Sync Framework: Next Generation Synchronization Framework
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, ...
-
It All Adds Up
Tom’s having a lot of fun playing with SQL Server 2005’s T-SQL enhancements.In this article he combines a bunch of them in concert to solve an interesting problem.
-
LINQ to Relational Data: Who’s Who?
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 relation...
http://codemag.com/article/0712062/LINQ-to-Relational-Data-Who’s-Who
-
Making Sense of the XML DataType in SQL Server 2005
As database developers, many of us have had to dip our feet into the wide ocean of XML.It should come as good news that in SQL Server 2005, you can store XML in the database with a new XML datatype. Although this is good news, many developers have be...
http://codemag.com/article/0605081/Making-Sense-of-the-XML-DataType-in-SQL-Server-2005
-
Methods for Moving a Database
Moving a SQL Server database from one server to another is simple-initially. But there are various methods for moving a database, and some have more advantages than others. Investigating the types of moves ahead of time can make planning for a databa...
http://codemag.com/article/070113/Methods-for-Moving-a-Database
-
Microsoft Exception Management Application Blocks
A new feature of .NET is its ability to handle exceptions. This article demonstrates implementing Microsoft's Exception Management Application Blocks.
http://codemag.com/article/0211131/Microsoft-Exception-Management-Application-Blocks
-
Moving a Database: Dependencies
xIn the past two installments of this series I’ve discussed two key aspects of moving a SQL Server database from one server (or instance) to another. First I covered the advantages of designing databases to make them easier to move, and then I looke...
http://codemag.com/article/070133/Moving-a-Database-Dependencies
-
N-Tier Application Design
As applications become more complex, designing with components becomes a very important factor in the successful completion of projects.This article discusses n-tier application design, why it's important to modern application development, and shows ...
http://codemag.com/article/0002101/N-Tier-Application-Design
-
ODBC Rocks!
Fifteen years after its launch, ODBC is a firmly entrenched cornerstone of the software industry. This article explains why and will explore the relationship between Microsoft SQL Server and ODBC and discuss where ODBC may go in the future.
-
Passing Data Over .NET Web Services
Web Services is a powerful technology, even in its basic form.However, with .NET, you can easily couple Web Services with .NET's new data services to provide a powerful data delivery mechanism that works over the Web, making it possible to build dist...
http://codemag.com/article/0201041/Passing-Data-Over-.NET-Web-Services
-
Performance Counters on the 64-bit Road Less Travelled
Ron Talmage discusses performance counters in SQL Server.
http://codemag.com/article/080015/Performance-Counters-on-the-64-bit-Road-Less-Travelled
-
Post Mortem: Tower48 Software Escrow
http://codemag.com/article/0909041/Post-Mortem-Tower48-Software-Escrow
-
Processing Large Datasets Using C# and SQL Server Table Data Types
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.
-
Programming SQL Server 2008
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.
http://codemag.com/article/0712122/Programming-SQL-Server-2008
-
Query XML from SQL Server 2000
XML is quickly becoming the preferred method of passing information, not only for the Internet, but also across applications and within applications.Until now, developers have been forced to create our own routines to convert data stored in a databas...
http://codemag.com/article/0003091/Query-XML-from-SQL-Server-2000
-
Resolving Deadlocks in SQL Server 2000
Your application can detect a deadlock and resubmit its transaction, but a better approach is to resolve a deadlock by changing the conditions that lead to it in the first place. In this article, you'll learn how SQL Server deadlocks arise, what type...
http://codemag.com/article/0309101/Resolving-Deadlocks-in-SQL-Server-2000
-
Scaling Out Database Writes
Ron Talmage discusses scaling out database writes.
http://codemag.com/article/060093/Scaling-Out-Database-Writes
-
Scripting SQL Server 2000 Indexes
Adding indexes to tables is the most effective way to optimize your SQL Server query performance. Tables that you query often may require several indexes in order to handle the various search arguments you send. There is one particular situation wher...
http://codemag.com/article/0301101/Scripting-SQL-Server-2000-Indexes
-
Securing Your SQL Server
SQL Server, like most complex databases, has potential security holes. This article discusses these security holes and how to close them.
-
Security in the CLR World Inside SQL Server
One of the major benefits of writing .NET code to run in the Common Language Runtime (CLR) hosted in any environment is code access security (CAS).CAS provides a code-based-rather than user-based-authorization scheme to prevent various kinds of lurin...
http://codemag.com/article/0603031/Security-in-the-CLR-World-Inside-SQL-Server
-
Snapshot Isolation in SQL Server 2005 "Yukon"
Snapshot isolation is a new isolation level that reduces blocking reads and allows transactions to read previously committed versions of data, instead of uncommitted data.SQL Server's default isolation level of READ COMMITTED restricts transactions t...
http://codemag.com/article/0407071/Snapshot-Isolation-in-SQL-Server-2005-"Yukon"
-
SNAPSHOT Isolation in SQL Server 2005, Part II
In addition to the transaction-based SNAPSHOT isolation level, SQL Server 2005 Beta 2 also introduces a statement-level variation of the READ COMMITTED isolation level called READ_COMMITTED_SNAPSHOT.Part I of this article (see "Snapshot Isolation in ...
http://codemag.com/article/0501061/SNAPSHOT-Isolation-in-SQL-Server-2005-Part-II
-
SQL Server 2000 Replication 101: Replication Agents
Replication agents are the basic components of SQL Server 2000 replication.Before you settle on the type of replication you want in your application architecture, it is important to understand how each type of replication works and what agents they u...
http://codemag.com/article/0405081/SQL-Server-2000-Replication-101-Replication-Agents
-
SQL Server 2000 Replication 101: Terminology, Types, and Configuration
Replication figures as one of the more prominent features of SQL Server 2000.Replication is a complex application that uses a combination of stored procedures and executables to distribute and copy data between SQL Server databases. If you take care ...
-
SQL Server 2005 Query Notifications Tell .NET 2.0 Apps When Critical Data Changes
One of the classic problems with database applications is refreshing stale data. Imagine a typical e-commerce site with products and categories. A vendor’s product list most likely does not change very often and their category list changes even less ...
-
SQL Server 2005 Secures Your Data Like Never Before
If you care about your data, you must upgrade to SQL Server 2005 the day it is released. There simply is no other option.An outrageous assertion? Perhaps. I tend to split my time equally between praising and bashing Microsoft, but the new security fe...
http://codemag.com/article/0509021/SQL-Server-2005-Secures-Your-Data-Like-Never-Before
-
SQL Server 2005 T-SQL Enhancements
SQL Server 2005 or "Yukon" is going to be a major SQL Server update containing updates to nearly every facet of the program, including T-SQL.In this article I am going to explore some of the new T-SQL features, commands, and capabilities in SQL Serve...
http://codemag.com/article/0501041/SQL-Server-2005-T-SQL-Enhancements
-
SQL Server 2005: Scaling Up and Out
Ron Talmage discusses SQL Server 2005 in this introductory SQL Server Observer Newsletter
http://codemag.com/article/060063/SQL-Server-2005--Scaling-Up-and-Out
-
SQL Server 2008 Under the Hood: Compression Technologies
http://codemag.com/article/080103/SQL-Server-2008-Under-the-Hood-Compression-Technologies
-
SQL Server 2008: Two Winning Features
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?
http://codemag.com/article/0909051/SQL-Server-2008-Two-Winning-Features
-
SQL Server Database Mirroring Roles: Instance versus Database
Ron Talmage discusses the roles of SQL Server databases and instances in high availability scenarios.
http://codemag.com/article/080083/SQL-Server-Database-Mirroring-Roles-Instance-versus-Database
-
SQL Server Reporting Services Hits its Stride
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 Servic...
http://codemag.com/article/0909071/SQL-Server-Reporting-Services-Hits-its-Stride
-
SQL Server Reporting Services: Eight Power Tips
Kevin looks at his favorite reporting tool (SSRS) and shows you how to maximize your users’ experience.
http://codemag.com/article/1711061/SQL-Server-Reporting-Services-Eight-Power-Tips
-
SQL Server Reporting Services: Eight Power Tips
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.
http://codemag.com/article/1605111/SQL-Server-Reporting-Services-Eight-Power-Tips
-
SQL Server Reporting Services: Seven Power Tips
You already know that SQL Server’s Reporting Services tools are useful. Kevin shows you some nifty work-arounds and extra-credit tricks that will make your reports sing.
http://codemag.com/article/1705061/SQL-Server-Reporting-Services-Seven-Power-Tips
-
SQLCLR Security and Designing for Reuse
An important principal of software design is that of “least privilege.”Basically, in any given layer of a program, you should only grant minimal access such that the code has rights to only exactly the resources it needs to get its job done-and nothi...
http://codemag.com/article/0705051/SQLCLR-Security-and-Designing-for-Reuse
-
Stages of Data #1: A New Beginning
Kevin leaves his SQL Server-focused Baker’s Dozen behind and launches into a new series looking at the various stages of data warehousing. His first installment includes a look at reporting and storage layers, handy tips, and dealing with the business side of development.
http://codemag.com/article/1811051/Stages-of-Data-#1-A-New-Beginning
-
Testing SQL Server 2000: Inspecting Configuration Information
Testing SQL Server is an often-overlooked area of the software development process, because programmers primarily place testing focus on code residing in the middle tier or the client desktop, rather than the database. However, as SQL Server database...
http://codemag.com/article/0203051/Testing-SQL-Server-2000-Inspecting-Configuration-Information
-
Testing SQL Server 2000: Testing Database Options
Testing SQL Server 2000 applications begins with making sure your production server is configured properly.You generally do this by verifying that the server's settings match a properly configured target computer. After configuring your server, you c...
http://codemag.com/article/0207081/Testing-SQL-Server-2000-Testing-Database-Options
-
The Baker’s Dozen Doubleheader: 26 New Features in SQL Server 2012 (Part 1 of 2)
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,...
-
The Baker’s Dozen Doubleheader: 26 Productivity Tips for Managing Data (Part 2 of 2)
In the conclusion of this two-part series on managing data, I will focus on .NET generics, the ASP.NET 2.0 ObjectDataSource, and some more T-SQL 2005 capabilities. Regardless of whether you work in C# or VB.NET, or whether you spend more time on the ...
-
The Baker’s Dozen Doubleheader: 26 Productivity Tips for Optimizing SQL Server Queries (Part 2 of 2)
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 compar...
-
The Baker’s Dozen: 13 Tips for Building Database Web Applications Using ASP.NET 3.5, LINQ, and SQL Server 2005 Reporting Services
Are you moving a Windows desktop application to the browser, and sweating bullets, or perhaps just not quite sure about how all the new Web and data tools work together?With each passing year, Microsoft offers newer and more powerful tools for buildi...
-
The Baker’s Dozen: 13 Tips for Querying OLAP Databases with MDX
MDX is just like Transact-SQL, right? MDX is English-like and therefore easy to learn, right? Different software tools offer MDX generators and therefore I don’t need to learn MDX, right? MDX isn’t that popular, right?Well, just like the punch-line o...
http://codemag.com/article/0801051/The-Baker’s-Dozen--13-Tips-for-Querying-OLAP-Databases-with-MDX
-
The Baker’s Dozen: 13 Tips for SQL Server 2008 and SSRS 2008
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 pr...
http://codemag.com/article/0807041/The-Baker’s-Dozen--13-Tips-for-SQL-Server-2008-and-SSRS-2008
-
The Baker’s Dozen: 13 Examples of Functionality in SQL Server 2008 Integration Services
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 ...
-
The Baker’s Dozen: 13 Examples Using XMLA to Update Analytic Databases
Database developers who learn Microsoft SQL Server Analysis Services (SSAS) know that they face a number of learning curves. In prior Baker’s Dozen articles, I’ve covered many of the steps for creating both SSAS OLAP and SSAS Tabular databases. In th...
-
The Baker’s Dozen: 13 Great Things to Know About SQL Server 2016
All eyes were on Microsoft when the latest version of SQL Server came out a couple of months ago. If you want to know what’s so great about it, you need to read Kevin’s handy summary.
http://codemag.com/article/1609061/The-Baker’s-Dozen-13-Great-Things-to-Know-About-SQL-Server-2016
-
The Baker’s Dozen: 13 Miscellaneous C#, SQL, and Business Intelligence Development Tips
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 sev...
-
The Baker’s Dozen: 13 Miscellaneous SQL Server Tips
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 d...
http://codemag.com/article/1201071/The-Baker’s-Dozen-13-Miscellaneous-SQL-Server-Tips
-
The Baker’s Dozen: 13 Miscellaneous Transact-SQL Tips
Whether you’re new to T-SQL or not, you’re sure to find something interesting among Kevin’s tips for using it, no matter which version of SQL Server you’re using.
http://codemag.com/article/1509081/The-Baker’s-Dozen-13-Miscellaneous-Transact-SQL-Tips
-
The Baker’s Dozen: 13 Productivity Tips for Transact-SQL 2005
Thinking of upgrading to SQL Server 2005? Or are you using SQL 2005 already and you want to learn more about the language features? Then this article may be for you!Microsoft implemented many new features in SQL Server 2005, including an impressive s...
http://codemag.com/article/0709031/The-Baker’s-Dozen-13-Productivity-Tips-for-Transact-SQL-2005
-
The Baker’s Dozen: 13- SQL Server Interview Questions
Kevin uses his experience on both sides of the interview table to help you wow at your next interview. Not only that, but you’ll probably pick up a few pointers, too!
http://codemag.com/article/1601051/The-Baker’s-Dozen-13--SQL-Server-Interview-Questions
-
The Baker’s Dozen: 13 Steps for Building a Lookup Page Using ASP.NET 2.0, SQL 2005, and C# 2.0
Lookup and navigation screens initially seem like no-brainers, when compared to other parts of an application-yet by the time a developer has met all the user requirements and requests, he/she has expended much more time than expected. This issue of ...
-
The Baker’s Dozen: 13 Steps for Building a SQL Server Analysis Services 2012 Tabular Model
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 remai...
-
The Baker’s Dozen: 13 Tips for Basics of Data Warehousing and Dimensional Modeling
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 vie...
-
The Baker’s Dozen: 13 Tips for Better Extract/Transform/Load (ETL) Practices in Data Warehousing (Part 1 of 2)
In this first installment of his ETL articles, Kevin shows you what to do—and even what not to do—when designing your Data Warehouse.
-
The Baker’s Dozen: 13 Tips for Building Dashboards with Microsoft BI Tools
Scorecards, test results, report cards, summaries-nearly everyone wants to skip past the details and see the bottom line. Whether it is “pass or fail”, “go or no go”, managers evaluate professional efforts based on performance. Microsoft’s Business I...
-
The Baker’s Dozen: 13 Transact SQL Programming Tips
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 ins...
http://codemag.com/article/1112061/The-Baker’s-Dozen-13-Transact-SQL-Programming-Tips
-
The Baker’s Dozen: 26 Productivity Tips for Optimizing SQL Server Queries (Part 1 of 2)
There’s an old programmer adage: “First you make it work, then you make it work fast.” Well, when writing T-SQL queries, you can do both, if you have some knowledge about how the SQL Server optimizer works. This will be a two-part article. In part on...
-
The Baker’s Dozen: A 13-Question Pop Quiz of SQL Server Items
If you’ve ever wondered how your SQL Server knowledge stacked up, you’ll want to take Kevin’s unofficial test. He explains both the right and wrong answers, so no matter what your skills are, you’re bound to learn something new.
http://codemag.com/article/1511061/The-Baker’s-Dozen-A-13-Question-Pop-Quiz-of-SQL-Server-Items
-
The Baker's Dozen: 13 Productivity Tips for Database Development Using Transact-SQL
Many application developers face the challenges of working with SQL Server 2000.These challenges include retrieving and grouping large amounts of data, building result sets, and tracking changes to data. All require professional strategies that hold ...
-
The Data Dude Meets Team Build
“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 d...
http://codemag.com/article/0712152/The-Data-Dude-Meets-Team-Build
-
The Provider Model
In this article you will learn how to isolate yourself from change by taking advantage of the Provider Model.Designing your applications using the Provider Model will allow you to swap components out at runtime, thus allowing you to upgrade them easily.
-
The x64 Path Less Travelled
Ron Talmage discusses 32-bit vs. 64-bit version of SQL Server 2005
http://codemag.com/article/070193/The-x64-Path-Less-Travelled
-
Two Dozen of My Favorite System Stored Procedures
SQL Server 2000 is packed full of useful system stored procedures there for its own use that you can use as well.This article will explore a couple dozen of the most useful hidden gems you can use to more easily manage your databases, improve the app...
http://codemag.com/article/0505041/Two-Dozen-of-My-Favorite-System-Stored-Procedures
-
Using Configurations to Manage SQL Server Extended Properties
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.
http://codemag.com/article/1105061/Using-Configurations-to-Manage-SQL-Server-Extended-Properties
-
Using Stored Procedures in Conjunction with the SqlDataAdapter
A well-designed application that uses a relational database management system in the backend should make extensive use of stored procedures.A stored procedure is a named collection of SQL statements that you store in a database. To the client, a stor...
http://codemag.com/article/0303141/Using-Stored-Procedures-in-Conjunction-with-the-SqlDataAdapter
-
Using the Amazon Web Service SDK for .NET
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 ...
http://codemag.com/article/1003071/Using-the-Amazon-Web-Service-SDK-for-.NET
-
What’s New in Entity Framework 4, Part 2: Modeling Changes
If you have been working with the ADO.NET Entity Framework, you have probably been extremely eager to get your hands on the next version that is now part of Visual Studio 2010 and .NET 4.0. Long referred to as “EF Version 2,” this version is now call...
http://codemag.com/article/0911121/What’s-New-in-Entity-Framework-4-Part-2-Modeling-Changes
-
What’s New in Entity Framework 4? Part 1: API Changes
If you have been working with the ADO.NET Entity Framework, you have probably been extremely eager to get your hands on the next version that is now part of Visual Studio 2010 and .NET 4.0. Long referred to as “EF Version 2,” this version is now call...
http://codemag.com/article/0909081/What’s-New-in-Entity-Framework-4-Part-1-API-Changes
-
XML to Database using .NET's XmlTextReader
As XML becomes more and more prolific in the world of data exchange it's increasingly important that data can be quickly and easily extracted from XML documents and moved into more permanent data stores.Although .NET offers several different ways for...
http://codemag.com/article/0201031/XML-to-Database-using-.NET's-XmlTextReader
-
XML UpdateGrams in SQL Server
The new XML features in SQL Server 2000 give the developer more power to implement distributed solutions.One of the newest features, XML UpdateGrams, allows the developer to handle the inserting, updating and deleting of records while getting around ...
http://codemag.com/article/0201091/XML-UpdateGrams-in-SQL-Server
-
XPath Queries in SQL Server 2000
Imagine the potential of accessing your database without needing to know any specifics about how that data is stored.Imagine the possibility of allowing your DBA the freedom to change the database structure without affecting your software code. Impos...
http://codemag.com/article/0101031/XPath-Queries-in-SQL-Server-2000