|
Category: Uncategorized
#TSQL2SDAY (8) Administration (41) AI (2) AlwaysOn Availability Groups (11) Azure (12) Career (25) Community (37) Continuous Integration / Deployment (7) Development (12) Disaster Recovery (27) General (20) High-Availability (9) Microsoft SQL Server (20) Performance (30) PowerShell (12) SQL Agent (8) SQL Server Management Studio (2) SSAS (1) SSIS (1) SSRS (2) T-SQL (14) Uncategorized (191) Windows Clusters (7)
-
SQL Data Warehouse – Fast row counts – SQL Hammer
/
A couple of years ago I published a script to calculate fast, light-weight, row counts for SQL Server on-premises. The need to view the…
-
5 Extended Events Sessions Your SQL Server Instance Cannot Live Without – SQL Hammer
/
SQL Server Extend Events.aspx) is a general event-handling system. It correlates data from SQL Server and, to a limited degree, the operating system. Extended…
-
Big Data Round Up – SQL Hammer
/
This month’s T-SQL Tuesday was all about Big Data. See what the community has to say about Big Data with this collection of articles…
-
Inside the XEvent Profiler – SQL Hammer
/
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…
-
T-SQL Tuesday #95 – Unstructured Cosmos – SQL Hammer
/
T-SQL Tuesday (#TSQL2sDAY) is a blog party founded by Adam Machanic (b | t). Each month a member of the community hosts the party…
-
TSQL2sday #95 Invitation – Big Data – SQL Hammer
/
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…
-
SQL query performance tuning tips for non-production environments – SQL Hammer
/
It is a common misconception that you need real production data, or production like data, to effectively tune queries in SQL Server. I am…
-
Synchronizing SQL Server Instance Objects in an Availability Group – SQL Hammer
/
Availability groups can no longer be considered new. The feature was released in SQL Server 2012 but I often notice that SQL Server Failover…
-
Launch your database into Azure SQL Database – bacpac edition – SQL Hammer
/
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…
-
AWS Database Migration Service – SQL Hammer
/
I have begun writing a few blog posts focused on launching your databases into the cloud. Specifically targeted on database migration methodologies. Choosing a…