Creating Azure SQL Data Warehouse Databases
Learn how you can create an Azure SQL Warehouse database quickly and easily.
The Cost of Database Downtime
Do you know what the cost is for your database going down? Maybe more interesting, is do you want to know?
Integrating DACPAC deployments of Azure SQL Database with Visual Studio Team Services
One of the concepts that has recently been growing rapidly in popularity, in the context of cloud technologies, is DevOps. In this article, Marcin Policht looks at using DevOps principles in regard to Azure SQL Database deployments. To implement some of the more common DevOps practices, he will rely on Visual Studio Team Services.
AI Helpers or Replacements
The future will see more of our data used in machine learning and other AI-like systems. Is that something we want?
Nuance of datetime data type in SQL Server
One of the most confusing data types in SQL Server is the datetime datatype.
Harmful, Pervasive SQL Server Performance Myths
Aaron Bertrand begins a new series around disproving prevalent myths regarding SQL Server performance.
The Value of Your Personal Data
Today Steve Jones discusses the idea of data value, and what it might mean to you, personally.
Automating database deployments to and from source control using SQL Compare and PowerShell
Phil Factor shows how you can use the SQL Compare Pro command line with PowerShell to automate the task of getting a new database into version control, creating a new database build script, and creating a database migration script.
Dynamic SSRS report documentation via a ReportServer.dbo.Catalog query
This article demonstrates a method of generating SSRS report documentation by using an SSRS report that queries the ReportServer.dbo.Catalog table.
Blogs
Track SQL Server Configuration Changes Using the Error Log
By SQLPals
Track SQL Server Configuration Changes Using the Error Log If you...
Data Engineering Books Worth Having on Your Shelf (or your tablet)
Good documentation gets you started. Good books get you deep. After years of working...
SSMS Evaluation – future ready
By Vinay Thakur
In previous posts, we looked at the SQL Server engine. for us DBAs, the...
Forums
Alamat kontak resmi BCA KCU BUKIT BARISAN Telp:0817866887
WhatsApp:0817866887 Jl. Bukit Barisan No.3, Kesawan, Kec. Medan Bar., Kota Medan, Sumatera Utara 20111
Alamat kontak resmi BCA KCU BUKITTINGGI Telp:0817866887
WhatsApp:0817866887 Jl. Sudirman No.59, Bukit Cangang Kayu Ramang, Kec. Guguk Panjang, Kota Bukittinggi, Sumatera...
SQL Server Showing Out of Space But Plenty of Drive Space
We have a SQL Server installed. We have a 500GB drive for the database....
Question of the Day
Creating a JSON Document IV
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