Easy way to test log shipping or availability groups setup
Have been working through the fantastic training resources from Brent Ozar’s Everything Bundle and on the recommended resources they mention...
2016-01-29
600 reads
SQL Server Management Studio Setup and Configuration
This is my first #entrylevel blog post. The challenge identified by the tags #entrylevel and #Iwanttoshare was started by Tim...
2016-01-28
1,474 reads
SQL Server Principals – Back to Basics
A fundamental component of SQL Server is the security layer. A principle player in security in SQL Server comes via principals.
Related Posts:
Easy Permissions Audit January 21, 2019
SQL...
2016-01-28
428 reads
SQL Server Principals – Back to Basics
Prelude in SQL Minor
Back in late December of 2015, a challenge of sorts was issued by Tim Ford (twitter) to...
2016-02-03 (first published: 2016-01-28)
3,322 reads
Memory Fundamentals for SQL Server - Virtual Memory, /3GB Switch
Just a few days back I was asked a very basic question related to AWE and /3GB switch.I was surprised...
2016-01-28
4,849 reads
Save the date: SQLSaturday Iowa City
Q: True or False – Iowa has one of the world’s longest-running SQL Server conferences?
A: True! SQLSaturday #19 was held in the fall of...
2016-01-28
1,014 reads
Where in the world are Jen and Sean?
Updated with more SQL Saturdays! Well hi there, folks. A month slips by so very fast. Here is your January...
2016-01-28
1,038 reads
Reblog: Building the Script Component
SQLKover update: For some reason, this was my most popular blog post on the old LTD site. Over 110,000 views. People...
2016-01-28
864 reads
Encrypting AlwaysOn Availability Group Transport- Some thoughts!
Transport security for AlwaysOn Availability Group is an interesting topic, and any day it’s a topic which is debatable. The transport security involves encryption of packets exchanged between the...
2016-01-28
13 reads
Encrypting AlwaysOn Availability Group Transport- Some thoughts!
Transport security for AlwaysOn Availability Group is an interesting topic, and any day it’s a topic which is debatable.
The transport...
2016-01-28
2,201 reads
Blogs
T-SQL Tuesday #202 Invitation: That One SQL Server Outage You’ll Never Forget
I am excited to host T-SQL Tuesday for the first time. I want to...
A Daily Report from Claude
By Steve Jones
Redgate had some Claude training recently, which I went through as my knowledge has...
A New Word: Gnossienne
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
Forums
Measuring Productivity
Comments posted to this topic are about the item Measuring Productivity
Importing Excel files into SQL Server using DuckDB and Python
Comments posted to this topic are about the item Importing Excel files into SQL...
Tracking All the Queries
Comments posted to this topic are about the item Tracking All the Queries
Question of the Day
Tracking All the Queries
I have 3 instances of a brand new long running query that are executing on a SQL Server 2025 instance. Query store is enabled. One of the queries is killed by the administrator, one is cancelled by the user. The other runs to completion. How many rows are in Query Store for this query?
See possible answers