There are times when a Developer or DBA needs to determine the best performance options with transferring data through a linked server from point A to point B but may not know the best way to do it. In the following example, I am going to show you the differences...
Directory Tree: In Microsoft (MS) Windows, the C:\ drive is where your operating system (OS), programs, and other files typically reside. In Linux, this is known as the "root" directory and is represented with the forward slash character ( / ). In Windows, your...
Creating a new database in SQL server is a very common and general task for professionals dealing with SQL in an environment. There could be different ways of creating a new database. You can literally run a basic create DB statement, which will follow the default...
Replication is a great way to copy tables/data from one server to another so you can do reporting on the second server. Within replication tables, stored procedure, functions, views, and indexed views are called articles but in this blog tables and articles mean the...
AlwaysOn Availability Group (AG) is one of my favorite features in SQL Server and is worth considering when using SQL server 2012 or greater. One of the nicest features in AlwaysOn AG is that in a single subnet environment it can be totally transparent to your...
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...
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...