Error: No mapping between account names and security IDs was done
I recently decided to move over to Windows 8 so I can take advantage of Hyper-V and get off a...
2012-09-04
11,096 reads
Bradley Schacht
The INSTALLSHAREDWOWDIR command line value is not valid.
I was recently making some changes to my laptop setup and installing SQL Server 2008R2 and SQL Server 2012 directly...
2012-08-28
1,554 reads
Internal error: Invalid enumeration value. Please call customer support! is not a valid value for this element.
If you have done a lot of work with SQL Server Analysis Services (SSAS) you may have seen this message:
We’ve...
2012-08-21
1,168 reads
Modify Host File on Windows 7
Modifying the Windows host file can be a great way to ensure that you don’t accidentally modify production while doing...
2012-08-14
1,169 reads
View Flat File Contents Using PowerShell
We have all been there; you need to take a look at the data inside a file. Sure you can...
2012-08-07
1,780 reads
Exporting Data Using BCP
BCP, or bulk copy program, has been around in SQL Server for a long time. It is a great way...
2012-08-03 (first published: 2012-07-31)
10,065 reads
Color Expressions in SSAS Calculations
Color expressions in SSAS allow you to build an MDX expression to control the color of text displayed in a...
2012-07-27
1,676 reads
Office 2013 and SharePoint 2013 Beta
If you follow anything outside the regular SQL Server world coming from Microsoft it should be Office and more importantly...
2012-07-17
1,336 reads
PowerPivot for Excel 2013
The preview for Office 2013 is live!! You can hop over to the Microsoft website and grab it here: http://www.microsoft.com/office/preview/en/try-office-preview. Naturally...
2012-07-17
5,290 reads
PowerPivot for Excel Now 2012 Only
I’m not exactly sure when this happened, but it looks like Microsoft has moved past the PowerPivot 2008R2 and PowerPivot...
2012-07-17
860 reads
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