Bliv klogere med Inspari

På bloggen finder du inspiration og gode råd til at gøre data til et aktiv i din organisation.

Posts om

sql server

SQL 2008 R2 ryger ud af support

Efter september 2019 stopper Microsoft supporten af SQL Server 2008 og 2008 R2. Hvad betyder det...

SQL server file initialization

Data and log files are initialized to overwrite any existing data left on the disk from...

How much space are you wasting?

A few weeks back I was visiting a client who asked me to write a script that could tell him the...

Network package size

We all know that network handling is very expensive, so when loading a large amount of data...

Are you wasting storage space?

Do you see tables taking up much more space than expected? And when looking at the table design...

SQL Server trace flags

Normally I’m not a big fan of using trace flags, my advice is only to use these when it is...

Backup On-Premises SQL Server Databases to Azure Storage

With the release of SQL Server 2012 SP1 CU2, an enhancement to the BACKUP command has been...

Filegroup confusion

Where did I put my Sales table?

Using table variables in a SSIS data source

Every now and then standard queries just aren’t sufficient as data sources and therefore it...

Special characters in SSAS Name properties

Have you ever got the request to use special characters, like ( ) / & %, in the names of your...

Throw your server off balance

…Balanced Power Plan that is

Caring about nature is most certainly a likable trait. But did you...

Output row values effected by an update

Have you ever thought about logging the before and after value for an update or delete? It’s...

Updateable views

By default view are updateable. It means you can write a TSQL update statement against a view...

Avoid schema changes corrupting your views

Maybe you are using views as a layer between your tables and your users. If you have a lot of...

dbcc checkdb

Almost every one of my customers is running a backup of their databases (you would be surprised...