Getting Started with GitHub for SQL Server Developers
Learn some of the basics of GitHub and how this can be utilized for your SQL Server development projects.
2019-01-09
2,918 reads
Articles
Azure DWH part 29: MicroStrategy Desktop with Azure
In this article, we will show how to connect MicroStrategy Desktop with ASDW.
2019-01-08
589 reads
Azure Data Explorer
Read this white paper to get a better understanding of the architecture and technology powering Azure Data Explorer, a fast and highly scalable data exploration service.
2019-01-08
2,277 reads
Factors Behind Successfully and Repeatedly Executing Digital Transformation Programs at a Lightning Pace
IT transformation projects often fail due to poor planning, poor communication and more. In this article, Mohammad Rizvi explains how to be successful and give your customer a great experience.
2019-01-08
2,602 reads
Bootstrap 4 and Self-validating Forms
Validating the user input of a web form is important for security and data quality. In this article, Dino Esposito explains how to validate a form and add undo capability with Bootstrap 4.
2019-01-07
2,392 reads
Understanding Peer-to-Peer Transactional Replication, Part 3
We've gone through the basics of Peer-to-Peer Transactional Replication (PPTR). Now, we will blow it up! We will then fix it and show you how you how to triage and repair PPTR. When you remain calm and take some easy steps, you can stabilize PPTR with ease.
2019-01-04 (first published: 2016-01-07)
3,006 reads
"Surely this one will get a clustered index scan."
In which SQL Server stubbornly insists on doing key lookups way, way past the tipping point.
2019-01-04
2,905 reads
Workplace Encounter: Effects of TLS 1.2
In this article we share a recent experience we had with implementing TLS 1.2 ONLY support on our databases and particularly with respect to its effect on Transaction Log Shipping sessions.
2019-01-03
2,159 reads
SSRS Reporting Basics: When is SSRS the Right Tool?
SSRS has undergone a number of changes over the past few versions. It remains a very popular reporting tool in companies large and small. In this article, Eugene Meidinger recounts the history of SSRS and explains when it’s the best tool to use.
2019-01-03
4,119 reads
Working with SQL Server Stored Procedures and .NET
Learn how to build a simple .NET application that uses SQL Server stored procedures to retrieve and update data from a database.
2019-01-03
3,952 reads
Blogs
The Notification Trap: How Input Fatigue Is Killing Deep Work in Tech
By gbargsley
If you've been here before, you know this blog is usually about SQL Server,...
Designing a Storage Load Test for SQL Server
I’ve been doing storage load tests for SQL Server for a long time, both...
Questions and Answers from Running a Local LLM
By Steve Jones
I had a few random questions from my Running a Local LLM on Your...
Forums
A question about how to store the address in the database
I have an app that has an address field on the customer and the...
SSIS package failing intermittently on last Excel Component
Good Afternoon, I have a Job which "fires" off an SSIS package (that is...
T-SQL in SQL Server 2025: JSON_ARRAYAGG
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Question of the Day
Multiple Sequence Values
How do I easily get the next 12 sequence values from a sequence object?
See possible answers