Menu

SQL Server 2019 Query Store And SSMS

0 Comment

While not specific to SQL Server 2019 (I was using this version to do some testing) I was struggling to find how to change the time period of analysis for the Query Store reports within SSMS. This is not a … Continue reading ? The post SQL Server 2019 Query Store And SSMS appeared first […]

Is it just me or does msdb feel a lot like a user database?

0 Comment

When you think of system databases, tables, etc there are a number of things you might think of. Necessary to running SQL. Tables/views are read only. SYS schema. Built in roles are fixed. And yes, msdb is necessary to running SQL and it absolutely is a system database. One of its primary functions is to […]

Investigating Azure Databricks

0 Comment

At SQL Saturday #884 – Pensacola, I dropped into Rodney Ladrum’s session on Azure Databricks (ADB) and the Traditional DBA. I had heard a bit about Databricks, and read a little, but I didn’t really know much more than a rough overview. I’ve heard quite a bit from Microsoft about running Databricks notebooks, but I […]

None of the IP addresses configured for the availability group listener can be hosted by the server Either configure a public cluster network 19456

0 Comment

Requirement: Remove a node from one of… [[ This is a content summary only. Visit my website for full links, other content, and more! ]] The post None of the IP addresses configured for the availability group listener can be hosted by the server Either configure a public cluster network 19456 appeared first on SQLServerCentral.

Life Support 2008 – Audit Logons

0 Comment

With SQL Server 2008 and 2008R2 limping along and becoming terminally ill (End of Life Support was July 9, 2019), it should come as no surprise that it is recommended to migrate/upgrade affected databases/servers to newer technology. Planning to upgrade/migrate requires a fair amount of prep work. Some of that prep work involves auditing your […]

All the signs were there, but we didn’t understand them: an essay on gatekeeping in IT

0 Comment

This is the first in a series of posts about gatekeeping in Information Technology and other fields. I am not the first — nor will I be the last — to say that the terminology we use in the technology sphere is problematic. Language and gender bias Let’s look at several tweets collected in the-> […]

Understanding Columnstore Indexes in SQL Server Part 3

0 Comment

My last two blogs were on understanding columnstore and creating columnstore indexes. In this post, I will touch on one last topic, when to use columnstore indexes. As noted in my prior posts these indexes are designed for large data warehouse workloads, not normal OLTP workload tables. As with any index design it is important […]

T-SQL Tuesday #116 Roundup – SQL on Linux

0 Comment

This month’s topic is wide open to anything you could think of that had to do with SQL on Linux from something technical on how to implement it or something you needed to know to run it on Linux to why you may not have adopted it yet.  We extended the deadline thinking maybe the […]

sp_drivespace – See How Much Space You Have On Your Disks, Including Mount Points

0 Comment

We love xp_fixeddrives here, it’s a quick and simple way to see how much space you’ve got available on your drives. But there are just a couple of things that I really wish it would do better. Firstly, I’d love to see the total size of the drive and possibly even a percentage of free […]

Adding a Column with a Default Constraint

0 Comment

Last week a question came up about adding a column to a table, and giving that column a default constraint. Would that default value be assigned to all existing rows, and how much processing would be involved. Unsurprisingly, the answer is that – “it depends”. I’ve got a table with about a million rows that […]