Issue while using SQLCompare against Azure SQL DB
I’ve encountered an issue while trying to compare a local SQL Server database against an Azure SQL DB using Redgate...
2018-05-15
323 reads
SQL Server Save Time Managing Multiple Servers With Central Management Servers
Central Management Servers give us a way to manage a collection of SQL Servers as one, a query executed against...
2018-05-15
82 reads
SQL Server Building On Calculations With APPLY
I find myself using Apply more and more in my queries, aside from the usual reasons I’ve been finding I...
2018-05-14
47 reads
I’m speaking: SQL Saturday Los Angeles 06-09-18
Hello California! I’m headed your way and will be speaking at SQL Saturday #773. The full schedule is live and...
2018-05-14
245 reads
Monday morning comic 2018-05-18
Here’s the first issue of a new Monday morning comic series. Hopefully some of you all get a giggle.
2018-05-14
351 reads
Reaching the Refactoring Redoubt with #SQLPrompt
I enjoy themes, and when I ran across the SQL Prompt Treasure Island, I had to take a few minutes...
2018-05-14
310 reads
Quick charts in SQL Server Operations Studio
Sample chart for quick insightsSQL Server Operations Studio will be a new tool for managing SQL Server, Azure SQL Database,...
2018-05-14
126 reads
Handy TSQL for Azure SQL Database
I do not always use the Azure portal to make database changes or to check for certain information. I use...
2018-05-14
331 reads
A View Will Not Make Your Query Faster
Twice recently, one on a blog post, and one in a forum post, I’ve seen people state, unequivocally, without reservation...
2018-05-14
329 reads
Day 14 MySQL sys Schema
MySQL 5.7.7 and higher includes the sys schema, This has View, Stored Procedures and Functions to gather the performance related information, as...
2018-05-14
214 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
Anyone knows where to download SQLexpress edition for 2022
Where to download earlier version of SQL server express 2022? Thanks
Risk Vs Reward, The never ending ROI discussion.
Comments posted to this topic are about the item Risk Vs Reward, The never...
SSL/TLS Cert Validity Periods Decreasing
Hi, to all of you who are using CA certs on SQL Server boxes...
Question of the Day
Checking the Error Log III
If I want to run sp_readerrorlog on SQL Server 2025, what permissions do I need?
See possible answers