Is ROI for Vendors Worth the SQL Saturday Investment?

Piggy backing onto the recent SQL Saturday post here in Louisville, I wanted to take a more in-depth look, from my perspective, on how vendors all fit into these events. 490 more words

SQLServerPedia Syndication

#0387 - SQL Server - Script to find source backups used in a database restore

In our development environment, we frequently refresh our databases from various baseline backup sets for each sprint of the product development cycle. During one such sprint, we had a confusion as  to which backup was used to refresh the database. 455 more words


Búsquedas sin acentos (tildes) con SQLServer

Técnicamente una vocal con tilde es distinta a una que no lo posee, y esto se puede notar de una forma muy simple mirando en la tabla ASCII y observando sus códigos respectivos los cuales difieren, por ejemplo : 233 more words


Comparing SQL Server configurations via the command-line

Aireforge OmniCompare 0.9.0 was the first release to ship with the CLI module. This is a separate application, allowing comparisons to be called from 3rd party applications, such as SQL Server Agent jobs, custom scripts and software deployment tools including… 742 more words


Duplicados con SQL – Parte II

Previamente en este Blog… Los registros duplicados son generalmente un dolor de cabeza para todos quienes manipulan datos, por eso en la primera parte resolvimos como “quitar” esos molestos duplicados usando consultas SELECT y aplicando los criterios DISTINCT o bien realizando agrupaciones con GROUP BY. 334 more words


#0386 - SQL Server - Cursor Scope - A cursor with the name 'cursor name' does not exist.; Msg 16916

It’s a well-known fact that using T-SQL cursors have a significant overhead on the query performance. At the same time, there are applications where one simply cannot use a set-based approach and use T-SQL cursors. 1,141 more words


The SQL Server Community Collaborative GitHub Organisation is born

My wonderful friend Chrissy LeMaire and I are the creators of two GitHub repositories for SQL Server and PowerShell called dbatools and dbareports

If you are working with SQL Server I highly recommend that you take a look at the vast number of commands available to you at… 247 more words