Regaining access to SQL server after changing the domain
If you changed your domain and have lost control over the SQL server or have been blocked from logging in , this article talks about it
2014-10-23
14,183 reads
Yousef Ekhtiari
The Truth Table
Truth tables are an important part of working with logical values in SQL Server. Yousef Ekhtiari brings us some T-SQL that can help you construct those many variable truth tables and ensure you are getting the results you expect.
2008-03-07 (first published: 2007-04-19)
11,753 reads
Usages of CONTEXT_INFO
How many of you have ever used SET CONTEXT_INFO in your SQL Server applications? Chances are it is not something you have been exposed to, but new author Yousef Ekhtiari brings us an example of how this particular construct can be used in your application.
2007-12-18 (first published: 2006-12-21)
16,008 reads
Searching Words and Phrases in a Rich Text Field
Searching for data in a database is something we all do constantly, but few of us use the Full-Text Search features of SQL Server. Yousef Ekhtiari brings us a look at how you can get around some of the limitations of this feature and possibly use it in your application.
2007-07-24
6,317 reads
Some Usages for XML
While SQL Server 2005 has greatly expanded the XML capabilities of the platform, many DBAs are still not familiar with or comfortable
with using XML in their coding. Yousef Ekhtiari brings us a new article that looks at a basic use of XML in inserting data into a table.
2007-02-22
7,351 reads
Blogs
Check your regions people
Today I was having a nice discussion with some colleagues about Fabric and pricing/licensing...
Using Git Prune–#SQLNewBlogger
By Steve Jones
As I’ve been working with SQL Saturday and managing changes to events, I’ve accumulated...
Microsoft Purview new data governance features
By James Serra
Starting last week is a rollout of the public preview of a new and...
Forums
Read Only Replica in SQL Server Standard
By Stewart "Arturius" Campbell
Comments posted to this topic are about the item Read Only Replica in SQL...
Identifying Customer Buying Pattern in Power BI - Part 1
Comments posted to this topic are about the item Identifying Customer Buying Pattern in...
Backup of encrypted databases failing
I've had some backups of my encrypted databases failing with the error "BACKUP 'DBName'...
Question of the Day
Read Only Replica in SQL Server Standard
Our environment runs using SQL Server Standard. We are implementing Availability groups. Our database has been experiencing high read volumes, so I want to let the application read the Synchronized Secondary replica, as I read that HADR does this. Can we implement this?
See possible answers