Software Patents
Patents are one way that governments can spur innovation. However many people think software patents should be eliminated. Steve Jones doesn't think so, but would like reform.
SQL Server AlwaysOn Availability Groups Using an Azure Template
There is already a template on the Azure marketplace for setting up an AlwaysOn Availability Group. In just a few easy steps you can get a working AlwaysOn Availability Group setup, configured and running - this post describes the steps to quickly set it up.
Don’t Underestimate the Importance of Good Co-workers
It is important to have people that do good work and are good to work with.
Key Lookups and ColumnStore Indexes
Erik figures out why SQL Server really doesn't like combining these two things in a query plan.
The Cloud is Better In At Least One Way
Azure SQL Database has a lot of integrity checks. Probably more than your local instance.
Timing is Everything
Phil Factor on the wise habit of timing your database routines, to avoid relying on received wisdom about performance.
The Power of Python and SQL Server 2017
Python is new to SQL Server 2017. It is intended primarily to allow the use of Python-based machine-learning within SQL Server, but it can be used for far more than this, with any Python libraries or Frameworks. To provide an example of what is possible, Hitendra shows how to use the feature securely to provide intelligent application caching, where SQL Server can automatically indicate when data changes to trigger a cache refresh.
A Lightweight, Self-adjusting, Baseline-less Data Monitor
Can data alert us that something is going on, without baselines and thresholds?
The Blame Game
Equifax is blaming a single IT person for their data breach. Steve Jones worries this is a sign of things to come.
Blogs
Measuring RAG Solutions: Are We Retrieving the Right Information?
A RAG pipeline that answers questions in the demo is not the same thing...
Advice I Like: Lots of Ideas
By Steve Jones
“A multitude of bad ideas is necessary for one good idea” – from Excellent...
Building a DBA Agent for Your SQL Server Estate with MCP
Yesterday I gave a talk for MSSQLTips called “Building a DBA Agent for Your...
Forums
How do I connect to a SQL Server database on my ISP?
I've got a web application for my side business. I've added a SQL Server...
Looking for New Blood
Comments posted to this topic are about the item Looking for New Blood
Server-Level Row Counts for Tables and Views
Comments posted to this topic are about the item Server-Level Row Counts for Tables...
Question of the Day
Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers