What do you do when technology changes? : T-SQL Tuesday #138
Our host for this month’s TSQL Tuesday is Andy Leonard (blog|twitter). He’d like us to discuss how we handle changes ... Continue reading
2021-05-11
17 reads
Blog Posts
#PowershellBasics: Setting a variable vs a comparison.
In SQL Server both the set and equality functions are handled by the equals sign (=). For example: Set Equality ... Continue reading
2021-05-10 (first published: 2021-04-27)
401 reads
Basic XML Queries–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I ran across a question recently on querying...
2021-05-10
19 reads
Daily Coping 10 May 2021
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-05-10
9 reads
Expanding Inclusion and Diversity – Better Linking
I’m a native English writer/speaker. Some might debate how well I really know the language, but I am a native. I wasn’t a good student of languages. I struggled...
2021-05-10 (first published: 2021-04-26)
164 reads
Query Compile Time
A question that came up recently was how to track the query compile time. It’s actually a pretty interesting question because, there aren’t that many ways to tell how...
2021-05-10
4 reads
New Blog post- Best practices for migrating Microsoft SQL Server databases to Amazon EC2 using CloudEndure Migration
Check out my new blog post-Best practices for migrating Microsoft SQL Server databases to Amazon EC2 using CloudEndure Migration
2021-05-09
157 reads
New Blog post- Best practices for migrating Microsoft SQL Server databases to Amazon EC2 using CloudEndure Migration
Check out my new blog post-Best practices for migrating Microsoft SQL Server databases to Amazon EC2 using CloudEndure Migration
2021-05-09
8 reads
Azure SQL database security
In Azure database, security is managed through multiple-layers such as network layer, server layer and database layer. A secure blue print in deploying Azure SQL(more...)
2021-05-08
12 reads
Azure SQL database SKU selection
When migrating on-premise SQL Server database to Azure SQL environment, identifying the right compute capacity of the target environment to match the resource consumption of(more...)
2021-05-08
118 reads
Blogs
Setting FK Constraints in Data Modeler
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
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...
Forums
SSMS 22 Latest Update Crashing
Hi all, I've just had to roll back my SSMS 22 version from 22.3.0,...
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...
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