I am a Microsoft Data platform MVP
I am so excited and happy to be chosen to receive the Microsoft Data Platform MVP award. This is my...
2016-07-04
479 reads
Dennis's SQL Blog
SQL Server 2016 available today
In case you haven't heard, SQL server 2016 is generally available today! If you haven't try it out, you should...
2016-06-02
845 reads
StorSimple Appliance – Part 1 Overview
Last time, I talked about cloud backup and the two different ways of doing it – directly and using StorSimple appliance...
2016-05-27 (first published: 2016-05-19)
1,531 reads
End of Support - SQL Server 2005
It finally comes to this date, 12th April 2016, the end of support for SQL server 2005! SQL 2005 is...
2016-04-12
667 reads
Cloud backup - MS StorSimple Applicance
In the previous post, I talked about how we can revamp the backup infrastructure for SQL to backup directly to Azure,...
2016-04-15 (first published: 2016-04-11)
2,197 reads
Cloud Backup - Directly to Azure
Backup is one of the major task for DBAs, it has many different options and ways for each companies to...
2016-04-07
1,635 reads
SQL server on Linux
Microsoft accounted yesterday that SQL server will plan run in Linux, with early private preview available today along with full...
2016-03-09
2,258 reads
Installation of SQL Server (Part 2 - Post-installation)
Previously we discussed about the pre-installation consideration, which can be found here. In the second part of this series, we...
2016-03-01
1,544 reads
Installation of SQL Server (Part 1 - Pre-installation)
I have been wanting to write this for a long time, and finally got time to do it. Which is...
2016-02-29 (first published: 2016-02-23)
2,733 reads
Parallelism setting in SQL Server – reduce CXPACKET waits?
This is one of the hot topic within the DBA community, what should be the best setting for parallelism in your environment? The answer is – it depends! J
Let’s...
2016-01-13
67 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