Gather Always On Configuration using a DMV query
If you were like me, you would know your AG configuration by heart. However, what if you get busy with...
2018-04-26
363 reads
Blog Posts
How to find out whether your database is transactional, analytical or hybrid?
If you are a DBA, especially Infrastructure DBA, Production DBA or Operations DBA then you don't necessarily always know what...
2018-04-26
397 reads
Securing Test and Dev Environments at the SQL Privacy Summit
Redgate Software is putting on a one day SQL Privacy Summit on May 18 in London at the Grange Tower...
2018-04-26
388 reads
SQL Ops Studio extension development : Starting an adventure
I’ve been in technology a long, long time (more than 2 decades). Over the years, I learned Access which took...
2018-04-26
1,192 reads
SQL Server 2016 – SQL Server Telemetry \ CEIP Services
CEIP (Customer Experience Improvement Program) is somethings runs from ages and almost each vendor perform it to collect product usage...
2018-04-26
8,958 reads
SQL Server Advanced Aggregations Part 1 Grouping Sets
This post is part 1 of a 3 part series…
Part 1 Grouping SetsPart 2 ROLLUP and CUBEPart 3 GROUPING and...
2018-04-26
107 reads
SQL Server database Backup and Restore strategies
One of the most important roles of a database administrator is to constantly protect the integrity of the databases and...
2018-04-26
552 reads
Benefits for Veterans
Wanted to share a few things I came across recently with regards to benefits for veterans:
You can get a printed...
2018-04-25
347 reads
Dates and Times in SQL Server: T-SQL functions to get the current date and time
We have come on quite a journey so far. SQL Server and Azure SQL Database provide date and time data...
2018-04-25
388 reads
Exploring the Caves of Code Analysis in #SQLPrompt
I enjoy themes, and when I ran across the SQL Prompt Treasure Island, I had to take a few minutes...
2018-04-25 (first published: 2018-04-16)
2,296 reads
Blogs
Webinar: Navigating the Database Landscape in 2026
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
Claude AI Convinced Me Not to Build an iPad App
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Forums
Transactional Replication setup issue
Hi! I've been banging my head against the wall for 2 days now trying...
The Power of Data and Privacy
Comments posted to this topic are about the item The Power of Data and...
What's the Date?
Comments posted to this topic are about the item What's the Date?
Question of the Day
What's the Date?
In SQL Server 2025, there is a new function that returns the current date without the time. What is it?
See possible answers