SQL Server Migration
Some SQL migrations require keeping the server name, instance name, IP, and port number. Geoff Ruble shares some notes on his recent experience with a SQL Server migration.
2018-07-20 (first published: 2015-10-12)
6,821 reads
Geoff Ruble
Verify SQL Backups With SQL Powershell
With SQL Powershell, you can check all your database backups in minutes, whether you have ten SQL servers or 100.
2016-04-25
3,711 reads
Blogs
Daily Coping 5 Mar 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Microsoft Ignite Announcements 2021
By James-Serra
Microsoft Ignite has always announced many new products and new product features, and this year...
Daily Coping 4 Mar 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Loading large JSON file into a Data Table to Bulk Copy into SQL Server Table
We have a JSON file with 10M records to bulk copy load into a...
Help with OPENJSON for Google Maps API data
Hello, I'm a newbie when it comes to JSON so when I started down...
pivot multiple columns and transpose to same row sql server
I have a table like below: CREATE TABLE #Test (Category_ID INT, [Type] VARCHAR(2),Student_ID INT,...
Ask SSC