Querying a Database
When we want to retrieve information from a database, we query the structure with language appropriate to the database. Remember...
2017-05-17
100 reads
Randolph West
- Twitter: @_randolph_west
- Website: https://bornsql.ca/blog/
- LinkedIn: https://linkedin.com/in/rabryst/
SQL Server Management Studio v17.0
Version numbers are confusing. SQL Server Management Studio (SSMS), the client user interface by which most DBAs access SQL Server,...
2017-05-10
230 reads
SQL Server 2017 Announced
By now you will have heard that the next version of SQL Server has been announced. There’s no release date yet,...
2017-05-03
92 reads
Something something Production something something you idiot
You’re reading this series of posts because you want to learn about databases and how to use them. What you...
2017-04-26
93 reads
Upcoming SQLSaturdays in Alberta, Canada
Taking a short break from the Database Fundamentals series of the last few weeks, I’d like to mention some upcoming...
2017-04-19
112 reads
So, like, what is a byte?
A friend of mine in the filmmaking business, who is exceedingly bright but has never worked with SQL Server before,...
2017-04-12
100 reads
Normalization, The Sequel
If there’s one thing that SQL Server is really good at, it’s relationships. After all, a relational database management system...
2017-04-05
109 reads
A First Look At Normalization
Phew! There’s a lot to take in with data types, collation, precision, scale, length, and Unicode, and we’re just getting...
2017-03-29
311 reads
Fundamentals of Data Types
Last week, we discussed storing text in a database. This week we will dive deeper into data types. When storing...
2017-03-22
103 reads
Blogs
Down the Rabbit Hole: Dealing with Ad-Hoc Data Requests
By Rayis Imayev
"But I don’t want to go among mad people," Alice remarked."Oh, you can’t help...
Adding a Local Model to Ollama through the GUI
By Steve Jones
I saw some good reviews of the small gemma3 model in a few places...
Connect resiliently to SQL Server
Why you should connect resiliently to SQL Server Transient failures happen — in the cloud...
Forums
Some query values change when query is run but not others. Why?
Hi everyone I have a 1000 line SQL query that is too long to...
using different credentials when debugging ssis
hi, now and then i want one connection in my ssis pkgs to use...
AlwaysON health check alerts
Comments posted to this topic are about the item AlwaysON health check alerts