Speaking at the Data Platform Summit 2017
I am honored to be speaking at the Data Platform Summit 2017. The event takes place August 17-19, 2017 in...
2017-06-20
562 reads
Power BI Custom Visuals Class (Module 56 – Rotating Tile)
In this module you will learn how to use the Rotating Tile Custom Visual. The Rotating Tile gives you the...
2017-06-20
718 reads
Database Fundamentals #3: What’s In a Database?
It’s worth noting that a lot of people will never need to create their own database. You may never create...
2017-06-20
494 reads
Statistics and Cardinality Estimation
Cardinality
This is a term originally from Mathematics, generally defined as “The number of objects in a given set or grouping”....
2017-06-30 (first published: 2017-06-20)
5,851 reads
SQL Server 2017 Concatenation With STRING_AGG
One of the new less publicized features in SQL Server 2017 is STRING_AGG. This new feature can take an expression...
2017-06-20
95 reads
How the Initial VLF sequence number gets decided of the default transaction log file
In last three years, I presented two times on the topic Transaction Log File Architecture. During the sessions, when I discussed...
2017-06-28 (first published: 2017-06-20)
1,572 reads
DevOps – Downloading a File from the Internet with PoSh
One of the things we need to do as data professionals is move data files around. Often we’ll get a...
2017-06-19
471 reads
PASS Security VC Presentation – The Dirty Business of Auditing
On Thursday, June 22, at 1 PM EDT / 10 AM PDT, I’ll be presenting for the PASS Security Virtual Chapter.
Registration...
2017-06-19
375 reads
dbfs – command line access to SQL Server DMVs
With SQL Server on Linux, Microsoft has recognized that they’re opening up their products to a new set of users. People that aren’t used to Windows and it’s tools....
2017-06-19
16 reads
dbfs – command line access to SQL Server DMVs
With SQL Server on Linux, Microsoft has recognized that they’re opening up their products to a new set of users....
2017-06-28 (first published: 2017-06-19)
1,707 reads
Blogs
Monday Monitor Tips: Configuring Access to the MCP Server
By Steve Jones
I have been experimenting with MCP servers in a few ways, including the Redgate...
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
Forums
A Challenge of Our Knowledge
Comments posted to this topic are about the item A Challenge of Our Knowledge
The memory toll of VARCHAR(MAX) in SQL Server
Comments posted to this topic are about the item The memory toll of VARCHAR(MAX)...
Transaction Log Truncation
Comments posted to this topic are about the item Transaction Log Truncation
Question of the Day
Transaction Log Truncation
In SQL Server 2025, where can I find information about items that prevent or delay the transaction log truncation?
See possible answers