There are only two hard things in Computer Science: cache invalidation and naming things -- Phil Karlton The recommendations in this article are not the ultimate truth. Please consider this article as a rule template that you can adapt to your needs. A naming convention is a set of rules for choosing the character sequence to […]
You want to use SQL Compare or SQL Change Automation (SCA) to create or update a database, and at the same time ensure that its data is as you expect. You want to avoid running any additional PowerShell scripting every time you do it, and you want to keep everything in source control, including the data. You just want to keep everything simple. Phil Factor demonstrates how it's done, by generating MERGE scripts from a stored procedure.
The other day, a friend asked me if Microsoft is discontinuing SQL Server Reporting Services (SSRS) now that Power BI is the premier MS reporting and dashboarding tool. It seems like more organizations are finding fewer reasons to use SSRS due to the ease of use and features of Power BI. Despite all the news about the general availability of SQL Server 2019, I had not heard any recent news about SSRS, so I could only say that I didn’t know.
The Microsoft Threat Intelligence Center actively works to track the world's hackers and help warn us when we become the object of their attacks.
Improving the response times of queries in SQL Server is a common task for DBAs and developers. In this article, we will talk about how you can effectively use covered indexes to improve your performance, and when you should use them.
Read on to step through the process of implementing Azure Data Factories.
Steve looks at a number of tools that you should spend time learning and building a level of comfort that enables you to use them in your daily work.
In this article, learn how to identify performance tuning opportunities using Extended Events.
Today Steve wonders if your company is understanding of your human frailty.
Giorgi Abashidze explains how his team use SQL Compare Command line to automate database deployments for their customers, without having access to the real staging or production databases, merely by using our development database contained under TFS Source Control.
Every PostgreSQL migration eventually hits the same fork in the road. The database is...
By Steve Jones
I’m off on vacation today. Which is a little weird as I just got...
By Arun Sirpal
Every DBA has a box like this. Sitting untouched for months. Nobody’s proud of...
WA:08218154393 Jl. Brawijaya No.8, Pocanan, Kec. Kota, Kota Kediri, Jawa Timur 64123
Wa:0817819444 Jl. Arjuna Utara No.Kav. 8 A, RT.1/RW.1, Tj. Duren Sel., Kec. Grogol petamburan,...
Jl. Radio Dalam Raya No.5 B-C, RT.9/RW.13, Gandaria Utara, Kec. Kby. Baru, Kota Jakarta...
Can I set Accelerated Database Recovery on tempdb?
See possible answers