|
Author: Derik Hammer
#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)
-
Linked Server Elimination – SQL Hammer
/
SQL Server has a feature for partitioning tables and indexes. Partitioning can be implemented at many levels, however. You can create multiple tables for…
-
What is a data lake? – SQL Hammer
/
Our zatz-its are wise. Our zatz-its are dispersed. We have questions to ask the zatz-its, so we corral them in a warehouse. Now everyone…
-
What is a cloud data warehouse? – SQL Hammer
/
Amazon Redshift was announced in November of 2012 and became the first cloud data warehouse, opening a whole new segment of technology. What is…
-
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…