FrankDolan77

I have been working with SQL Server for nearly 10 years as a database developer.

SQLServerCentral Article

Using Registered Servers in SSMS

One of the features in SQL Server Management Studio (SSMS) that I find very useful is to have a list of registered servers and databases in SSMS. This lets me quickly pick from a number of servers rather than flipping the drop down in the connection dialog. This post looks at this feature and how […]

5 (2)

You rated this post out of 5. Change rating

2024-07-31

2,011 reads

SQLServerCentral Article

T-SQL Language Changes in SQL Server 2022

SQL Server 2022 is in preview in August 2022. I assume this version will be released later this year, and I have been testing it with the idea that I will be looking at an upgrade sometime in the next year for a few servers. There are a lot of changes in the database platform, […]

4.92 (12)

You rated this post out of 5. Change rating

2022-08-31

26,168 reads

SQLServerCentral Article

PowerShell Day By Day: The Pipeline

In this article, I wanted to discuss the PowerShell (PoSh) pipeline, which was confusing to me at first and took some time to get used to working with. I had used one in Linux before, but the PoSh one is more powerful, but also slightly different. Hopefully I can demystify some of the concepts for […]

5 (5)

You rated this post out of 5. Change rating

2020-12-31

4,079 reads

SQLServerCentral Article

Creating SQL Agent Jobs to Run PowerShell

In one of my articles, Calling Procs from PowerShell with Parameters, there was a question in the discussion about calling PowerShell (PoSh) from SQL Agent Jobs. I haven't done much of that, as most of my PowerShell is interactive scripts to make work easier when managing lots of servers. However, it was an interesting challenge, […]

4 (1)

You rated this post out of 5. Change rating

2020-11-30

6,395 reads

Blogs

Small Data SF 2024

By

I can’t remember how I heard about Small Data SF 2024, but it caught...

A New Word: Moledro

By

moledro – n. a feeling of resonant connection with an author or artist you’ll...

Snowflake + Azure blob

By

Let’s go back to data platforms today and I want to talk about a...

Read the latest Blogs

Forums

Need to group the same valued ID fields to run an aggregate average over them

By Zososql

I have data that contains poll results, with the poll_id consistuting a single row...

SSIS Question

By water490

Hi everyone.  I am re-writing a portion of my SSIS logic.  My SSIS package...

How are statistics stored?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item How are statistics stored?

Visit the forum

Question of the Day

How are statistics stored?

How are the statistics for query optimization stored in SQL Server?

See possible answers