Why use a data lake?
Previously I covered what a data lake is (including the Azure Data Lake and enhancements), and now I wanted to touch...
2015-12-29
3,344 reads
Slow Running Query? Where do I Begin?
Maybe you’re new to SQL Server or maybe you’re just expanding into performance tuning a little more. Query tuning can...
2015-12-29
495 reads
Happy Holidays
It’s the time of the year again: the obligatory “how was the past year” blog post, combined with “what do...
2015-12-29
793 reads
Using a Variable to Populate the Query in a Lookup in SSIS
I encountered a situation on my last SSIS project in which I needed to be able to populate the query in lookup...
2015-12-29
844 reads
Tabular Models, Multiple Data Sources and Unknown Members
Self-service data modeling tools like Power BI Desktop, Power Pivot and SSAS Tabular promote the advantage of using data from...
2015-12-29
1,063 reads
What is an execution plan? When would you use it? How would you view the execution plan?
An execution plan is basically a road map that graphically or textually shows the data retrieval methods chosen by the...
2015-12-28
865 reads
What does that N in nvarchar really mean?
In any study of Data Types in SQL Server you are going to have to look at the various string...
2015-12-28
2,392 reads
Thank You for More Than You Realize
Blogging and presenting have changed me for the better, and in ways I didn’t see coming. However, I know I wouldn’t have had them if it wasn’t for three things. Getting...
2015-12-28
10 reads
Thank You for More Than You Realize
Blogging and presenting have changed me for the better, and in ways I didn’t see coming. However, I know I wouldn’t...
2015-12-28
697 reads
Presentations & Blogging of 2015 in Review
Another year is coming to an end and I am doing a review of which goals I have managed to...
2015-12-27
767 reads
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