Our blog is an invaluable resource for anyone struggling with the challenges of managing a database, applications, or clouds.
We understand the difficulties involved in troubleshooting, building, improving, securing, and operating these platforms,
and we’re here to share our insights and expertise with you. Browse through our collection of blog posts below,
and don’t hesitate to leave your comments and feedback.
Many people have heard that the traditional DBA role is changing. This is one of the hottest topics out there right now. One way that Microsoft is moving forward with this way of thinking is SQL Operations Studio (SOS). When it was first released in preview mode, many...
Arithmetic overflow error; converting it to data type numeric Understanding Decimal and Numeric arguments The problem: Entering a number in a field that is data type of decimal (5, 3) works for values like [85.200] but not others like [500]. The Cause: The arguments...
Azure SQL has introduced the ability to set firewall rules at the database level. A database firewall is different than the server firewall which can be configured via the Azure Portal. The database firewall gives you the ability to not only limit connections at the...
What is Collation? Collation is a set of rules dictating how each group of characters within SQL Server is treated. A list of collations and their definitions can be found using the following query. SELECT name, description FROM sys.fn_helpcollations() WHERE...
How Db2 Handles SQL SQL is a powerful language in the hands of the right RDBMS. One of SQL's strengths is that you specify what data you want returned without specifying what file, disk, san, or sector that data is stored on. Because we describe the result set we...
Connection Error Details While attempting to make an RDP connection to another Windows client the following error may be encountered. Typically this error is encountered when attempting a connection to an Azure hosted client, it has also been encountered when...
A service is a program that runs in the background that does not require any user interaction. Some examples of services are the drivers for your keyboard and mouse, your antivirus software, and the SQL Server Service. The SQL Server Service is the executable process...
For some time now, SHA-1 has not been allowed to be issued from CA’s with few exceptions. This was due to a large catalog of evidence suggesting that SHA-1 was less secure than acceptable. Starting with SQL 2016 self-signed certificates are issued using SHA-2,...
Indexes are Good for Performance Generally speaking, DBAs and developers spend a fair amount of their performance time trying to find which indexes to add to a database to improve performance. If a specific query is having performance problems, one of the strongest...
These are the ten most important commands to know as a DBA working in a Linux environment. This is not specific to any Linux distribution or single database platform necessarily, however, I have added some really good links specific to MSSQL Server running on Linux at...