Being a database administrator is much more than knowing how to install SQL Server and set up a database. One of the most important responsibilities is being proactive by monitoring the instances in their care. But, what should be monitored? Here are the top five things to monitor when you are a SQL Server DBA
2018-08-09
5,799 reads
Although there are many different things that can be done to improve the performance of a database system, creating an index is the main tool in every DBA's toolbox that is used when we are trying to improve the performance of a query.
2018-08-08
4,545 reads
In the world of paradigm shifts, many organizations are looking at the prospect of a technology migration, where capabilities are moved to a new set of technologies, supporting and enabling the business for the future. On other hand, a technology or platform may reach the end of its life for other business reasons, like ease of use, increased cost, etc.
2018-08-07
3,088 reads
Agile methodology for software delivery is accepted at many organizations but is not used everywhere. In this article, Mohammad Rizvi gives advice on how to successfully implement a software project in a non-Agile environment.
2018-08-06
3,773 reads
Pinal Dave explains how missing index hints are like restaurant appetizers.
2018-08-03
5,219 reads
Many organizations are moving to Azure and other cloud providers. Understanding how resources are being used and what is spent is very important. In this article, Feodor explains his solution for automating the collection of the Enterprise Agreement billing from Azure into an Azure SQL Database where it can be analyzed.
2018-08-02
3,296 reads
Do you need a way to roll-up multiple rows into one row and one column. You know you can roll-up multiple rows into one row using Pivot, but you need all of the data concatenated into a single column in a single row. this tip looks at a simple approach to accomplish this.
2018-08-01
4,826 reads
Global distribution of updatable data stores is one of the more challenging goals that software designers and architects have been struggling with over the years. Addressing this challenge has become increasingly pressing as the rapid growth of cloud technologies increased the need for deployments capable of spanning multiple geographical areas. In this article, we will provide an introduction to global distribution-related functionality in Cosmos DB.
2018-07-31
3,325 reads
Data for Power BI can come from many sources, but often the data is hosted in SQL Server. In this article, the fifth of the series, Robert Sheldon demonstrates how to work with SQL Server data in Power BI Desktop, including relationships between tables.
2018-07-30
3,913 reads
Starting to translate sp_BlitzCache into the cloud.
2018-07-27
4,046 reads
By Steve Jones
One of the language changes in SQL Server 2025 that I’ve seen a lot...
By Steve Jones
I hosted this month, but I decided to put my own entry in as...
By Chris Yates
I get asked a lot about why or how I began working with databases...
Nomor telepon call center Agoda: (0811) 222143 atau (0811) 222611. Hubungi Untuk Refund Dan...
Layanan Bantuan Planggan 24 Jam Call Center Agoda Indonesia Hubungi WhatsApp: 0811 222 143....
Untuk melakukan klaim cashback, Silahkan menghubungi Agoda melalui WhatsApp di nomor: 0811 222 143.
I get a new SQL Server instance from my build team. How can I tell if the instance was installed using a slipstream installation later?
See possible answers