Speaking? You? Go on. #tsql2sday #84
This is a blog post for this month’s T-SQL Tuesday post, hosted by Andy Yun (b|t). T-SQL Tuesday is a monthly...
2016-11-08
374 reads
SQL DBA With A Beard
PowerBi and API – Visualising my Checkins
For my own amusement and also to show my wife where I have been I use the Swarm check-in app...
2016-11-03 (first published: 2016-10-29)
2,179 reads
PSConfAsia 2016
I have just got back to the UK from Singapore following the amazing PSConfAsia conference. I must say that Matt,...
2016-10-24
526 reads
PowerShell, Pester and Ola Hallengrens Maintenance Solution
If you are a SQL DBA you will have heard of Ola Hallengrens Maintenance solution If you haven’t go and...
2016-10-04 (first published: 2016-09-24)
3,758 reads
The SQL Server Community Collaborative GitHub Organisation is born
My wonderful friend Chrissy LeMaire and I are the creators of two GitHub repositories for SQL Server and PowerShell called...
2016-09-14
772 reads
Converting SQL Agent Job Duration to TimeSpan using PowerShell
When you look in msdb for the SQL Agent Job duration you will find that it is an int.
This is...
2016-09-15 (first published: 2016-09-12)
1,487 reads
Making Start-Demo work with multi-line commands without a backtick
I love to speak about PowerShell. I really enjoy giving presentations and when I saw Start-Demo being used at the...
2016-08-29
530 reads
Remove-SQLDatabaseSafely My First Contribution to DBATools
What is DBA Tools?
A collection of modules for SQL Server DBAs. It initially started out as ‘sqlmigration’, but has now...
2016-07-20
998 reads
Using the new SQLServer Powershell module to get SQL Agent Job Information
So with the July Release of SSMS everything changed for using PowerShell with SQL. You can read the details here...
2016-07-14 (first published: 2016-07-03)
3,427 reads
PowerShell CMDLets added for SQL2016 Always Encrypted
The post on the SQLServer blog at TechNet by the SQL Server Tools Team today made me jump out of...
2016-06-30
1,003 reads
Blogs
SQL, MDX, DAX – the languages of data
By DataOnWheels
Ramblings of a retired data architect Let me start by saying that I have...
Setting PK Names in Redgate Data Modeler
By Steve Jones
A customer was testing Redgate Data Modeler and complained that it auto-generated PK names....
Flyway Tips: AI Deployment Script Descriptions
By Steve Jones
With the AI push being everywhere, Redgate is no exception. We’ve been getting requests,...
Forums
Connecting Power BI to SSAS and effective user not working
Hi everyone, Below is a consolidated summary of what we validated Architecture & data...
High Availability setup - has anyone seen this method?
Hi all, I recently moved to a new employer who have their HA setup...
Semantic Search in SQL Server 2025
Comments posted to this topic are about the item Semantic Search in SQL Server...
Question of the Day
Encoding URLs
I have this data in a SQL Server 2025 table:
CREATE TABLE Response ( ResponseID INT NOT NULL CONSTRAINT ResponsePK PRIMARY KEY , ResponseVal VARBINARY(5000) ) GOIf I want to get a value from this table that I can add to a URL in a browser, which of these code items produces a result I can use? See possible answers