Data Matters
Data is important, but today Steve Jones notes that what we do with it is even more important.
Stairway to Data, Level 7: Data Encoding Schemes - Part I
Joe discusses how to deal with the kinds of encoding schemes, how to use them and how to design them. He discusses Enumeration, Measurement, Abbreviation and Algorithmic categories
Understanding Utility Control Point (UCP) in SQL Server 2008 R2
As your business grows, the number of applications grows as well, as do the SQL Server instances to support these applications. As a SQL DBA, you need to have a multi-server management dashboard that proactively tells you about the resource utilization on each SQL Server instance.
Raw Materials - Alternative Energy
Revenge is a dish best served cold, but body temperature's OK, too.
Simplify Large Queries with Temporary Tables, Table Variables and CTEs
This article demonstrates how to manage the development of complex queries by building them in stages with temporary tables, table variables and common table expressions.
The Window Is Shrinking
Today Steve talks about security and the fact that your window for lax security is shrinking for new applications.
Automatically Capturing SQL Server Performance Metrics
This article looks to provide a method that you can use to collect the author's top 10 SQL Server performance metrics automatically over time.
Hardware Hacking
Steve Jones examines one of the issues of foreign chip production: security. Will this be an attack vector in the future?
Hidden RBAR: Counting with Recursive CTE's
"Counting" is essential to many high performance code techniques. SQL Server MVP, Jeff Moden, shows us how to make sure that we're "Counting" and not "Crippling" our trick-code.
TSQL Challenge 62 - Break a long sentence in groups of 5 words
Read the input string and break each sentence into groups of 5 words. A row may contain more than one sentence. Each sentence in the input should start a new group.
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