-
Calling Stored Procedures with the Entity Framework in .NET 5
By:
Paul Sheriff
Last updated: Wednesday, August 31, 2022
Published in: CODE Magazine: 2021 - January/February
Paul shows you how to avoid the frustration of having to determine a stored procedure’s function before you call it by using Entity Framework in .NET 5. Learn how to make calls to stored procedures using Entity Framework in .NET 5.x.
-
A SQL Programming Puzzle: You Never Stop Learning
By:
Kevin Goff
Last updated: Thursday, May 6, 2021
Published in: CODE Magazine: 2018 - January/February
Kevin learns the hard way how to estimate a process’ duration and he uses a clever bit of code to figure it out.
-
The Baker’s Dozen: 13 Tips for Better Extract/Transform/Load (ETL) Practices in Data Warehousing (Part 1 of 2)
By:
Last updated: Wednesday, May 12, 2021
Published in: CODE Magazine: 2017 - September/October
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.
-
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:
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.
-
The Baker’s Dozen: 13- SQL Server Interview Questions
By:
Last updated: Friday, June 25, 2021
Published in: CODE Magazine: 2016 - January/February
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!
-
The Baker’s Dozen: A 13-Question Pop Quiz of SQL Server Items
By:
Last updated: Tuesday, June 29, 2021
Published in: CODE Magazine: 2015 - November/December
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.
-
The Baker’s Dozen State of the Union: 13 Points on SQL Server Data Warehousing and Business Intelligence
By:
Last updated: Thursday, July 15, 2021
Published in: CODE Magazine: 2015 - May/June
Kevin takes a look at SQL Server “then and now,” and shows us just how important it is to understand the various tools involved in BI.
-
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 Examples Using XMLA to Update Analytic Databases
By:
Last updated: Tuesday, April 26, 2022
Published in: CODE Magazine: 2013 - September/October
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 this article, I’m going to cover another topic: How to add or change data in analytic databases.
-
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.
-
The Absolute Beginner’s Guide to Windows Azure SQL Database
By:
Last updated: Tuesday, February 19, 2019
Published in: CODE Magazine: 2013 - May/June
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
By:
Last updated: Wednesday, June 8, 2022
Published in: CODE Magazine: 2013 - March/April
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
By:
Last updated: Thursday, November 30, 2023
Published in: CODE Magazine: 2013 - January/February
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)
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 Doubleheader: 26 new Features in SQL Server Integration Services 2012 (Part 2 of 2)
By:
Last updated: Wednesday, August 31, 2022
Published in: CODE Magazine: 2012 - May/June
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)
By:
Last updated: Tuesday, February 19, 2019
Published in: CODE Magazine: 2012 - March/April
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.
-
Microsoft SQL Server 2012 Management and Administration, 2nd Edition, Chapter 2 - Administering Storage, I/O, and Partitioning in Microsoft SQL Server 2012
Last updated: Tuesday, February 19, 2019
Published in: Book Excerpts
By Ross Mistry, Shirmattie Seenarine, Published Sep 18, 2012 by Sams. Copyright 2013, Dimensions: 5-3/8" x 8-1/4", ISBN-10: 0-672-33600-6, ISBN-13: 978-0-672-33600-3. Sample Chapter is provided courtesy of Sams Publishing. Click here to purchase book. http://www.informit.com/store/microsoft-sql-server-2012-management-and-administration-9780672336003
-
Microsoft® SQL Server® 2012 Step by Step - Chapter 1
Last updated: Wednesday, February 20, 2019
Published in: Book Excerpts
By Patrick LeBlanc, Publisher: Microsoft Press, Released: January 2013, http://shop.oreilly.com/product/0790145338273.do?sortby=publicationDate
- Home
Articles filed in category 'SQL Server 2012'