The (SSMS) Import Flat File Feature
The Import Flat File wizard within SSMS was introduced in December 2017 (14.0.17213.0). This is a streamlined version of the Import Data feature and it minimises the user intervention during a file import.
Tech Blog – Home
Attaching SQL Databases Without Log Files
If you’ve lost a database log file and you’re in critical need of the data, well… that would never happen ( ͡° ͜ʖ ͡°) Nevertheless, this is might be a handy random fact to know, that you can attach a data (.mdf) file without the associated log (.ldf) file in SQL Server.
Backup & Restore (WITH FILE)
In this post I’m going to show what the WITH FILE = X option does when backing-up or restoring a SQL Server database.
Applying Data Retention to a SQL Table
There are many reasons why you’d need to delete old data from a table within a database, some of which include;
Using Custom Connection Colours in SSMS
SSMS has an option that allows you to change the colour of your query banner, which is useful if you want visually mark a server that you work with every-day.
Count rows within CSV files using PowerShell
This post is a quick run-through of using a PowerShell script to count rows within many CSV files, with a quick check of the data afterwards.
Exporting SQL Server Query Results to CSV
This post is a quick guide on how to export data from SQL Server into a CSV file. The default export to settings will try save your query as a column aligned .rpt file, so I’ll cover that below while converting to CSV format.
How to Check Table Sizes in SQL Server
There are many ways to check the size of a table in SQL Server. The way you’ll do it will likely depend on what you’re task at hand is.
