New Horizons Get Schooled Blog

Why Microsoft Experts Want More Open Source

Posted on 6/13/18 12:57 PM by Get Schooled in Microsoft

Microsoft loves Open Source! So declared Microsoft CEO Satya Nadella, and for very good reason. More and more of the corporate world is adopting Open Source applications and utilities to run their IT operations. In fact, Microsoft says 40% of all VMs on Azure are running Linux. Learn about the amazing things you can accomplish with Open Source, and how being part of the Open Source Community can benefit your career.

0 CommentsContinue Reading →

Microsoft CSP is a Great Place to Start, and Here’s How to Make it Better

Posted on 4/19/18 9:00 AM by Get Schooled in Microsoft

Microsoft CSP is a Great Place to Start, and Here’s How to Make it Better

The Microsoft Cloud Solution Provider program offers a great foundation for cloud solutions, but there’s much more to integrate around it to enhance the services, increase the value proposition, and complete the solution.

Microsoft created the Cloud Solution Provider program to focus its partner community on the two things Satya Nadella identified in his first address to Microsoft after becoming CEO, in which he said, “Microsoft will be the platform and productivity company.”

By “platform” he meant Azure. By “productivity” he meant Office 365, and now Microsoft 365.


0 CommentsContinue Reading →

Understanding the two audiences for TSQL training

Posted on 2/14/18 1:59 PM by Get Schooled in Microsoft

Relational database systems, such as Microsoft SQL Server, are used throughout organizations. TSQL, or Transact-SQL, is the language used to program, manage, and query Microsoft SQL Server.
But did you know there are two different ways people use TSQL, and two difference audiences for TSQL training? 

0 CommentsContinue Reading →

Finding the most hassle-free data import approach in SQL Server

Posted on 2/10/17 11:56 AM by Get Schooled in Microsoft

When importing or exporting data to/from Microsoft SQL Server, you have many options: bcp, .NET's SqlBulkCopy class, SSIS, linked servers, OPENROWSET, and BULK INSERT. Each of these solutions tends to perform faster than other approaches that are further removed from SQL Server. Nevertheless, choosing the right solution from this list depends on your situation. In particular, these approaches differ markedly in terms of the setup requirements.
Generally, OPENROWSET and BULK INSERT are used for one-off or on-the-fly queries that access an external data source. However, they can be a problem in custom applications if there's a reason why the application shouldn't have the elevated privileges required to execute them. To make these work, the ad hoc distributed queries option must be set:
sp_configure 'show advanced options', 1;
RECONFIGURE;
sp_configure 'Ad Hoc Distributed Queries', 1;
RECONFIGURE;
GO
Furthermore, OPENROWSET and BULK INSERT syntax both involve specifying a "provider" that will actually read the external data. For this to work, certain dlls have to be found on the machine. Many of the examples posted online involve outdated 32-bit drivers, and it's not guaranteed that any given syntax will work in your environment.
Linked servers use the very same "provider" syntax but set up a permanent linked to an external data source. The ad hoc distributed queries option isn't required; so, to a degree, the requirements for linked servers are a little lower. Also, in addition to using sp_addlinkedserver to create a linked server, you can also create one in GUI fashion right from the SQL Server Management Studio. A possible disadvantage of linked servers, however, is that applications that rely on them may fail if the database is transferred to another server. The problem is that details such as linked servers often get missed when it comes to knowledge management, so future staff may not know that a linked server needs to be set up for a certain application to work properly.
SSIS is a very popular tool for data import, because of its power and drag-and-drop GUI interface. Another advantage is that many people have been trained on SSIS, facilitating future support for any solution that uses it. However, a number of components need to be installed to develop SSIS packages and have them work properly in development mode.
Bcp, which stands for Bulk Copy Program, is a single executable to which you pass parameters. While it's much older than SSIS and has some limitations, in many ways it's the simplest option for performing basic imports and exports. Another simple option is .NET'sSqlBulkCopy class, which is designed for fast-performing import/export operations integrated directly in one's application code. If your code reads in data from an external source, this class facilitates fast import into SQL Server, with just a connection string and a DataTable.

0 CommentsContinue Reading →

It's a Beautiful Day to Go to The Fair

Posted on 2/10/17 8:56 AM by Alex Matthews in Certifications, in Cisco, in Citrix, in Computer Education, in IT Career, in IT Training, in Microsoft, in Vendor-Authorized, in vmware

State Fair of Texas Media Gallery

0 CommentsContinue Reading →

Compelling Reasons for Using the XML Data Type in SQL Server

Posted on 4/20/16 3:03 PM by Get Schooled in Microsoft

If you need to store XML data in a Microsoft SQL Server database, you can simply store the data as text in a varchar or nvarchar column. Since SQL Server 2005, you can also define a column with the XML data type. However, you may wonder why you'd want to deal with the slight additional complexity of doing that, given that varchar works just fine.

0 CommentsContinue Reading →

Are You Getting the Best Possible IT Deals for Your Institution?

Posted on 3/21/16 3:52 PM by Get Schooled in Microsoft

Small nonprofits, private schools, and similar institutions may find it difficult to keep up with the costs associated with growing IT needs. Fortunately, if you're in this situation, you may be able to get discounted or free IT equipment and software.

0 CommentsContinue Reading →

How to Access a Linked Server's Linked Server in SQL Server

Posted on 3/21/16 3:49 PM by Get Schooled in Microsoft

In Microsoft SQL Server, you can define remote data sources as "linked servers" and access them in a query using syntax that qualifies the object (e.g., table) name according to where it resides ... e.g., server.database.schema.object. However, sometimes, you may need to access a linked server's linked server.

0 CommentsContinue Reading →

Find the Most Hassle-Free Data Import Approach in SQL Server

Posted on 2/25/16 8:07 AM by Get Schooled in Microsoft

When importing or exporting data to/from Microsoft SQL Server, you have many options: bcp, .NET's SqlBulkCopy class, SSIS, linked servers, OPENROWSET, and BULK INSERT. Each of these solutions tends to perform faster than other approaches that are further removed from SQL Server. Nevertheless, choosing the right solution from this list depends on your situation. In particular, these approaches differ markedly in terms of the setup requirements.

0 CommentsContinue Reading →

Microsoft Ignite Benefits IT Leaders in Many Ways

Posted on 5/14/15 3:51 PM by Get Schooled in Microsoft

Microsoft Ignite 2015 was recently held in Chicago. Ignite is an annual event that allows IT leaders around the world to connect, hear from industry thought-leaders on the changing landscape of IT, find new technology partners and learn how others are transforming their businesses with key technology trends.

0 CommentsContinue Reading →

Search by Topic

    Lists by Topic

    see all

    Knowledge Ninjas

    a web-based service that allows software application end users to access a subject matter expert in real-time via a chat interface to resolve questions or problems they encounter in their specific software.

     

    Subscribe