Test

All about Searching - Full-Text Indexes

SQL server has the capability to store text-based data in the form of char, varchar, nchar, nvarchar, text, ntext, image,...

Analytics Platform System (APS) AU5 released

The Analytics Platform System (APS), which is a renaming of the Parallel Data Warehouse (PDW), has just released an appliance update (AU5),...

Basic SQLCMD–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...

Changing Of the Guard

As many of you know,  I stay very active within the PASS community.  In late 2007 I got my start,...

Cool Tools: Powershell ISE-Steroids

Disclaimer: I have been provided with a free license because I am reviewing. This doesn't impact my assessment of the...

Modulo!

I love this somewhat obscure mathematical operator. All it does is return the remainder of a division statement but even...

MongoDB – How to Copy Database

Using copydb
Run the copydb under admin database with from,to, host parameters
>use admin
switched to db admin
> db.runCommand({ copydb: 1, fromdb: “test”,...

The Next Chapter ~ A SQL Journey

The past five years have been nothing short of an amazing ride on this thing we call “The SQL Journey”....

Upcoming Speaking Engagements

The next few months will be crazy for me. I will be travelling a lot around Europe, speaking about SQL Server topics.
Here is where...