Power BI Custom Visuals Class (Module 54 – Route Map)
In this module you will learn how to use the Route Map Power BI Custom Visual. The Route Map uses...
2017-06-06
764 reads
Reverse It
Recently I had a conversation with a colleague that wasn’t aware of the REVERSE function in SQL Server. I had...
2017-06-06
147 reads
Reverse It
Recently I had a conversation with a colleague that wasn’t aware of the REVERSE function in SQL Server. I had...
2017-06-06
370 reads
Working with Data in Always Encrypted
In this post we’re going to create some encrypted columns in a table in a test database and look at...
2017-06-06
11,024 reads
var Microsoft_Data_Platform_MVP = “Yip.”;
The 2nd June 2017 will always be something of a special day for me.
It was the day I was awarded...
2017-06-06
659 reads
SQL Server 2016 What's New With TSQL
DROP IF EXISTS
This allows us to drop objects without first having to check if they exist. It works on pretty...
2017-06-06
55 reads
Be Aware of CARTESIAN PRODUCT When Using Join Keys in SQL
I got a massive satisfaction last week when I was able to bring down the execution time of a sql...
2017-06-06
4,238 reads
SQL Server Monitoring: Creating your own metrics
The one and only important factor in monitoring is data. How much of x and how little of y? If...
2017-06-05
579 reads
SQLSat Pcola 2017 Security Principals and Permissions
Great attendance and awesome questions from my afternoon session on "SQL Security Principals and Permissions". As promised, both the demo...
2017-06-05
276 reads
VSTS– Hosted Agent is the Default for Releases
In keeping with the idea I don’t want this to get out of date, this is VSTS as of Jun...
2017-06-05
612 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