Additional Articles

Implementing Azure Blob Storage (ABS) With SQL Server 2014

by Additional Articles

Microsoft MSDN

Azure

With any application organizations face consistent key challenges such as high efficiency and business value, complex configuration, and low total cost of ownership. Extending applications to the cloud in hybrid scenarios addresses many of these challenges, whether distributing SharePoint content across on-premises and Office 365 while leveraging search as a service (hybrid search) or externalizing data, extending it to the cloud with Remote Blob Storage or related technologies.

2014-09-02

7,465 reads

More Text Analysis with the SSIS Term Lookup Component

by Additional Articles

MSSQLTips.com

Integration Services (SSIS)

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.

2014-09-01

7,063 reads

A TDD Journey: 2 - Naming Tests; Mocking Frameworks; Dependency Injection

by Additional Articles

SimpleTalk

Test Driven Development (TDD)

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.

2014-08-29

7,571 reads

SQL Server AlwaysOn Availability Groups Fail the Initial Failover Test

by Additional Articles

MSSQLTips.com

always on

The first test of AlwaysOn in SQL Server 2012 is successful, but after testing to swing back again to your primary replica, you find out that automatic failover works only the first time. How come? Carla Abanes explains.

2014-08-28

7,981 reads

Questions about T-SQL Expressions You Were Too Shy to Ask

by Additional Articles

SimpleTalk

Expressions

Nobody seems to ask questions about SQL Expressions in forums, even though expressions can cause all sorts of problems. It's time for some straight-forward Q&As, and who better than Robert Sheldon to give the A?

2014-08-27

12,876 reads

Big Data Technologists Transition to Customer-Facing Roles

by Additional Articles

Database Journal

Big Data

As the enterprise embraces big data, management assumes that staff sizes will decrease. What should be done with those unneeded technologists? One answer: convert them into technology consultants that collaborate and coordinate with the lines of business. In other words, give them customer-facing roles.

2014-08-26

8,744 reads

The Mindset of the Enterprise DBA: 8 Ways To Centralize Your Work

by Additional Articles

SimpleTalk

dba skills

As well as standardizing and documenting, the enterprise DBA needs to centralize the management of systems. Joshua Feierman explains.

2014-08-25

10,801 reads

Management of Windows Azure SQL Databases via PowerShell with REST APIs

by Additional Articles

Database Journal

Windows Azure SQL Database

Management of Azure SQL Databases has been greatly simplified by the introduction of the Azure PowerShell module. Marcin Policht describes the principles of dealing with the Azure PowerShell module’s REST APIs directly.

2014-08-22

8,728 reads

Office 365 Essentials - Subscriptions and Licenses

by Additional Articles

SimpleTalk

cloud services

Should you be planning to move from Exchange to Office 365? If so, why? What sort of license should you get, and should you use cloud identities or federated identities for your users?

2014-08-21

9,937 reads

Quickly Investigating What's in the Tables of SQL Server Databases

by Additional Articles

SimpleTalk

tables

From SQL Server Management Studio it's hard to look through the first few rows of a whole lot of tables in a database. This is odd, since it is a great way to get quickly familiar with a database. Phil tidied up a SQL routine he uses to investigate databases quickly in a browser. He explains how to use it, how it works, and how to use it from PowerShell.

2014-08-20

10,983 reads

All authors

Additional Articles

Implementing Azure Blob Storage (ABS) With SQL Server 2014

More Text Analysis with the SSIS Term Lookup Component

A TDD Journey: 2 - Naming Tests; Mocking Frameworks; Dependency Injection

SQL Server AlwaysOn Availability Groups Fail the Initial Failover Test

Questions about T-SQL Expressions You Were Too Shy to Ask

Big Data Technologists Transition to Customer-Facing Roles

The Mindset of the Enterprise DBA: 8 Ways To Centralize Your Work

Management of Windows Azure SQL Databases via PowerShell with REST APIs

Office 365 Essentials - Subscriptions and Licenses

Quickly Investigating What's in the Tables of SQL Server Databases

Blogs

Shifting Mindsets: Why FinOps is Essential for Cloud Efficiency

March 2026 SQL Server Security Updates

How Fabric Mirroring Transformed with SQL Server 2025

Forums

XACT_ABORT being set to ON by web services

OPENQUERY Flexibility

A Full Shutdown

Question of the Day

OPENQUERY Flexibility