How to use Azure SQL Database features and settings
Vitor Montalvao explains how to work with the basic configuration settings for a SQL Azure database from the Microsoft Azure portal itself.
2017-12-15
4,054 reads
Additional Articles
Questions About the GDPR That You Were Too Shy to Ask
The General Data Protection Regulation (GDPR) will affect organisations in countries around the world, not just those in Europe. The GDPR regulates how personal data is stored, moved, handled, and destroyed. Not following the regulation will lead to dire consequences for your organisation. As a data professional or developer, you may have many questions and might be wondering how it will affect the way you will do your job. William Brewer answers common questions about the GDPR that you were too shy to ask.
2017-12-14
3,329 reads
Partition Level Locking: Explanations From Outer Space
Erik Darling partitions the Stack Overflow database, then uses sp_WhoIsActive's @get_locks = 1 parameter to demo locking.
2017-12-13
3,150 reads
Checking SQL Server with Policy-Based Management
Policy-Based Management, a feature of SQL Server, is a flexible tool that can help DBAs manage one or more SQL Server instances. It's used for monitoring and enforcing a standard set of policies for SQL Server throughout an organization. While there are many built-in conditions from which to choose, Dennes demonstrates how to set up a custom policy as well as a standard one. Viewing the policy status over many servers can be tedious, so he also explains how DBAs can evaluate the states of multiple servers with just one glance.
2017-12-12
2,640 reads
Azure SQL Database Virtual Network Service Endpoints and Rules
One of the most commonly requested Azure SQL Database features has been support for more granular control of server-level firewall settings. A recently announced public preview of Azure SQL Database and Data Warehouse VNET service endpoints and rules promises to address this limitation.
2017-12-11
2,346 reads
How Much Data Has Changed Since Your Last Full Backup
Have you ever wanted to know how many pages in your database have changed since the last full backup? If so, then you will be glad to hear that the SQL Server 2017 version of the DMV, sys.dm_db_file_spavce_usage, has a new column named modified_extent_page_count, which shows the number of pages that have changed since the last full backup.
2017-12-08
3,696 reads
SQL Server R Services: Working with Multiple Data Sets
Although it is easy to use SQL Server R Services to create R scripts that incorporate SQL Server data by passing in a T-SQL query as an argument when calling the sp_execute_external_script stored procedure, you are limited to that one query, unless you pass additional data directly between R and SQL Server via CSV files. It is simple to do, and opens up many additional opportunities for data analysis. Robert Sheldon explains how.
2017-12-07
3,542 reads
Correlation Analysis using Correlation Plot in Power BI Desktop
Power BI provides correlation plot visualization in the Power BI Visuals Gallery to create Correlation Plots for correlation analysis. In this post, Siddharth Mehta shows how to create a correlation plot in Power BI Desktop using a sample dataset of car performance.
2017-12-06
2,780 reads
Book Review: Database Reliability Engineering by Campbell & Majors
Brent Ozar explains why DBAs should read this book about the future of database administration at scale.
2017-12-05
3,193 reads
Importing JSON Data from Web Services and Applications into SQL Server
To support many applications, it makes sense for the database to work with JSON data, because it is the built-in way for a JavaScript or TypeScript application to represent object data. It can mean less network traffic, looser coupling, and less need for the application developer to require full access to the base tables of the database. However, it means that the database must do plenty of checks first before importing. Phil Factor explains how it can be easily done.
2017-12-04
4,513 reads
Blogs
Future IT Roles – Agentic Architect and AI Boom!!
By Vinay Thakur
These days everything is changing to AI World, IT roles are getting changed and...
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them Introducing PlanTrace — a free, browser-based...
A Cloud Dependency Failure from Amazon
By Steve Jones
I went to sleep while reading a Kindle book on my phone. I know...
Forums
BCA KCP Kapuk Kamal Hub.0851•8812•0691
BCA KCP Kapuk Kamal Hub.0851•8812•0691 No. 1A, Jl. Kapuk Kamal Raya Blok DEF, Kamal...
BCA KCP Taman Palem Lestari Hub.0851•8812•0691
BCA KCP Taman Palem Lestari Hub.0851•8812•0691 Komp. Perum Jl. Taman Palem Lestari No.C5 No....
BCA KCP Kebon Jeruk Tlpn/wa (0853)73737551
Komp, Jl. Taman Kb. Jeruk Jl. Meruya Ilir Raya No.Blok B 6, RT.1/RW.9, Srengseng,...
Question of the Day
Creating a JSON Document III
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 TOP 2
json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers