Setting Maximum Database File Sizes in SQL Server
Setting maximum database file sizes in SQL Server is something you’d ideally not have to set, but it’s a good last resort option available if you need it.
Updating Help Documentation in PowerShell
The Update-Help cmdlet in PowerShell will download the latest help files for PowerShell modules installed on your machine. Running PowerShell as Administrator is a requirement for this one, else you’ll get the following error.
Moving TempDB Files in SQL Server
It’s a solid best practise to have TempDB files stored in separate drive, away from your C: drive. This is because TempDB can grow very large, very quickly (within minutes);
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.
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.
Backing Up a SQL Server Database
Backing up a database is something I’ve always found easier done within a query window. There’s not much to it; BACKUP DATABASE [DATABASENAME] TO DISK = N'e:\directory\databasename_backupdate.bak'
