Data Size – LEN() vs DATALENGTH() - WaterOx Consulting
Reading Time: 3 minutes No. It isn’t just the way you use your data that...
The post Data Size – LEN() vs...
2015-03-13 (first published: 2015-03-04)
7,119 reads
Blog Posts
Friend of Redgate 2015
Today I am excited to announce that I have been accepted into the Friends of Redgate program for 2015. The...
2015-03-13
396 reads
Friend of Redgate 2015
Today I am excited to announce that I have been accepted into the Friends of Redgate program for 2015. The program targets influential people in their respective technical communities...
2015-03-13
3 reads
How to Replace Multiple Strings in a File using PowerShell
Replace the Data Source and Initial Catalog values of WebConfig.XML
Content of XML file
<Configuration ConfiguredType=”Property” Path=”\Package.Connections[ConnStaging].Properties[ConnectionString]” ValueType=”String”>
<ConfiguredValue>Data Source=localhost;Initial Catalog=Stage;Integrated Security=SSPI; Connection Timeout = 10</ConfiguredValue>
</Configuration>
PARAM(
[String]$DatabaseName='DCTarget',
[String]$XML='c:\webconfig.XML',
[String]$DatabaseServer='DataCenterDB01')[string]$db...
2015-03-13
15,505 reads
My First Ever SQL Saturday Pre-Con
Like most people I have a bucket list of things to do before I depart for other things. However I...
2015-03-13
795 reads
Speaker of the Month: February & March 2015
It’s not a question of scheduling. I just haven’t been to lots of community events in the last several months...
2015-03-13
573 reads
SQL Saturday #408 Houston – June 13th 2015
Call for speakers is now open for SQL Saturday #408 in Houston, TX. If you are interested in presenting please...
2015-03-13
896 reads
SQL Server Virtualization for VM Admins – SQL Saturday Madison Precon
I am pleased to announce a brand new pre-conference training session, entitled “SQL Server Virtualization for VM Admins“, to be...
2015-03-13
534 reads
Why You Shouldn’t Skip the Infrastructure/Security Architecture Review
It’s not usual for development projects to undergo an architecture review, but too many times these reviews consist only of...
2015-03-13 (first published: 2015-03-09)
5,645 reads
Allowing a User to Create Objects in a Schema
I was testing something the other day and realized this was a security area I didn’t completely understand. I decided...
2015-03-12
1,171 reads
Blogs
Flyway Tips: AI Helps with Commit Messages
By Steve Jones
At Redgate, we’re experimenting with how AI can help developers and DBAs become better...
Startup scripts in SQL Server containers
I was messing around performing investigative work on a pod running SQL Server 2025...
Using SQL Compare with Redgate Data Modeler
By Steve Jones
Redgate recently released SQL Compare v16, which included a new feature to work with...
Forums
What is Page Density
Comments posted to this topic are about the item What is Page Density
T-SQL in SQL Server 2025: Fuzzy String Search II
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Azure-SSIS, Self-Hosted Integration Runtime, & Data Gateway?
Looking to confirm my understanding of these three products and how they can be...
Question of the Day
What is Page Density
In SQL Server, there is a concept of page density. This is determined by how much data is stored on each page. What is a page density of 90%?
See possible answers