Databases in Azure… Where to begin? Create a Database and log in!
Ready to create your first Database in Azure. Here are the step by step instructions with plenty of definitions and terms.
2019-10-23 (first published: 2016-06-16)
5,868 reads
Michael Morin
Windowing Functions: Tell me when that changes
Windowing functions aren't just for analyzing numbers/dates. Using windows functions to analyze when a character field changes is a little know resource
2017-03-17 (first published: 2016-02-17)
8,561 reads
Databases in Azure: Copy and Exports
Toady we are going to make a copy and export your DB to Azure Storage. Lets get started.
2016-07-19
942 reads
Finding Special Characters within Character Strings
Special Characters can lead to many problems. Identifying and reporting on them can save a lot of headache down the road.
2016-04-08 (first published: 2014-08-19)
65,198 reads
Blogs
Daily Coping 18 Sep 2020
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Optimize for Unknown for Inline Table-Valued Functions
I had a curious performance issue today. An inline table-valued function (iTVF) was performing...
Daily Coping 17 Sep 2020
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
SQL Server 2016 seeding automatic stuck
Hi all, Problem help please, I have 2 servers in sql server 2016 and...
will this get replicated to secondary replica
Dear Experts, In Availability Group, if we move ndf file to another drive on...
slow query performance
Hi All, I have a SELECT query which is taking more 8 mins. Can...
Ask SSC