The Best High Availability
Clustering is often the first choice for high availability, but is it the best choice? A lot of people think so, but Steve Jones has other thoughts.
Performance Testing SQL 2008’s Transparent Data Encryption
The focus of this article is to test the performance of SQL Server 2008's Transparent Data Encryption. How does it perform compared to a database without encryption? How does the mix of SELECT/INSERT/UPDATE affect the performance results?
Secure Storage
How do you keep the passwords and keys for encrypted data safe? Steve Jones comments on the challenges of working with keys and passwords.
Secure Storage
How do you keep the passwords and keys for encrypted data safe? Steve Jones comments on the challenges of working with keys and passwords.
Secure Storage
How do you keep the passwords and keys for encrypted data safe? Steve Jones comments on the challenges of working with keys and passwords.
Starting Conversations - Part 2
A week or so ago I posted a note about reading How to Start a Conversation and Make Friends (worth reading), and I had a comment posted to the blog by author Don Gabor. I like that kind of follow up, so I sent Don a note and a ...
Take Advantage of In-Memory Analytics
Fast analysis, better insight and rapid deployment with minimal IT involvement: these are among the benefits of in-memory analytics, but different products are appropriate for different environments. Read our in-depth report on in-memory technologies.
All-Access
A licensing scheme from Embarcadero catches Steve Jones' eye. He comments on a great way for the company to work with customers.
Ethics and Leaders - Database Weekly (Apr 27, 2009)
This week Steve Jones discusses ethics and leadership in IT.
Convert Implicit and the related performance issues with SQL Server
I was a running a routine query using an equal operator on the only column of the primary key for a table and I noticed that the performance was terrible. These queries should have been flying because all I was doing was retrieving one row of data which should have been doing an index seek. When I looked at the query plan it was doing a scan instead. This tip shows you what I found and how to resolve the problem.
Blogs
The Agent Era: When “How do I…?” Replaces “Where do I click?”
By Arun Sirpal
After a year away getting to grips with AI and its application across the...
Beware of Generic SQL Server License Keys (What to Use Instead)
By SQLPals
Beware of Generic SQL Server License Keys (What to Use Instead) ...
On Speaking Well
By Brian Kelley
Professor Patrick Winston of MIT used to give a one-hour talk about how to...
Forums
Creating a JSON Document II
Comments posted to this topic are about the item Creating a JSON Document II
Backing Up Azure Key Vault EKM Key: Stairway to TDE Level 6
By VishnuGupthanSQLPowershellDBA
Comments posted to this topic are about the item Backing Up Azure Key Vault...
Every Database Has Problems
Comments posted to this topic are about the item Every Database Has Problems
Question of the Day
Creating a JSON Document II
I want to create a JSON document that contains data from this table:
TeamID TeamNameCity YearEstablished 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960If I run this code, what document(s) is/are returned?
SELECT json_objectagg( n.city : n.TeamName) FROM dbo.NFLTeams;See possible answers