SQL Saturday #42 - Columbus Call for Speakers
If you want to speak at this June 26 event, submit a session now.
April Webinar: MVP Series
Free webinar training brought to you by Pragmatic Works, WROX, SQL Server Central, and SQL Server Magazine. The April Series will run from April 20 - April 29, 2010. Register now to reserve a place.
Speed Racer
Speed is critical. That's the theme for today's editorial, using the NYSE as an example.
Using Full Text Search in SQL Server 2008
SQL Server 2008 Full-Text Search feature can be used by application developers to execute full-text search queries against character based data residing in a SQL Server table
No One is Safe
A funny example of SQL Injection has Steve Jones reminding us that every application needs to protect itself.
SQL Server Ranking Functions
A new article from Wayne Sheffield that examines the ranking functions in SQL Server. Learn how you can use ROW_NUMBER(), NTILE(), RANK(), and DENSE_RANK() in your applications.
Connecting Your Zend Framework Application to Microsoft Azure
After years of using PHP content management systems and a variety of custom-built PHP content management solutions, PHP Guru Jason Gilmore concluded that no solution effectively offered both the fundamental features of a content management system (CMS) and the flexibility of a web framework.
More Support for Customers
A change in the support policy from Microsoft is a good thing, Steve Jones notes. Now you can still get help if you haven't been applying service packs.
New SQL Saturdays Coming
Quite a few new SQL Saturday events were announced recently in Louisville, Phoenix, and Raleigh.
Smart Virtualization
With so many people looking at virtualizing their environments, it's easy to assume it's easy to get done. Steve Jones, however, points out some advice from a very performance oriented company: the NYSE.
Blogs
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...
Monday Monitor Tips: Oracle Custom Metrics
By Steve Jones
One of the popular features of Redgate Monitor has been the ability to add...
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