"Failover Partner" keyword in connection string - Q&A
1. How to connect client to a Database Mirroring Session with failover aware
A: add FailoverPartner keyword in the connection string,...
2013-11-08
13,907 reads
Blog Posts
Building The Redneck Treadmill Desk
Don’t tell Brent Ozar, but here’s another DBA writing another helpful article about shrinkage. Before he gets bent out of...
2013-11-08 (first published: 2013-11-04)
3,964 reads
Friday Followup for November 8th, 2013
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2013-11-08
437 reads
My SQLrally Session about how to measure Index Impact Changes
(Be sure to checkout the SQLpassion Online Academy, where you get High-Quality SQL Server Trainings with Instant Access!)
During the...
2013-11-08
787 reads
PowerShell: Delete Unneeded Rows/Columns In Excel
I had a project to automate the import of a large number of excel files via SSIS into SQL 2012....
2013-11-08 (first published: 2013-11-01)
6,919 reads
Reblog: November 1 to November 7
I’ve always been a fan of the feeling when I find an old blog post that’s got just the information...
2013-11-08
915 reads
SSAS– Resolving target machine actively refused
I always wanted to have my hands on SSAS, SSIS and SSRS as I always feel short-hand in these areas....
2013-11-08
965 reads
What If Someone Tampered with the Process?
I’m a big fan of automation. Automation means I can do more. Automation means I eliminate the mundane stuff to...
2013-11-08
2,373 reads
What If Someone Tampered with the Process?
I’m a big fan of automation. Automation means I can do more. Automation means I eliminate the mundane stuff to...
2013-11-08
483 reads
Configuring the RecycleTime SSRS Setting
If you administer a SQL Server Reporting Services server, chances are you’ve had users complain the report manager is loading...
2013-11-07
4,449 reads
Blogs
A New Word: los vidados
By Steve Jones
los vidados – n. the half-remembered acquaintances you knew years ago, who you might...
In-Person CISA Training – April 13-16, 2026
By Brian Kelley
I will be leading an in-person Certified Information Systems Auditor (CISA) exam prep class...
EightKB 2026
EightKB is back again for 2026! The biggest online SQL Server internals conference is...
Forums
Vectors in SQL Server 2025
Comments posted to this topic are about the item Vectors in SQL Server 2025
Odd Sequences
Comments posted to this topic are about the item Odd Sequences
Everything is the right question away
Comments posted to this topic are about the item Everything is the right question...
Question of the Day
Odd Sequences
What values are returned from this code?
CREATE SEQUENCE NumericSequence
AS NUMERIC(5,1)
START WITH 1.0
INCREMENT BY 0.1;
GO
SELECT NEXT VALUE FOR NumericSequence
GO
SELECT NEXT VALUE FOR NumericSequence
GO See possible answers