Our blog isn’t just a record. It’s a resource.
We know how difficult managing a database can be. Luckily, we’re here to share our experiences troubleshooting, building, improving, and operating them. Browse blogs below, and feel free to comment!
SQL Error 8623: What To Do To Handle It And Get Going Again
What do you do when something that has been working for months suddenly stops working and gives you a SQL Error 8623? Worse yet, what do you do when that error message tells you to either rewrite your extremely complex query or spend some cash on a Microsoft customer...
read more
SQL Operations Studio is Microsoft’s Push to Bridge the Gap
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...
read more
Why won’t SQL accept my value? Msg 8115, Level 16, State 8
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...
read more
Firewalls at the database Level for Azure SQL
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...
read more
SQL Server Collation
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...
read more
Seven SQL Performance-Killers to Avoid in Db2
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...
read more
Remote Desktop Connection Error: CredSSP Encryption Oracle Remediation
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...
read more
SQL Server Services
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...
read more