Get All Referenced Tables and Columns
I was always challenged when my customers asked me what tables and columns are referenced by a stored procedure which...
2015-11-19
1,577 reads
Aggregation Design is Back!
If you use SQL Server Data Tools (SSDT) and SQL Server Data Tools – BI (SSDT-BI) for your SQL Server 2012...
2015-11-19
468 reads
Print Long String
Quite often, I output information through PRINT command. It works well only when message is shorter than 8000 bytes. When the message is greater than 8000 bytes, extra-characters will...
2015-11-19
30 reads
Print Long String
Quite often, I output information through PRINT command. It works well only when message is shorter than 8000 bytes. When...
2015-11-26 (first published: 2015-11-19)
1,746 reads
Job & Process Documentation Tips
Three big things I look for in documentation:
Who to call when it goes wrongWhere to find it the code, especially...
2015-11-19
544 reads
Webinar Followup: Migrating your SQL Server VMs to Azure with PowerShell
Earlier this week I presented a free webinar for Pragmatic Works where I discussed how to migrate virtual machines to...
2015-11-19
1,321 reads
MVP of The Month
If you follow Grant Fritchey (B|T) at all, you know that every month he picks a “Speaker of the Month”....
2015-11-19
462 reads
The Power of Data in the Cloud
Today we had a full-day event in Microsoft about the data offerings and possibilities in the Microsoft cloud platform – Azure....
2015-11-19
711 reads
SQL New Blogger Challenge November 2015 Edition - Week 3 Digest
This week’s #sqlnewblogger posts!
Author Post @eleightondick [[T-SQL Tuesday] Data modeling: The trouble with prefixes @tomsql Adventures With TomSQL, aka Tom Staab @EdDebug [Automatically name primary key constraints in SSDT...
2015-11-19
14 reads
In-Memory OLTP Table Checkpoint Processes Performance Comparison
Checkpoint processes and other internal processes have undergone major changes for In Memory OLTP tables and transactions. The following article...
2015-11-18
690 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