Script for compressing a database

When you have to compress a database you’d better first see the consideration for the compression. This is a script that I use for compressing databases. Of course you...

SQL Server - Convert() function

Convert () function in SQL Server to convert an expression from one data type to another data type

Syntax for CONVERT function
CONVERT ( data_type [ ( length ) ] , expression...

Except and Intersect

EXCEPT and INTERSECT are two uncommon commands. Not that they do anything odd but they aren’t exactly well known in...

F# Type Inference

I’m just starting to look at functional languages from an Object Oriented background. One of the first things I thought...

Friday Followup For January 23, 2015

It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...

I’m A Friend Of Red Gate For 2015

I was excited to learn this week that I’ve been chosen as a participant in the Friends of Red Gate...

Technology Advances – mSATA external case

I had an SSD die last year. It was one of my traveling SSDs, where I keep spare copies of...

Video: A Better Way to Reindex

Sean presented A BETTER WAY TO REINDEX for the Performance Virtual Chapter. Here are links to the video, and to...

Excel Apps – Not Quite Ready for Primetime

While this is not a regular Excel tip, but it is about Excel. In my Excel BI Tips series, I...

How to install standalone SQL Server 2012 instance ?

Steps to install standalone SQL Server 2012 instance
1) Start the setup > Go to Installation from Left > Click on 1st option...