I suspect it works in general, but they don't want to support any problems on 2014. I've run many systems out of support,and it's rarely been an issue.

However, when it...

No idea, and searching for this is hard. Too many PoSh things work with IPs.

I suspect that it (or the PS Gallery modules) have some hard-coded IPs they use to...

Gail's piece: https://www.red-gate.com/simple-talk/databases/sql-server/database-administration-sql-server/gail-shaws-sql-server-howlers/

You can't partition a column. This is for tables. A client asking for this doesn't really understand what they want.

Here's my thought.

While Johan is right, and you know splitting makes sense, it's not practical. I'd kick the can and assume we will need to split this, but try the...

As a boy, I helped my father dig trenches for water pipes, cut trees, plow firebreaks, and build simple structures. I always enjoyed knowing how things went together and...

I've found that doing and creating things in the physical world is critical to my mental health.  Working in IT the vast majority of my work hours are spent...

I'm going to throw in something different on this topic. I hate cooking. If it were up to me, I'd make PBJ sandwiches all the time. I like PBJ...

I also enjoy accomplishing things around the house.  I have never tapped a bolt, nor do I have the tools for it.  But it is something that I would...

In this case, tooling did this for me. No typing involved. This makes it clear where the column is located, and if there were joins, this is required.

We often alias...

I think those local environments are tough, though I'd made sure they were VMs. Helps with replacing hardware and DR. I think this is one reason Azure and AWS moved...

Yes,...

We have a physical 3 node WSFC with 6 SQL FCIs. We are using cross-site AGs for DR. We built this in 2017; running MSSQL 2016. Pretty much everything...

New physical nodes installed with Windows Server 2019, and hooked up to FiberChannel & SAN shared storage; setup MSSQL...

In SQL Server, we have more databases on a service more easily than some other RDBMS. For the sake of argument, whether there is a separate db or schema isn't...

In SQL Server, we have more databases on a service more easily than some other RDBMS. For the sake of argument, whether there is a separate db or schema isn't...