Using sp_DBPermissions and sp_SrvPermissions v6.0
It’s been a while since I posted an updated to usp_DBPermissions and usp_SrvPermissions. Sorry. I got lazy with my posting....
2015-02-25
1,290 reads
Blog Posts
Book Review – SQL Server Internals: In-Memory OLTP
In-Memory OLTP – a potential game changing technology
Every once in a while a technology comes out that has the potential to...
2015-02-24
613 reads
Book Review – SQL Server Internals: In-Memory OLTP
In-Memory OLTP – a potential game changing technology
Every once in a while a technology comes out that has the potential to change things dramatically. In-Memory OLTP (Hekaton) is one...
2015-02-24
9 reads
Book Review – SQL Server Internals: In-Memory OLTP – Detailed Notes
Here are my unedited chapter notes:
Chapter 1Chapter 2Collation – current version requires BIN2 on character index columns. Best to do so...
2015-02-24
760 reads
Book Review – SQL Server Internals: In-Memory OLTP – Detailed Notes
Here are my unedited chapter notes:
Chapter 1 Chapter 2 Collation – current version requires BIN2 on character index columns. Best to do...
2015-02-24
4 reads
Check Out Josh’s Blog on Creating Percentile in DAX
I would like to introduce a “new” blogger to you. Joshuha Owen has restarted his blog and will be covering...
2015-02-24
747 reads
How easy to determine table dependencies ? TIP # 86
Determine the table dependencies is challenging sometime but we can easily resolve this by using a simple stored procedure which ...
2015-02-24
517 reads
How to Encrypt password in SQL Server ? TIP #87
Security is always a concern for every database developer. How to secure valuable information is one of the major and...
2015-02-24
420 reads
Identifying Blocking via Extended Events
There are a number of ways that you can identify blocking that is occurring in your SQL instance. You can...
2015-02-24
356 reads
Outlier Detection with SQL Server, part 3.5: The Modified Thompson Tau Test
By Steve Bolton
…………Based on what little experience I’ve gained from writing this series on finding outliers in SQL Server databases,...
2015-02-24 (first published: 2015-02-14)
8,778 reads
Blogs
Merry Christmas
By John
Today is Christmas and while I do not expect anybody to actual be reading...
Self-Hosting a Photo Server the Whole Family Can Use
By Bert Wagner
Until recently, my family's 90,000+ photos have been hidden away in the depths of...
Start with the FabricTools PowerShell module
By Kamil
Managing Microsoft Fabric at scale quickly becomes painful if you rely only on the...
Forums
UNISTR Escape
Comments posted to this topic are about the item UNISTR Escape
Celebrating Tomorrow
Comments posted to this topic are about the item Celebrating Tomorrow
SQL Art: I Made a Christmas Card In SSMS
Comments posted to this topic are about the item SQL Art: I Made a...
Question of the Day
UNISTR Escape
In SQL Server 2025, I run this command:
SELECT UNISTR('*3041*308A*304C\3068 and good night', '*') as "A Classic";
What is returned? (assume the database has an appropriate collation)
A: 
B: 
C: 
See possible answers