|
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 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.…
-
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…
-
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…
-
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…
-
Background
/
Background The days of restarting SQL Service with trace flags 1204 or 1222 (MSDN Detecting and Ending Deadlocks.aspx)) or being forced to start up…
-
February 2013 Cumulative Updates for SQL Server 2008 R2 / 2012
/
SQL Server 2008 R2 Service Pack 1 Cumulative Update # 11 KB Article: KB #2812683 Build number is 10.50.2869 Applicable to @@VERSION 10.50.2500 through 10.50.2868…
-
Managing Multi-Instance Cluster Failovers
/
A couple of weeks ago I was reviewing my daily news feeds and a featured post on SQLServerCentral.com caught my eye. Michael Lacy‘s post…
-
November Update – SQL Server 2012 SP1 CU #7
/
SQL Server 2012 SP1 Cumulative Update #7 is now available. KB Article: KB #2894115. Build Number is 11.0.3393. Applicable to @@VERSION 11.0.3000 through 11.0.3381. Written…