Using the Script Task in SSIS to Process Data Files When They Arrive
Learn how you can process data files with SSIS as soon as they arrive using the Script Task.
More Text Analysis with the SSIS Term Lookup Component
As mentioned before, we will use the same use case in this tip as used with the Term Extraction component, which is an archive of all my tweets I've downloaded from Twitter. Using this archive and the Term Extraction transformation I found out which topics I particularly tweeted about in the past years or which persons I mentioned the most.
Data Mining Introduction Part 2
This is a continuation of first article about Data Mining. We will talk about decision trees.
Data Mining Introduction Part 2
This is a continuation of first article about Data Mining. We will talk about decision trees.
Hooks
Building hooks from your software into enterprise monitoring systems is prudent, and might save you from a few late night phone calls.
A TDD Journey: 2 - Naming Tests; Mocking Frameworks; Dependency Injection
Test-Driven Development (TDD) relies on the repetition of a very short development cycle starting from an initially failing automated test that defines the functionality that is required, and then producing the minimum amount of code to pass that test, and finally refactoring the new code.
Free SQL in the City Seminar Cambridge, MA – Oct 8, 2014
SQL Server MVP Grant Fritchey and Steve Jones will present the Stairway to Continuous Delivery in Cambridge this October in place of the NESSUG meet-up. Learn how to build an efficient development and deployment process for your organization. Register for this free event.
Data Mining: Part 15 Processing Data Mining components with SSIS
In this lesson, we will show different components to Administer the Data Mining Models with SSIS.
Data Mining: Part 15 Processing Data Mining components with SSIS
In this lesson, we will show different components to Administer the Data Mining Models with SSIS.
Reverse Engineering Disasters
Preparing a disaster recovery plan means more than just trying to prevent a few specific disasters. It means turning around the way you view the world.
Blogs
Data Engineering Books Worth Having on Your Shelf (or your tablet)
Good documentation gets you started. Good books get you deep. After years of working...
SSMS Evaluation – future ready
By Vinay Thakur
In previous posts, we looked at the SQL Server engine. for us DBAs, the...
Claude.ai vs Claude API
By Arun Sirpal
You have used Claude. But which Claude? The Claude app (claude.ai, the desktop and...
Forums
Creating a JSON Document IV
Comments posted to this topic are about the item Creating a JSON Document IV
Restoring Azure Key Vault Keys and Validating SQL Server TDE Recovery: Level 7 of the Stairway to TDE
By VishnuGupthanSQLPowershellDBA
Comments posted to this topic are about the item Restoring Azure Key Vault Keys...
Permissions Removal When Changing Object Schema
When the schema of an object is changed, SQL Server wipes out the previous...
Question of the Day
Creating a JSON Document IV
I have this data in a table called dbo.NFLTeams
TeamID TeamName City YearEstablished ------ -------- ---- --------------- 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960 5 49ers San Francisco 1946 6 Broncos Denver 1960 7 Seahawks Seattle 1976 8 Patriots New England 1960If I run this code, how many rows are returned?
SELECT YearEstablished, json_objectagg(city : TeamName) FROM dbo.NFLTeams GROUP BY YearEstablished;See possible answers