Essential for developments of all shapes & sizes

  • Inside the XEvent Profiler

    Inside the XEvent Profiler

    XEvent Profiler is a new feature of SQL Server Management Studio v17.3. I applaud the SQL Server Tools Team for this feature. I feel like it will go a long way towards putting the legacy SQL Profiler to bed. Sometimes you cannot do any better than taking it straight from the source. Here is Microsoft’s […]

  • T-SQL Tuesday #95 – Unstructured Cosmos

    T-SQL Tuesday #95 – Unstructured Cosmos

    T-SQL Tuesday (#TSQL2sDAY) is a blog party founded by Adam Machanic (b | t). Each month a member of the community hosts the party and selects a topic for us to write about. This month, I am hosting. I invited everyone to write about Big Data. For my post, I chose to learn about Microsoft […]

  • TSQL2sday #95 Invitation – Big Data

    TSQL2sday #95 Invitation – Big Data

    T-SQL Tuesday is a monthly blog party started by Adam Machanic. Everyone is invited to this party. Participation is easy. Simply write a blog post about the topic presented and post it on the second Tuesday of the month (October 10th, 2017) between 00:00 and 23:59 UTC. Do not worry about whether something has already […]

  • SQL query performance tuning tips for non-production environments

    SQL query performance tuning tips for non-production environments

    It is a common misconception that you need real production data, or production like data, to effectively tune queries in SQL Server. I am going to explain how you can compile the same execution plans as what your production environment would compile, so that you can tune them in a non-production environment, gaining these benefits. […]

  • Synchronizing SQL Server Instance Objects in an Availability Group

    Synchronizing SQL Server Instance Objects in an Availability Group

    Availability groups can no longer be considered new. The feature was released in SQL Server 2012 but I often notice that SQL Server Failover Cluster Instances (FCIs) are much better understood. For a very long time, when people thought about SQL Server they thought about the entire instance as a unit. Microsoft has been implementing […]

  • Launch your database into Azure SQL Database – bacpac edition

    Launch your database into Azure SQL Database – bacpac edition

    You have decided to migrate our on-premise SQL Server database into Azure SQL Database. How do you do that? The first thought that comes to mind is a simple backup from on-premise and restore to Azure SQL Database. Unfortunately, that is not supported by Microsoft. Instead, there are three supported methods of migrating into Microsoft’s […]

  • AWS Database Migration Service

    AWS Database Migration Service

    I have begun writing a few blog posts focused on launching your databases into the cloud. Specifically targeted on database migration methodologies. Choosing a migration method involves making a lot of decisions up-front. This post will assume that Managed Relational Database Service (RDS), which is a Platform as a Service offering by Amazon Web Services […]

  • Website hosting challenges

    Website hosting challenges

    I appreciate everyone’s patience with SQLHammer.com. It is encouraging that you are reading this instead of seeing a Cloudflare error message, a site that does not load images and has a bad SSL certificate, or my maintenance page. Over the last 8+ days I have had a lot of challenges with hostmonster.com. They were my hosting […]

  • T-SQL Tuesday #90: A Tool Is Nothing without a Craftsman

    T-SQL Tuesday #90: A Tool Is Nothing without a Craftsman

    This month’s T-SQL Tuesday is being hosted by James Anderson (b | t). T-SQL Tuesday (#TSQL2sDAY) is a blog party founded by Adam Machanic (b | t). Each month a member of the community hosts the party and selects a topic for us to write about. James invites us to write about database deployments. I […]

  • Redgate SQL Prompt Grid Features

    Redgate SQL Prompt Grid Features

    I love Redgate tools. Most of all, I love SQL Prompt because its features increase my productivity on a daily basis. Recently I discovered a couple of new features for the SQL Server Management Studio results grid. The usefulness of these features is incredible. Script to Insert By selecting rows from the results grid, you […]