T-SQL Random Numbers using RAND() for Test Data
T-SQL Random Numbers using RAND()
SQL Server includes the T-SQL RAND() function to create a random value between 0 and 1...
2015-01-12
1,391 reads
2014 Year In Review
As is our want, we must look back over the past year to see what happened. While I normally focus...
2015-01-11
631 reads
A Whole New Mind by Daniel Pink
I have dedicated much more time to reading in the past 6 weeks (Since the beginning of December 2014), and...
2015-01-11
488 reads
In-Memory OLTP Part 2 : Memory-Optimized tables
In part 1 of the In-memory OLTP articles we gave you an introduction into In-memory OLTP, showing what the requirements...
2015-01-11
4,215 reads
SQL Saturday NYC Update #3
SQL Saturday NYC Planning is in going well and we are now getting ready to finalize our precons as 2...
2015-01-09
473 reads
Learning SQL #1–Start from buying a Copy of SQL Server Developer Edition
If learning SQL is in your New Year Resolution, then you will be happy to read this post.
We all make...
2015-01-09
1,054 reads
SQL – Split delimited columns using XML Or UDF function
The requirement is to convert the delimited column into rows
Input data and required output details are given below
EnoEnameEslocEDept1ABCNJ10,20,30,40,50Output:-
EnoEnameEslocEDept1ABCNJ101ABCNJ201ABCNJ301ABCNJ401ABCNJ50Download the Script Split...
2015-01-09
1,356 reads
The mysterious permission issue
As you might have realized, this is not the title of an Agatha Christie book, but rather about some nasty...
2015-01-09
782 reads
I Am Grateful For
A while back I wrote about saying “Thank you” to people. Last night I was listening to NPR on my...
2015-01-09
695 reads
On Failure
The first rule of blogging is that you should write about topics you know a lot about. And I know...
2015-01-09
704 reads
Blogs
Architecting Zero Downtime Deployments–Day of Data Boston
By Steve Jones
Here are the resources for my talk at Day of Data Boston. Slides –...
The Book of Redgate:A Prehistory
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
Evidence-bound: what AgentDBA will and won’t link
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
Forums
Azure SQL Database Event Log Limitations
Hi, Do you know if there is a way to get more detailed logging...
Four Rules for Adding AI Without Breaking What Already Works
Comments posted to this topic are about the item Four Rules for Adding AI...
SQL Server 2025 section missing?
Hello, the title says it all. Is the SQL Server 2025 section missing?
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers