Where should middle tier business logic be stored?
The age old question of where should business logic be stored
2015-10-16
299 reads
Articles
Idle Connection Resiliency
Describes the idle connection resiliency feature, which allows ODBC and SqlClient data access applications to maintain their connections to SQL Server 2014 or an Azure SQL Database.
2015-10-16
2,930 reads
Integration Services Logging Levels in SQL Server 2016
At the time of writing, SQL Server 2016 preview (CTP 2.3) has been released and there are some changes for the Integration Services (SSIS) Catalog logging levels.
2015-10-15
3,310 reads
2015-10-14
287 reads
SQL Prompt Tips #1 - Selecting in the Object Explorer
A quick tip to help you get the most out of SQL Prompt.
2015-10-14 (first published: 2012-05-01)
1,666 reads
Azure SQL Database - Row-Level Security
One of the benefits of using Azure-based Platform-as-a-Service and Software-as-a-Service offerings, is considerably quicker access to newly developed capabilities. In this article Marcin Policht focuses on row-level security, included in both Azure SQL Database V12 and SQL Server 2016 Community Technology Preview 2 (CTP2).
2015-10-14
3,552 reads
Find Permission Changes In The Default Trace
Learn how to find who has changed permissions from the default trace
2015-10-13
11,938 reads
SQL Server 2014 and Windows Azure Blob Storage Service: Better Together
This technical article will cover in depth SQL Server 2014 Data Files on Azure Blob storage service, starting from step-by-step configuration
2015-10-13
2,489 reads
Power BI Desktop Web Queries to Screen Scrape Data from Websites
I have heard the new Power BI Desktop can screen scrape data off websites; how does that process work?
2015-10-12
3,473 reads
How efficient is your covered index?
Observing an index seek utilizing a composite index within SQL execution plan might be more than meets the eye – you should look again.
2015-10-09 (first published: 2013-08-12)
14,498 reads
Blogs
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Claude Code Helps Analyze Test Data Manager Log Files
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
PowerPoint to HTML with Claude AI
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Forums
Optimism Without Illusion or Why AI Needs Blunt Technologists
Comments posted to this topic are about the item Optimism Without Illusion or Why...
SSIS with VS2022 64/32 issue with Excel files
Hi all, I'm trying to do classic scenario for loading multiple Excel files into...
Case part is sloooooow
Hi So the case statement is slowing this down - but for the life...
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('tim', 'tom')
Assume preview features are enabled. See possible answers