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,903 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)
9,193 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
1,028 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)
92,252 reads
Blogs
Goal Progress for July 2021
By Steve Jones
I set goals at the beginning of the year, and I’m tracking my progress...
Data Modeling at your fingertips
By Rayis Imayev
(2021-July-30) A picture is worth a thousand words, the same way a visual database schema...
How to put a SQL Server Database into Recovery Pending
By John
You might be asking why on earth would you want to get a database...
Forums
How is Throughput optimized HDD (st 1)
Hi Everyone. i am planning to shift my website to AWS I want...
Alternative to LAG(SUM) - Can a Column Reference The Sum of the Values Above It
Hi Everyone, I'm trying to do something that seems pretty simple, but SQL Server...
Transaction log shrink w/ logshipping
Hello everyone, Again with this question. 🙂 I've got a log-shipped database, and I...
Ask SSC