In this post I want to share how we can use powershell to automate Hyper-V virtual machines creation for easiness and consistency This post is part of the T-SQL Tuesday, which is…
T-SQL Tuesday #92, Lessons learned the hard way. Wrapping up
Wrap up for the #tsql2day event for July 2017. The topic for this month is "e;Lessons Learned the Hard Way"e; #tsql2sday is a monthly blog party on the second Tuesday of each…
T-SQL Tuesday #92, Lessons learned the hard way
#tsql2sday is a monthly blog party on the second Tuesday of each month. Everyone is welcome to participate, so no matters you are an experienced blogger or you just want to start…
Successful Anti-Patterns, Using Deprecated Data types
From time to time it’s good to remind people about the complexity of a product such as SQL Server. The internals are so wide and complex that we easily get lost and…
Spring cleanup, LOB considerations
For DBA’s it is important to have the ability to recover databases quickly in case of disaster. In order to maximize the potential we need to have our databases ready but sometimes…
Not the typical story about key lookups
Query plans are very useful to tune queries, but some operations are usually avoided or blamed for performance problems when not always are the culprit, let me show you one of those…
T-SQL Tuesday #88 – The security audit WTF
In this post I want to share the stored procedure I wrote to audit the different logins and server permissions within an instance. This post is part of the T-SQL Tuesday,…
Benchmarking storage using Diskspd.exe
One of the most important things when something goes wrong is to have an idea how your environment looks like in a normal day. Let me show you how to easily get…
Statistics and Data types, What can go wrong?
One of the most interesting things in SQL Server are Statistics. Today I want to write about the creation and update. One of the most interesting things in SQL Server from my point…
Playing with Azure, File Snapshot backups
This week I want to go another step into moving databases to the cloud and start using some advanced features that Azure offers Last post, we explored how to move part of our…