It’s easy to use invoke-sqlcmd to send T-SQL statements to SQL Server from PowerShell. There is, however, a rich PowerShell library, sqlps, that can be used instead. In this article, Greg Moore shows how to use sqlps to treat a SQL Server instance as an object.
Learn a few possible solutions to a frustrating issue when you attempt to patch a SQL Server installation.
When I look at a SQL Server, one of the first things I check is, “How much memory does this thing have relative to the amount of data we’re hosting on here?” I’ve long used some seat-of-the-pants numbers, but armed with data from SQL ConstantCare® users who opted into public data sharing, let’s do a little deeper analysis.
Learn about new functions in SQL Server 2016 and 2017 to have more readable and compact code including STRING_AGG, TRIM, TRANSLATE and DROP... IF EXISTS.
In this level we examine how to add disks to separate our data, log, and tempdb files.
Data breaches do more than harm an organization. There's a human cost.
JSON is a viable option for transferring data between systems. It has the ability to include schema information along with the data which is an advantage over CSV files. In this article, Phil Factor demonstrates how he takes advantage of JSON when exporting or importing tables.
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
Pert.Grogol Permai, Jl. Prof.Dr.Latumeten No.4 Blok F 3, Jelambar, Kec. Grogol petamburan, Kota Jakarta...
Jl. Pangeran Tubagus Angke No.37, Jemb. Lima, Kec. Tambora, Kota Jakarta Barat, Daerah Khusus...
Jl. Interchange Karawang Barat, Purwadana, Karawang, 41361, Jl. Panatayuda I No.37, Nagasari, Kec. Karawang...
In the new VECTOR_DISTANCE() function in SQL Server 2025, the first parameter is the distance_metric. What is this?
See possible answers