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.
Changing SQL Server Collation After Installation
In some scenarios we can find different SQL Server collations between the server instance and its databases. Douglas P. Castilho explains a simple way to correct the collations in a few steps.
Blogs
T-SQL Tuesday #198 Roundup: How Do You Detect Data Changes?
Thank you to everyone who participated in T-SQL Tuesday #198! When I wrote the...
Optimizing Redshift Performance by Configuring WLM Queues
Efficient query performance in Amazon Redshift often comes down to how well you manage...
PowerShell Strikes Back: Return of the Loop
By gbargsley
Welcome back to PowerShell Strikes Back. We’re three weeks in, and the training is...
Forums
BCA KCU SCBD No. telp:087757645171
Whatsapp:087757645171 Equity Tower, Ground Floor, Unit D & Lantai 8, Unit E, Jl. Jenderal...
BCA KCU A. YANITelepon 083179431638
WhatsApp083179431638Jl. A. Yani No.656-658, Cicaheum, Kec. Kiaracondong, Kota Bandung, Jawa Barat 40282
BCA KCP Wahid Hasyim No.Telpon 087781685647
Whatsapp 087781685647 Jl. K.H. Wahid Hasyim No.82, RT.15/RW.3, Kb. Sirih, Kec. Menteng, Kota Jakarta...
Question of the Day
QUOTENAME Quote Parameters
When I use QUOTENAME(), I can optionally provide the character used to surround the string in the result. Can I use any character?
See possible answers