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.
2018-06-18
2,632 reads
Articles
Splitting Strings in SQL Server 2016
Comparison of the new methods of splitting strings in SQL Server 2016 to the tried and true methods
2018-06-15 (first published: 2016-04-12)
9,394 reads
How to Tell If Your SQL Server Has Too Much Memory
Brent shows what Perfmon counter to watch after your SQL Server restarts.
2018-06-15
5,646 reads
SQL Server From .Net: Reading SQL Server Metadata in ADO.Net
A basic introduction for developers (or anyone) about reading the metadata of a SQL Server database from a .Net application.
2018-06-14
3,447 reads
Using Regular Expressions With T-SQL: From Beginner To Advanced
Its possible to use some comparable expressions to a full regular expression library for matching certain patterns with T-SQL using the like operator. This tutorial uses these expressions for filtering price phrases involving alphabetic, numeric, and special characters
2018-06-14
4,713 reads
Data Governance, DevOps, and Delivery
Data governance must be included in DevOps practices. William Brewer explains how to define business policies and standards to ensure compliance with privacy regulations and bring data governance to all aspects of continuous delivery.
2018-06-13
2,693 reads
Dynamic File Column mapping in SSIS.
An efficient and reliable method for reading CSV files with variable columns.
2018-06-12
28,467 reads
Indexes That Have Not Been Used but Are Being Updated
Greg Larsen talks about how indexes that are not being used are costing you valuable resources and causing your update statements to run longer.
2018-06-12
3,648 reads
Using Power BI in a Hybrid Environment
This paper describes best practices for security, networking, and component architecture for building a hybrid business intelligence (BI) environment by using a combination of Microsoft Office 365, Microsoft Azure, and on-premises data sources. Many organizations are taking advantage of the benefits of cloud computing such as lower capital expenditures and increased agility, while still maintaining data in on-premises data stores.
2018-06-12
2,710 reads
Improving SQL Server 2016 Large Database Performance
This article aims to save you days or weeks of troubleshooting when using SQL Server 2016 for large databases
2018-06-11
10,281 reads
Blogs
How to Connect to SQL Server When Nothing Else Works – DAC
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
Get a Range of Sequence Values: #SQLNewBlogger
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
The Agent Era: When “How do I…?” Replaces “Where do I click?”
By Arun Sirpal
After a year away getting to grips with AI and its application across the...
Forums
Are luxury packages in Andaman suitable for a honeymoon?
Yes, luxury packages in Andaman are highly popular among honeymooners due to their romantic...
Hiring: Financial SQL Systems Administrator
Fisher Phillips is looking for a Financial Systems Administrator to help support and improve our financial...
Job Opening for ERP Systems Administrator - Hybrid
Employee owned company, been around for over 50 years. Hybrid opportunity, looking folks in Pacific...
Question of the Day
Creating a JSON Document II
I want to create a JSON document that contains data from this table:
TeamID TeamNameCity YearEstablished 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960If I run this code, what document(s) is/are returned?
SELECT json_objectagg( n.city : n.TeamName) FROM dbo.NFLTeams;See possible answers