SQL Prompt Tips #1 - Selecting in the Object Explorer
A quick tip to help you get the most out of SQL Prompt.
2015-10-14 (first published: 2012-05-01)
1,663 reads
Articles
Azure SQL Database - Row-Level Security
One of the benefits of using Azure-based Platform-as-a-Service and Software-as-a-Service offerings, is considerably quicker access to newly developed capabilities. In this article Marcin Policht focuses on row-level security, included in both Azure SQL Database V12 and SQL Server 2016 Community Technology Preview 2 (CTP2).
2015-10-14
3,552 reads
Find Permission Changes In The Default Trace
Learn how to find who has changed permissions from the default trace
2015-10-13
11,887 reads
SQL Server 2014 and Windows Azure Blob Storage Service: Better Together
This technical article will cover in depth SQL Server 2014 Data Files on Azure Blob storage service, starting from step-by-step configuration
2015-10-13
2,489 reads
Power BI Desktop Web Queries to Screen Scrape Data from Websites
I have heard the new Power BI Desktop can screen scrape data off websites; how does that process work?
2015-10-12
3,473 reads
How efficient is your covered index?
Observing an index seek utilizing a composite index within SQL execution plan might be more than meets the eye – you should look again.
2015-10-09 (first published: 2013-08-12)
14,497 reads
Storing Passwords in a Secure Way in a SQL Server Database
Measures such as using special characters and numbers within a password are of little use to security if passwords are then stored in an insecure way. Sergey Gigoyan explains how to encrypt and store passwords in a SQL Server database.
2015-10-09
5,878 reads
SQL and R
There is plenty that is novel and perhaps foreign to a new R user, but it's no reason to abandon your hard-earned SQL skills! In this article, Casimir Saternos explains that not only can you easily retrieve data from SQL Sources for analysis and visualisation in R, but you can also use SQL to create, clean, filter, query and otherwise manipulate datasets within R, using a wide choice of relational databases.
2015-10-08
6,620 reads
Follow-Up on Cursor Options
In this follow-up to a previous article, Aaron Bertrand reiterates that – while you should never just accept the defaults – you really should think about which options are most applicable to your scenario.
2015-10-07
5,494 reads
Shorten Audits, Tighten Security with Minion Enterprise
Minion Enterprise can help you with security management in an enterprise.
2015-10-06
752 reads
Blogs
The Book of Redgate: Spread across the world
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
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...
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