Date Range Challenge in sql
Hi Folks,
When you work in a offshore - onsite setup in IT industry and if you are fortunate 🙂 to be a...
2015-03-15
508 reads
Blog Posts
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,123 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
14 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...
2015-03-13
409 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,521 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
802 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
584 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
902 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
538 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,652 reads
Blogs
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
How to Check TDE Progress and Elapsed Time in SQL Server
By SQLPals
How to Check TDE Progress and Elapsed Time in SQL Server ...
PostgreSQL Support in the Data API Builder
By Steve Jones
Next week I’m at VS Live in San Diego (register and join me) and...
Forums
Squared Values
Comments posted to this topic are about the item Squared Values
I Don't Want To Do XX
Comments posted to this topic are about the item I Don't Want To Do...
Managing Feature Flags with GET_BIT() and SET_BIT() in SQL Server
Comments posted to this topic are about the item Managing Feature Flags with GET_BIT()...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers