|
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)
-
Bug: INSERTing into a MySQL Database via Linked Server
/
Recently I found myself involved in a project where a tab delimited text file (updated daily) was being imported into a MS SQL Server…
-
T-SQL Command Line Options – Part 1
/
Every SQL Server DBA is intimately familiar with SQL Server Management Studio (SSMS) and/or previous tools such as Query Analyzer. What some of us…
-
Upgrading SQL Server with Replication
/
Recently I had to create an upgrade plan for a company with 50+ SQL Servers with replication, both transactional and merge, spider-webbed between most…
-
SQL Server 2014 CTP1 Product Guide
/
SQL Server 2014 CTP1 Product Guide has been released. List of Inclusions White papers SQL Server 2014 Mission Critical Performance SQL Server 2014 Faster…
-
SQL Server 2012 RTM Cumulative Update 9
/
SQL Server 2012 RTM Cumulative Update #9 is now available. KB Article: KB #2867319. Build Number is 11.0.2419. Applicable to @@VERSION 11.0.2100 through 11.0.2410.
-
July SQL Server Updates
/
July Updates for SQL Server SQL Server 2012 Service Pack 1 Cumulative Update #5 is now available. KB Article: KB #2861107. Build Number is 11.0.3373. Applicable…
-
Free SQL Tools
/
Below is a collection of free tools every DBA should know about. Plan Explorer Apex SQL sp_Blitz sp_BlitzIndex sp_WhoIsActive Index Defrag Script 4.1 SQL…
-
Creating Logins and Users – Why I can’t connect
/
If you have ever used database projects with SSDT I’m sure you’ve experienced a situation where that user you just created yesterday is suddenly…
-
Attention users running SQL Server 2008 and 2008 R2! – SQL Hammer
/
This is a bit of a piggy back post but I find the information very important and should be publicized far and wide. Complete…
-
Querying Central Management Servers
/
SQL Server Central Management Servers have a number of great features such as, policy enforcement, spawning group connection query windows, and organizing your list…