The CHOOSE keyword
G’day,
I love coming across features of SQL that I’ve not used before and one happened today – the CHOOSE statement – introduced...
2014-02-17
1,549 reads
Marty
- Interests: Playing Guitar, Music Theory
- Website: http://martincatherall.com/
TSQL-Tuesday#050 – Automation
TweetG’day,
Well, it’s the first TSQL-Tuesday of 2014 and one of my New Years resolutions for 2014 is to contribute to...
2014-01-14
1,296 reads
Do you clean up after yourself?
TweetG’day folks,
I remember a fair few years ago when I was relativly new to TSQL creating a stored procedure that...
2014-01-13
1,262 reads
Installed SQL SERVER 2012? maybe you’d like to re-set your shortcuts!
TweetG’day,
Just a quick post on a seemingly trivial matter that others may find useful.
The post was prompted by the Simple-Talk...
2013-12-30
1,362 reads
SQL Saturday #252, Christchurch New Zealand
TweetSQL Saturday #252 Christchurch, New Zealand
G’day,
Well, these are exciting times for the Christchurch SQL SERVER User Group.
After a period of...
2013-07-28
1,171 reads
Dedicated Admin Connections (DAC) and SQL SERVER 2012 SSMS
TweetG’day,
As part of any SQL SERVER install that I do, I turn on Remote admin connections (using sp_configure) and open...
2013-04-07
5,181 reads
Multiple ALTER DATABASE SET options
TweetG’day,
Did you know that you can actually combine multiple SET operations into a single ALTER DATABASE statement.
It’s true, you can!
Mostly...
2013-04-06
4,298 reads
SSPI error and Incorrect timing.
TweetG’day,
Recently, quite out of the blue I started seeing this error when I tried to log into my SQL instance...
2013-03-28
1,658 reads
The first record on data page.
TweetG’day,
I had a recent conversation about data pages. There was some debate about the location of the first record on...
2012-08-06
1,196 reads
2012 DDL for Roles
TweetG’day,
I’m extremely pleased that Microsoft are continuing their commitment to provide full DDL to preform TSQL operations that have previously been preformed using stored...
2012-04-22
1,328 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