Have Availability Groups Gotten Easier Lately?
2018 is coming to an end, and AGs have been out for 6 years. They're stable now, right?
2018-12-28
2,749 reads
Additional Articles
Building a Collaborative Platform to Speed up Data Analysis
In this article, Feodor demonstrates the architecture, workflow, and some of the challenges of a collaborative platform (cloud foundation) for speeding up enterprises in their search for analytical power. He uses an example from the EA Billing solution, which was presented in the previous articles of the series.
2018-12-27
2,332 reads
Auto Generate NetBackup script to backup SQL Server databases
In this tip we look at how we can use SQL Server to auto generate a backup script for NetBackup to make sure we backup the required databases.
2018-12-26
1,876 reads
SQL Server 2019 Community Technical Preview (CTP) 2.1 is Available Now
Microsoft announced the release or CTP 2.1 for SQL Server 2019. This is the second CTP released for SQL Server 2019, and it has lots of new exciting features, like " UDF inlining". Read on to find out more!
2018-12-25
2,797 reads
Building Better HTML Forms in Vanilla-JS
Creating forms is one of the most basic skills for a web developer. It’s easy to, do but achieving the best user experience takes some work. In this article, Dino Esposito demonstrates how to improve the usability and functionality of web forms.
2018-12-24
2,345 reads
Disable Data Sync for SQL Server Merge Replicated Table via Publisher
Learn how to stop the data sync process in SQL Server Merge Replication on a large table during maintenance windows.
2018-12-21
2,104 reads
Data Quality
Problems with data quality are easier and cheaper to prevent than to solve later. In this article, Joe Celko talks about data quality and where the issues tend to happen.
2018-12-20
2,693 reads
Getting Sneaky With Forced Parameterization
In which Erik works around the documented limitations with CROSS APPLY.
2018-12-19
2,722 reads
SQL Server AlwaysOn Availability Groups Monitoring and Alerting - Part 2
In this tip we look at some additional scripts that you can use to monitor your SQL Server AlwaysOn Availability Groups.
2018-12-18
2,855 reads
Power BI Introduction: Visualizing SQL Server Audit Data — Part 9
SQL Server Audit is a powerful feature that can help you comply with regulations such as HIPAA and SOX, but it’s not easy to view the data collected. In this article, Robert Sheldon demonstrates how Power BI can be used to view and filter SQL Server Audit results.
2018-12-17
3,047 reads
Blogs
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...
Deploying AI in logistics (the unfiltered version)
A conversation with Jan Laš, CIO at HOPI, about what deploying a data agent...
Forums
Kantor BCA KCP Gajah Mada Tegal Telp/wa 085169998803
Telp/wa 085169998803 Jl. Gajah Mada. 41A & 41B, Mintaragen, Kec. Tegal Tim., Kota Tegal,...
BCA KCP Senayan City Hubungi:0851•8812•0691
BCA KCP Senayan City Hubungi:0851•8812•0691 Mall Senayan City Unit 6-09A, Jl. Asia Afrika Lot...
BCA KCU PANGERAN JAYAKARTA Hubungi:0851•8812•0691
BCA KCU PANGERAN JAYAKARTA Hubungi:0851•8812•0691 Jl. P Jayakarta Komp. No.127, Mangga Dua Sel., Kecamatan...
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