Git Anatomy
In this article, Dino Esposito gives an overview of git explaining repository, commit, and branch.
2020-11-05
In this article, Dino Esposito gives an overview of git explaining repository, commit, and branch.
2020-11-05
In this tip we walk through an exercise of developing a data model based on the characteristics of the data requirements.
2020-11-04
SQL Monitor v11 introduces native support for SQL Server instances hosted on Amazon Web Services (AWS) Relational Database Service (RDS) platform. In this post we'll explore the metrics you need to keep an eye on with Amazon RDS SQL Server monitoring, how a monitoring tool will help you manage the process of migrating databases to the Amazon cloud, as well as measures its success, and how SQL Monitor allows you to monitor all your SQL Server instances, wherever they are hosted, through a single pane of glass.
2020-11-04
No matter what you need, Azure probably has a solution. In this article Diogo Souza demonstrates how to host a static web page in Azure in just a few steps with Azure Blob Storage and Azure CDN.
2020-11-03
In this article we look at how to manage Power BI workspaces using PowerShell cmdlets.
2020-11-02
Phil Factor reviews the major features of SSMS IntelliSense and autocomplete and then explains how SQL Prompt fills in the gaps, and how to use to use the two in tandem to 'get the best of both worlds'.
2020-11-02
In this article, Edward Pollack describes some of the issues when querying against remote data sources. He covers remote SQL Servers and also connecting to a PostgreSQL database.
2020-10-30
In this article we look at how to build a custom stored procedure template that can be used in either SSMS or Visual Studio for all new development.
2020-10-29
With remote working still encouraged around the world, there is a need to ensure that operations teams have full visibility of your estate, not just your production servers. If your engineering teams have access to secure development and testing servers, deployment issues are caught before they reach production. Find out how to keep communication flowing between DBA and development teams in this free whitepaper. Read the whitepaper here.
2020-10-29
Oracle has been established as one of the top database systems used in enterprises throughout the world. In this article, Cynthia Dzikiti describes her career as an Oracle application developer and covers some of the benefits of Oracle.
2020-10-28
By Brian Kelley
If you are considering any of the ISACA AI certs like the Advanced Artificial...
By ChrisJenkins
Are you currently using Microsoft Fabric or considering migrating to it? If so, there...
By SQLPals
Track SQL Server Configuration Changes Using the Error Log If you...
Tlp/Wa_Cs:0817-866-887 Komplek Apartemen Grand Kartini, Ruko. 18, Jl. Kartini Raya No.57, Daerah Khusus Ibukota...
Tlp/Wa_Cs:0817-866-887 Jl. Sultan Agung No.115, Gajahmungkur, Kec. Gajahmungkur, Kota Semarang, Jawa Tengah 50232
We have a SQL Server installed. We have a 500GB drive for the database....
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