Dynamic data masking provides a simple way to implement obfuscation of private data. However it's important to understand the limitations, and to keep in mind that it is not true encryption and that the data cannot be protected in all scenarios. Aaron Bertrand explains.
With the recent acquisition of Datazen by Microsoft, if you have SQL Server 2008 Enterprise Edition or later with Software Assurance, you can download and use Datazen to create visually appealing dashboards for mobile devices across all the major platforms at no additional cost. In this article, Arshad Ali demonstrates creating data source, data views and then creating dashboards using them with Datazen Publisher.
It seems the software industry doesn't do a good job of planning and estimating software development efforts.
Are you an ISV and/or commercial software developer using SQL Server? Are you considering how to upgrade your application to take advantage of new SQL Server 2014 and would like to know more about how Microsoft can help your migration and sales/marketing efforts? Register using this invitation key 9ABED3
Many developers get the misleading perception that ASP.NET SignalR merely helps to build a chat application or provides live updates of news, stock and score tickers. In reality, ASP.NET SignalR has a broader scope. In this article, Dino Esposito covers a few techniques to make selective SignalR updates to pages behind an ASP.NET authentication layer.
Create a professional looking HTML table from T-SQL, not SSRS.
Does it make sense to avoid FKs for use other architectures in software development? Steve Jones isn't sure a a general rule this is the case.
By Steve Jones
This month we have a new host, Meagan Longoria, who graciously agreed to help...
By Steve Jones
I’m at the UK Redgate office today, meeting with senior leaders in all areas...
Optimizing Azure SQL Database performance often begins with identifying the most resource-intensive queries. Understanding...
I’m currently researching the best wireless credit card terminal for a growing business and...
Comments posted to this topic are about the item Creating a JSON Document IV
By VishnuGupthanSQLPowershellDBA
Comments posted to this topic are about the item Restoring Azure Key Vault Keys...
I have this data in a table called dbo.NFLTeams
TeamID TeamName City YearEstablished ------ -------- ---- --------------- 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960 5 49ers San Francisco 1946 6 Broncos Denver 1960 7 Seahawks Seattle 1976 8 Patriots New England 1960If I run this code, how many rows are returned?
SELECT YearEstablished, json_objectagg(city : TeamName) FROM dbo.NFLTeams GROUP BY YearEstablished;See possible answers