|
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)
-
FILESTREAM garbage collection with AlwaysOn Availability Groups
/
It seems that, of the DBAs who use FILESTREAM, it is common to ask, “why do I have more file system objects then I…
-
My Epic Life Quest
/
As a child I watched television and watched movies. The influence of the shows I watched on me is undeniable. It didn’t take much…
-
SQL Server 2014 RTM – Release Date
/
Today, Microsoft announced that SQL Server 2014 RTM will be generally available on April 1st, 2014. In addition to this wonderful piece of information;…
-
Session review – Brent Ozar at RSSUG
/
Yesterday (Friday, March 14th, 2014) Richmond, VA’s SQL Server user group was fortunate enough to have Brent Ozar ( @BrentO | BrentOzar.com) stopped by…
-
SQL Server 2008 R2 SP2 – Cumulative Update #11
/
From blogs.msdb.com: Dear Customers, The 11th cumulative update release for SQL Server 2008 R2 SP2 is now available for download at the Microsoft Support site. Cumulative…
-
Are your backups enough? – SQL Hammer
/
“You only need one thing; a backup or a résumé. Never both.” This quote certainly summarizes a very important piece of being a DBA.…
-
SQL Agent Monitoring – Long Running Job Queries
/
The SQL Server alert system does a great job of handling notifications for SQL Agent job failures but if want to know if a…
-
PRO TIP: Force table suggestions – Red-Gate SQL Prompt 6
/
For those SQL Prompt users, like myself, I’m sure you love its table suggestion feature. Unfortunately, there are situations where you open a query…
-
Transactional Replication – Find the Publisher
/
I manage a moderately complicated topology that includes one-way transactional replication with push subscriptions to and from several database instances. Due to my day-to-day…
-
Avoid GUID clustered index write problem – SQL Hammer
/
A globally unique identifier (GUID) is a great way to identify a record in your database. It can be easily created at the database…