#0357 – SQL Server – Best Practices – Avoid Implicit conversions as they may cause unexpected issues (Part 01)

Often, I see database developers relying on implicit conversions more than they should. Implicit conversions can use unexpected problems if not used judiciously.

In this post, I will demonstrate how implicit conversions can cause issues when trying to insert data in a table using the VALUES clause. 445 more words


#0356 – SQL Server – Search with the LIKE operator and the underscore (_) wildcard character

String searches in most applications are based on the “contains” or “begins-with” paradigms – which are implemented by the use of the LIKE logical operator. The LIKE operator allows for the use of wildcard characters (underscore being one of them), which is the part that most people unknowingly overlook when they have been working with T-SQL for quite some time. 443 more words


The Froogle DBA - Management Data Warehouse Part 1

Originally Posted 8/26/2014

So far we have discussed two of the three core components of the Froogle DBA’s toolbox (Central Management Servers and Extended Properties).  With these two features we can manage systems at scale by improving our ability to apply scripts to all or a portion of our environment, make our environment more self-documenting, and improve communication between the members of our DBA team.  775 more words


Gathering Extended Properties into your Management Data Warehouse database

Originally Posted 8/27/2014

In the first post on the Management Data Warehouse we looked at how to set it up and start collecting default data using Data Collection.  1,540 more words


select all coulmns name and values from Table whose values are not NULL

DECLARE @colName varchar(255), @cmd varchar(max)
DECLARE Columninfo cursor for
SELECT Column_name
WHERE TABLE_NAME = N’yourTableName’ and Column_name LIKE ‘yourcoulmnname%’

OPEN Columninfo
FETCH NEXT FROM Columninfo into @colName… 29 more words


Laravel and Azure SQL Server

From the same project as my last blog post, we had to connect a Laravel 5 web application to a SQL Server instance running on Azure. 248 more words

SQL for Beginners - Introduction

SQL stands for Structured Query Language. It is a query language which acts on data stored in database tables to perform the following display, modification, updating and so on. 482 more words