Got this email from a client in the southern US asking how to up their game in SQL Server, frustrated by a lack of hands-on opportunities to administer SQL...
2019-04-15
20 reads
A database can be offline at the time that you take over responsibility of the database. You will be asked when it was taken offline. This script will help...
2019-04-15
21 reads
A database can be offline at the time that you take over responsibility of the database. You will be asked when it was taken offline. This script will help...
2019-04-15
147 reads
A database can be offline at the time that you take over responsibility of the database. You will be asked when it was taken offline. This script will help...
2019-04-15
6 reads
I needed an SSH key. First I needed to the WSL subsystem, and once I had that working, I could do the work I needed to do: get an...
2019-04-15
845 reads
In my last post I discussed the fact that SQL Ids can, in fact, be useful on an instance that ... Continue reading
2019-04-15
2,909 reads
An indexed view is a view where the result set from the query (the view definition) becomes materialized in lieu of the virtual table result set of a standard (non-indexed) view. Many...
2019-04-15 (first published: 2019-04-01)
897 reads
So it’s about a week after SQL Saturday Chicago 2019. The event was amazing, tons of great people and in a great venue. Here’s the details of what happened...
2019-04-15 (first published: 2019-04-01)
605 reads
There are a few ways to scale a SQL elastic pool. For this blog post I show you how to scale up. It can be done via the Azure...
2019-04-15
61 reads
Good day folks! Let’s make this week great (again)! It is spring already there so it is easy to get up at 6am and write the blog! Now looking...
2019-04-15
53 reads
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
A while back I wrote a quick post on setting up key mappings in...
Comments posted to this topic are about the item Lots of FKs
Comments posted to this topic are about the item Real-time On-prem SQL Server Data...
Comments posted to this topic are about the item Can You Let Go of...
In SQL Server 2025, what are the most outgoing and incoming FK references a table can have?
See possible answers