Tag: T-SQL

Daniel Holt, Database Administrator at Pythian, provides readers with commonly used SQL Server date functions.

  Fuzzy Search in SQL Server is not done very well. This post will cover how to implement Fuzzy Search capabilities using several approaches.   What is it? Fuzzy Search is the process to locate records that are relevant to…

  An environment where you have a high number of databases on one server, or many, can be time consuming to something as simple as adding a user account. You have the option of using the GUI with SQL Server Management…

Introduction This is the sixth and final post in the series on the Pillars of PowerShell, at least part one of the final post. The previous posts in the series are: Interacting Commanding Debugging Profiling Windows OS PowerShell + SQL Server…

This Log Buffer Edition cuts through the crowd and picks some of the outstanding blog posts from Oracle, SQL Server and MySQL.

This Log Buffer edition transcends beyond ordinary and loop in few of the very good blog posts from Oracle, SQL Server and MySQL.

As a DBA there are occasions where we are required to collect details from a database which can be used for further analysis. For example, getting the status of the database (i.e. File Size, Free Space, Status of the database,…