Penny wise, pound stupid
Growing up my mother used this phrase quite a bit. Penny wise, pound stupid. (In case you didn’t know the...
2017-02-20
428 reads
Setting up SQL Server to SQL Database (Azure) Replication
I had a need to setup transactional replication from my SQL Server to SQL Database (Azure) where I only needed...
2017-02-20
396 reads
AlwaysOn Availability Groups: Step by Step Setup
An availability group supports a failover environment for a discrete set of user databases, known as availability databases, that fail over together. An availability group supports a set of...
2017-02-20
37 reads
AlwaysOn Availability Groups: Step by Step Setup
An availability group supports a failover environment for a discrete set of user databases, known as availability databases, that fail...
2017-02-20
78,255 reads
Adding a T-SQL Job Step to a SQL Agent Job with PowerShell
In my last post, I explained how to alter an existing job step across many servers. I also had cause...
2017-02-23 (first published: 2017-02-20)
3,170 reads
DevOps Webinar Tomorrow
A quick reminder that tomorrow, Feb 21 at 12pm EST, I’ll be hosting another DevOps, Database Lifecycle Management (DLM) webinar....
2017-02-20
717 reads
Monday Coffee 2017-02-20
No rugby on last weekend so I didn’t have anything to distract me from working. On another note, my flat...
2017-02-20
257 reads
SQL Server Tips and Tricks
In this article I will be listing the tips and tricks to work like
a Pro.
So let's get started –
Important keyboard...
2017-02-20
339 reads
Out of memory error because of the very low virtual address space – Error 701 – Trace Flag 8075
If you are dealing with a SQL Server which got a lot of memory, you may encounter the out of...
2017-02-20
1,299 reads
SQL Cruise 2017 – Western Carribean – my experience
As some readers may know, I am a regular attendee on SQL Cruise s for 8 years now. SQLCruise is...
2017-02-19
632 reads
Blogs
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Forums
Training the next generation
Comments posted to this topic are about the item Training the next generation
Reusing Customer Specific Order Filtering Logic with CROSS APPLY and an Inline TVF (Part 4)
Comments posted to this topic are about the item Reusing Customer Specific Order Filtering...
PostgreSQL psql Meta Commands: Databases
Comments posted to this topic are about the item PostgreSQL psql Meta Commands: Databases
Question of the Day
PostgreSQL psql Meta Commands: Databases
Which of the following meta commands (sometimes called backslash or slash commands) within psql will provide you with information about the databases on the cluster?
See possible answers