What collation variables take on in T-SQL
I was asked an interesting question about collations in sql server recently about where variables in a script got their collation's from. I really wasn't too sure of the...
2014-10-22
15 reads
Off to London
Today I’m off across the Atlantic again. SQL in the City 2014 kicks off in London and I have 3...
2014-10-22
1,000 reads
Wishing You a Very Happy Diwali
Wishing You a Very Happy Diwali…………….
KAHI TIMTIMAHAT HAIN DIYO KI, KAHI SHOR HAAN ATHISBAZI KA
CHAMAK HAAN DIL MAIN, UMEEDO KI...
2014-10-22
755 reads
Force only certain values to be unique
I thought of something rather interesting the other day while answering a question asking for help with some table structures....
2014-11-03 (first published: 2014-10-22)
6,580 reads
DBAs - Step away from production
I have worked as a DBA and also as a Sql Server developer and in many roles had full access...
2014-10-21
23 reads
DBAs - Step away from production
I have worked as a DBA and also as a Sql Server developer and in many roles had full access...
2014-10-21
59 reads
DBAs - Step away from production
I have worked as a DBA and also as a Sql Server developer and in many roles had full access...
2014-10-21
45 reads
DBAs - Step away from production
I have worked as a DBA and also as a Sql Server developer and in many roles had full access to production, it is OK though I know what...
2014-10-21
18 reads
SQL Server Upgrade Preconference at PASS Summit 2014
Please join my associates and I for an all-day SQL Server Upgrade workshop on November 3rd
If you are planning an...
2014-10-21
752 reads
Have You Contributed to “Argenis Without Borders”?
So, I’m a little behind the ball on all of this. And others have already blogged about it:
Donate to Doctors...
2014-10-28 (first published: 2014-10-21)
5,477 reads
Blogs
Automated SQL Server Benchmarking with HammerDB and Docker: A Complete Testing Framework
I’m excited to announce the release of a new open-source project that fully automates...
T-SQL Snapshot Backups on Availability Group Secondary Replicas
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
Forums
AI Experience Gap that we keep talking about
Comments posted to this topic are about the item AI Experience Gap that we...
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...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers