-
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 (#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
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
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
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
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
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
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
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
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 […]